1 Reply Latest reply on Feb 23, 2011 10:44 AM by philmodjunk

    Relationship between fields with if/then

    GuenevereMcMahon

      Title

      Relationship between fields with if/then

      Post

      I am building an inventory database for a theatrical costume shop. I am using a single table, and would like to create a relationship between the fields of "Gender" and "Size" such that if Gender=M then Size=male sizes and if Gender=F then Size=female sizes.If all values are part of one list for "Size", can I then choose which values will be related to Male and which will be related to Female? Or is there a way to have one field reference two lists? Most of what I am seeing in the help files refers to relationships between tables, and I haven't found where I would specify that if/then relationship.  

      Thanks in advance.