Here is what I want to do. I will have 2 tables 1 customer details 2 orders Customer table: ############### CustomerID First Name Last Name Address TEL FAX Order: ###### OrderID Product Price First name Last Name What I want to have the First Name field in the Order table to be a lookup. This works OK. The problem is i can’t get it to add the customer’s Last name to the order table. How do i do this? Thanks

I would seriously advice against this. One problem with adding customer name to the orders table is that if you update the information in the customer table, you would also have to update the same changes to each instance in the order table. A better option would be to add the customerid field to the orders table. If you insist on doing this, you would use the After Update event for one of the name controls (on your form) to update the other. Use the dlookup function to look up the name.