I'm trying to design a relational database where two tables link to each other through
unique id sa below
table1_id INT UNSIGNED NOT NULL AUTO INCREMENT,
table2_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
table1_id INT UNSIGNED NOT NULL,
Sorry. The above is just a rough sketch of what I have here and I hope you understand what
I'm trying to portray but the value of table1_id inside table2 keeps returning the value 0
thereby it doesn't correspond with any value in table1_id in table1.
Please I need help on this issue.
Thanks in anticipation of your prompt response.
Drag n’ drop—Get easy photo sharing with Windows Live™ Photos.