So I am a newbie at Infopath, so my skill level is base level compared to some of the postings I have seen here you guys are wizards so I will explain as best I can.
I have a billing sheet that is grouped by a Date field broken down into repeating tables for Personnel, Equipment, Services, Materials, Subcontractors, and Additional Fees. So far as the the repeating tables for everything except Personnel, the rules I have applied function just fine. It is when I attempt some mental gymnastics in the Personnel group that stuff goes sideways.
Personnel rates are not mathematical calculated values, they are looked up from an external SharePoint list based on the Position field AND RateTier fields. For the most part it functions fine if you select the Rate Tier pertinent to the billing sheet and then choose the Position values from the drop down. It's when you attempt to change the RateTier value that it grabs the first row in the Personnel grouping and duplicates the value for the other Position rows. It will change if you adjust the Positions after setting the RateTier again, but I want it to simply update the values for the rates without having to do this extra step. I have been beating my head against the wall trying to figure this out since it's really the last piece to the puzzle that I need to figure out.
Is there a trick to getting it to query for each row? Do I need to set the Position field a level above the rates?