I am trying to embed an editable table containing child records to a parent table that has a conditional proxy field. Help!

  • 0
  • 1
  • Question
  • Updated 9 months ago
  • In Progress
My Parent table, "Release Orders" has many "RO Line Items."  I have another relationship where "Line Items" have many "RO Line Items." When the user adds an RO Line Item from the Release Order, their Proxy Field, "Select a Line Item" is a conditional lookup field - where the Line Item OA# must equal the RO OA Number. My users do not want to add line items where they have to save each time.

I want to embed a grid editable table within my Release Order Table that allows users to select their Line Item quickly - but I am struggling with the condition of first having to choose the OA Number. There has to be an easier way...
Photo of nancy

nancy

  • 114 Points 100 badge 2x thumb

Posted 9 months ago

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

QuickBaseCoach App Dev./Training, Champion

  • 53,038 Points 50k badge 2x thumb
Are you looking to launch off a Release Order record and be presented with a list of appropriate Eligible Line Items and quickly click click click to select the ones they want ( say 3 so 3 clicks) and then return to the Release Orders to see the newly added child RO Line Items on the Release Order parent?
Photo of nancy

nancy

  • 114 Points 100 badge 2x thumb
yup! EXACTLTY
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,038 Points 50k badge 2x thumb
This is a very similar question to this one so it the same answer.  I do this all the time for my clients.

https://community.quickbase.com/quickbase/topics/adding-groups-of-materials-to-work-order