One to many to a single record

  • Thread starter Thread starter Randy Hartwick
  • Start date Start date
R

Randy Hartwick

I have a database designed to maintain Firearms Permit
information. The main table has information about the
applicant and has approximately 70 fields. A second table
has information on firearms owned and contains 15 fields
for each firearm. The second table is related to the main
table in a one-to-many relationship.

I need to create a Plastic ID card that will print the
applicant information on the front of the card and list
each firearm owned on the back of the card.

My problem is that all of the ID Card creation software
that I have found will not handle data from a one-to-many
relationship. All of them require that all information
printed on a single card be contained in a single record.

Is there a way that I can extract the data from the
relevant fields of the main table (18 fields) and the data
from relevant fields of the second table (5 fields for
each firearm owned - potentially 15+) and place all of
this information in a single record. (I have been
thinking an array might work but am unsure of how to do
this in MS Access).

Thanks for any help.
 
Shobha,

Thanks for the reply. But your solution (unless I
misunderstood it) still results in the data from the one
to many relationship being in more than one record.

That won't work with any ID Card software that I have
found. They all need all of the information contained in
a single record.

Thanks,

Randy
-----Original Message-----
Hi Randy!

I don't know any of the ID Card Creation S/Ws. I am
Click to expand...
assuming you already have the two tables in MS-Access
joined by the one to many relationship. In that case,
create a Select query. Add both the tables to the design
view of query. Make sure that the join between the tables
is visible in the design window. Drag the fields you need
from each of the tables. Run the query and you are all
set!!!!
 
Back
Top