Creating a Member Delivery Calendar

[julie_filemaker]

I am new to Filemaker Pro, btw, so please explain fully in explanations.

I am working on planning a database to help me organize a CSA program. Community Supported Agriculture.

Basically this is what needs to be organized:

Members sign up on a quarterly basis to purchase baskets of produce from our farm.

They have the option to choose to receive large or small baskets, each with its own price, obviously.

They also have the option to receive it every week or every other week. For the biweekly crew, we would like to separate them into two groups (1st and 3rd week // and 2nd and 4th week) in order to distribute the load of baskets to make each week.

I need to track what days they get baskets, based on the previous criteria. I also need to calculate how much they owe us, based on the size of the basket and the # of baskets they receive in the quarter.

One more glitch is that sometimes members go on vacation or have to switch a week, so I would need to be able to change the day of their basket delivery manually as well.

I would love some help planning this database. I know FileMaker Pro can accomplish this task, I'm just not sure if i can tell it what I want.

Any tips and/or tutorials or examples would be really appreciated.

Thanks to anyone who can help,

Julie