ill try and explain this one as best i can.
i have a list of treatments that clients book in and pay for when it is completed. however there are a couple of treatment items that the client can purchase a course of. ie we have a body wrap that the client can purchase a course of 3. this is of course discounted to encourage them. i need to be able to find a way of adding a course as an item. now that bit is simple but what i am finding difficult is:
if a client has purchased a course and that client has a treatment from that course there is obviously no charge as they have already paid for it.
i have uploaded my database so you can see for yourself what i mean. i may need a lot of changes to make this happen.
on frmDeparturesPaymentScreen i would like to add a button that says 'Courses'.
the course would then be added to the payment screen and the value added to the total. but there will still be an item on there that would not need paying for. the course item. on each and every item in the list box you can double click it to open another small form to make changes. ie price and employee. i would like to be able to double click the course item and in some way change it so it is no longer payable but only if the client has course items remaining. maybe i would have to do it as 2 different transactions to make things a little more simple but i dont know how to set it all up. ive been racking my brain for weeks now trying to think of ways buti seem to hit a brick wall. the main stumbling point is that the course i have in mind in a UCW priced at £120. this is a course of 3 so each treatment in that course is £40. but the actual price is £44.95. now for report purposes when i want to look at what an employee has done over the last 6 months i want to be able to take that into the caculations. i suppose i could do it manually but in 3 years time am i still going to remember what the course price was or even in 10 years.
so, i need to be able to remove the charge on the course item if the client has purchase a course and still has course items remaining. also i need to be able to record and amount 'course price' / 'course quantity' for reports.
i hope i have explained myself well enough
answers on a postcard please.
i have a list of treatments that clients book in and pay for when it is completed. however there are a couple of treatment items that the client can purchase a course of. ie we have a body wrap that the client can purchase a course of 3. this is of course discounted to encourage them. i need to be able to find a way of adding a course as an item. now that bit is simple but what i am finding difficult is:
if a client has purchased a course and that client has a treatment from that course there is obviously no charge as they have already paid for it.
i have uploaded my database so you can see for yourself what i mean. i may need a lot of changes to make this happen.
on frmDeparturesPaymentScreen i would like to add a button that says 'Courses'.
the course would then be added to the payment screen and the value added to the total. but there will still be an item on there that would not need paying for. the course item. on each and every item in the list box you can double click it to open another small form to make changes. ie price and employee. i would like to be able to double click the course item and in some way change it so it is no longer payable but only if the client has course items remaining. maybe i would have to do it as 2 different transactions to make things a little more simple but i dont know how to set it all up. ive been racking my brain for weeks now trying to think of ways buti seem to hit a brick wall. the main stumbling point is that the course i have in mind in a UCW priced at £120. this is a course of 3 so each treatment in that course is £40. but the actual price is £44.95. now for report purposes when i want to look at what an employee has done over the last 6 months i want to be able to take that into the caculations. i suppose i could do it manually but in 3 years time am i still going to remember what the course price was or even in 10 years.
so, i need to be able to remove the charge on the course item if the client has purchase a course and still has course items remaining. also i need to be able to record and amount 'course price' / 'course quantity' for reports.
i hope i have explained myself well enough
answers on a postcard please.
