Click here to Skip to main content
15,069,408 members
Please Sign up or sign in to vote.
3.00/5 (2 votes)
See more:
Hello guys, I would like someone to help me know the query used to enforce related data meaning same data in different table, how to enforce the first table to update others automatically with the same data.
Posted
Comments
Estys 10-Sep-13 7:26am
   
For foreign key relations there's the cascading update/delete.

Can you show us an example of the problem?Cheers
DAVID DUSHIMIMANA 10-Sep-13 7:31am
   
I would wish to show you that, unfortunately there is no way I can attach the database I m developing. unless if you send your email address
Estys 10-Sep-13 7:37am
   
I don't need your entire DB :-) , just a glimpse of what you are trying to achieve.
Do you know the relations-window in Access? There you can set the integrity rules for the table colums. You can specify that changes in one column cascade to other columns in other tables.
DAVID DUSHIMIMANA 10-Sep-13 7:45am
   
Yes I know the relationship, but I used to apply them the did not work. Now I would like to apply them in my queries table,using update query but did not work.
Estys 10-Sep-13 7:49am
   
You really need to show WHAT is not working, otherwise we can't point you to a solution.
DAVID DUSHIMIMANA 10-Sep-13 7:34am
   
mine is dushidav7@hotmail.com

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




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900