updating several tables with product info without prodid listed

[Guest_imported]

I am updating four tables with information from user interface. The information will be sent to each table throught edit or add interface (pages). All the tables have the product id column in common. However on the interface the product id in not listed. In the main table the product id is automatically increased by one each time a new product is added. The product id in all the other tables is set to not allow null value.

When I try to save the information captured on the add or the edit screen i got a message that the column product id in the other three tables does not allow null value. But there is not place on the screens(add or edit) where i can insert the product id info. Even there was any, the user will not know the product id of particular id in the database.

Now I will like to have a way to capture the last product id in the database and increase that by one each time the user wants to add a new product info through the add screen. I was told to declare a global variable to capture the last prodid and insert that into the add screen every time a new product is being added.

Please help.

Thanks

Hakim Barbosa
Niarela@aol.com

 

[DougP]

Well somehow you need to get it.
Either by looking it up in another Table.
you can then put it in a Hidden text.

DougP, MCP
dposton@universal1.com

Ask me how Bar-codes can help you be more productive.