Link to home
Start Free TrialLog in
Avatar of peispud
peispudFlag for Canada

asked on

Access 2010 validation based on another field in same table

Hi

I am using Access 2010

I am building a table using the designer (this is not a vba question).
I have two particular fields in this table that have to work together.  The two fields are
[PriceLookup] and [Percent].

[PriceLookup] is a boolean field.
[Percent]  is a numeric field

In the table design,  I would like the [Percent] field to only allow zero values if the [PriceLookup] entry is set to true.   I've attached an image to show where I think your answer would be applied in my table design.

Thanks!
val.PNG
ASKER CERTIFIED SOLUTION
Avatar of peter57r
peter57r
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
<No Points wanted, as Pete has already addressed your question>

You can "Kinda" do things like this using *Table Validation*.
But it is only for very basic comparisons:
    Field1>Field2
...not for what you are specifying
See here for more info you can research at your leisure:
http://www.msofficetuneup.com/2009/01/28/creating-a-table-validation-rule-in-access-2007/

JeffCoachman
Avatar of peispud

ASKER

Thanks for your help.  You saved me a lot of futile work.