I have an Access 2010 frontend which is linked to a view on SQL Server 2005.
In the table if i enter a value in one field it will change the selected record to another record and auto fill the other fields with the data from that existing record.
There is an identity column which should automatically increment up by 1 but instead it shows the id of the existing record. The big problem is that when this happens users may end up deleting data from records not realizing what they are deleting.
Any help much appreciated!
In the table if i enter a value in one field it will change the selected record to another record and auto fill the other fields with the data from that existing record.
There is an identity column which should automatically increment up by 1 but instead it shows the id of the existing record. The big problem is that when this happens users may end up deleting data from records not realizing what they are deleting.
Any help much appreciated!
