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

K

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!
 
K

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top