Once again, something I should probably know or be able to reference --but once again, I still can not get to my books to find the answer. Thanks to everyone I am still able to get my work done, big thanks to everyone who has assisted. Here it is:
I have a Table that holds Requests (tblRequests) and a Table that holds the Location Information (tblLocation) (the tblLocation pulls the contact information from tblContacts)
When I enter data into the "Location Code" field of the tblRequest, I would like to have it auto-fill the default information from the tblLocation and the tblContacts that the specific Location Code corresponds with. I was thinking that I should be able to make the default value (but still have the option to change) of the field equal the corresponding field from the other table, but I have not been able to figure out how to make this work.
(i.e. Location Code =1 in tblRequest, auto-fill Man=tblContacts: Man field for tbl_Location Code = 1)
I am at a big stand still until I figure this out, so if someone could point me in the right direction I would appreciate it greatly.