Hi all,

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

Solved: it was related to the foreign key name given in the mysql workbench, I tried it in the command line and it worked changing the foreign key name, then I did the same in workbench and it's working

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.