bernie05
December 26th, 2005, 10:30 AM
I have a database which contains both Vendor AND customer CODE in the same field, and I'm trying to display the NAME for either the Vendor or Customer depending on the transaction, with the following...
----------------------------
if {IM5_TransactionDetail.TransactionCode}='PO' then {AP1_VendorMaster.VendorName} else
if {IM5_TransactionDetail.TransactionCode}='SO' then {AR1_CustomerMaster.CustomerName}
else " "
---------------------------
but I am only getting the customers,
Thanks for your help,
Bernie
PS: I have attached a pic of the linked tables
----------------------------
if {IM5_TransactionDetail.TransactionCode}='PO' then {AP1_VendorMaster.VendorName} else
if {IM5_TransactionDetail.TransactionCode}='SO' then {AR1_CustomerMaster.CustomerName}
else " "
---------------------------
but I am only getting the customers,
Thanks for your help,
Bernie
PS: I have attached a pic of the linked tables