TBird said:
HELP! I have a list of 100 companies that do subcontracting for us.
Also in this table is other info like address, phone, etc.... I need
a form to be able to select which sub(s) are being used for each
particular contract. So what I need is a check box linked to each of
the subcontractor names. How can I link the names in each record to a
check box?
I don't quite follow you. As I understand it, you want to establish by
selection, for a given contract, which companies are subcontractor for
that contract. Is that right? There are several ways to do that, but
where does the check box come in? Where is this hypothetical check box,
and what field in what table is it bound to?
If I've understood you correctly, you need a Contracts table, a
Subcontractors table, and a ContractsSubcontractors table to link the
two. Is that the way you have it set up?
The simplest way to do this is with a normal subform bound to
ContractsSubcontactors, on a main form devoted to Contracts. A combo
box on the subform is then used to select each subcontractor.
Admittedly, this simple method doesn't let you simply pick a bunch of
subcontractors at once from a list, and I think probably you're hoping
for a way to do that. Before going off in that direction, though, I'd
want confirmation that I've guessed the situation correctly.