Automatically create a new row

[Palladian1881]

Okay, I have three tables: a Scholarship table, a Contacts table, and a Scholarship/Contact Relationship table (which lists if the contact is a primary donor, the founder of the scholarship, etc., etc.). This third table is (I believe) necessary because a given contact can be affiliated with multiple scholarships, and a given scholarship can have multiple contacts (right?).
So I have a form for entering Scholarship information that includes a Contact subform. It's set up to use the information from the S/C Relationship table to show the (already-entered) contacts and their relationship information for any given scholarship--so that part works--but when you add a new scholarship and/or contact, the form does NOT create a new relationship in the S/C Relationship table. How do I get it to do this?


Is this making sense? I can email the database to anyone who wants a closer look at it. Any help is greatly appreciated.

[rpeare]

From what you're describing you will not need any form/subform combination.

You would have a data entry form for your scholarships table, a data entry form for your contacts table and, because you can have multiple contacts per scholarship AND multiple scholarships per contact you would have your third table as another data entry form where the user would input the scholarship and the contact for each combination you have.