Problem with create form with two tables

[maxtor]

Dear all,

I would like tocreate a matrix of courses taken by a list of people.

I have two tables,one with names of people, second with list of courses.

I would like tocreate form like on graph but I don't have idea how it should looks table tothem.

First idea wascreate table like this:




But I don't know howi can create form like on below:


Thanks for anysuggestions,

[mike60smart]

Hi Maxtor

Can you upload a zipped copy of your database?

[maxtor]

Hi,

Thanks for your replay,
Here you are, in appendix copy of database.

[mike60smart]

Hi

I changed the relationships so that Referential Integrity was enforced.

I also changed the fieldnames where you were using:- Name_ to Coursename and Firstname

Look now at the Relationship Diagram and also how the subform is constructed.