Query error

[ptquan]

Hi there,

I have 2 table:
tblJobInfo include: JobNumber, SHPPR, CNEE, AGENT
tblSupplier: SuppCode, SuppName

SHPPR, CNEE, AGENT look-up a SuppName in tblSupplier
In the query the tblJobInfo, I want to exract a value as:
Iif(SHPPER=Null, CNEE, SHPPR), the output is not SuppName as my expect but the ID. How can I extract the SuppName?

Many thanks,
Quan

 

[pr2-eugin]

Hello Quan, Welcome to AWF..

Sounds to me like, the Field in the table is set up as Lookup.. Do not use Lookup's at table level.. They will cause only confusion.. Remove Lookup's and use JOIN to get the field you wish to obtain..

 

[ptquan]

Hi Paul,

Thanks for your advice. I will make a change then.

Thanks again.

Quan