Form for data entry

[Chky071]

I am creating a database to house all the information for a box content label. For any given product it could have multiple items that go on the label.



For example:

My_Part_1
1. Part_1
2. Electrical Assembly
3. Instructions
4. Warning Label

I imagine my database being setup as follows:

ID Model# Contents
1 Part_1 Part _1
2 Part_1 Electrical Assembly
3 Part_1 Instructions
4 Part_1 Warning Label
5 Part_2 Part_2
6 Part_2 Electrical Housing
7 Part_2 Housing instructions
8 Part_3 Part_3
9 Part_3 Instructions

I would like to setup my form so that I could type in the Model # once and then type in each item that would go in the box. I don't mind typing in each item individually and then pressing an "add" button. But I would like it to show everything that is currently on that box content label and be able to delete items out of the label.

Is this possible? What would be the best way to do this?

Thanks!!

[June7]

Consider a form/subform arrangement.

Do you have a table of unique Model#s?

BTW, should not use spaces or special characters/punctuation (underscore is exception) in naming convention. Better would be ModelNum or Model_Num.