Hi all,
I have a SQL table linked in to an access frontend, sometimes the table needs to be opened from the table view in access and filtered upon. The table has a primary key which is an autonumber, however when filtering on some data in the table the results return as if the table has lost its indexing, and the autonumber (primary Key) is all jumbled, and requires manually re sorting
Can anyone help as to why this happens or how to stop it from happening
Thanks in advance
I have a SQL table linked in to an access frontend, sometimes the table needs to be opened from the table view in access and filtered upon. The table has a primary key which is an autonumber, however when filtering on some data in the table the results return as if the table has lost its indexing, and the autonumber (primary Key) is all jumbled, and requires manually re sorting
Can anyone help as to why this happens or how to stop it from happening
Thanks in advance