I'm pretty new to Access so bear with me. I have two tables ApplicantInfo and Involvement. ApplicantInfo holds the typical columns (FirstName, LastName, Phone..etc) The Involvement table can hold up to three rows of information from the same applicant (Acitvity, Position, Start Date, End Date) When I try to create a report that shows the majority of the data from ApplicantInfo along with the three records from the Involvement table, I'm given 3 reports for the same user, included is one different involvement record for each form. How do i resolve this?
Thankyou in advanced