Wednesday, 15 April 2015

mysql - how to give foreign key contraints when records came from many table -



mysql - how to give foreign key contraints when records came from many table -

i using java swing mysql database.

as per requirements have 1 jcomboxbox has values 3 parent table. dont know how give foreign key on it.

i have 3 tables cmaster, smaster, gmaster , 3 table has different no of columns. want provide cname, sname , gname values jcombobox.

can 1 please suggest me?

every parent table must having mutual column in jcomboxbox.. refer column foreign key in table..

mysql

No comments:

Post a Comment