I have a database that is used by people in the office. Then we have people that work outside the office and they are called field personnel. Using the "office" database we want to be able to export a record that is being viewed on a form. In addition to this we want to export another record that is related to that record being viewed on the form.
Then, I believe that the field people need a separate copy of the database with everything removed that they don't need other than the form so they can view the same record when they receive it. They will edit the record and send it back to the office.
What is the best way to handle the transfer of the record back an forth. Has anyone done something like this before?