query probelms

[Pkobo58 via AccessMonster.com]

I am a new access user and haveing problems joining tables into a query.
table A is a list of engineering spec numbers and ES_id
table B a list of details pertaining to the ES (namem rev, etc)
table C is a list of procedures numbers pertaining to a ES. This table can
have from 0 to 10 precedures per ES.
Table D is a list of details pertaining to the procedures (name, rev etc)
Table E is a list of drawing numbers pertaining to a ES. This table can have
from 0 to 10 drawings per ES.
Table F is a list os details pertainging to each drawing.
I have no problems linking table A and B becasue it is a one to one
relationship.
Also no problkems linking tables C and D and linking E and f.
The problems I am haveing is linking tables A and c and A and D.
I want the data to come out like this:

ES # and details
LP (process number) details
LP (process number) details
Draing number) details
I've tried lookups and don't get the correct results. what am I doing wrong.

 

[John W. Vinson]

I am a new access user and haveing problems joining tables into a query.
table A is a list of engineering spec numbers and ES_id
table B a list of details pertaining to the ES (namem rev, etc)
table C is a list of procedures numbers pertaining to a ES. This table can
have from 0 to 10 precedures per ES.
Table D is a list of details pertaining to the procedures (name, rev etc)
Table E is a list of drawing numbers pertaining to a ES. This table can have
from 0 to 10 drawings per ES.

Why 0 to 10 - why not as many records as you need? Each drawing should be in
its own record; E should have fields

DrawingNumber <Primary Key>
ES_ID <link to A>

Table F is a list os details pertainging to each drawing.
I have no problems linking table A and B becasue it is a one to one
relationship.

So there is one and only one detail for each ES? Or are you "committing
spreadsheet" by having one *field* for each detail? One to one relationships
are quite uncommon; if it really is a one to one, you could just include table
B's field in table A.

Also no problkems linking tables C and D and linking E and f.
The problems I am haveing is linking tables A and c and A and D.

Is there an ES_ID field in C or in D? How are you trying to do the link?

What is the Primary Key of each table?
What (if any) Relationships have you established in the Relationships window?

I want the data to come out like this:

ES # and details
LP (process number) details
LP (process number) details
Draing number) details
I've tried lookups and don't get the correct results. what am I doing wrong.

Since you don't say *how* you've "tried", nor what the errors were, I'm a bit
in the dark!

John W. Vinson [MVP]