A real struggle (1 Viewer)

This is so simple for experienced folks, but as a newcommer to ms access I just cannot fathom how to do this. I have 2 tables. One is "parents" and the other "tutors". The PK is ID / autonumber in both tables.

Now this is where I bang my head against the wall: On the parent table, I need a subrecord which contains the tutor that has been booked by the parent.

For example: Parent name is Diane
There are 4 tutors: Tania, Jenny, Rose, Jacky

If the parent (Diane) chooses Rose, then I want Rose's name and info in the subrecord. Somehow, what is happening is that all the parents show Rose as the tutor.

How on Earth do I stop banging my head against the wall:banghead:

you need a junction table (table in between parent and tutor), say tblParentTutor with
fields:

ParentID (long the ID of the parent)
TutorID (long the ID of tutor)

add the parent ID and tutor to this table.

now create a query, drag the parent first, then the tblParentTutor, lastly the tutor table.
join the ID of parent table to the ParentID of the junction table.
right click on the connecting line and choose option (2).
drag the TutorID from junction table to Tutor table.
right click on the connecting line and choose option (2).
select which field you want to show in the query.

Thanks, I will follow your advice and report back. It takes me a few times to get right in databases. Teaching myself a new "career" at 53 - not easy

here is a sample you might want to study.

Thanks. I will work through your example and get back to you.