Access Validation rule of 1 field based on a field of another table

Joined
Sep 8, 2017
Messages
2
Reaction score
0
Hi. Here is the situation.

I have two tables (Field_a & Table A and field_b & Table b) and I wanna set up validation rule for field_b (Table b).

Rules needed for field_b:
1. If field_a (Table A) = 0, field_b (Table b) = 0.
2. If field_a (Table A) = 1, field_b (Table b) > 0.

Thanks a lot for the help!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top