I have a table 'table 1' which has a primary key. Now I want to create two other tables with a composite key in each one, composed by primary key and a foreign key both referencing table 1 's primary key. However I can only do it with one of the tables at each time. Can´t a a primary key reference two tables at the same time? All the types and collations are according to table 1.
Thanks in advance