Click here to Skip to main content
14,390,949 members
Rate this:
Please Sign up or sign in to vote.
See more:
According to the bussiness logic, I succeed to select all data in access and present on webform.But now I have a problem that how to update the data in the databae which refer to at least three tables.The designed colunms is below:
NEWS:
ID(pk) TITLE DES
AUTHOR:
ID(pk) Name Age Sex
PUBLISH:
ID(pk) Date Note NEWS_ID AUTHOR_ID

Can anybody help me? Thanks first.
Posted

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

What is the issue you are facing here?

Update the tables 1-by-1.
First update the data to table1, and then to table 2 and then to table 3.

Nothing complex. Instead of one update query, there will be 3 now.
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100