I have the main form for the "one" side of the relationship and a subform for the "many" side, linked by the primary key of the main table to the foreign key of the join table (the many-side table). But at the initial start, the form shows no entries in the subform because none have been created yet. How do I create the situation where the user can select from a list and make the proper entries into the join table in the subform? Otherwise, the form is only good for viewing what entries have already been made, but the point of the database is to facilitate the population of the join tables.
Thank you, Todd
Thank you, Todd