cardgunner Registered User. Local time Today, 13:41 Joined Aug 8, 2005 Messages 210 Jul 12, 2010 #1 I have a form where the record source is a query with 2 joined tables. I can not edit the records. Is there a way to do this?
I have a form where the record source is a query with 2 joined tables. I can not edit the records. Is there a way to do this?
pbaldy Wino Moderator Staff member Local time Today, 13:41 Joined Aug 30, 2003 Messages 36,157 Jul 12, 2010 #2 Can they be edited directly in the query? If not: http://allenbrowne.com/ser-61.html
JamesMcS Keyboard-Chair Interface Local time Today, 21:41 Joined Sep 7, 2009 Messages 1,819 Jul 12, 2010 #3 Something to do with the relationship between the tables. If it's not set to one-to-many it won't allow you to update the records.
Something to do with the relationship between the tables. If it's not set to one-to-many it won't allow you to update the records.