how to do an auto-lookup to fill in the blanks on a database

R

Rick B

If you have a question, please post it in the big white area. Us complete
sentences and explain exactly what you are trying to accomplish. what
tables do you have, and how are they related? Are you going to be using
data from one of these tables in your "lookup"? Not sure what an
"auto-lookup" is. Fill in which blanks? Are you using a form?

Details please. Your question is way too vague to offer an appropriate
response, and no one wants to send you their guesses at how to do this.

Thanks,
 
P

PR Kid

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
 
Top