Best way round my value lists issues
I am currently building a database to work with out customer logging and support logging. In this database we have the customer information and the machine information. As we are an Apple Specialist company we only deal with apple products.
I would like to select the product type (i.e. macbook, iMac, iPad etc)
then have a selection of AppleCare Name (i.e. 15in macbook pro late 2011, 13in macbook air late 2009)
once the model has been selected i would like to select the processor speed
Then once the processor speed has been selected i would like the other fields to automatically populate based on the record found in my "Devices List Table"
i have uploaded a few images for you to see what i am on about. I have been struggling with this for a while now.