Recent content by JoeMee1

Plog, you are a genius. Got it working how it should this morning. Thank you so much for your help!! Joe

We have a list of students (700 odd) which we could put into the students table, yeah. I'm just thinking the drop down would then be huge, with all the names in? However what you are saying would be fine, and exact what is needed

So, the way I want it to be is that Staff get presented with a front screen which has the ability for them to add a students First Name, Surname, Date, and Detention on it. They then save this, and then at the end of the day, a member of staff from our admin team views an overview form of...

See that works for me too. Reason i am thinking that it's not working is that eventually i will need to put this in a nice form format, for staff to input data. When i go to the Form Wizard, go through the process (adding the Student_FN, Student_LN, Detention_Date and Detention_Type) fields...

Hi Plog, Thanks for your speedy reply! Database attached. I think this is where i post an embarrassed face! There is not much on there at the minute, as started fresh with your guidance! :)

Hi Plog, Many thanks for your reply again, it really is appreciated. I have just checked the composite primary key field, and can confirm i have the 'key' next to the Detention Fields (ID_Student, Detention_Date and Detention_Type). I then have made a form, and i can still submit duplicates with...

Thanks very much for your reply. I have created a new sheet, with the two new tables (Students, Detentions). I have created the fields as you suggested for both, and i believed linked the Foreign key on the Relationships. (Apologies, im a noobie!). I've tried everything, and still i can add...

Hi all, Thanks for taking the time to read this. I am quite new to Access, and i was wondering whether you could help me with something? I work at a School and have been given the task to devise a detention sheet. I have a simple table and form created, which allows the user to submit the...