I have an existing SharePoint/InfoPath/Power BI tool that has been in use for years in North America, and I have been instructed to roll it out globally. The existing tool is HUGE and I am quite certain I am near absolute capacity (column-wise) with 280 columns, so the one section that I think is most likely to require additions to suit legal requirements in each region is a checklist that I plan on breaking out into a totally separate list and form. This should enable more flexibility without worrying about a ton of work and then having SharePoint reject publishing the form.
I only give that background by way of asking: since there will be two different lists and forms, but each with one entry devoted to the same build unit, I am looking for a way to somehow "link" the two. One idea I have in mind: have a simple button in the "main" form that (when pressed) just opens the checklist list, where they create a new entry, then (when saved) copy the URL into a dialog in the main form. This seems kind of crude, but I am not sure that InfoPath has the ability to automate this any better.
For example, if I pasted a link, could I make a different button open the list entry directly, without copying and pasting a link? Any other, better ways that I could link specific entries in a list to each other?