Seeing the QVW will help.
Either the values for 'document' are not the same between the 2 tables or the documents that were selected have not been used on the server (and have no log references)
I suggest adding a 2nd document field in each load named differently
Capitalize(Document) as [Document-AuditFiles],
Capitalize(FileName) as [Document-Sheets],
Then add both these fields as list boxes and start clicking them to see if the values associate.
No, 'Document' field from both tables is the same and data is connected correctly by this field.
Also data is connected correctly by other key fields (SheetCode,ObjectCode).
My task - when i choose some data in ObNaame field to see:
Capitalize(Document) as Document,
from 1 table. (not it's not available)
There's structure in attachment !
struct.png 15.5 K
Because of the composite key, all 3 fields must be matching in both tables for there to be any association between a value in one table and values in the other table. Hover over the $Syn1 field in each table and see the subset ratio in each table. If they add up to 100%, then there is no association between the tables. If either of them contain less than 100%, then there are non-associated rows in the other table.
If you post your model or a sample that illustrates your problem, then someone will be able to help in more detail. It might be useful to post the spreadsheet and a couple of your log files.