Praise 1st: Love this series of tutorials. I know they've been around a while, but I'm new and they are perfect for the new Access programmer.
Now for my Question:

It is odd to me that I can create a sub form (child) to a parent and not need to have the linking field ie. the ProductID and the Primary Key field ProductCategoryID somewhere in the form. Ie. how does Access handling the insert of these records without that information? Thanks. Elizabeth

---

Reply from Alex Hedley:

If you have the fields in the record source and have the master/child fields have auto linked access handles the rest.