Many-to-Many Forms AGAIN !!!!!!

[RalphMorris]

In October several of the experts helped Richard178 with exactly the same problem which I had then & still have.

Since that time I’ve tried every combination of Forms & Sub-forms that I can devise and still cannot populate a sub-form from the Link Table. Please, if you can help, lead me very slowly 'cos I'm sure it's one of the "obvious" steps that is eluding me!! Right now humiliation is a small price to pay for being led by the nose.

At the simplest level, I have many people involved in many events and when I add either a body or an event I want to be able to relate a Body to many Events or Event to many Bodies - presumably using two forms, one with BODY, sub-form LINK[events] and EVENTS sub-form LINK[bodies].

My Tables look like this:
TABLE1 – PEOPLE
Personal_ID
Name
Etc.
TABLE 2 – EVENTS
Event_ID
Event
Etc
TABLE 3 - LINK
lnkMember_ID
lnkEvent_ID

Personal_ID links to lnkMember_ID
Event_ID links to lnkEvent_ID

I need Reports of a similar nature, and hope that once the penny has dropped for Forms, Reports will follow ??

HELP!

 

[tunsarod]

The key points here are that for every event/person combination you will require one link record. Whereas you need only one each for events and persons respectively. While PEOPLE.Person_ID and EVENTS.Event_ID should be unique PrimaryKeys the LINKS table requires no PrimaryKey.

I have just created an example of what you describe and it works fine. That's three tables, two forms, two subforms, two queries and a report that displays Attendees by Event.

It's in Access97. If you can use it post your email and I'll send it to you.

 

[RalphMorris]

Many thanks tunsarod.

If it works in Access97, it shouldn't have a problem with AcsessXP. I'm sure I must be missing something 'obvious'. What you say is what I have - but I don't pick up the EVENTS records from the LINK sub-form.

Maybe seeing a working example will produce the "Eureka" that I need.
My email is ralph.morris@ntlworld.com

Thanks again.

 

[tunsarod]

OK Ralph, email sent.

If you have any probs post details here rather than by return email.

Rod