RELATION SHIP

[Faisal]

Dears

i was about make a small progamm in ware house for stock updating in my
factory
please helpe me in its relation ship to have a good base for my work.


i have four table in my data base

first table is for spare parts number and its detail
Second table for its openign stock in ware house
Third table is for enter details of isuue(delivery) to customer
fourth table is for enter details of receipt(receive) from purchase

now i want to connect this table in relation ship window

Can you any body sujest a good methode for how to connect in relation ship
between this tables

I make some connection between table like First table in left side other all
table in right side
in the first table i have one filed called sapre parts number this filed i
want to connect to all table
how it is possible and while i am openig a form is comming "insert sub data
sheet" what is this???


pls help me

regards
Faisal
Riyadh

 

[Allen Browne]

There's a little screenshot in the middle of this article:
http://allenbrowne.com/AppInventory.html

It's very much like the tables you suggest, but it handles these factors:
- one delivery can contain many procducts (hence tblAcq and tblAcqDetail),

- one sale to a customer can contain many products (hence tblInvoice and
tblInvoiceDetail),

- the opening stock value is reset periodically (hence tblStockTake.)