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

Access Discussion in 'Microsoft Office' started by morie_0905, Sep 8, 2017.

  1. morie_0905

    morie_0905

    Joined:
    Sep 8, 2017
    Likes Received:
    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!
     
    morie_0905, Sep 8, 2017
    #1
    1. Advertisements

  2. morie_0905

    morie_0905

    Joined:
    Sep 8, 2017
    Likes Received:
    0
    Can anyone help?
     
    morie_0905, Sep 18, 2017
    #2
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.