multiple selection

[Clare]

I am creating a degree database, each degree can be
offered at a number of colleges, and each college
naturally offers a number of degrees. I have two separate
tables listing all degrees, and the colleges, how do I
select from a listbox or alternative the list of degrees
offered at the college? And then print out in a nice list
so the Dean can take a simple flier out on his travels
showing the programme list offered by each college.

 

[Tim Ferguson]

I am creating a degree database, each degree can be
offered at a number of colleges, and each college
naturally offers a number of degrees.

This is a straightforward many-to-mnany relationship.

I have two separate
tables listing all degrees, and the colleges, how do I
select from a listbox or alternative the list of degrees
offered at the college?

You also need a list (table) called Offers that contains pointers to the
College and Degree records for each combination:

College Degree Level Cost
======= ====== ----- ----
Herring Law DDL 3400
Herring Maths BA 2900
Herring Third World Studies BA 450
Cod Law PhL 3380
Cod Modern Angling BSc 20

In fact, you would use the primary key value, presumably a number, rather
than the names, but you get the picture. You need to enforce the
relationships between Offers.College >-- Colleges.CollNumber and
Offers.Degree >-- Degrees.DegreeID.

And then print out in a nice list
so the Dean can take a simple flier out on his travels
showing the programme list offered by each college.

That is just a report based on a query combining the three tables, grouped
and sorted in whatever order you require.

Hope that helps


Tim F

 

[John Vinson]

I am creating a degree database, each degree can be
offered at a number of colleges, and each college
naturally offers a number of degrees. I have two separate
tables listing all degrees, and the colleges, how do I
select from a listbox or alternative the list of degrees
offered at the college? And then print out in a nice list
so the Dean can take a simple flier out on his travels
showing the programme list offered by each college.

You need THREE tables, not two: Colleges; Degrees; and DegreesOffered,
with one record for each unique combination of college and degree.