Multiple field in record

[nevmel]

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... 

[nevmel]

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.