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

Ah, can you tell me the Key field of you child table - the real child table. Is it the usual [Record ID#] field or another text field. I suspect that the child table Key field is not the [Record ID#] field and hence you are "SOL".