How to create a form that can handle a many-to-many relationship.

[Guest_imported]

Hi all,

I have a challenge that I am trying to solve. I have to represent the following in a form using subforms.

Employer_Applicant
EmplAppID
EmpAppName

Employer_Applicant_Application_Relate
ID -(auto increment)
EmplAppID
ApplicantID

Applicant
Applicant ID
ApplicantName
Other

When an Employer Applicant is chosen, one or more Applications will show up. The reason for the relate is that The EmployerApplicant and Applicant are 2 different people who will be tagged together based on the relate table which essentially forms a list of applicants for the Employer Applicant. I hope that I have not confused anyone. This many-to-many type of relationship has to be there.

Thx,

dave

 

[jflachman]

I think what you really want to do is create one form/subform that represents the one-to-many relationship between employer and applicants. As in, select an employer and see all of the applicants in a subform that have applied to this employer.

You also want a totally separate form/subform to represent the opposite relationship. Select an applicant in the main form, see all of the employers that applicant has applied to in the subform.

Does that make sense?

Jonathan
________________________________________
It is not fair to ask of others what you are unwilling to do yourself.
-Eleanor Roosevelt

 

[Jitterbug]

It is impossible to create a many to many relationship in access. You have to create two one to many realtionships with the many ends at a central table.

 

[jflachman]

Jitterbug,

If you read the original post, he has implemented the table structure exactly as you suggest. Now he is looking to implement a form to best represent the table structure he has in place. Jonathan
________________________________________
It is not fair to ask of others what you are unwilling to do yourself.
-Eleanor Roosevelt