A User designs a set of Forms to represent the intake of individuals and their multiple phases through the system: "Intake Form"; "Phase I Form"; and "Phase II Form". These Forms have been connected by multiple Reference Fields but a single Lookup Key, as so:
|Phase II Form|
|Reference Field||->||Phase I Form|
|Phase I Form|
|Reference Field||->||Intake Form|
|Serial Number||Key Field|
This Form/Reference Structure was designed in order to be able to see all information from previous phases in the current phase i.e. In Phase II, we can extract all information from Phase I as well as their Intake information.
Currently the system does not allow for this, and will not allow the Phase II Form to open.
From the Phase I Form, the reference hierarchy looks like:
|Phase I Form: Reference Field|
|->||Intake Form: Serial Number (Key)|
The system currently accepts this hierarchy, as it can easily determine the LookupKey to use (the Intake Form's serial number field).
From the Phase II Form, the reference hierarchy looks like:
|Phase II Form: Reference Field|
|--------->||Phase I Form: Reference Field|
|--------->||Intake Form: Serial Number (Key)|
The system currently does not accept this hierarchy. The issue is due to the Phase I Form reference, highlighted. The Lookup system can resolve the reference from Phase I -> Intake Form. However, as the Phase I Form has no key fields itself, the system throws an error.
From the Phase II Form, the system should be able to pass the resolved reference from Phase I -> Intake Form as the "key" on the Phase I Form as well.