Folks, I was wondering if it is possible to limit the choices in a lookup based on the value in another field.
I have two tables..one called equip type and another called problems. For example purposes assume the equip type table may have items
Bill Changer
Vacuum
Wash Bay
The problem table has numerous problem descriptions and each description is associated with a specific equip type.
For example the problem description of "has no suction" would be associated to vacuum. while "bill stuck in acceptor" and "received no change" would be problems associated with the Bill changer type.
On a form based on a set of these two tables I will look up and enter a specific equipment type. The next item to be entered will be the problem ...I have a look up field which basically shows all the problems in the problem table...what I would like to be able to do is filter the values in the lookup based on the equip type..for example if I entered bill changer as the equip type when the lookup displayed at the next field it would only show the problems related to "bill changer" equip type.
I the problem table has the following fields
prob_id
prob_desc
equip_type_id
I link the tables with the equip_type_id. Hopefully I have explained this well enough that some of you can help me out with this. Thanks in advance. I did search for browse related items but did not find any like this...
I have two tables..one called equip type and another called problems. For example purposes assume the equip type table may have items
Bill Changer
Vacuum
Wash Bay
The problem table has numerous problem descriptions and each description is associated with a specific equip type.
For example the problem description of "has no suction" would be associated to vacuum. while "bill stuck in acceptor" and "received no change" would be problems associated with the Bill changer type.
On a form based on a set of these two tables I will look up and enter a specific equipment type. The next item to be entered will be the problem ...I have a look up field which basically shows all the problems in the problem table...what I would like to be able to do is filter the values in the lookup based on the equip type..for example if I entered bill changer as the equip type when the lookup displayed at the next field it would only show the problems related to "bill changer" equip type.
I the problem table has the following fields
prob_id
prob_desc
equip_type_id
I link the tables with the equip_type_id. Hopefully I have explained this well enough that some of you can help me out with this. Thanks in advance. I did search for browse related items but did not find any like this...
Comment