Email data collection failure message

G

gaildean

I have a table in my access database called Class-TBL. When I send out an
email for data collection, the replies all fail to export. I get the
following message:
Cannot export data due to errors. Failure: You cannot add or change a
record because a related record is required in table 'Schedule-TBL." (My
Class-TBL is linked (related) to the Schedule-TBL in a one to many
relationship. The class table lists all the classes at our school. The
schedule table lists the 6 periods for the day. Many different classes can
be scheduled during the same period but each class can only have one
scheduled period.) If I create a new Class-TBL (with a slightly different
name, of course) and NOT link it to any other table, the email data
collections will work just fine. What's up? Thanks!!
 
P

Pete D.

The tables are related and returned information doesn't include required
data to update the related table. Try this, use a query to send the data
collection request and include both tables. It sounds like your recipients
can change a field that has multiple relationships so the returned record
cannot be parsed into the tables as it violates the relationship rules.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top