Good day to you all,

We were indeed very pleased to see some of the new functions in Gridview 9.0C especially those that let us emulate a SQL join.

I have been working with the GetLinkedValue() call and have it working but am at a loss as to which tables to use.

I am trying to create a view that would include invoices data and the corresponding payment data.

Fields such as Inv#, InvDate, InvAmount, PaymentDate, PaymentAmount etc...

I understand the limitation that only the first reference to a matched payment will appear and ponder if anyone has been down this path before and has come up with something reflective of the underlying data.

Any help / ideas would be appreciated!

Thank you and,

Cheers, JK