first of all a big thanks to everyone that has helped so far(nearly there).
i would like to create what i call 'a client departure form'
what i want to do is click 'depart' button, select a client, and go to a form that lists the treatments that client has just had. tally the cost of the treatments and display that total. that is just the start.
then i would like to be able to add further treatments and product that they wish to buy.
i know that it is possible but i dont know where to start with tables, qry forms etc.
i really need some guidance on this.
thanks
ps. if you need me to uploa my database for you to know how it got here i will try but it is getting large.
i would like to create what i call 'a client departure form'
what i want to do is click 'depart' button, select a client, and go to a form that lists the treatments that client has just had. tally the cost of the treatments and display that total. that is just the start.
then i would like to be able to add further treatments and product that they wish to buy.
i know that it is possible but i dont know where to start with tables, qry forms etc.
i really need some guidance on this.
thanks
ps. if you need me to uploa my database for you to know how it got here i will try but it is getting large.