I have a database which needs protection during data entry. The data entry form looks up staff_surname and staff_firstname from a lookup table tblstaff. I would like to return staff_ARN which is a unique ID number(primary index). I can get access to return staff_ARN whilst displaying only the first and last name however it does not write the name fields to the underlying tables. I want it to do both. Write the staff_surname and staff_firstname to the underlying tbleventdata and auto enter the staff_ARN into the tbleventdata after selecting it based on the name selected on the form.

Any ideas? Is this possible?


Greg Smith