Display data field from latest child in the parent form

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
I have a parent table for clients and a child table for quotes.  Each client has multiple quotes and each quote is a revision of the previous quote.  There is a field in the quote form for dollar value.  I want to be able to insert the dollar value from the latest quote onto the client form so I can see the value of the most recent quote.
Photo of Joe Kirchner

Joe Kirchner

  • 100 Points 100 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,296 Points 50k badge 2x thumb
If the quotes are entered in order, then what you want is to identify the most recent quote.

Do a Summary Maximum on the relationship to get the Maximum [Record ID#] up to the Client. call is [Record ID# of Most Recent Quote]

Look that up down to the Quote again and call it 

Then do a new summary maximum of the Quote value subject to the filer that the [Record ID#] is equal to the value in the field [Record ID# of Most Recent Quote]

There will only be 1 record that matches so you will have that value up on the client record now.
Photo of Joe Kirchner

Joe Kirchner

  • 100 Points 100 badge 2x thumb
Worked like a charm.  Thanks!