Workflow advise needed
Can you please help with advice regarding what is the best way to create Work Order pages.
I'm designing site for my Grave Care Business.
I have the following steps:
Users, CemeteryList, GraveList database tables created.
User registers himself.
Registers a grave.
Purchase Grave Tendering Services 1, 3, 6, 12 times per year (as separate products).
Then the tricky part.
I need to create Work Orders table for admin purposes. I need to have there UserID, GraveID, CemeteryID and OrderID automatically without manually typing-in into Record Insert Form.
And is any way to auto-generate the maintenance schedule (Work Orders for 1,3,6,12 times a year maintenance)?
I have products and services to sell.
For products I can use an ordinary approach.
But how to deal with Services. They need to be treated differently, they should triger an entry in Work Orders table.
I want also to have a Product/Service where customer types in his/her own mesage to be printed on a card. What would be the way to implement this to apear it in the cart?
Is it better to have two database tables - one for products, one for services or should I keep everything in one place?
Is it doabble or it's too complicate? :)
Would apreaciate very much if could someone help with ideas.