Need to updates two tables

R

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
 
J

John Vinson

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Crosstab Query to Existing Table 0
Adding data to MS Access from csv file 0
Split form 0
Access 2013: Form problem in reading data tables; relationship one-to-one 0
How do I clear a form? 0
Dealing with a Pivot Table (when I don't want to) 0
Is this possible? 0
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0

Top