Relationships between two tables

[Guest]

I have two tables created and I have a one to many relationship on them. The
table I am using in my report has two foreing keys to draw information from
two places in the other table. Why is it that when I view the report it just
shows the autonuumber i used to call it with? What do I need to do to get the
information in the report instead of the number used to import the
information.
Example:
Table 1 is LSV-2472 with fields
LSV-2472-Autonumber
Serial Number-text
Delta Q1-number
Delta Q2-number
Table 2 is Delta Q with fields
Delta Q-Autonumber
Serial Number-text

The relationship is between Delta Q1 and Delta Q2 on the LSV-2472 table,
both of these connect to Delta Q on the Delta Q table.
I put the autonumber in the Delta Q1 and Delta Q2, using them as foreign
keys. What I want in my report is the serial numbers from the Delta Q table
not the autonumbers, How do I do this?

 

[John Vinson]

I have two tables created and I have a one to many relationship on them. The
table I am using in my report has two foreing keys to draw information from
two places in the other table. Why is it that when I view the report it just
shows the autonuumber i used to call it with? What do I need to do to get the
information in the report instead of the number used to import the
information.

Base the report on a QUery joining the two tables.

The foreign key is just that - a link to the other table. It doesn't
contain the data from the other table!

John W. Vinson[MVP]