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

JanaBaker

Qrew Cadet

7 years ago

Thanks Mark! So I must be doing something wrong. For testing purposes due to failure...no matter what Parent side i create my summary "Max Record ID#" field on, i cant get it to show up in the drop down list when i create the new Relationship looking back at that table, so to speak.

Suggestions?