Hi Everyone,
I cannot tell you how glad this forum exists.
I’ve got an issue and it’s probably been asked before but I
cannot find a good representation of it when I search.
I have a expense request form that deals with mileage. I have a SPList that stores Begin_Date,
End_Date and Rate_Per_Mile. The list
will be updated by the person who is responsible for the information.
In my form I have a Date field and a Miles field in a
repeating table. I want the
reimbursement amount to find the right row with the right Rate_Per_Mile and
calculate the amount. I tired it by
adding a secondary data connection and no matter what I put in for the date on
the expense request, I get the first row and I’m not sure what I’m doing wrong.
Any help would be greatly appreciated.
Thanks.