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