S
Sheila
I am a very new Access user, so I hope I manage to explain what I need...!
I am trying to build a database to record details of students attending
various classes for a dance school. I have tables as follows:
Student personal details
Class timetable (fields show day, teacher, venue, dance type)
Class v Student (links students with the classes they attend)
It is the Class v Student table that I have a problem with. Fields as follows:
1) Student Name (created a "look-up" control so I can't mis-spell names -
all ok
2) Class attended!!!!!!!!
I need to be able to only enter the details of a valid class (as per the
class timetable) and I need the table to then show me the FULL class details
(ie day, teacher, venue, dance type). At the moment, I have produced a
look-up control which is great because when I enter the information, I can
see EXACTLY the class I want to link to a student. BUT, the table itself does
not display ALL that information once I've selected it which therefore makes
verification of data entry a bit tricky. It only displays the text contained
within the first column of the class timetable - in this case it is the day
(Mon, Tues etc) the class takes place.
So, I then created extra fields in my class v student table, to show Day,
teacher, venue etc. I thought this would work, but it seems that I still have
to select a teacher, then a venue, then a day, then a dance type. This means
that I could get it all wrong. I expected to be able to select the class I
wanted and then all the data is entered in the relevant fields (a bit like
predictive texting).
My Class timetable will correctly show that teacher X teaches tap at venue Y
on Monday but the way I have my class v student table set up, I could enter a
student name against a teacher X who could teach ballet at venue C on
Thursdays and my Class v Student table will happily accept it! I need it to
only accept the details from the class timetable table without being able to
mix and match.
I also tried setting up the venues and days of the week etc in separate
tables, but of course this made no difference.
I feel sure that there is something quite basic that I am getting wrong, but
I just can't see what. I can't put all the class details intogether in one
field, because I need to run reports/registers, by each of the fields (eg
sort by day, venue or teacher). Because I am a new user, even with the help
of a manual, I am at a loss.
Please can anyone tell me what I am doing wrong.
I am trying to build a database to record details of students attending
various classes for a dance school. I have tables as follows:
Student personal details
Class timetable (fields show day, teacher, venue, dance type)
Class v Student (links students with the classes they attend)
It is the Class v Student table that I have a problem with. Fields as follows:
1) Student Name (created a "look-up" control so I can't mis-spell names -
all ok
2) Class attended!!!!!!!!
I need to be able to only enter the details of a valid class (as per the
class timetable) and I need the table to then show me the FULL class details
(ie day, teacher, venue, dance type). At the moment, I have produced a
look-up control which is great because when I enter the information, I can
see EXACTLY the class I want to link to a student. BUT, the table itself does
not display ALL that information once I've selected it which therefore makes
verification of data entry a bit tricky. It only displays the text contained
within the first column of the class timetable - in this case it is the day
(Mon, Tues etc) the class takes place.
So, I then created extra fields in my class v student table, to show Day,
teacher, venue etc. I thought this would work, but it seems that I still have
to select a teacher, then a venue, then a day, then a dance type. This means
that I could get it all wrong. I expected to be able to select the class I
wanted and then all the data is entered in the relevant fields (a bit like
predictive texting).
My Class timetable will correctly show that teacher X teaches tap at venue Y
on Monday but the way I have my class v student table set up, I could enter a
student name against a teacher X who could teach ballet at venue C on
Thursdays and my Class v Student table will happily accept it! I need it to
only accept the details from the class timetable table without being able to
mix and match.
I also tried setting up the venues and days of the week etc in separate
tables, but of course this made no difference.
I feel sure that there is something quite basic that I am getting wrong, but
I just can't see what. I can't put all the class details intogether in one
field, because I need to run reports/registers, by each of the fields (eg
sort by day, venue or teacher). Because I am a new user, even with the help
of a manual, I am at a loss.
Please can anyone tell me what I am doing wrong.