[AccessD] Many to Many relationship issue

Hi,  I have a bit of a struggle with this concept.  It's been several years
that I have done anything with database applications..not since using
Foxpro.  Anyway, I work for a contractor and have a need to maintain a
customer table (contractor general information), a table for the contact
people at the contractor's companies, a projects table (jobs we bid) and a
table to log phone calls.  I have the tables created with an "associate"
table for the M2M relationship between the customer table and the jobs
table, another "associate" table between the customer contact table and the
phone calls table.  I also have a one to many created between the customer
table and customer contact table.

 

If I create forms for either of the two M2M examples  above, they work fine
as a standalone but I just can't seem to "tie" the two M2M examples into a
functioning arrangement where if you select a company, all the phone calls
made by the contact people at the company will display and likewise, if I
select a particular job, all the phone calls relating to this job display.
I have followed an example by Susan Harkins from 2004 that I dug up in a
search but am still unable to get beyond the basic.

 

 

Jon Albright

Iniki Enterprises

Honolulu, Hawaii

(808) 677-7800 x116