Cannot add or change a record

[Louise Smith]

Hi,

I'm creating a database with a number of tables and forms.

Two of my tables (and the forms "tied to" these tables) will not allow
me to add records.

When I'm in the table, the option to add a record is greyed out.

When I'm in the form, the opton to add a record is greyed out. I can
enter data in the various fields but attempting to save the changes
results in the following error message:

"You cannot add or change a record because a related record is
required in table [tablename]"

The AllowAdditions property is true.

Both of these troublesome tables and forms were created by copying
others, then making appropriate changes. I've done this successfully
in the past and am fairly certain that some of the other working
tables/forms in this database were created the same way.

I'd be grateful for some assistance.

Thank you,

Louise


Hope this helps,

Louise

 

[Wayne Morgan]

Well, since you can't add directly in the table, I wouldn't expect you to be able to add
in the form based on the table. What type is the table, is it in the database or linked?
If linked, what is it linked to?

The error message you mention makes it sound as if the table is on the Many side of a
One-to-Many relationship. To create a record in a table on the many side, there needs to
be a record in the table on the One side that matches the data in the linked field.