Sorry I have to post this again because I thought my first post was confusing I need a design suggestion from all you experts
So I have tables as below:
Table 1
( A integer not null , B char(1) not null , C integer not null , D not null , primary key (A, B, C, D) i.e. composite key )
Table 2
( A integer not null , B char(2) not null , C integer not null primary key (A, B, C) composite key )
Table 3
( A integer not null , B char(2) not null , D not null primary key (A, B, D) )
I want to create a relationship between table 1 and 2 and Table 1 and 3.
Table 1 being the parent table and table 2 and 3 being the child table of Table 1. I can easily creat a relationship between table 1 and table 2, but I get an error when I try to create a relationship between 1 and 3 because the foreign key can not be the part of the composite key and it has to be the whole composite key. I would highly appreciate any suggestions.
Aucun commentaire:
Enregistrer un commentaire