Multiple fields in single record

[Guest]

If anyone can help me I would grealy appreciate it. I have two tables one
labeled LSV
and on labeled Delta Q. I need to of the fields from Delta Q, their serial
numbers, assigned to one record in the LSV table. I have not found a way to
insert two fields into one record yet. Thanks for your time and I appologize
for the lengthy question.

Josh

 

[John Vinson]

If anyone can help me I would grealy appreciate it. I have two tables one
labeled LSV
and on labeled Delta Q. I need to of the fields from Delta Q, their serial
numbers, assigned to one record in the LSV table. I have not found a way to
insert two fields into one record yet. Thanks for your time and I appologize
for the lengthy question.

Josh

It's much too short a question to be readily answered.

I presume you meant to say "I need TWO of the fields..." Do you mean
two fields in one record? or the same field in two different records?
Into what fields of LSV should these two fields be inserted?

Please give an example with typical data from a few records of Delta
Q, and the desired result in LSV.

John W. Vinson[MVP]

 

[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

 

[Pieter Wijnen]

I Assume

Table: LSV
LSVID (autonumber/long int /text)
....

Table: DeltaQ
DeltaQID (autonumber/long int /text)
....
LSVID (Long int/long int /text -corresponding to LSV.LSVID)

Create a Relation Between LSV & DeltaQ, with enforce referential integrity
HowTo:
Tools/relationships
Add Tables
Drag LSVID from LSV to DeltaQ & select the proper relationship

you can now create a main form for LSV with a subform for DeltaQ &
auto-create related data in DeltaQ
For Existing DeltaQ's you'd have to "manually" do the job. (using a
spreadsheet/texfile - to automate it is possible)

HTH

Pieter