RAN
Posts: 28
|
Posted: 05/26/2005, 3:16 AM |
|
Hi,
I have two tables "Models" and another "Products"
"Models" and "Products" have a column (Menu_ID)
When I insert a record, in table "Models" I like to insert to
same value in table "Products" It is possible.
"Insert a record on two diferent tables in one click"
I try to use this script, but dosent work.
updateSQL = "update Products set status = 'x' where Menu_id= '"& fldMenu_id & "'"
cn.execute updateSQL
Can anyone could help me please?
Thank you in advance.
Rui Nunes
|
|
|
|