Greetings!
I have a quick question to pose to everyone. I am trying to make a database program that makes a weekly schedule. However, since I am still a novice at Alphafive, I am wondering how to go about it.
Each week we have 6 positions to fill in our schedule. I will name those 6 position's M1, M2, S1, P1, A1 and A2. So that means I will have 6 different people each week assigned.
What I'd like to do is to be able to enter the person and then assign what they are capable of doing. IE: Some individuals can only do S1 and P1, others may be able to do all of the positions, etc.
So far I have set up a table to hold the people; we'll call the table 'people.' I then have another table to hold what they can do; this table we'll call 'abilities.' I have these two tables linked one-to-many by a field called 'ID.' I have also created forms to add and delete people and also enter each person's abilities. This all works great.
What I'd like is some direction in making the schedule. This is where it gets tricky. Each week there will be those 6 positions to fill by 6 different people. I want the DB to be able to read what each person can do and then assign them accordingly. There will be upwards to 12 weeks on a single sheet of paper.
Hopefully I described what I'd like to do well enough. I searched but couldn't find anything close to what I am looking for. Just to clarify, I am not looking for someone to do this for me. I'd just like some direction in how to do it.
Thanks,
I have a quick question to pose to everyone. I am trying to make a database program that makes a weekly schedule. However, since I am still a novice at Alphafive, I am wondering how to go about it.
Each week we have 6 positions to fill in our schedule. I will name those 6 position's M1, M2, S1, P1, A1 and A2. So that means I will have 6 different people each week assigned.
What I'd like to do is to be able to enter the person and then assign what they are capable of doing. IE: Some individuals can only do S1 and P1, others may be able to do all of the positions, etc.
So far I have set up a table to hold the people; we'll call the table 'people.' I then have another table to hold what they can do; this table we'll call 'abilities.' I have these two tables linked one-to-many by a field called 'ID.' I have also created forms to add and delete people and also enter each person's abilities. This all works great.
What I'd like is some direction in making the schedule. This is where it gets tricky. Each week there will be those 6 positions to fill by 6 different people. I want the DB to be able to read what each person can do and then assign them accordingly. There will be upwards to 12 weeks on a single sheet of paper.
Hopefully I described what I'd like to do well enough. I searched but couldn't find anything close to what I am looking for. Just to clarify, I am not looking for someone to do this for me. I'd just like some direction in how to do it.
Thanks,
Comment