Microsoft Office Tutorials and References
In Depth Information
2. In this case, you need to ensure that the value in the Cost field is less than the value in the
Price field, so enter the formula [Cost]<[Price]. (To select the fields to put in the Formula
box, just double-click them or select them and click the Add To Formula link.)
3. In the User Message box, enter an appropriate warning (see Figure 7.46 for my example).
Once you’ve entered your formula and user message, click Save.
The List Validation
4. That should take you back to the List Settings page. Go to the list by clicking its name in
the title breadcrumb, and let’s test the List Validation setting to see whether it works.
5. Back on the Sales content page, click Add A New Item.
6. Fill all the fields as you want except Cost and Price; there, enter amounts such that Cost
is higher than Price. You already know the column validation for the Quantity works, so
enter a value of 10 or less.
7. Once you’ve entered your data, click Save. The save should fail, with your list validation
user message displayed at the top of the form (Figure 7.47). This is because there may be
more than one field involved in this issue. The list validation error goes on top (and there
can only be one), and each field’s error message goes beneath its field.
8. So there you have it. Edit the Price field so that its value is greater than Cost, and
Back on the list, you’ll see the fields that were added to the default view, complete with their
data. That’s it. You now have your very own custom list including lookup, site column, and a
People And Groups field. Both list and column validations are in force, so data entry is more
likely to be accurate.