john9210 Posted October 31, 2008 Share Posted October 31, 2008 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? Link to comment Share on other sites More sharing options...
IdealData Posted October 31, 2008 Share Posted October 31, 2008 What is (was) the Auto Enter value? Link to comment Share on other sites More sharing options...
john9210 Posted October 31, 2008 Author Share Posted October 31, 2008 it was the auto enter field Link to comment Share on other sites More sharing options...
IdealData Posted October 31, 2008 Share Posted October 31, 2008 No - I mean the "value" that was being auto entered. Link to comment Share on other sites More sharing options...
john9210 Posted October 31, 2008 Author Share Posted October 31, 2008 The values are serial numbers, increased by 1 for each new record. The last value was 198. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5797 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now