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!!
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!!