Reply to thread

Message: [QUOTE="Luis Miguel, post: 2548672"] John, I understand your point about not using datasheets for data entry and would never let a user interact directly with them. That's why I didn't mentioned anything about it. Correct me if I'm wrong, instead of using the setup I explained in my earlier post what I need to do to avoid the drawbacks and limitations you mentioned is: 1 - Create a relationship between the fields employee_id in the two tables 2 - Create a combo box that looks up the formatted data (Name: first_name & " " & last_name) in a form, but post the real value (employee_id) to the foreign key on the other table Thanks, Luis. [/QUOTE]