none
Linking data in Forms - If/Then Statements RRS feed

  • Question

  • I apologize if this gets a little rambly....  I am new to Access (2010).

    Ok, I have 2 separate tables/forms that I would like to link and maybe flag through an if/then statement.  

    I have one table & form that has a list of individuals.  The individuals are entered and a check box is checked if they're prohibited from owning a firearm.   

    I have another table & form that has information on "recovered guns".  This form will potentially have the same names as the other form.  

    What I would like to do if possible is link the two and "flag" them if a match is detected.  Also, automatically check the "prohibited box" if the individual is prohibited.  

    This will make my life sooo much easier if this is possible!!!  

    Thank you in advance!

    Thursday, May 26, 2016 4:07 PM

Answers

  • Well a query that joins those two fields will give you the matches. But I don't know what to tell you about surfacing that in the front end; it depends on how your forms are set up.

    Feel free to come back with more details if you need some help with that step.

    HTH


    Rebecca M. Riordan

    • Marked as answer by 12Jen12 Thursday, May 26, 2016 7:17 PM
    Thursday, May 26, 2016 6:03 PM

All replies

  • Not rambly at all 12Jen12. What's the schema of the two tables. Do they have a field in common?

    Rebecca M. Riordan

    Thursday, May 26, 2016 4:38 PM
  • Thank you....  Yes, they have last name and DOB fields in common.  Both the last name and DOB will need to match before it's "flagged".   
    Thursday, May 26, 2016 4:48 PM
  • Well a query that joins those two fields will give you the matches. But I don't know what to tell you about surfacing that in the front end; it depends on how your forms are set up.

    Feel free to come back with more details if you need some help with that step.

    HTH


    Rebecca M. Riordan

    • Marked as answer by 12Jen12 Thursday, May 26, 2016 7:17 PM
    Thursday, May 26, 2016 6:03 PM
  • Thank you!  I will work on joining the fields. 

    -Jen

    Thursday, May 26, 2016 7:16 PM