Hi Pixi, just got back from camp and I am taking a look at this. This model I actually kind of medaled with, But i didn't think it was right because there was no portal to show the join info or to join the employees to the schedule. as for the scheduling you mentioned, is the days table that is joined to the Join table (there is currently only the one table) have to be duplicated and joined to each of the other Join TO's. Then when it comes time to display them on a schedule, show all the related data and filter each of the seven portals by the IDday #'s?
Am I following this.correctly or could you try and explain what you have done.
Hi Pixi, long time no talk. I have taken the above aproach and got the whole thing working tikitiboo, and now they want to start using it. They told me it wasn't working correctly. I wasn't sure why but after investigation, they had changed the way things work. If an employee works on Mon, Wed, Sat the hours available are now 6.5 and on a Friday they are 5.5. So what I did, it create some field in the duties table to allow for the extra rates. two fields. So now when you add a dutie you can enter 3 different hr variables. I am stuck on the formula that can look at the emplyee and the day and the available hours for that day. Then add accordingly the daily hours and so forth. I would be glad to email you a copy of what I have.