John Frederick
j.frederick at att.net
Wed Feb 26 12:03:00 CST 2003
You can't update the one side of a query with a one to many join. If there is a rule for determining that the claim record needs to be updated, I suggest code to do DoCmd.OpenQuery using a query that references the event record on the form for the ClaimID or DoCmd.RunSQL a constructed sql statement to update the claim record and then requery the form. -----Original Message----- From: accessd-admin at databaseadvisors.com [mailto:accessd-admin at databaseadvisors.com]On Behalf Of John W. Colby Sent: Wednesday, February 26, 2003 10:20 AM To: AccessD Subject: [AccessD] Operation must use an updateable query I have a database where a claim table has an event child table. The event table may have an event such as Open for a set of claims. In order to discover which claims have an open event I have a query that pulls out that event and has the claim id exposed. now I want to update a field in every claim that has an open event (as an example). Trying to do so generates the infamous "Operation must use an updateable query". this is one I have banged into before and never really understood why I get it, not how to reliably not get it. Update a field in the parent table, if it has a related record in the child table. It sounds so simple. How is it done? John W. Colby Colby Consulting www.ColbyConsulting.com ---------------------------------------------------- Is email taking over your day? Manage your time with eMailBoss. Try it free! http://www.eMailBoss.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com