What I want to do is as follows, I have table with all the employee
information, name, company ID, hire date, etc. What I have done is set up a
form so that I can track their leave of absence. both forms will have there
Company ID so what I want to do is have the LOA form fill in the names and
other information from the master list when I fill in the "company ID" on the
LOA form