Between a rock and a hard place

[TBird]

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
form to be able to select which sub(s) are being used for eac
particular contract. So what I need is a check box linked to each o
the subcontractor names. How can I link the names in each record to
check box

 

[Dirk Goldgar]

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.

 

[Tamara]

TBird,

Have you thought about using the contacts folder in outlook. The contacts
file will allow you group subcontractors together. You can also customize a
tab specificaly for subcontractors.

 

[Tamara]

Dirk,

I was thinking the same thing. I don't see a need for acheckboxe unless she
will enter a field that will require a check mark to be entered.

 

[Van T. Dinh]

The O.P. posted from "ExelForum" so there is a good chance of an
"Excel-imitated" database structure.

TBird

Most likely, you have a Many-to-Many relationship and you need at least 3
Tables as Dirk already pointed out.

Perhaps, you should check Access Help / your Access book on the Many-to-Many
relationship and how to model this in a relational database. (subjected to
Dirk's agreement <smile>).