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?