Hi all,
I am hoping someone can save me from my complete lack of cracking this issue.
I am modelling a database from an excel spreadsheet, I have 25 apprentices all completeing their own spreadhseet slightly differently, so want to standarise, there are multiple tabs, it is espically difficult to report on everyone, currently 25 users. So, I am thinking a database is the answer?
What I have in English is:
Apprentices have to do Knowledge Skills and Behaviours (KSB - there is a list of them K1,K2...B1,B2...S1,S2... There are about 20 altogether) the apprentice changes placements every 6 months, so for each of these placements they may do multiple KSB's, next to each KSB there is evidence given with a date, the same KSB can be done multiple times over differenet placements.
I also have the other issue that there are now two different KSB lists, so apprentice that joined 2022 and before are on one list, apprentice 2023 are on another, so I need to make sure that, that is reflected in the evidence form.
So, in short hand, each apprentice does multiple pacements and multiple KSB are carried out on each placement.
That in my mind is a Apprentice to many placements, many placements to many KSB's and each KSB can have many evidence.
I have laid out what in my mind is how it should work, I look after apprentices.
The course tables work fine (right hand side), it is the left that is causing me issues.
What I am having issue with:
The right side of the database works fine, it is the left that is causing me headaches, I cannot seem to get all the different forms and tables to update as they should, I have only given the relationship diagram.
I am sure there is an easy and elegant fix, that someone who has far more experience than I, will simply say do this, and it will all work.
I think I have given all the information needed, but if there is more, then please let me know and I shall get it.
Thank you in advance.
Enizag
I am hoping someone can save me from my complete lack of cracking this issue.
I am modelling a database from an excel spreadsheet, I have 25 apprentices all completeing their own spreadhseet slightly differently, so want to standarise, there are multiple tabs, it is espically difficult to report on everyone, currently 25 users. So, I am thinking a database is the answer?
What I have in English is:
Apprentices have to do Knowledge Skills and Behaviours (KSB - there is a list of them K1,K2...B1,B2...S1,S2... There are about 20 altogether) the apprentice changes placements every 6 months, so for each of these placements they may do multiple KSB's, next to each KSB there is evidence given with a date, the same KSB can be done multiple times over differenet placements.
I also have the other issue that there are now two different KSB lists, so apprentice that joined 2022 and before are on one list, apprentice 2023 are on another, so I need to make sure that, that is reflected in the evidence form.
So, in short hand, each apprentice does multiple pacements and multiple KSB are carried out on each placement.
That in my mind is a Apprentice to many placements, many placements to many KSB's and each KSB can have many evidence.
I have laid out what in my mind is how it should work, I look after apprentices.
The course tables work fine (right hand side), it is the left that is causing me issues.
What I am having issue with:
The right side of the database works fine, it is the left that is causing me headaches, I cannot seem to get all the different forms and tables to update as they should, I have only given the relationship diagram.
I am sure there is an easy and elegant fix, that someone who has far more experience than I, will simply say do this, and it will all work.
I think I have given all the information needed, but if there is more, then please let me know and I shall get it.
Thank you in advance.
Enizag