OK I have searched and searched for a simple answer to this task:
I have multiple lists that are related. Example: Client, Spouse, Dependent, etc. All lists have a lookup that references the Client table. This works fine.
If I add all the lists to a display (multiple App Parts) and put them in tabs so the data is presented in a better way how can I if I click on say Spouse and click "Add New" - how can I force the Lookup field to auto populate with the Client name in the main tab?
We have thousands of clients and manually filling in this field is not practical and I am still barely learning how to script, I am assuming this will require scripting to work.
Are there are easy solutions or OOB solutions I can use for this?