AnsweredAssumed Answered

Relationships and drop down values

Question asked by kilbot on Mar 6, 2013
Latest reply on Mar 7, 2013 by philmodjunk


Relationships and drop down values


     I have three tables


     on the STATS table I want to create a drop down to show the units (records) I created in the UNIT table. Then I want a drop down on the stats table to CODES but it will only show me the codes related to the unit I selected from the UNIT table.

     i thought I needed to create the fields on the STATS table and have them use drop downs from the fields I wanted on the UNIT and CoDES table but no matter why unit I select when I go to select the codes I can see them all. 

     Lost appreciate any help