I am trying to create a relationship between two forms.  The first form is Donor Information with three fields (First_Name, Last_Name and Email_Address).  The second form is Contribution Entry.  I have placed three lookup fields in the second form and linked each to its respective field name from form #1 (donor information).

Here is my issue.  In the second form with the lookup fields, I type in the last name of a person all is fine.  When I go to the next field which is the First name look up field then all the names listed in form one appear in the drop down and the same problem with the email address form.  Is there a way when the last name is chosen in the lookup field on the second form that the first name and email address of the exact person (only one name and email) are available to be chosen or is there an automatic updating function.

I sure do have a lot of runons but just a frustrating step.  I am new to this program.

Thanks - Steve Chaney