nrimlinger
New member
- Local time
- Tomorrow, 04:49
- Joined
- Jul 12, 2012
- Messages
- 1
Hi all
I haven't played around with DB's for many many years but have been asked to help out a friend. I've got everything working just about the way I want it to (not sure if it's particularly pretty but it works!). I'm stuck with one last thing that I'm trying to do and I'm not even sure that I should be ABLE to do it. My coding experience is limited so be gentle with me please :0
Basically I have 2 tables. One has a list of clinical placement sites. The other table has the list of students in the clinical program.
What I want to be able to do is allocate a particular placement to a particular student on the program (that's easy and I can do the look up for that). BUT I want to be able to state a semester and year that the placement will occur (again, I've managed this with a combo box or two).
The issue starts when I want to be able to pull out a report that gives me the following info when I enter a given semester and year.
Student name/ID & placement for that semester and year.
I've got about 30 students that all have to do 4 or 5 placements. So I originally structured it so that they each had placement 1 2 3 4 and 5. But that meant that there were potentially 5 fields that I had to try and get access to search across and then report only the student id and placement that matched my criteria (say semester 1 2012).
So if any of you have the time and patience to help me work out whether I've structured the whole dang thing wrong or whether there's a better way to do this? Or tell me it's simply not possible and I should export to excel and teach my colleague to do some fancy sorting in there!
Many thanks in advance.
Nat
I haven't played around with DB's for many many years but have been asked to help out a friend. I've got everything working just about the way I want it to (not sure if it's particularly pretty but it works!). I'm stuck with one last thing that I'm trying to do and I'm not even sure that I should be ABLE to do it. My coding experience is limited so be gentle with me please :0
Basically I have 2 tables. One has a list of clinical placement sites. The other table has the list of students in the clinical program.
What I want to be able to do is allocate a particular placement to a particular student on the program (that's easy and I can do the look up for that). BUT I want to be able to state a semester and year that the placement will occur (again, I've managed this with a combo box or two).
The issue starts when I want to be able to pull out a report that gives me the following info when I enter a given semester and year.
Student name/ID & placement for that semester and year.
I've got about 30 students that all have to do 4 or 5 placements. So I originally structured it so that they each had placement 1 2 3 4 and 5. But that meant that there were potentially 5 fields that I had to try and get access to search across and then report only the student id and placement that matched my criteria (say semester 1 2012).
So if any of you have the time and patience to help me work out whether I've structured the whole dang thing wrong or whether there's a better way to do this? Or tell me it's simply not possible and I should export to excel and teach my colleague to do some fancy sorting in there!
Many thanks in advance.
Nat
