I have been trying to figure out just what RE does but my small brain doesn't seem up to it. Here is my situation:
I have no server. I have a form created using LS that is distributed to 50 end-users using Acrobat Reader. These users will fill in the form, save it, possibly print it, and email the filled-inform.
The form requires a sort of database containing multiple names and addresses. The names are used to populate a drop-down list contained in a repeatable subform. Each time a new instance of the subform is created, the dropdown is populated with the list of names for selection. Selection of a name causes the address information to be automatically populated into the subform.
My solution so far is to have another repeatable subform (1 to n instances) containing the name/address information. The administrator enters the name/adress information (1 per subform instance), then saves the form, then emails it to the end users. Each time the name/address info changes, a new version of the form is distributed - the end user never updates this info.
It would be handy to maintain the name/address info in a spreadsheet instead. This would allow easier maintenance of the data (copying, sorting, etc). My understanding is I can't use a data connection to the excel spreadsheet because of rights management on strictly local forms. Is this understanding correct?
I want to distribute the form and an excel spreadsheet in order to be able to update the form and the data independently.
It seems like RE may answer this problem? Is this correct?
Thanks to all for any advice and information!