Conditional Sub-Category Drop Down?

[Rick Lane]

Experienced Access Convert due to current employer purchasing FM, needing help with what is a 30sec task in Access, but has so far consumed three hours of my life in FM.

The DB I am creating is for Inventory Control.

One of the aspects I am having trouble with is Storage Areas and Locations.

I have in my item table ´inventory_items´ a field called ´Storage Area´ which is populated with a drop down, that pulls values from another table called ´SA´, values XYZ.

I have another field ´Storage Location´, which is also a drop down, but needs to populate with values ABC if X is chosen in the previous drop down - and DEF if Y etc.

My question is how the heck do I do it?

[TheTominator]

Maybe this will help.

You didn't specify if the Storage Location values to be chosen are coming from a new Storage Location table (SL) or are a static set of values.

Assuming that the values are coming from another table that defines which ones are associated with which Storage Areas, the following example may be what you seek.

ConditionalValueList_fp7.zip

[Rick Lane]

Thank you very much, perfection! You are correct in presuming it is within another table.