Invoice Table and Ledger Voucher Table Joining Issue in ODBC.

Discussion in 'Tally Developer' started by Rohit Jadhav, Jan 29, 2020.

    
  1. Rohit Jadhav

    Rohit Jadhav New Member


    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
     


  2. teja varma

    teja varma Active Member


    use xml http request instead..
    you can query whatever info you need by sending custom request(including tdl)
     


  3. Rohit Jadhav

    Rohit Jadhav New Member


    can you provide me some code how to get data from xml .
     


Share This Page