Forum Discussion
AlexCertificati
7 years agoQrew Cadet
If I'm reading you correctly (never a sure thing), you'll need to create either A) relationships between the Locations table and any tables where you have a Location and want the related Region to show up, or B) a Region field in the intermediate table that looks up to the Location table, which field you'll then look up from there to your parent table.
So I think you have
PARENT table with [Related Company] as a field
COMPANY table with [Location]
LOCATION table
So you either need a relationship between PARENT - LOCATION so that your lookup field in PARENT can 'see' the LOCATION table, or you need to look up [Region] onto the COMPANY table via [Location] and then look up the Region again from COMPANY to PARENT. Which way I guess depends on the nature of your PARENT table. Does that make sense?
So I think you have
PARENT table with [Related Company] as a field
COMPANY table with [Location]
LOCATION table
So you either need a relationship between PARENT - LOCATION so that your lookup field in PARENT can 'see' the LOCATION table, or you need to look up [Region] onto the COMPANY table via [Location] and then look up the Region again from COMPANY to PARENT. Which way I guess depends on the nature of your PARENT table. Does that make sense?