Record creation problem

[john9210]

I have a relationship between two tables but when I try to create records in a portal, I get the error message “pk_payments ID” is defined to require a value, but is not available on this layout. Use another layout to assign a value”. When I click OK (instead of revert) a new record is created anyway.

Pk_payments ID is the record Id in the child table, set to auto enter, not empty and unique value. The only way I could eliminate the error message was to delete the not empty and unique value requirements.

Anyone know why the above message should occur, and why removing the validation requirements solved the problem?

[IdealData]

What is (was) the Auto Enter value?

[john9210]

it was the auto enter field

[IdealData]

No - I mean the "value" that was being auto entered.

[john9210]

The values are serial numbers, increased by 1 for each new record. The last value was 198.