The foreign keys in the sheets should work the same as in the reporting based on the same name.
Example: Now in the application there are 2 sheets Patients Overview and Patients History.
To connect Patient Overview with Patient History through Patient Number, 1:n, in Patient History the user has to create a new field with the exact name of the Patient Number as is in Patient Overview.
If in Patient Overview there is Patient ID, to make a link between the two sheets, the user should create Patient ID in Patient History.
This should work when the user click on Add Column.
The foreign keys in the sheets should work the same as in the reporting based on the same name. Example: Now in the application there are 2 sheets Patients Overview and Patients History. To connect Patient Overview with Patient History through Patient Number, 1:n, in Patient History the user has to create a new field with the exact name of the Patient Number as is in Patient Overview. If in Patient Overview there is Patient ID, to make a link between the two sheets, the user should create Patient ID in Patient History.
This should work when the user click on Add Column.