For simplicity, I have the 2 tables below in my front end (Table1 & Table 2). The one is Sales by Manager whereas the other is Survey Count by Survey Manager. The values in the Manager and Sales Manager fields are the same person. I want to create a table in the front end where Manager and Survey Manager are linked. (see below table Correct).
However, my table is not displaying correct (see table marked Incorrect)
Please note, I don't want to link it in the backend as it has implications on other parts of the model.