For some reason I’m just blanking on how to do this and I feel like it should be really simple.
I have two tables. One is a table with the Model and Manufacturer and the other is a Device table with Name, Model, Manufacturer etc. I have the Model table foreign key linked to the Device table so that if a protocol change in the Model table happens (i.e. HP becomes Hewlett Packard) it cascades and also so that when someone is entering the data into the device table they make sure they spell everything correctly.
I have a form set up to enter data for the Device table such that I want to have Manufacturer and Model as combo boxes. I have the source set up correctly so only Manufacturers in the Model table show up, but I can’t seem to get it so that when you pick a Manufacturer in the device table it only shows the models that exist for that manufacturer. My foreign keys are set up correctly because if I choose something like a Cisco model number but listed HP as the manufacturer it still throws an exception but I want to make sure only models for that chosen manufacturer show up.
How do I go about doing this?
