Newbies nevmel Posted January 14, 2015 Newbies Share Posted January 14, 2015 Hello, Complete newbie to FM, so apologies if this is a bone stupid question. I'm attempting to build a weekly rota table for a site that has highly flexible staffing levels (40 on day 1, 87 on day two, 25 on day three for example), so I need to be able to rota people on day by day with no discernible pattern. There are a finite number of shift options (8), but need to be able to change them on a daily basis. I don't think using a portal would be an option, but can't seem to be able to fathom how to get differing values for each day? Currently have three linked tables, one for people, one for shifts, and one for the rota table. Apologies if this makes no sense to anyone... Link to comment Share on other sites More sharing options...
Newbies nevmel Posted January 15, 2015 Author Newbies Share Posted January 15, 2015 I seemed to have solved my own problem. Although it's a rather inelegant solution, I have set up 7 copies of the shift table, and 7 shift table foreign keys. Thanks to all those that took a look at my problem. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 3361 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now