Hello all,
I'm trying to design a relational database where two tables link to each other through
unique id sa below
Table 1
table1_id INT UNSIGNED NOT NULL AUTO INCREMENT,
entrydate TIMESTAMP
Table2
table2_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
table1_id INT UNSIGNED NOT NULL,
entrydate TIMESTAMP,
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.
http://www.microsoft.com/windows/windowslive/products/photos.aspx
