I have 3 different databases that all use the same linked table for one thing or the other. Each has different uses and for different customers.
However, one of the databases when connecting to Table1 shows 200 records, where the other two databases show all 3721 records.
I have changed Cashe setting 4 different ways, removed link, closed reconnected link and tried again. For hours Ive been trying to figure this out.

Final test was I created a new record in the table1
When opened, it shows records 3372-3571, when there should be 3372-6642.
So if I create a new test record in this table, Sharepoint autonumbers it 6643 like it should and the table1 will now show 201 records...
Why would it not show my other 3000 records?