Help setting up a form for specific data

  • Thread starter Thread starter Kels
  • Start date Start date
K

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?
 
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
 
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
 
Back
Top