I have to create a report where i have to use Bankchequetable,ledgerjournaltrans,ledger journal table.I have one field “name” which has to come from vendtable.I am able to get the field by display method using find method on vendtable using bankchequetable.accountnum.but there is no relation between ledgerjournaltable and bankchequetable.i am not able to get proper data.
You cannot directly relate those two table. You may need to use an intermediate table(Eaxmple - LedgerJournalTrans)