Access 2010: Collect data through email forms

[Katie Howard]

I love the tool in Access that allows you to create an HTML (or InfoPath) form and send that in an email to collect/update your data. I’m wondering if anyone knows of a way to use this feature when you need to update more than 1 table of data? From what I’ve been reading, this only works if the data is all stored in a single table, but I have 3 tables that link together that would need to be editable (a table of customers, events, and then the invitations table which is just the ID’s of the other 2 tables that indicates which person is on which event mailing list).

Is there a workaround to make this work somehow?

Thanks!

[Narender Sagar]

Hi Katie,
I have used this feature of access 2010 and I really like it. But even I used it for a single table. Just as an Idea, can you try & create a query based on your three tables, and then design this infopath form or HTML form from this query. This way data should be updated in all the three tables.
Pl. let me know if this works.!

[Katie Howard]

I actually did try that. My query itself works great and I can run it and make edits and everything updates perfectly, but when I try to "Create Email" it gives me an error that it's read only and "You cannot use e-mail messages to collect or update data on this object". From the various forums that I've read, I'm lead to believe that I'll get this error when I try to create email messages based on more than 1 table (despite that my 3-table query isn't read-only). I'm stumped...and maybe there isn't any way to do this at all!


@Narender Sagar