Re: Comparison between two tables and display the outcome on one column using the API_DoQuery

Thank you. I am developing an application that has five tables. An agent is has a one to many relationship to a float table where floats are transferred to agents and once the previous float has been cleared, they can get more, this data is input one by one therefore sending a corresponding value to the Reconciliation table. These agents do get customers and they can only where they sell tokens and get the money in return via Cash or Cheque and deposit into the bank. These types of deposits have been associated into two separate tables. The final table is the Reconciliation table that flags any float that has not been deposited onto the bank. Bank records are uploaded once every day from a spreadsheet into the Cash/ Cheque tables and should get the deposit amount into the Reconciliation table using the ImportFromCSV_API This should be matched with the date and reference number in the Reconciliation table to add the deposit amount. My challenge is it dumps all the records without matching any values in the Reconciliation table. There is no relationship between the Reconciliation and Banc/ Cheque tables respectively.

I have not applied any code but i am planning to use javascript and add the query to match the criteria. How can I apply this?

------------------------------
Daniel Othwolo
------------------------------