I have created database with main form as attached, to be installed at the company headquarters. However, in a different part of the company (geographically displaced ), I need them to be able to use and input only part of the form in red square and not be able to access (see) other part of the form/database. Since the job number is both the autonumber and the key field for main table, the people in headquarters obviously need to be able to see others input and they both need to talk to the same main table. Questions are as follows:
1. How do I get people on different geographical locations to speak to same database table?
2. Should I create another database with only that part of the form displayed for people that are not atthe headquarters (in which case how do I get two databases to talk to each other), or should I use same database, but disable access to buttons etc (in which case what is the best way?)
P.S. It is obviously very important that they both speak to the same Main table as the Job Number is both AutoNumber and key field.