T
tidwellbj
I am trying to create a simple subform but for some reason it is not working.
Table 1 - tblequipmentprice (This table is fixed priced) one to many to
table 2
ID - (PK)
DESCRIPTION
UNIT
PRICE
Table 2 - tblinstallqty
IDqty (PK)
quantity
ID
I am trying to create a subform where I can select DESCRIPTION from a combo
box and it auto fills the records for UNIT and PRICE. Then the only
information that needs to be inputed is the QUANTITY field.
The problem I am having is when I select from the combo box it pulls the
records back into table 1 (which shouldn't). I have tried to do a query but
still have the same problem.
Table 1 - tblequipmentprice (This table is fixed priced) one to many to
table 2
ID - (PK)
DESCRIPTION
UNIT
PRICE
Table 2 - tblinstallqty
IDqty (PK)
quantity
ID
I am trying to create a subform where I can select DESCRIPTION from a combo
box and it auto fills the records for UNIT and PRICE. Then the only
information that needs to be inputed is the QUANTITY field.
The problem I am having is when I select from the combo box it pulls the
records back into table 1 (which shouldn't). I have tried to do a query but
still have the same problem.