Cascading combobox from multiple tables

[BMag]

I have searched this forum and FAQ's for cascading combobox and have not come across something to assist me with this version of cascading combo boxes. Any thoughts would be apreciated.

I have 2 combo boxes and 4 tables to deal with.

Combo boxes: cboQtyLocID and cboQtyLocation
Tables: LocationID, LocStored2C, LocStored3S, LocStored3R
LocationID has 3 fields
Each of the other tables has one field named [LocStored]

The first combo (cboQtyLocID) - (bound column is(1)) is populated with the following SQL:

SELECT LocationID.LocationID, LocationID.LocationName, LocationID.LocTableName
FROM LocationID
ORDER BY LocationID.LocationName;

What I would like to achieve is to have cboQtyLocation populated with data from the table associated with the selection from cboQtyLocID. The required table name can be obtained from LocationID.LocTableName.

I have not been able to work out the SQL for this yet.

 

[Rich]

Why do you have separate tables for LocStored when it appears that you only need one?

 

[BMag]

The data is not related

The data is not related. LocStored2C has 16 records while LocStored3S has 25 records and LocStored3R has 5 records
LocStored tables are storage locations in various areas.