1 Reply Latest reply on Mar 7, 2013 9:47 AM by philmodjunk

    Relationships and drop down values



      Relationships and drop down values


           I have three tables

           STATS, UNIT, CODES

           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