Trouble setting up table to table relationship

  • 0
  • 1
  • Question
  • Updated 4 months ago
  • In Progress
I have a PO Header Table and a PO Detail table and I am trying to set up a relationship between the 2 where there are many detail records attached to one header record. The common link between the 2 tables is the PO Number field. I thought that if I used the PO Number field as my reference field, it would automatically link the current information in the 2 tables together, however all I get is a drop down field in the child record where I would have to manually select the correct parent record. What am I doing wrong?
Photo of cs5469

cs5469

  • 80 Points 75 badge 2x thumb

Posted 6 months ago

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

QuickBaseCoach App Dev./Training, Champion

  • 67,348 Points 50k badge 2x thumb
Are you launching off the parent record when you are creating the detail lines or are you entering the PO# manually and entering child record starting off at the child record table?
Photo of cs5469

cs5469

  • 80 Points 75 badge 2x thumb
The problem is that the 2 tables are created from 2 separate spreadsheets full of data that I uploaded into QuickBase creating thousands of records in each table. What I am trying to do sync up the two tables of info using the one piece of info common to both tables, the "PO Number" field. It almost seems like I need to set up the relationship before uploading the spreadsheets? So basically create the 2 tables, each with a "PO Number" field. Then create the relationship between the two tables using that field as the key field, then upload the spreadsheets letting them create the rest of the fields?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,348 Points 50k badge 2x thumb
This part is quite correct;

So basically create the 2 tables, each with a "PO Number" field. Then create the relationship between the two tables using that field as the key field, then upload the spreadsheets letting them create the rest of the fields?

The Key field of the PO table should be set to be the PO#.  

But the Key field of the PO Lines table will just be the usual [Record ID#] field.