I have a dilemma of sorts. I am building a Data Update SharePoint List form app for a client. The data consists of Master Records, Changes to the Master and Changes from a Questionnaire sent to the data owner. I have a need to display the three sets of date "MASTER (Read Only) | Mashup (Editing Data) | Questionnaire Data (Read-Only)" on a single screen. I wanted three columns. There are well over 40 fields for each set, so ~40 * 3. I was thinking having three forms, left side is a View Form, center and Edit Form, right a view form. The concept works great, until you need to scroll the form. I can't synchronize, or scroll all forms at once so the fields stay aligned horizontally.
I could potentially put all the fields on one form but I see that as being a nightmare to manage. Since the data is from 3 different sources and I need everything to align precisely.
Has anyone ever done anything like this? I am open to any ideas. I did think of one, but not sure it's a great UX.
Looking for some alternatives.
Thanks.