setting up tables

[Bicycle Bel]

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

 

[Steve]

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
(e-mail address removed)

 

[John W. Vinson]

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

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]

 

[Pat Hartman \(MVP\)]

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