Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: Toguspyder
- Order by date
-
Field update based off of child relationship
Lespaul I have two tables with a one to many relationships. Both have a similar field to them (ex. Complete) and I want the parent field to update when all of the children that are related to that record have been updated. So if I have a parent record with 3 child records to it, and all the...- Toguspyder
- Post #4
- Forum: Microsoft: Access Queries and JET SQL
-
Field update based off of child relationship
I am trying to figure out how to have a parent field update when all children records have met criteria. For example I want the Parent field "Complete" which would be a yes/no to update when all of the children field "ChildComplete" is marked yes. I have need for many uses (in different...- Toguspyder
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
