Text Concatenation Follow Up Question

[Guest]

Thanks again to Duane for his invaluable concatenation function.
Here's a follow up to concatenating text between a master and child table
with a 1-many relationship:
My child table uses a lookup table for its values; When I use the
concatenate function it returns the secondary child lookup tables key value,
not the text value. How should I get the substitution correct (given
differing primary/secondary/tertiary keys between 1st/2nd/3rd tables) TIA!!!

 

[Duane Hookom]

Replace the table name in the SELECT statement with the name of a saved
query that contains the fields/columns you want to return from the
concatenate function.