update

[makala]

i have two tables in my database, one is lotno_details and the other one is customer_detail s both having lotno_id column. I want when i update values of lotno_id from lotno_details table the changes should also affect lotno_id column of the customer_detail s table. what should i do? Please help me.

[jsmithstl]

can you post the description of each table. Are you trying to update the lotno_id column in both tables? Is lotno_id a primary key or foreign key in either table?

[debasisdas]

The following links might be useful to you.

Link1
Link2

[makala]

lotno_id is primary key in lotno_details table

[OraMaster]

Please post your both table structure and also mention which columns you want to update from each table. I hope lotno_id is PK in lotno_details table.