I have inherited a database that has a table with some Field validation rules and a Record Validation rule (if field A has a value then Field B has to be blank) . I can see and remove the Field validation rules in the table design. But I can find where the record validation is. How do I view/modify Record validation Rules
turn off Record validation rule (1 Viewer)
- Thread starter hwest27
- Start date
Thanks for the reply. I had looked in form using table but nothing there.
I actually was adding a new column to table. Then running query to do mass update to that column and while trying to run the update query the validation rule warning message appeared and the update did not work.
I then looked at the two fields the rule referred to and they are all valid. So it appears all the current records meet the rule.
I actually was adding a new column to table. Then running query to do mass update to that column and while trying to run the update query the validation rule warning message appeared and the update did not work.
I then looked at the two fields the rule referred to and they are all valid. So it appears all the current records meet the rule.
- Local time
- Today, 00:35
- Joined
- Oct 29, 2018
- Messages
- 21,467
To help you look for it, we may have to see a copy of your db. Are you able to post it? You can take out any data, if it's sensitive.
- Local time
- Today, 03:35
- Joined
- Feb 19, 2002
- Messages
- 43,257
You need to look in the table's property sheet. Here's a picture.
Attachments
-
TableRules.JPG
