D
Double A
I would like to create a subform as a spreadsheet that has 2 columns. The
first column uses a drop down menu to choose a category (using a 2 column
combo box). I would like to have the choice made in the drop down menu for
category to automatically populate the second column, Info. The table
structure for this is as follows:
tblWorkLineItem
--------------------
WorkOrderNumber
LineItem Number Key field
Category uses look up table
Step uses look up table
Each category may have many steps.
Please help me with how to set this subform up. It needs to be connected to
the WorkOrderNumber.
Thanks.
first column uses a drop down menu to choose a category (using a 2 column
combo box). I would like to have the choice made in the drop down menu for
category to automatically populate the second column, Info. The table
structure for this is as follows:
tblWorkLineItem
--------------------
WorkOrderNumber
LineItem Number Key field
Category uses look up table
Step uses look up table
Each category may have many steps.
Please help me with how to set this subform up. It needs to be connected to
the WorkOrderNumber.
Thanks.