Hi, I would be most grateful to hear from anyone that has built a system for hospital Consultants Rota's, the main issue I'm having is both at the table design level and at the programming in as much as I'm trying to figure out how to calculate the the correct next dates in varying rota patterns, that include anything from simple 1 in 1 weeks to 49 in 53 week and anywhere in-between, also should the table structure be that of a calendar and create empty fields for each day, or leave it as a transactional file with a date?
This has been a most perplexing issue.... any help much appreciated
This has been a most perplexing issue.... any help much appreciated