Jaybird, this table really, really, really needs to be redesigned.
Whenever you see repeating fields such as [Part Number 1], [Part Number 2],
... it always means that you need a related table where you can store many
records instead of having many fields in the one table.
One order can contain many line items. That means you need 2 tables:
- an order header table, with fields such as OrderNumber, OrderDate,
- an order detail table to hold the line items. Fields such as Quantity,
For an example of how to build such a table, open the Northwind sample
database that installs with Access. Open the Relationships window (Tools
menu.) You will see an example of how to set up the Order and OrderDetails
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Jaybird" wrote in message