I have 3 tables – Customers – Properties – WorkOrders
Each day we enter any new workorders - this table contains date,property,
worknotes,price, status
We have certain contracts that need work done every month – this I have put
in s Separate table Schedule
It has property,week1,week2,week3,week4,price
What I want to do now is to open this schedule table at the beginning of the
month and make the entries for the next 4 weeks
I thought perhaps the best way would be to load a form and open each
schedule (at the moment there are 19) and make the entries in the workorders
table but was wondering if there is a more efficient way
Suggestions appreciated

Hi Nylex,
here are some links for doing scheduling.
http://allenbrowne.com/AppRecur.html

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Crosstab_CalendarSty leTaskPlanner.mdb'


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia



"Nylex" <Nylex@discussions.microsoft.com> wrote in message
news:F4F4B624-63EC-446E-9F07-6A95C024E805@microsoft.com...
>I have 3 tables - Customers - Properties - WorkOrders
> Each day we enter any new workorders - this table contains date,property,
> worknotes,price, status
> We have certain contracts that need work done every month - this I have
> put
> in s Separate table Schedule
> It has property,week1,week2,week3,week4,price
> What I want to do now is to open this schedule table at the beginning of
> the
> month and make the entries for the next 4 weeks
> I thought perhaps the best way would be to load a form and open each
> schedule (at the moment there are 19) and make the entries in the
> workorders
> table but was wondering if there is a more efficient way
> Suggestions appreciated
>