I am getting "data integrity error" when using a dropdown list to enter a value for a field that is in a relationship. Basically I want to give the user the chance to enter nothing, i.e. NULL, i.e. not pick anything from the dropdown list. But this does not seem possible on a data page, even with an additional custom value set to empty. So, how do you default to no value when editing with a dropdown?
The same problem doesnt seem to exist in when i enter data directly into the table in bridge. In such circumstances there is no obligation to pick from the dropdown list
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
RichardAukland
Hi, hope you can help
I am getting "data integrity error" when using a dropdown list to enter a value for a field that is in a relationship. Basically I want to give the user the chance to enter nothing, i.e. NULL, i.e. not pick anything from the dropdown list. But this does not seem possible on a data page, even with an additional custom value set to empty. So, how do you default to no value when editing with a dropdown?
The same problem doesnt seem to exist in when i enter data directly into the table in bridge. In such circumstances there is no obligation to pick from the dropdown list
Thanks
Richard
Link to comment
Share on other sites
7 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.