hello. im new to infopath. i hope someone can help me with this. i have a repeating table containing diff. courses with its respective course fee, days, participants, and total fee.
two of the courses has a provision that if this course has been chosen : the client will be billed for a minimum of 10 persons.
course = CourseA, CourseB
for example the course fee of CourseA is 20,000.00, the participants = 3
so, the total fee = 20,000 * 10 participants bec. of the provision.
now, to inform the user of the form about this, i would like to use a "Show a dialog box message".
i've tried this, it works but the dialog box prompts several times before it displays the total fee and until it gets an error saying that the ONAFTERCHANGE has reached its limit. something like that...
i dont know about ONAFTERCHANGE, i've seen this in the Data Validation under Script (Events). im only using Rules.
can u please help me how to fix this using rules?
and also what should be the right usage of rules since these courses has its own conditions/provisions. it seems like when i set each course's conditions, it's not functioning well. it seems like the provision of the other course is functioning at the wrong course. Since, i have many courses listed in my drop down box. can u give me a step by step procedure on this? i'll give a few example. thanks a lot.
course coursefee days participants totalfee
COURSEA 20,000.00 1 (to be filled up) (PROVISIONS/ CONDITIONS should be set up) - if participants <=9, the total fee should be equal to coursefee*10
COURSEB 30,000.00 2 (to be filled up) (PROVISIONS/ CONDITIONS should be set up) - if participants <=9, the total fee should be equal to coursefee*10
COURSEC 40,000.00 3 (to be filled up) total fee = coursefee*participants less discount (discount = 20% if participant = 5-10 persons)
COURSED 50,000.00 5 (to be filled up) total fee = coursefee*participants less discount (discount = 20% if participant = 5-10 persons)
COURSEE 60,000.00 11 (to be filled up) total fee = coursefee*participants less discount (discount = 20% if participant = 5-10 persons)
can you help me how to do this so as not to mixed up all the formulas. thanks alot.