Linked Table Manager show same records

[uoghk]

The following is a query run on SQL Server, it shows different records and total 204 records.

I use Linked Table Manager to link to the table _QryDispenHistory, it shows 204 records, but they are all the same as below

Actually, I use Linked Table Manager to link other tables from SQL Server, they are all correct.
How can I fix it?
Thanks

[Welshgasman]

Don't keep creating a new post for the same problem. https://www.accessforums.net/showthread.php?t=88275

[Gicu]

So your problem in the other post might not be caused the code used to set the record source but the actual data from the source table. Is _QryDispenHistory a SQL table or a view? What driver are you using? Paid is the same on all 204 records so I think it might be a view????

Cheers,

[NoellaG]

For linked tables or views from SQL you need to give a unique combination of fields as primary key for access. For tables the primary key of the table is automatically taken as PK for the linked table. For views, you might need to give the PK combination yourself. If no PK possible, create a procedure in SQL server to retrieve the recorset and link the procedure to Access.

[uoghk]

Thanks all.
I create a unique PK in SQL and then re-link it again, it works.