MichaelSmith
Registered User.
- Local time
- Yesterday, 23:13
- Joined
- Jan 7, 2014
- Messages
- 34
I've been building a database which will be used on a large archaeology project to store and analyse data on shipwrecks.
I built the database in Access 2013 and am hosting the backend on a Windows Azure SQL Database. I converted the database to SQL Azure using SSMA for Access.
I currently have 615 rows in most of my tables, the problem I'm encountering is that the tables are not being sorted by their primary key, in one case they're being sorted by an index which doesn't allow duplicates except for NULL and in another it seems to be using the number at the start of an address line.
It's not the end of the world, honestly it's just an aesthetics issue BUT is there any way I can make my Access Forms in the front end automatically sort by Primary Key without having to force the user to right click and choose sort smallest to largest?
EDIT: Please move this to the forms sub-forum if it's more appropriate.
I built the database in Access 2013 and am hosting the backend on a Windows Azure SQL Database. I converted the database to SQL Azure using SSMA for Access.
I currently have 615 rows in most of my tables, the problem I'm encountering is that the tables are not being sorted by their primary key, in one case they're being sorted by an index which doesn't allow duplicates except for NULL and in another it seems to be using the number at the start of an address line.
It's not the end of the world, honestly it's just an aesthetics issue BUT is there any way I can make my Access Forms in the front end automatically sort by Primary Key without having to force the user to right click and choose sort smallest to largest?
EDIT: Please move this to the forms sub-forum if it's more appropriate.