S
Sharon
I hope this is the correct Newsgroup!
My situation involves three forms: PARTICIPANTS,
REGISTRATIONS, and CSQ8. PARTICIPANTS has a one-to-many
relationship with REGISTRATIONS. REGISTRATIONS has a one-
to-one relationship with CSQ8.
On the PARTICIPANTS' form, I have a command button to
open the REGISTRATIONS form The REGISTRATIONS form has a
command button to open CSQ8.
Basically, the data-entry flow for these forms works like
this: enter a participant's information in the
PARTICIPANTS form (name, address, etc.). The key field
is PARTICIPANT_ID (as an autonumber). Next, one would
press the REGISTRATIONS button to enroll that participant
in an event. The REGISTRATIONS form also contains the
PARTICIPANT_ID field and I have it set up so the control
pulls across the ID number for the participant that was
just entered. A REGISTRATION_ID is generated in this
table (autonumber and it's the key field) for this
event. At a later date, the participant will take a
Customer Satisfaction Questionnaire (CSQ8). The CSQ8
button on the REGISTRATIONS table brings up a CSQ8 form
with the unique REGISTRATION_ID for the registration that
called it. REGISTRATION_ID is also the key field for the
CSQ8 table.
Anyway, I thought this setup would work so each
participant could enroll in multiple events and take one
survey for each event. Two things are happening:
1. the information entered into the REGISTRATIONS, and
CSQ8 forms is not retained (even after a SAVE).
2. if I change information in these forms while in the
process of entering data, when I go to save the form I
get:
ERROR 3201: You cannot add or change a record because a
related record is required in table PARTICIPANTS.
I don't understand this because there IS a related record
in PARTICIPANTS. For the life of me, I can't figure out
how to get any information entered into either the
REGISTRATIONS or CSQ8 to be retained and how to make this
error go away. Any help would be greatly appreciated. I
also apologize for the length of this request. Thanks.
My situation involves three forms: PARTICIPANTS,
REGISTRATIONS, and CSQ8. PARTICIPANTS has a one-to-many
relationship with REGISTRATIONS. REGISTRATIONS has a one-
to-one relationship with CSQ8.
On the PARTICIPANTS' form, I have a command button to
open the REGISTRATIONS form The REGISTRATIONS form has a
command button to open CSQ8.
Basically, the data-entry flow for these forms works like
this: enter a participant's information in the
PARTICIPANTS form (name, address, etc.). The key field
is PARTICIPANT_ID (as an autonumber). Next, one would
press the REGISTRATIONS button to enroll that participant
in an event. The REGISTRATIONS form also contains the
PARTICIPANT_ID field and I have it set up so the control
pulls across the ID number for the participant that was
just entered. A REGISTRATION_ID is generated in this
table (autonumber and it's the key field) for this
event. At a later date, the participant will take a
Customer Satisfaction Questionnaire (CSQ8). The CSQ8
button on the REGISTRATIONS table brings up a CSQ8 form
with the unique REGISTRATION_ID for the registration that
called it. REGISTRATION_ID is also the key field for the
CSQ8 table.
Anyway, I thought this setup would work so each
participant could enroll in multiple events and take one
survey for each event. Two things are happening:
1. the information entered into the REGISTRATIONS, and
CSQ8 forms is not retained (even after a SAVE).
2. if I change information in these forms while in the
process of entering data, when I go to save the form I
get:
ERROR 3201: You cannot add or change a record because a
related record is required in table PARTICIPANTS.
I don't understand this because there IS a related record
in PARTICIPANTS. For the life of me, I can't figure out
how to get any information entered into either the
REGISTRATIONS or CSQ8 to be retained and how to make this
error go away. Any help would be greatly appreciated. I
also apologize for the length of this request. Thanks.