Creating a calendar/Visual Map

[stockingup]

Hey guys,

I have yet another query I can't get my head around. I have searcheda bout, read some material and followed the calendar tutorials online for filemaker, but nothing quite seems to suite this application.

Essentially, I need to create a visual map for all the employees of a company (approximately 15) whereby it shows dates across the top, employees down the side (like a grid) and each individual day for each individual employee can be changed:i.e. to represent where he is in the country on that day.

I have tried several methods but ended up with ridiculous strategies like having 31 fields, numerous scripts etc etc.

all suggestions, references and hints would be greatly appreciated.

Thanks again for your continued support.

[comment]

Perhaps this can get you started:

http://fmforums.com/forum/showpost.php?post/163265/