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