I have a database with 5 tables, but most of the tables are to ensure that fields in the 5th table can only have certain values. I have one table that contains the values for 'type' and another one that holds the values for 'subtype' and associates them with 'types' via a relationship.
In the form for entering data into the 5th table, I have a combo box that contains all the types pulled from the types table.
What I want to achieve is to have a second combo box that updates every time the first combo box is changed. In other words, when the user selects a 'type', I want the 'subtypes' of that 'type' only to appear in the second combo box.
I can't seem to work out how to do this though, so suggestions would be greatly appreciated!
Thanks in advance,