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.
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.
