Search:

That's great :)Thanks again for your help and advice Scott with this - as well as the Askexperts website.
I'd probably encounter all sorts of probs otherwise.

Thank you pal

That's right, that's what I am trying to achieve and hope that that table will be able to do that. The student will move to different areas also so I am hoping a new record will be made for this as...

Hi Scott

Thank you for having a look for me. The placement attendance table which we have been discussing is called tbl studentplacementattendance, which links students, mentors and placements;...

Hmm is it possible you could have a quick look for me - I've attached the database as this might make easier for me to understand.

Really sorry for being a pain but I appreciate your advice.

Hi Scott

When you say single record per combination, what do you mean? Do you mean when the mentor field in the student placement table is the foreign key as I think this is already set.

Hi Scott

Am I right in that from what you're saying the relationships are already correct? So in theory I should now be able to make multiple records linking students to a mentor - am I right?
...

Hi

Please can some help me with this relationship design problem - it really has me stumped!

Here is what I am trying to get the design to do for me:


I have 200-300 students that as part...