Jump to content

Multiple field in record


This topic is 3361 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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

  • Newbies

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.