AnsweredAssumed Answered

Value list from seperate table

Question asked by BrianWilliams on Sep 24, 2010
Latest reply on Oct 5, 2010 by philmodjunk


Value list from seperate table


I have been searching for instructions to do this, but I must not be using th correct FileMaker terminology:

I have a membership table that includes a number field called MemberTypeId.  I have another table that describes the membership types such as member, non-member, corporate member and so on.  This is so my user can go to the MembershipType layout and maintain member types. 

As I stated before, the type Id is stored in the membership table to allow joining by ID number to the type table when running reports or whatever.  So, in the Membership layout, I want to have a dropdownlist of Membership Type descriptions to allow selection, but to store the type ID in the actual field.  So If my user enters a new type via the membership type layout, it will be available in the membership table layout.

I have read about value lists where you enter your own custom list, but I'm not sure this is the correct thing to do in order to allow users to maintain.  Is there a way to do this?

If there is a more FileMaker type of method to do this, please explain.