Bundling products together

[Rickochezz]

Hello All:



Today's dilemma that I'm sure that you can pull me out of the fire with as I just can't figure out any way to accomplish the following

1 - Class - A - Price
2 - Class - B - Price
3 - Class - A and B - Discounted Price

Everything plays nice together scheduling - pricing - revenue etc

The problem comes into play when I want to see the student listed when I call up Class A (1) or B (2) but shows up into Class (3) obviously

When the form loads

CboCourse - The combobox loads with Name of Course
CboYear - The combobox narrows the courses down by year
CboSerial - The third cascading combobox lists all Serials of course throughout year - automatically loading most recent Serial

The form and subform are linked together by the Serial

Which is where my problem lies

Any advice would be wonderful

Thanks Guys

[Bulzie]

Not clear on the problem. So the output in the subform is names of students that have taken any of the courses selected or that the combo box combinations refer to? Can you give sample data of the output that is wrong like you did with the input data.

[Rickochezz]

When I click the combobox to Serial the class roster populates

So when I click on Course "A" and Serial 1 (first one of the year)
Then the serial roster populates

The same for Course "B" as well as Course "C" which is both Course A and B together

But what I need is the students loaded into the combination course C to show in both Course A and Course B

[aytee111]

Your table structure would help! Presuming that your table contains records with Student and Course:
- query 1 - all students in A
- query 2 - all students in B
- query 3 - query 1 and query 2 joined on student

[Rickochezz]

Thanks for the info - I will give it a shot

[aytee111]

You could also use a duplicates query to count how many courses each student is registered for. Use the query wizard to create it, select student and course, and the query will give you a count of courses. You can use that to find all students where the count field is > 1.