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?