Why doesnt this work?
=DLookUp("[Masternr]";"Masterinfo";"Masterinfo.Masternr = " & [Masternr])
cant i look up values from other tables in a report?
Masternr is both a field in my recordsource, and a filed in the table Masterinfo, which is not in the recordsource.
What is wrong here?
=DLookUp("[Masternr]";"Masterinfo";"Masterinfo.Masternr = " & [Masternr])
cant i look up values from other tables in a report?
Masternr is both a field in my recordsource, and a filed in the table Masterinfo, which is not in the recordsource.
What is wrong here?