problem with find unmatched query

[smahdih]

i have tow table

table1

OrderCode.....PrimaryKey
OrderDate
LeadTime
OrderStatus
Description

table2

OrderCode
OrderDate
LeadTime
OrderStatus
Description
Senddate
Id..................PrimaryKey

i create a form base on table1, and insert into a button. i want when press button into form, record copy in tow table.
by find unmatched query do it but when update a exist record in table1, and press button, just updated record in table1, how can i update record in two table?

 

[Guus2005]

You might want to look into your database design. It is not normalised.