Multiple outputs from one form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to be able to enter a components description and then its serial
number. After I enter the serial number I would like to enter another using
the same description. I have set up a form that uses a subform to display
the description multiple times. I end up with a table of descriptions and a
table of serial numbers and have no idea how to link the two together so that
the right serial number goes with the right description. Any suggestions on
how to accomplish this objective

Thanks
 
Jerri

I think your post contains your solution. You have two tables of facts that
are related to each other in a "many-to-many" relationship. To resolve
this, you need to create a third table, into which you place the IDs of
valid "pairs" from the two tables.

For example, this third table will have as many rows in which the
DescriptionID matches one of your descriptions as you have serial numbers
using that description.

This is not the solution you are looking for if you don't have a
many-to-many relationship between serial numbers and descriptions.
 
Back
Top