Database modeling - using unique identifier to auto populate second table

Baserow Help
2

Hi,

The first thing you need is a list with the names of the owners where each name only appears once. You can achieve this be sorting the table cars based on the owner, export to view and manually delete duplicates. Or you can export the view an let a JS or python function do this for you.

Once you have the CSV file with the unique owners, take the following steps

  1. Create a new table Owners
  2. Import the CSV file with the unique owners, but only import the field with the name of the owner.
  3. Create a new table Cars (this will overwrite your original table)
  4. Set the structure for the table with the fields VIN, Make and model as text fiels and Owner as a field that links to the Owner table.
  5. Now import the original CSV file that you have exported and it should automatically recognize the owner as a linked field.