SQL server and SharePoint (1 Viewer)

NauticalGent

Ignore List Poster Boy
Local time
Today, 06:32
Joined
Apr 27, 2015
Messages
6,286
No experience with the Azure flavor. @Minty would be able to respond on that one.
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 06:32
Joined
Feb 19, 2002
Messages
42,981
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

Top Bottom