Email data collection failure message

  • Thread starter Thread starter gaildean
  • Start date Start date
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!!
 
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.
 
Back
Top