Please see the below Snap and attached simple Database TestDB , where Tbl_COTag Table "COLOR" field value Lookup "ColourName" Field value from Table "Tbl_HBColor" and Lookup String (ShortText) value populate in field "Hb_Eng_Col" on Table "Tbl_COTag" . Could you advise where I was mistaken ? Dlookup Not working on my TestDB which attached for your better understanding, your help and advise highly expecting.
Note : All are ShortText data
Tidak ada komentar:
Posting Komentar