AnsweredAssumed Answered

One primary key for couple of related tables

Question asked by mark-it on May 17, 2018
Latest reply on May 28, 2018 by mark-it

Dear all

 

I'm wondering is that's the correct way of working to use one primary key to a couple of related tables.

 

Sample:

Table Car (parent table) with auto enter -pk car001

 

Table Color (child table) - with fk (from Table Car) - car001

Table Warranty (child table) - with fk (Table Car) - car001

Table Wheels (child table) - with fk (Table Car) - car001

 

I want to do that because one car will only have a specific color, warranty details, so all the details will always be related to the specific car (and pk).

Outcomes