No luck with reverse relationships....HELP in lamens terms

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
Ok I have more than one table in an app but they are all embedded in a main page. The current issue is a purchase order table and a need to look up child records from there into a report comprised mostly of fields from the parent table. I can make the one project has many purchase orders but cannot figure out how to make the reverse relationship to pull in the Customer PO number to the report.

Can someone spell this out like I was a two year old, because that is how I am feeling about right now.

Record ID# is the key field in all of my tables at this point
Photo of Joey Zint

Joey Zint

  • 1,800 Points 1k badge 2x thumb

Posted 2 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 69,572 Points 50k badge 2x thumb
How many children are there typically in a Parent Project record. Are you looking to pull like the first few POs from the first few children?  How many Children does the app realistically need to handle?
Photo of Joey Zint

Joey Zint

  • 1,800 Points 1k badge 2x thumb
Typically in this case each project will need to report one purchase order per project.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 69,572 Points 50k badge 2x thumb
Ok no problem then.  1is a  small number.

Make a field which is a summary minimum of the [Record ID#] of the child purchase orders.  Call it [Record ID # Purchase Order #1]

Then make a reverse relationship wher 1 Purchase Order has many Projects.  But on the right side, for the reference field of the relationship, use that new field you just created.  Then lookup the CUstomer Purchase Order down (up??) to the Parent Project and call it [Customer Purchase Order #1.
Photo of Joey Zint

Joey Zint

  • 1,800 Points 1k badge 2x thumb
It is showing a numeric value, I need it to show the actual PO number which also contains letters.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 69,572 Points 50k badge 2x thumb
Did you make the reverse relationship?  What field did you select to lookup from the purchase  to the Project?
Photo of Joey Zint

Joey Zint

  • 1,800 Points 1k badge 2x thumb
The field I created above which is the Record ID#.....I may have already solved my problem

One more....since this is a master app that is going to have many programs, many projects, and many embedded tables.....does it make since to do intermediate table with many to many relationships instead of creating all of these summary fields and look ups and is this any easier to do.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 69,572 Points 50k badge 2x thumb
I cannot answer a general question like that other than to say that if you have a need to move text data from children up to the Parent record, then this is the only way to do it using native QuickBase.  Having a many to many relationship does not change that method.
Photo of Joey Zint

Joey Zint

  • 1,800 Points 1k badge 2x thumb
Thanks Mark...figured it out with trial and error just like life.!
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 69,572 Points 50k badge 2x thumb
OK, glad to hear its working.