Trouble setting up table to table relationship

  • 0
  • 1
  • Question
  • Updated 2 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

  • 70 Points

Posted 2 months ago

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

QuickBaseCoach App Dev./Training, Champion

  • 57,468 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?