Hi,

I have made a simple database. for Example:

Products : A , B , C , D

Product A may have 5 variants: A1 , A2, A3, A4 & A5

A1 is required to be produced 4 times in a month.
A2 is required to be produced 2 times in a month.

Delivery Date for production is also defined. For A1, it is weekly production.

For A2, it may be 7th & 15th business day after last business day of last month. (Business day does not include Saturday and Sunday and Other pre-defined holiday)

Presently I have to prepare production schedule based on this dates.

I want to automate this process. Is there is any way???