Another Dlookup ?

[Thompyt]

I have:
IIf([Lin]="XXB840",DLookUp("[unique]","[Data]","[unique] ='" & [parent] & "'" & " And [Lin]='[Mounts].[MountLin]'"),"")


Tables1
..Data
....Fields: all are Short Text
.....LIN
.....Unique
.....Parent

Table2
..Mounts
....Fields: Short Text
.....MountLin



Mounts.MountLin = Data.Lin but filtered down.

How do I look up the parent if Mounts.lin

[ranman256]

you dont use DLOOKUP in a query. The QUERY is the dlookup. Join your data table to the Lookup table.