Hi,
I have an access database that contains three tables: Person, Scholarship, and PersonToScholarship (a junction tables that handles the many-to-many relationship between people and scholarships. It includes three fields: autoID, PersonID, and ScholarshipID).
I have a form that displays each person's information, including a subform that displays their scholarships (using a query that joins Person, PersonToScholarship, and Scholarship on Person.ID to PersonToScholarship.PersonID and Scholarship.ID to PersonToScholarship.ScholarshipID). The problem is that you can't use this subform to add or delete scholarships from a person's form page. The subform currently contains just one field, ScholarshipName, and if you change that name, you aren't changing the scholarship that the person is affiliated with, you are changing the scholarship's name.
What I need is a way to use this form to add and delete scholarships relationships without having to manually insert them into the PersonToScholarship table. Maybe with combo boxes...?
Any help is greatly appreciated. Thanks!