Hello,
I hit a block working on a form with a repeating table.
I want to select a row out of a predefined table and run calculations on other fields in that row, currently my form only uses the first row of the table for the calcuations.
I linked the HallName drop down box to the data source (should it be linked to the table or the field?) and that works fine.
AccessTable - This table is an XML table included with the form, it holds information on five seperate sites each listing the cost of their hourly Rate and other resource information. (I have this saved in XML or can use a Sharepoint list, i do not have to use access if it makes a difference)
One last piece of information, I have two tables - the first holds all the pricing information and the second is built for the final invoice style output.
Basically what i want to do is use the "RateType" dropdown list to pick what number to multiply with the HoursBooked field.
Hope this makes sence.
Thanks
Arran