Hi Alugo,
Hi Andy,
Thanks for your prompt response. However, since tbl1_id has an auto_increment value in tbl1, mysql is actually generating the values for it automatically.
Ah, I see your point. I'm guessing by your code you're using PHP? If
so call mysql_insert_id() after you've inserted your record into tbl1.
That will give you the ID of the auto increment column - see the note in
the below link about bigint columns if your data type is bigint.
http://uk3.php.net/mysql_insert_id
Hope this helps,
Andy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org