Beginner - Categories and Subcategories

[gr_96]

I'm developing a database which has an asset register in it (plus other things).

Asset register has a categories field, but will also have subcategories; based on the category selection.

This is where I'm struggling...

I have the category field as a Value List (manually enter values) and then I've created a subcategory table, with the fields as each subcategory and the datatype being a Value List (manually entered values).



In the form I want the category to determine which subcategories appear.

Hopefully this makes sense... Help?

[isladogs]

Sounds like you need cascading combo boxes where the output of the first combo modifies the items listed in the second combo
If you do a forum search for this you will find numerous examples

[gr_96]

Yeah, this is what I've found when googling - I just cant get my head around it... Could you advise further in this thread? Or is there a decent step by step (non-specific) guide?

[isladogs]

Try this link: https://www.access-programmers.co.uk...d.php?t=275155