Need to updates two tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Access 2000, and trying to use two table. In a form trying to find a record in one table, if it is exist then get the value and put values in the form fields to update the second table. If it is not exist then create record in table1 and update the table two also.....

Rashid
 
I am using Access 2000, and trying to use two table. In a form trying to find a record in one table, if it is exist then get the value and put values in the form fields to update the second table. If it is not exist then create record in table1 and update the table two also.....

Rashid
Click to expand...

I'm not sure I understand, Rashid. Are you trying to store data
redundantly in two tables? If so, why?
 
Back
Top