Not able to edit order form

[hrdpgajjar]

Hi all,
I have created a customer order entry system, I have tried to follow an online tutorial and make the attached access order entry system.

Now I need help on,

1. How to create a new customer and enter order items
2. how to edit items in OrderF (it shows an error)



Thanks

 

[DHookom]

You should consider downloading the new Northwinds Access template. There are two versions. You should probably consider the Starter edition

 

[Pat Hartman]

Do NOT name your autonumbers "ID". it just causes confusion and makes it hard for others to see how the tables relate. Name this field CustomerID and USE it as the PK or do not include an autonumber at all.

Order and Order details must be related on OrderID. REMOVE RegNo from OrderDetails and replace with OrderID. Then fix the master/child links.

 

[mike60smart]

Hi all,
I have created a customer order entry system, I have tried to follow an online tutorial and make the attached access order entry system.

Now I need help on,

1. How to create a new customer and enter order items
2. how to edit items in OrderF (it shows an error)



Thanks

Hi
Your CustomerT table has a field called "ID" and is an Autonumerber but you have not set this as the PK?
The "ID" field should be renamed to CustomerID

You should then add a new field named "CustomerID" to the table "OrderT" and this should be a Number data Type - Long Integer.

You should then link the CustomerID Pk from CustomerT to the CustomerID Fk in the "OrderT" and Enforce Referential Integrity.

You can still keep your field named "RegiNo".

Also you should remove all spaces in field names.

You do not need the field "RegiNo" in both the tables "OrderT" & "OrderdetailT".

You do not need the field named "Productname" in "OrderDetailT".