Sharepoint and Access - Table-level Lookups and other Questions

cavilatrest

New Member
Joined
Jul 4, 2012
Messages
5
Hello everyone,

Recently I started work on a supplier database, eventually deciding to convert it into a web database so that more people would be able to use it (this being a key deliverable that Access Runtime would not solve). I am however inexperienced with web databases so some help would be appreciated.

I am currently having trouble with figuring out whether or not form-level lookups are still better than table-level lookups, as the former doesn't seem to create relationships. i.e. though I have a combo box transferring data from table to table Access doesn't recognize there being a one-to-many relationship.

Also, most users will not be using typical forms, and will want to import data en masse. As far as I know this is not possible with a web database, so if anybody had any recommendations regarding that it would be great.

Thanks in advance,
 

Some videos you may like

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Watch MrExcel Video

Forum statistics

Threads
1,123,085
Messages
5,599,650
Members
414,325
Latest member
kfg1287

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top