Help setting up a form for specific data

[Kels]

Help!

I'm not new to the basics of Access but need help with something a bit more
complex. It might be simple, but cannot get my head around it!

I'm setting up a database to book delegates onto specific courses.

I've got a table set up to store the delegate information, and the to store
the course information, and forms for these.

However, what I want to be able to do is to create a form for a course, and
then add delegates to that particular course using a form, and then when I go
to the delegate information form (which is another form I have), I want the
courses they are registered to attend to display there.

You with me?

 

[Rui]

You have a typical many to many relationship between those two tables. This
needs to be split into a 1 many relationship.
(1 delegate may go to many courses and a course has many delegates)
Add a new table with at least two fields, 1 for the course id and the other
for the delegate id.

Once this is done, you will be have to implement forms that have sub-forms
in it, and this new table should 'glue' things together.

Hope this helps
Rui

 

[Kels]

Hi Rui! thanks very much! isn't it strange how we forget how to do the most
simple of things?!

Sorted now, thanks a lot for your help!

Kelly