Adding data to multiple tables with subforms

[mooserider2]

Hey guys I am new to access but I am familiar with SQL databases. I have two tables: one for project data and another for project leader data. These tables are linked by a third table that relates projectIDs to leaderIDs. I am currently working on making a form that will go through each project and display the people involved in each project in a subform. I pulling the data from the the leader table that matches the the projectID with a query.



I would like to be able to update the information in this subform directly (which I can currently do) and be able to add new project leaders to a project. What is the best way to add the new leader to this? If a person is already in the database how do I add them with the form without re-adding new information to the table?

Thanks!

[June7]

Maybe select from a combobox?

Options for data entry.

1. one form bound to junction table with comboboxes to select project and people

2. main form bound to projects table and subform bound to junction table with combobox to select people

3. main form bound to people table and subform bound to junction table with combobox to select project

[mooserider2]

Thank you, I was just working on a solution that sounds like it is your number 2 option. I just ran into an issue though.

I have a query in ROWSOURCE of the combobox that takes the name and the ID of each person. Now I want to add a button to add the ID of the selected person into an INSERT query. How to I reference the ID of the selected person in the combobox?

[June7]

Why do you need INSERT query?

If forms are bound to tables, and controls bound to fields, selected/entered data will pass directly to record.