DEar Experts,

I have three tables
Customer, Ledger, Inventory

In the Cust_Code of Inventory table some times stores customer code or
Ledger code or some times empty(cash purchase).

My purpose is while taking the report, if the cust_code is not empty i want to
retrieve customer name from Custome Or ledger name from Ledger based on the
value stored in the cust_code. how i will do that
pls help me.

Regards
Abdulla