Getting the next Record number..

[Anon]

I have 2 tables.

table1 contains the rec_id, product_ID & description.
table2 contains the location, price, availability & status.

Because we can have 1 product in more tham one location, the relationship is a ONE to MANY (table1 -->> table2).

I use the product_ID to tie the table2 records back to the record in table1.

Right now the problem for me is to get the next available product_ID number in table1 to create a new table1 & table2 record?

Any pointers, how do I get the next number in table1 to allow me to insert the data by using only 1 form?

I know this can be dangerous with multiple users accessing the DB...

[zalath]

I don't suppose you can simply use an auto_increment field? if not, do a "select max(rec_id)" on the table, then add 1 to it. Like you said, dangerous. The auto_inc would be lots and lots better.

-L-