Text Expressions

[tubar]

i have a master table with various lookup feilds. i want to create a querie that creates a text expression feild called description and it is based on the info provided in the lookup feild. problem is when i create this querie from the location master it provides the id's from the lookup colums and not their text.

any solution

 

[tubar]

How do I fix this to specify each table
Description: [level] & " " & [room] & " " & IIf(IsNull([direction]),[location],[direction] & " " & [location] & " " & [fixture] & " " & [note])

 

[Banana]

Tubar, I think you want to know how to refer to which table you want to use for field?

Expression: [TableName].[FieldName] & " " & [TableName2].[FieldName2]

Is that what you were asking about?