Showing Data from a Many to Many relationship in a report or on a

[Kathleen]

I have a many-to-many relationship in my Db. Here's the description.

Candidate Table - holds data about Recruiting Candidates
Contracts Table - holds data about Active Contract

I have a many-to-many relationship set up between these two tables
(specifically the "candidate ID" and Contract ID number fields) - using a
third table.

I use a list box on the input form when entering Candidate data for choosing
the one or more contracts to which a candidate can be assigned.

NOW - I have a report where I want to list All Candidates by Status. On
each Candidate line, I want to list all the contracts that they are assinged
to. Preferably - I want to list the contracts (which will most likely be 1-3
of them) on the same line as the other data on my report - Candidate Name,
and status.

How do I list the contracts for each candidate on the report.....HELP!

 

[Douglas J. Steele]

Take a look at http://www.mvps.org/access/modules/mdl0004.htm or
http://www.mvps.org/access/modules/mdl0008.htm at "The Access Web". That's
the sort of code you'll have to write to do what you want.

 

[Kathleen]

Thanks much - I'll give it a shot. I'm having to dust off 10 year old
programming skills....oooh so painful - but fun!

Kathleen