One-to-many sample database

[Pat Hartman]

This is the simplest example I could make. It is states as the main form and cities as the subform. The sample includes a mainform with a subform and a button to open the subform as a popup so you can see how to handle populating the FK for each new record in the popup form. Access does this automagically for you with a subform as long as you define the master/child links correctly.