I have Issue in joining the invoice table and voucher table in odbc. 1. There is Invoice table in which it has some detail but it doesn't contain the whole information about the sale 2. The information related to the Sale I need is in ledger voucher table 3. I cannot find the foreign key in both the table to join them. So please Help me in finding the foreign key so that i can combine both the information in odbc
use xml http request instead.. you can query whatever info you need by sending custom request(including tdl)