Ignore Duplicates

workingpoor

Registered User.
Local time
Yesterday, 19:44
Joined
Jul 19, 2006
Messages
21
I have 2 tbl's one is class and the other is professor... in my logic i create a new class for each student however, I am trying to make label for the professor and since a professor can teach more than one class i need only one label. How do i do this
 
Are you talking about table structure? Or form/report design?
Since we're in the query forum, maybe you're talking about queries...?

OK...
In queries you don't ignore duplicates, you keep them in. You deal with them when you're using the data (in form, report, or whatever).

In forms, you could have a subform listing the classes, with the professor's details on the parent form.

In reports, you can add grouping, eg so you can have the professor's name as a heading, then a list of classes they teach.

In tables, you want to normalise the data.
I'd suggest something like the following tables (primary keys in bold):
ProfessorTable: Prof_ID, Prof_Name, ... etc
ProfClassTable: Prof_ID, Class_ID, Class_Name, ... etc
StudentTable: Stud_ID, Stud_Name, ... etc
StudentClassTable: Stud_ID, Class_ID
 

Users who are viewing this thread

Back
Top Bottom