I have run into a problem which I cannot seem to find an answer to. I am relatively new to Access, so excuse my lack of proper terminology when discussing this problem.

I am writing a database to organize a list of funders and the programs they fund (at the most basic level). Most information in the database is tied to the name of the funder, but since any given program could be funded by more than one person and since any given person could choose to fund more than one program (many-to-many), Access keeps giving me a hard time when I want to integrate the two tables on a form.

The hierarchy now looks a little like this:

funder --> grant --> program_grant <-- program

where program_grant is merely a placeholder table where the grant_id and program_id can be related, in the hopes that it would create backwards continuity.

I don't know if this made any sense, but if anyone knows what I'm getting at and has the answer, I would be tremendously appreciative.

Thanks,

Yelena

If you'll post your email address, I'll send you a sample db that shows how to implement many-to-many relationships.

Thanks so much Pat, but after a couple hours of working on it, I figured it out. Now I'm just scanning the forum to figure out how to put the result of a calculated field from a query into a table.

You should not store calculated values in your table...you should calculate them "on the fly" in your form, report, etc.