Can someone help me with choosing a parent from the child record?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
I have an Events tables with some parents (Companies & Contacts), and I want to add a new parent Venues. Companies & Contacts work fine but with Venues, I can click Add Event from a Venue record and that works fine but when I choose a Venue from an Event record, the drop down appears, and it lets me make a selection but when I click save, it doesn't stick. I don't get any error messages. 

I'm thinking it has to be in the relationship somewhere but I don't see the issue.

Thanks for your help.

Photo of Josh

Josh

  • 40 Points

Posted 3 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 67,670 Points 50k badge 2x thumb
Please check if you managed to have the field for [Related venue] and [venue name] on the form at the same time.  99% what is happening is that these are both on the form and the second blank appearance of the data entry field is being used.  remove the [related venue] from the form and just use [venue name]
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,670 Points 50k badge 2x thumb
Please post back so I can mark this as Answered if that nailed it.
Photo of Josh

Josh

  • 40 Points
Yes and no. I didn't have [Related venue] and [venue name] but I did have [venue name] twice. I removed the 2nd instance of [venue name] and I'm good to go.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,670 Points 50k badge 2x thumb
Normally QuickBase prevents you from adding a data entry field twice - for the very problem you ran into, but sometimes the "protection" fails and its lets you have the same field twice - in that case the last appearance is the one that "takes"..