J
Jay S.
This has been evading my best work for the last few days, so I'm hoping
someone here can help me out with this problem.
I'm working on a printer cartridge change database, and have it set up so
that when a user selects a specific printer model from a dropdown list, the
correct cartridge is automatically selected. This works with no issue, but
only if the printer model only has one type of cartridge. If a printer
(color) has multiple cartridges, I cannot add multiple listings to my table
without changing the primary key (reference my setup below) to another field,
and doing this then causes the form to totally blank out. Setting a primary
key to an Autonumber in the table to allow multiple entries won't work as
well.
I need to have it so that a user can select a printer model and then have a
list box that contains multiple cartridges for that specific printer model,
if it has multiples. If it's just a single cartridge, then it puts the
correct cartridge in the list box (currently works for single only).
All relationships have referential integrity enforced on all.
tblMain - contains data entry information for form
-------
Serial Number (key)
Printer Resource Number
Printer Model (linked to tblPrinter in One-to-Many)
tblPrinter - has just Printer Model Numbers
someone here can help me out with this problem.
I'm working on a printer cartridge change database, and have it set up so
that when a user selects a specific printer model from a dropdown list, the
correct cartridge is automatically selected. This works with no issue, but
only if the printer model only has one type of cartridge. If a printer
(color) has multiple cartridges, I cannot add multiple listings to my table
without changing the primary key (reference my setup below) to another field,
and doing this then causes the form to totally blank out. Setting a primary
key to an Autonumber in the table to allow multiple entries won't work as
well.
I need to have it so that a user can select a printer model and then have a
list box that contains multiple cartridges for that specific printer model,
if it has multiples. If it's just a single cartridge, then it puts the
correct cartridge in the list box (currently works for single only).
All relationships have referential integrity enforced on all.
tblMain - contains data entry information for form
-------
Serial Number (key)
Printer Resource Number
Printer Model (linked to tblPrinter in One-to-Many)
tblPrinter - has just Printer Model Numbers