I have 3 files....

APMAS = master record for A/P
APDETL = invoices for A/P
APPAY = payments for invoices in A/P

These files are tied together by unique ID #'s for each file.

In "old school" programming, the rule of thumb was NOT to store totals of multiple records such as payments
towards invoices but to add them up again at the time of display. So, if I follow that thought....

I need to display in a listbox all the APDETL records for a selected client and also the total of all the payments
for the displayed APDETL record. An example would be

IVCDATE IVCNUM DUEDATE AMOUNT PAYMENT BALANCE
08/17/00 12345 08/17/00 $500.00 $100.00 $400.00

The payment is a sum of APPAY records for this invoice and the balance is the APDETL.amount - the total
of the payments.

I tried to due this with an SQL as follows:

select apdetl.ivcdate, apdetl.ivcnum, apdetl.duedate, apdetl.amount, sum(appay.amount), apdetl.amount-sum(appay.amount) ;
from apdetl left join appay ;
where apdetl.apmasid=apmas.apmasid and apdetl.apdetlid=appay.apdetlid ;
into cursor curLstApDetl ;
order by apdetl.ivcdate

but get a SYNTAX error. Is this the right track? What am I doing wrong? I thought of maybe
using a view but again couldn't figure out the SUM stuff. And I know, lots of people recommend
using a grid, but I hate grids and I want this to be a pick list, not one that they can edit or make
changes in. To get a grid to do this requires a great deal of "control" editing and then it doesn't
work 100% in my experience.

Suggestions?