All I need is for the data to refresh upon opening. And for users to
be able to make updates in 1 table only. I would need three linked
tables in total. This is a front end, where I prompt for user values
which determines the data they will see on a form. I don't really
even want them to see the tables. Just the entry screen (menu form)
and a data entry form. They will have server access to the folder
where the back end resides, but I don't want them to be able to open
the back end. The back end will be used by two people only with user
id and password. Is this possible?