hi all
i am using phpmyadmin and i have 10 tables in my database. my problem is that i have two tables(tbl1&2) and their respective primary keys i want to reference to the same primary key of another table (tbl3). however the primary key of tbl4 is also referenced to to this same primary key of tbl3. currently i have tbl 4 and tbl 2 referenced to the primary key of tbl 3 and i am getting an error when i am referencing the primary key of tbl1.
can anyone suggest a way in which i can do this.
cause so far these are the methods i have tried.
i tried to have the primary key of table3 referenced to the primary key of table 1 but i am not seeing the primary key of tbl1. i tried to have the the primary key of tbl1 referenced to tbl4 but i am getting an error.
cane23
0
Light Poster
kvprajapati
1,826
Posting Genius
Team Colleague
>comopsite foreign keys.
Please elaborate your question. Check the syntax - http://dev.mysql.com/doc/refman/5.0/en/innodb-foreign-key-constraints.html
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.