1 form to enter data in several tables

[scottscheffer]

Hi all,
I used Access a number of years ago, and with help from a friend set up a nice database with a form that entered data into several tables so nicely. Now I'm trying to replicate that and can't seem to get anywhere. It's probably so basic but I just can't get it right. I'm using 2016 and what I'm trying to do is have a table for contact info, another for political issues that each contact is interested in, and another table for donors at 3 different levels. I've given up on the donors table for now because maybe its easier for me to figure out using just two tables. In relationships I connect the ContactID field (the key field) from Contacts to the ContactID field (the foreign key) in the Issues table. I then use the form wizard and select the ContactID field, FirstName, LastName from the contacts table, and then the Issues field from the Issues table. It creates a form with a subform, but in the subform it shows every issue in the Issues table.
What I'm trying to do is create a form so that I can enter a new contact, and then enter one or more issues so that the Issues table or a query would display contact's names and their issue or issues.


what am I doing wrong?

Would really appreciate any basic info that anyone could pass along to help me figure this simple thing out.

Scott

[Bob Fitz]

Check that the subforms "Link Child Fields" and the "Link Master Fields" properties are both set to "ContactID"