October 31, 200817 yr 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?
October 31, 200817 yr Author The values are serial numbers, increased by 1 for each new record. The last value was 198.
Create an account or sign in to comment