Returning Data to underlying tables in Access

[GregSmith]

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?

Regards

Greg Smith
Coolangatta

[platinum]

You may be able to combine both tables within a query and sort of combine data that way. Just be carefull when you do it though, strange things can happen!

Maybe you should review your table structure as well, make it a bit simpler.