J
Joy Rose
I originally posted a message, Error 3201 - related record, October 8, 6:27
p.m. as follows:
I have a database that has Tables Customer, Orders, Order Details,
Payments, Products, and shipping methods.
I allowed access wizard to split the Customer table for me. I now have a
table entitled Customer-OLD, plus Customer Master, Customer Contact Title
and Customer e-mail.
Now when I enter information on customer-old, the information does not flow.
I have to enter my customer information on the Customer Master, but this
does not contain the email information or contact title info anymore.
Therefore, since these two fields are drop down lists, I have to enter that
information first or leave blank and go back to enter info and then go back
to the customer master file to enter info.
When I get to one of the last field when entering Orders, I get the message
"You cannot add or change a record because a related record is required in
table <name>. (Error 3201)" Help advises me that I must first add a record
to the "one" table that contains the same value for the matching field. I
have done this, but I still get the error and have to close without saving
my information.
What am I doing wrong?
Also, if I decide to delete the table email and contact title and just enter
that information on the customer table, what are the consequences of the
ones that I have already entered?
Thanks for helping. I am very unskilled at this!
Joy
I have since located the error. The related field is actually the customer
account number, not the last field. I must enter the information in both
the Customer_OLD table and Customer Master table. Perhaps I misunderstood.
I thought when the table was split into the different tables, that I only
had to enter the information one time and it would flow to the other tables.
If I must enter info into each of the tables separately with the way I have
done, is there another way that is more useful?
Thank you in advance. Joy
p.m. as follows:
I have a database that has Tables Customer, Orders, Order Details,
Payments, Products, and shipping methods.
I allowed access wizard to split the Customer table for me. I now have a
table entitled Customer-OLD, plus Customer Master, Customer Contact Title
and Customer e-mail.
Now when I enter information on customer-old, the information does not flow.
I have to enter my customer information on the Customer Master, but this
does not contain the email information or contact title info anymore.
Therefore, since these two fields are drop down lists, I have to enter that
information first or leave blank and go back to enter info and then go back
to the customer master file to enter info.
When I get to one of the last field when entering Orders, I get the message
"You cannot add or change a record because a related record is required in
table <name>. (Error 3201)" Help advises me that I must first add a record
to the "one" table that contains the same value for the matching field. I
have done this, but I still get the error and have to close without saving
my information.
What am I doing wrong?
Also, if I decide to delete the table email and contact title and just enter
that information on the customer table, what are the consequences of the
ones that I have already entered?
Thanks for helping. I am very unskilled at this!
Joy
I have since located the error. The related field is actually the customer
account number, not the last field. I must enter the information in both
the Customer_OLD table and Customer Master table. Perhaps I misunderstood.
I thought when the table was split into the different tables, that I only
had to enter the information one time and it would flow to the other tables.
If I must enter info into each of the tables separately with the way I have
done, is there another way that is more useful?
Thank you in advance. Joy