Forum Discussion

Qrew Trainee

11 years ago

How to use formula or summary field to get latest record data?

I have a table sales and a child table of products. I am trying to find the latest related child (products) field "price". I can create a summary field on the parent to get the latest date but it wi...

Formulas and functions

Relationships

reports and charts

QuickBaseCoachD

Qrew Captain

7 years ago

I suppose if you are desperate enough you could set up a Sync table for the Child table and on that table make the Key field be the Record ID# field. Set it up to Sync update once an hour.

The do the reverse relationship using that table. I have not totally thought it though it there is a solution in there somewhere.