In Access the data should only exist in one table. To achieve what you are describing should be done by creating a query that joins the Order Table with the Customer Table on the CustomerID field and only the CustomerID is stored in the Order Table as a ForeignKey. Then your order form is bound to this query rather than the Order Table. You can display any field in any table on this form as it all of the fields were in one table. You will want to be changing the ForeignKey field in the Order Table and when you do the fields you display from the Customer table will change to the new Customer.
(RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro - acXP, ac07, ac10, ac13
If your issue is resolved...go ahead and use the Thread Tools at the top of the thread and mark the thread as Solved!
Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"