I need to track multiple horses that get trimmed multiple times a year by multiple people.  I need to see at a glance what horse is due to be trimmed each month. Then print a report to give to barn mgr.  What is going to be the best way to set this up? i am having trouble normalizing the TrimT with the HorseT. In my form it repeats the date in every TrimDate field (9 of them) when i enter a date. I need to see every date in a column like an excel sheet to determine which horse gets done first.  not sure if this makes sense

---

Reply from Alex Hedley:

You can use a CrossTab Query to make a table like excel

I'd have a Horse Table, a Trimmed Table, you could then have a Foreign Key from Trimmed to Horse, you could have a Field of yes/no to say when it has been completed. Then you could add each date they're due to be and mark when complete
I take it the Horse would be linked to a Manager, that could be another relationship