User Profile

and111 · Aug 10 '12, 07:05 PM

Ok, once again thanks both of you for your help

and111 · Aug 10 '12, 06:26 PM

Hi, thanks Seth but it needs to be a query

and111 · Aug 10 '12, 06:24 PM

Thanks, is there any way to show a specific instructor in the query instead of grouping them

and111 · Aug 10 '12, 06:16 PM

Ok thanks, will do that now

and111 · Aug 10 '12, 06:12 PM

Sorry for asking another question, but do you know how I would make a query which would list the classes a particular instructor must attend

and111 · Aug 10 '12, 05:31 PM

Ok, I managed to do it on MS Access and its working.

Thank you Seth and twinnyfo.

and111 · Aug 10 '12, 05:09 PM

so in terms of relationship, what fields would i join together

and111 · Aug 10 '12, 04:54 PM

Ok thanks for your answers, but the database I am making means that one student can only join one class but a class can have multiple students.

and111 · Aug 10 '12, 04:30 PM

So I need to have 3 tables?

and111 · Aug 10 '12, 04:28 PM

Table 1 Field names: Customer ID (PK); Prename; Surname;Address
Table 2 Field Names: ClassID; Date/Time; Exercise; Instructor

Profile Sidebar