Thank you that did work. However I am running into another problem.
I realized that I need to combine more than two fields to get a total on this form.
There are a total of 4 fields involved in the calculation of the total amount.
I have:
1. Hotel Requested (which has per night amount like $105)
2. How Many Nights Staying
3. Number of King Rooms Requesting
4. Number of Double Rooms Requesting
Can I use the same method of having the first 3 fields with the fee field turned off then enabling the 4th field as the fee field? Or is that to complicated for it to handle?
Addition and multiplication would be needed in this calculation. Figured it would look something like this, using the last field (number of double rooms) as the one to input the code:
([FIELD_VALUE]+[PF_KING_ROOMS])*[PF_HOTEL_STAYING]*[PF_NIGHTS]
Is that correct or is that something the form is not capable of?
I attached a screen shot of the form.
