I use following 2 remote view to pool Ms Access table data.

1. stores - store item detail, primary is is stk_id
2. transaction - in and out transaction for store item.


When I insert a record to stores table, I also need to update the transaction table. The stores table have the primary key stk_id, that is handle by Ms Access itself and that key is used to link with transaction table.

My problem is once I insert a record to stores table, I need the primary key for stores table to update the transaction table, but don't know the key value that assign by Ms Access.

Any way to know the stk_id when I insert a record to stores table?

TIA.