User Settings across DB

Discussion created by ericjlindholm on Oct 15, 2016
Latest reply on Oct 15, 2016 by philmodjunk

My users have LOTS of preferences set in a "user" table.


I needs to access those preferences across a large and complex DB.


right now i am using Global variables but there are a lot of them and the user has so reopen the DB for them to get reset.  I could obviously program them to reset when they are edited but that is a huge pain.


I was considering using a global field set with their user ID but it would have be linked and a global field set is every table on DB open.


any ideas for accessing fields from a user record across the DB efficiently?