6 Replies Latest reply on Jan 3, 2011 12:42 PM by philmodjunk

    Create a subset for a look up

    Kaps_1

      Title

      Create a subset for a look up

      Post

      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.

      http://www.4shared.com/file/s3UDTgPK/forum_post_6.html

      thanks

      Kaps