I've got what should be a simple situation: an invoice table and a payment table. There are many payments for each invoice. The invoice table has an integer primary key field, PKEY; the payment table has an integer foreign key field, INVFKEY. The tables are related in the database and in the DataEnvironment of my form. I've even tried setting a relationship in the INIT method of the form. Nothing works: the grid that is supposed to show payments against the selected invoice shows ALL payments in the payment table. The pointer is OK, i.e., I am pointing to the first payment for the target invoice. However, I can scroll up and down from there thru all payments for all invoices.

I have tried setting a filter, which I thought would be optimized; too slow (there are already 12K+ payments on file). I tried creating a view (which I thought would be optimized). The REQUERY is slower than the filter. I have deleted the grid, recreated it, and used the builder. Same results.

I have optimistic table buffering. The form has page frames. First page frame is the customer selection. Second page is the invoice with the payment grid. ARGHHH!! Any ideas out there as to what I am doing wrong or what I could try to make it work? I have run out of options.

TIA.

John