I’m building a Travel Expense database for my co-workers who travel to
various companies to do audits. This will not be a shared database, each
employee will have their own copy of the application that stores only their
travel expenses.

It’s obviously a One to Many application with tblTravel as the Parent, and
tblExpenses as the child table. Tracking expenses was the easy part, however,
I’m having a hard time designing two nifty little features for the Form.  I’m
asking the question here because I assume it will require some coding on the
Form.

First question:
Each employee will have a one record table called tblTraveler that stores
their Lastname, Firstname, MI [if they have one], Office Name, Phone Number,
and Email address. When the traveler creates a new record, I would like the
form to automatically enter the traveler’s Lastname, Firstname, MI, Office
Name, Phone Number, and Email address from tblTraveler in READ ONLY format.

Second question:
There will be a combo box on the form so they can look up the name of the
company they’re auditing from tblCompanies. However, once they select the
company, I would like to automatically add the Company Address, City, State,
Zip, and Phone Number onto the form in READ ONLY format.

Thanks,
Robert