Hi Richard,
I'm an Access newbie using Access 2003, and am a bit confused about how to create a form/subform (when I have two tables linked by a junction table) which allows the creation of new records in either of the two main tables.  Here's the scenario: First table, tblEmployees, with three fields, EmployeeID (primary key, number, indexed, No Duplicates), Fname, LName. Second table, tblAwards, with three fields, AwardID (primary key, number, indexed, No Duplicates), Description, Source. Junction table, tblJunction, with two fields, EmployeeID and AwardID (with both fields jointly acting as the primary key,number, indexed, No Duplicates). Obviously, I've simplified the database for purposes of illustration, and for experimentation.  The relationship between Employee and Awards is that all Employees can be a recipient of any award.  I'd like to have my end user be able to have a form that allows them to add/create/delete any employee, and also be able to add/create/delete any awards and, be able to associate an existing award to an employee.  I've tried a combobox with awards, and that does give ability to select an existing award, but not the ability to create a new award from the form.
Thanks for your help!!!
Jeff

---

Answer from Richard Rost:

In this case, you're going to need to pick which way you want the data entered. Do you want the parent form to be the employee and show awards in the subform, or go the other way around. Nothing's wrong with building BOTH.

Let's go with the parent form as the employee form. In this case, your subform would be based on your JUNCTION table as the recordsource, and you would build combo boxes in there to show the list of awards to pick from.

I talk about this more in my Blog here:

http://599cd.com/blog/display-article.asp?ID=288