I am running into an odd problem. I have a form published on SP 2010 and a user can open it, push a button so it populates the form from MSSQL and make changes. The user is then supposed to email the form to the next person. Person A sees all the fields (spread across various views), but person B cannot see data from repeating sections where the source is a secondary MSSQL table. It seems to keep all other data without a problem - even the changes Person A made. All other fields are set to 'Refresh value when formula is recalculated' and the data connection is set to 'Store a copy of the data in the form template'. I do not have 'Automatically retrieve data when the form is opened' as it ends up overwriting changes made by Person A.
Anyone see this problem before? Or know how I can fix it? I would prefer the users not to open the form from the SP site (except Person A) and to have to respond as delegated parties when they receive the form as a mail attachment.