Many to many relationship

From: paulcjcross@xxxxxxxxxxxxxx
Date: Sat, 31 May 2008 13:22:13 -0700 (PDT)

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
.

Follow-Ups:
- Re: Many to many relationship
  - From: Phil Stanton

Prev by Date: Re: Save up to 60% On 3d Modelling, 3d Graphics and 3d Animation Services
Next by Date: Re: Maximising Access window
Previous by thread: Regulars are becoming Irregular
Next by thread: Re: Many to many relationship
Index(es):
- Date
- Thread

Relevant Pages

Re: Can this be done using a Data adapter??
... values to table3. ... view and manually run the insert or update SQL commands. ... have the 1st column read only and put the table1 values there). ... have done up to now is i bring the data of table1 and table2 from the ...
(microsoft.public.dotnet.languages.csharp)
Re: Appending tables
... So I will give the schema definations of the tables here: ... CREATE TABLE TABLE1 ... CREATE TABLE TABLE2 ... CREATE TABLE TABLE3 ...
(comp.databases.ms-sqlserver)
Re: Optimising the Query
... FROM TABLE1 TAB1 ... FROM TABLE3 ... The query is taking records from TABLE2 and TABLE3 and LEFT OUTER JOIN ...
(comp.databases.oracle.misc)
Optimising the Query
... FROM TABLE1 TAB1 ... FROM TABLE3 ... The query is taking records from TABLE2 and TABLE3 and LEFT OUTER JOIN ...
(comp.databases.oracle.misc)
Re: Optimising the Query
... SUM ... FROM TABLE1 TAB1 ... FROM TABLE3 ... The query is taking records from TABLE2 and TABLE3 and LEFT OUTER JOIN ...
(comp.databases.oracle.misc)