Skip to main content
Question

how do i use a child record on a parent table?

  • July 26, 2017
  • 0 replies
  • 39 views
what I mean is, that I want value on the child's table on the parent table.
I have a relationship that goes from Customers to Invoices, I wanted to copy/link one of the records on the invoices table to the parent table. I was told making the relationship back and forth like that is not good, so someone please help?
    This topic has been closed for replies.

    • ChuckGrigsby
    • Quickbase Alumni
    • July 26, 2017
    Whats the criteria for the one related invoice you want to link? most recent? something else? You could create a summary field that chooses the maximum record ID for the child table. This should give you the most recent. However you can add additional criteria like if a field is set to a certain value, then it will be the most recent record that matches that criteria. Then on the summary field, choose to link to the related record. Place that summary field somewhere on your form on the parent table. Make sense?
    Terms & ConditionsAccessibility statement