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.
My questions:
1. Does anyone know of existing ID Card Software that will
handle a one-to-many relationship and will work with a
Fargo HDP ID Card Printer.
2. 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.
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.
My questions:
1. Does anyone know of existing ID Card Software that will
handle a one-to-many relationship and will work with a
Fargo HDP ID Card Printer.
2. 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.