Forum Discussion

ChrisSwirtz's avatar
ChrisSwirtz
Qrew Cadet
7 years ago

Trouble setting up table to table relationship

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 t...
Relationships
Tables and fields
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
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.