Grandchild records

[kevin plummer]

Hi All,

I seem to be having a bit of trouble getting my filters right to display the correct records.

I have a form and a child browse. The field tran is the connecting field. As this is not unique for the child record, I have ID as the unique unchanging key.

So on the grandchild browse (or the child of child) I want to show all those with the same Tran but only those with the same line#. Again I have a field ID on this browse as the Unique, unchanging Key and is not related to the other browses.

So I have:

Invoice - tran
InvoiceDetails - tran+line, ID
InvoiceLog - tran+line, ID

I have set InvoiceLog to be a child of InvoiceDetails

When I click on differnt lines in the InvoiceDetails browse it does not update the bowse in the InvoiceLog screen.

I'm not sure if this is a limitation (because of the way me keys\fields are setup) or if it is just the way my filters are formed.

Thanks,

Kevin