SQL server and SharePoint

If the lookups don't change frequently, you can import the values to a local table to populate your RowSources. You just need a way to manually refresh them if the user needs to.

If you need a way to notify people that their lookups need to be updated, you can send a group email if someone updates the lookup table but of course if you have dozens of these, that becomes problematic. See my mini-app below.

This doesn't solve your location problem but it shows how you can use 2 tables and 2 forms to manage ALL your simple lookup tables.

If you decide to use the app, just change the theme to make it match your app.
 

Users who are viewing this thread

Back
Top Bottom