Apr 10, 2012 05:21 PM|human2x|LINK
I have two tables (master / detail)
The master table has a (Invoice No) primary key value inserted automatically as (Auto Increment) number.
The details table has (Invoice No) as a foreign key from master table.
Once I insert a record to master table the (Invoice No) is generated automatically.
How can I get this generated value so I can use it to insert the related records to the