setting up tables

Is there any set order for creating tables, I want to create the following
tables
Labour, Products, Customers, Orders, Confirmation, Deposits, Invoice,
Payments and Container import, what would be the best order to set these up

1. Customers - Customers place orders and make deposits
2. Products - Orders are for products
3. Orders - there must be an order to confirm, to make a deposit for and to
invoice
4. Confirmation - an order must be confirmed gefore a deposit is made
5. Deposit - deposit precedes invoice
6. Invoice - invoice precedes payment
7. Payment

I don't know what Labour and Container Import are.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications







"Bicycle Bel" Bicycle wrote in message
...
Is there any set order for creating tables, I want to create the following
tables
Labour, Products, Customers, Orders, Confirmation, Deposits, Invoice,
Payments and Container import, what would be the best order to set these
up

On Mon, 21 May 2007 12:23:01 -0700, Bicycle Bel Bicycle
wrote:

Is there any set order for creating tables, I want to create the following
tables
Labour, Products, Customers, Orders, Confirmation, Deposits, Invoice,
Payments and Container import, what would be the best order to set these up

Access neither knows nor cares in what order the tables are created.

Create the tables first; then define their relationships; then start building
Forms to enter data into the tables.

John W. Vinson [MVP]

Don't forget the OrderDetails table. It contains the line items for an
order.

"Bicycle Bel" Bicycle wrote in message
...
Is there any set order for creating tables, I want to create the following
tables
Labour, Products, Customers, Orders, Confirmation, Deposits, Invoice,
Payments and Container import, what would be the best order to set these
up