Two fields to one record

[Guest]

Sorry about the confusion, I did not realize I had so many typing
errors. Yes
I did mean Two fields in One row. An example is: In my Delta Q table I have
The fields ID and serial number.The ID is set to auto number and is my
primary key. The LSV table has the fields unit serial number and ID with unit
serial number being the primary key.
What I'm trying to do is take two of the serial numbers from the Delta
Q and
relate them to one record from the LSV table. I really don't know how else
to explain this problem. Once again thank you for your time and I hope this
is enough information.

Josh

 

[John Vinson]

Sorry about the confusion, I did not realize I had so many typing
errors. Yes
I did mean Two fields in One row. An example is: In my Delta Q table I have
The fields ID and serial number.The ID is set to auto number and is my
primary key. The LSV table has the fields unit serial number and ID with unit
serial number being the primary key.
What I'm trying to do is take two of the serial numbers from the Delta
Q and
relate them to one record from the LSV table. I really don't know how else
to explain this problem. Once again thank you for your time and I hope this
is enough information.

Josh

I'm sorry, I'm still baffled. Relationships are NOT defined between
records, but between tables!

A given record in the Delta table can have one and only one serial
number right?

And you want to relate two of the serial numbers (two of the one!?) to
the LSV table?

It would help visualize the situation if you could post an example of
the content (messed up to preserve privacy if need be) of one or two
records in each table, and indicate how you want this relationship to
be created.


John W. Vinson[MVP]