how to enter and store multiple entries

[Boze]

I'm setting up a database to store info on our Items. One thing we need to
show is the Group(s) the item is associated with. Some items are part of
only one group, some are in multiple groups. Ie, a Widget is part of Group
"Pump" AND Group "Tool".

So far I've setup tblGroup with a relationship to the Item table. How do I
show MULTIPLE Groups for an item? Do I have to use a subform set to
continuous?

Thanks
Boze

 

[Rick Brandt]

I'm setting up a database to store info on our Items. One thing we
need to show is the Group(s) the item is associated with. Some items
are part of only one group, some are in multiple groups. Ie, a
Widget is part of Group "Pump" AND Group "Tool".

So far I've setup tblGroup with a relationship to the Item table.
How do I show MULTIPLE Groups for an item? Do I have to use a
subform set to continuous?

That is the usual method.

 

[pbrstrtgang]

I'm setting up a database to store info on our Items. One thing
we need to
show is the Group(s) the item is associated with. Some items
are part of
only one group, some are in multiple groups. Ie, a Widget is
part of Group
"Pump" AND Group "Tool".

So far I've setup tblGroup with a relationship to the Item
table. How do I
show MULTIPLE Groups for an item? Do I have to use a subform
set to
continuous?

Thanks
Boze


..
YES. You use a subform. Decide which form you want to be the
Master. If you choose Group then your Items will be subform and
only show records when related to the currently displayed Master
Group. You Master form will have to be single, the sub can be
continuous.