Hi Everyone,
I'm fairly new to Access databases, so I apologise in advance if my approach is not the best method... I'm surre (and hope) I'll be corrected if I'm wrong.
I work in University accommodation housing 3000 students and we conduct meetings with the residents when they are to be disciplined.. for various things such as smoking in their room, poor conduct, or cause they've broken a window decided playing football in the kitchen using a window as a goal.
They can then be given a fine or community service or a warning.
I've created a database that logs a these meetings and it works fine when one person is called in, it logs the individual (Name, ID Number, Accommodation, Flat & Room No) and I can transfer the details to a new community service record or fine record and it all links to the auto generate ID number (known as the Case Number).
Though in cases where there is more than one person involved and each are given their own "discipline" I haven't got the knowledge to know how to keep it linked to the same 'Case Number'.
Is there any work around on this?
Can I create a case, add more than one person to the meeting record who will be present?
Then following that meeting for example Alan gets 10 hours community service, John gets a £40 fine, and Dave gets a £40 fine and 5 hours community service? Though all 3 are still linked to the same case number from the initial meeting?
If I've explained this poorly or posted in the wrong area then please let me know (I'm completely new to forums in general!)
Thanks in advance for any words of advice,
Joe