Validate against other fields

[Dave]

Ignore the previous post, I had an accident, anyhow
how do you validate against other fields
anotherwords, I have got 4 fields that are yes and no's,
if one out of three are yes already, and you elected to
change one of the others too yes, can it change the
prvious yes to no. Kinda like a group of option buttons.
Thanks David
Hope I made the right investment? Excel 2002 wasnt big
enough for what I am getting ready to design.

 

[John Nurick]

Hi Dave,

A table-level validation rule in Access lets you check the values of
various fields against each other, but can't modify values that are
already there.

To get option button behaviour, the simplest way is to use option
buttons<g>. In the table, have one numeric field and set the field-level
validation rule to something like
Is Null Or (>=1 And <=4)
so it can only have the values 1,2,3 or 4.

Then, on the form you use to display the data, put an OptionGroup
control. Set its ControlSource to the field in question, and create four
OptionButtons in the group with values 1,2,3,4.

(By the way, if you're coming from Excel: the normal way of working in
Access is to use forms to enter and display your data; table datasheets
are best used only for debugging).

As for whether you made the right investment, it depends on what you
want to do<g>. But if you are faced with more data than Excel can hold,
or data about a variety of real-world objects, Access is probably the
right choice - though you'll face a further investment of time while you
learn to "think database" rather than "spreadsheet".