🚀 go-pugleaf

Patricia Dilmore wrote:
> 
I found the solution for the reports problem.  If I set appropriate
filters on the two linked tables, I can use the canrender event of the
report's detail bands, and create a function that prints the parent
record only when the child rowset is not 'endofset'.  You have to attach
the canrender to all detail bands that involve parent fields.  It works
with select WHERE, rowset filter and with cangetrow.  

The grid issue is still a problem.  Maybe there is some alternative
approach to this too.  Let's say you want to display a patient ledger,
and allow a payment to be allocated between several bills open for the
patient.  You need to filter the bills table on patient number and
filter the lineitem table on paid = false, and then display fields from
both tables in a grid.  It has to be editable, because the objective is
to disburse the payment check among the items being paid.  As I think
about it, I suppose you can display the ledger in a listbox, select from
the listbox, and provide entryfields that capture the payment amount and
update the record.  A lot of programming.  Anyhow, thanks for help.

Patricia