Hello,
I have an InfoPath form I'm working with that is used for an internal R&D process around product cuttings. The data model I have created in SharePoint is 3 lists: Cuttings, Samples, and Evaluations. So how it works is the person in R&D will create an item in the cuttings list, create samples linked to a cutting in the samples list, and employees will give their feedback in the evaluations list. The InfoPath form I have created is on the Evaluations list.
On the form, an employee has to select a cutting (data source: cuttings list). Once a cutting is selected, employees have to select a sample #. The sample #s are filtered to the selected cutting (data source: samples list w/ selected cutting as a filter). Below the sample # dropdown, I have a repeating section which just pulls back the name of the selected sample #. Afterwards, there are some fields to evaluate the sample. All of these are in a repeating section as sometimes a cutting can have multiple samples we need to evaluate.
Now here's my issue: when an employee evaluates multiple samples (insert new item), the sample name disappears from the prior item.
Example:
Cutting: Bacon
Sample #: 123
Sample Name: Thick cut (this is in its own repeating section, I used this to pull back the name from the sample #)
Color: 3
Texture: 3
Saltiness: 3
Overall Liking: 7
*insert new item*
The prior item will now say:
Cutting: Bacon
Sample #: 123
Sample Name: (blank)
If I select a sample # in the new item, it will change the sample name for all of the prior and current items.
Any ideas?