AnsweredAssumed Answered

Relationships and drop down values

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

Title

Relationships and drop down values

Post

     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

Outcomes