Linking data in Forms - If/Then Statements

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!

Answer 1

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

---

Rebecca M. Riordan

Answer 2

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".   

Answer 3

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

Answer 4

Thank you!  I will work on joining the fields. 

-Jen