You cannot add or change a record because a related record is requ

[Liz]

Hello,
I have setup an employee review database and I have a total of 4 tables and
several forms. I am testing the relationship between the forms and I keep
getting the error "You cannot add or change a record because a related record
is required in table" I have set up a one to one relationship for main table
linked to the three other tables. I have searched for a similiar situation
but nothing has helped! I am on a deadline and any help would be much
appreciated. Thank you!

 

[Piet Linden]

Hello,
I have setup an employee review database and I have a total of 4 tables and
several forms. I am testing the relationship between the forms and I keep
getting the error "You cannot add or change a record because a related record
is required in table" I have set up a one to one relationship for main table
linked to the three other tables. I have searched for a similiar situation
but nothing has helped! I am on a deadline and any help would be much
appreciated. Thank you!

First of all, relationships are set up between *tables*, not forms.
Forms are just for data entry (or not... some don't have a
recordsource at all).
Why are you even using 1-1 relationships? Do you really need them?
why not put all the data in the same table?

Sounds like your relationships are wrong... could you post the table
names and primary/foreign keys?

 

[Liz]

The reason why I have several tables is because of the amount of fields I
have. There are several questions with multiple choice answers and I exceed
the number of allowable fields in the table.

 

[Liz]

The table names are as follows:

Appraisal Main tbl
Appraisal Main2 tbl
Appraisal Main3 tbl
Appraisal Main4 tbl

The primary key is the "Appraisal Number" which is set up as an auto number.

 

[Bob Quintal]

The reason why I have several tables is because of the amount of
fields I have. There are several questions with multiple choice
answers and I exceed the number of allowable fields in the table.

You should have 1 row per question in an answers table with a 1 to
many relationship between the employees and answers tables not one
row for the whole appraisal.

To see a good example database Google "At your Survey", a database by
Dwayne Hookom. An Appraisal is a specific type of Survey.

As to being on a deadline, remember the 90-90 Rule of Software
Development "The first 90% of the development consumes 90% of the
budgeted time. The last 10% of the development consumes the other 90%
of the the time."

Bob.