Change to list box on subform that populates table

[smg]

I have a list box in a subform that allows users to select the Error from this Error Table and write it to a Detail table:

ID Error Desc
1 A Alpha
2 B Beta
3 C Charlie

Now they want to add subcategories to Error Table and have it write the ID to the detail table as shown below:

ID Error Desc Subcategory


1 A Alpha 1
2 A Alpha 2
3 A Alpha 3
4 B Beta 1
5 B Beta 2
6 B Beta 3
7 C Charlie 1
8 C Charlie 2
9 C Charlie 3



How can this be done easily?

[ranman256]

the subform will use combo box as the key
they choose combo =A
the subform will add the A , then the user need only add Sub CAT (& date?)

be sure to bind the subform to the masterform:
LINK MASTER FIELDS=[ERROR]
LINK CHILD FIELDS = [ERROR]

[ssanfu]

BE aware that "ERROR" is a reserved word in Access and shouldn't be used for object names.

[Micron]

So is DESC, if it matters to anyone.

[ssanfu]

Ack!! I missed that one....

[smg]

Great thank you all