Error message when creating new record

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dosima - 22 Mar 2008 20:39 GMT

I keep getting an error message on my form when trying to create a new record.
The error message says -
A related record is required in the table tblCustomperProfile.

I dont know what i am doing wrong.
I have about 5 to 6 tables with relationships consisting of one to one and
one to many. The form uses tabs, so i have all most of the tables fields
displayed on the form and two subforms.
I'm quite sure that all the tables are related properly, but i cant work out
why it keeps saying that.
If someone could help me, or give me ideas why this is happening please.
Thanks in advance

Dosima

Reply to this Message

Rick Brandt - 22 Mar 2008 20:50 GMT

> I keep getting an error message on my form when trying to create a
> new record. The error message says -
[quoted text clipped - 10 lines]
>
> Dosima

Any table on the ONE side of the relationship has to have a saved record
before you can create a related record in the related table. Even in a
One-To-One relationship if you have referential integrity turned on then one
of the tables in the relationship has been designated the "master" and that
table must be the first one to have a record saved into it.

Generally speaking you should not try to bind forms to multi-table queries.
Use the main form for the master table and subforms for all others. Then as
long as you fill out the main form first you should be okay.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message