A method and system for controlling an application server in order to provide application services to clients while maintaining synchronization between records of tables of a database server. An application server retrieves records of tables and stores them locally on the application server. When a client requests some fields of a record of a table, the application server generates a bookmark that uniquely identifies the record. The bookmark may contain a table identifier and a record identifier or a query identification and an identifier of a record within the query result. The bookmark is opaque to the client and only the application server need know how to interpret its contents. When the application server provides the requested fields of the record to the client, it also provides the record bookmark to the client. When the client wants to identify the record, it uses the bookmark provided by the application server.