Linking Tables When Reference Field Already Exists

  • 0
  • 1
  • Question
  • Updated 4 months ago
  • Answered
I imported two spreadsheets into two separate tables, Districts and Schools. Each District has a District ID field and each School Record also has a corresponding District ID field. There are multiple Schools in each District. How can I set up a relationship between the tables so the District draws in the related School Records? I would like to avoid linking them 1 by 1 seeing as there are 18K+ districts....
Photo of Michael Horwitz

Michael Horwitz

  • 112 Points 100 badge 2x thumb

Posted 4 months ago

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

QuickBaseCoach App Dev./Training, Champion

  • 51,266 Points 50k badge 2x thumb
no problem,

Set the Key field of the District to be the [District ID] field.

Just make a relationship where 1 District has many Schools. 

Quick Base will helpfully offer to make a new data entry field called [Related District] and if you want to do 18,000 manual edits and maintain them in purpetuity, you can accept that offer or else you can say no thanks, and select a field on your school record to use to make that connection. [District ID] would be an excellent choice.