G
Guest
Item Number Description Unit Cost
DC-1037 Large Dish $1,000.00
DC-1010 Medium Dish $500.00
DC-1017 Small Dish $250.00
The above table is a 3 column lookup column in a form. This form was
created from another table that collects all my data. What I want to have
happen is when I select say DC-1037 (Record Source - ItemNumber in underlying
table) from the lookup column that the unit price gets displayed on the form
and recorded in the underlying table that has a record source (UnitPrice).
Disregard description, it is only informational to verify the item number is
correct.
DC-1037 Large Dish $1,000.00
DC-1010 Medium Dish $500.00
DC-1017 Small Dish $250.00
The above table is a 3 column lookup column in a form. This form was
created from another table that collects all my data. What I want to have
happen is when I select say DC-1037 (Record Source - ItemNumber in underlying
table) from the lookup column that the unit price gets displayed on the form
and recorded in the underlying table that has a record source (UnitPrice).
Disregard description, it is only informational to verify the item number is
correct.