Error message when creating new record

  • Thread starter Thread starter dosima
  • Start date Start date
D

dosima

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
 
dosima said:
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
Click to expand...

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.
 
Back
Top