AnsweredAssumed Answered

Relationship between fields with if/then

Question asked by GuenevereMcMahon on Feb 23, 2011
Latest reply on Feb 23, 2011 by philmodjunk

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. 

Outcomes