After an Order Is placed by a customer in my Orders form, The customer name replaces an existing customer in the Orders tables instead of going to a new record of its own.
Could someone help me please!!!


Orders Table : CustomersTable: OrderDetails:
OrderID CustomerID Date
CustomerName LastName OrderDetailID
OrderDate FirstName OrderID
PickUpDate Address ProductID
PaymentMethod City ServiceType
Status State Quantity
Zipcode UnitPrice
Phone Location

CustomerID in the CustomersTable is a One-to-Many Relationship to CustomerName in Orders.

OrderID in the Orders table is a One-to-Many Relationship with OrderID in OrderDetails.

I have a table called Status(Which is not listed above) that has a productkey field called StatusID which has a One-to-Many Relationship with Status in the Orders Table.

I have a table called Locations(Not Listed)that has LocationID as the Primary key, and it has a One-to-Many Relation with Location in Order Details.

I can't make any sense of the list of fields due to the lack of spacing. However, CustomerID is what should be stored in the Order table NOT CustomerName. That may be what is causing your problem

When you open the order form and go to a new record, you should be able to choose a customer from a combo and that customerID should be associated with the new record. There is no reason for it to be updating an existing record. Are you trying to use a bound combo to search for a customer's orders? If so, change the combo so that it is UNBOUND by removing the field name from its ControlSource.