Assiming Table 1 has a Key StockNumberID (Auto, PK)
Table 2 has a Key JobNumberID (Auto, PK) - I hate
underscores
Your Third table should be
StockNumberID
JobNumberID
UnitsNeeded
You must set both StockNumberID and JobNumberID as joint Primary Keys
(Highlight them both & press the Key symbol)
Then set up your relationships with the 3 tables linking the obvious fiels
together
This will allow you so see all the stock reqired for each job or which jobs
are using a particular stock item
Phil
<pa*********@btinternet.comwrote in message
news:a8**********************************@k30g2000 hse.googlegroups.com...
How to set up a many to many relationship. I know you need a third
table to join the other two. I need one table (table1) with
stock_numbers(unique), one table (table2) with job-numbers(unique) and
I want to join them with a table (table3) with job-number linked with
a stock-number and the number-of-units-of-that-stock.
how is it done? so that the relationship window shows up:
table1 many to one table3
and
table2 many to one table3
Paul