I have two tables, one has a list of chores that must be done once a month and the other is a table of who those chores can be assigned to. There are the same number of chores as there are people. Each month the chores rotate so each person gets a new chore until everyone has done each chore once and then start over again.
I'd like to setup a report that prints off the current list of chores and who they are assigned to for the current month.
Does anyone have any ideas on how I could do this?
Thanks
Bruce