Which Control does this?

[DeWayne Clinton]

I have a table of parts I want to be able to run a
queries that would pull up parts in groups. The parts
could belong to more than one group and the number of
groups can grow. So I have tables Parts, Groups, and a
table GroupParts which has three field Primary key,
GroupsID, and PartsID. I have a form that is used for
parts. I want to have a control on the form that you
could pull down a list or something and select which
groups the current part would apply to. This would have
to then write (or delete) multiple records in the
GroupParts table. Am I going about this wrong? What
control could do what I want?

 

[Media Lint]

A combo box is the control, but you'll need to code your
desired functionality.

 

[John Vinson]

What control could do what I want?

A Subform based on GroupParts (probably with a combo box based on the
table that isn't the recordsource of the mainform).