hello Guys, I am currently stuck, I have a prize database for a students, however I am unable to create select the same prize, multiple times for the same students.
So lets say chris won a prize and I want to gift him a pen twice, I cant do that.
Kindly help!
Victoria
Hey Victoria! Can you share a screenshot please? As much as you can share would be helpful!
Thanks!
Troy
Hey there!
I suggest creating an additional table called student prizes, with single-select columns student and prize 
i have done this, You can check the picture there
No no, only allow a single row selection for the prize, so if a student receives multiple prizes then you create an additional row in Student Points table
P.S: You should also create a table for students, and use that instead of the text in Name. It looks like you should also store Age, Points Earned and Points Remaining in this new Students table
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
