Create a subset for a look up
I currently have a lookup that exists between two tables.
The first is a resource_ details containing resource details. In the table there :-
1)a field for resource name e.g gardner / senior gardener / grass seeds
2) is a drop down (resource type) that determines whether the resource name is a material or labour e.g if the resource type is "garden seeds" the drop down is set to materials.
Likewise if the resource name is "gardener" then the resource type is "labour".
I currently have a look up based on the resource name. However I want a lookup that shows me only those resources that have resource type of "labour".
The attach screen shot shows my current relationship diagram and the current drop down.