Hello,
I have a simple LEFT JOIN query like below. The left table (tblSmall) is a from an SQL server (1000 records), the right table (tableLarge) is from a Oracle back end (200k records).
I would like to use this query as the data source of a simple form in datasheet view where the user can see the records of tblSmall with some fields from the tblLarge.
The query as it is shown comes out as "not updatable", so I tried to change its property Recordset Type to "Dynaset - not consistent updates". This make the query updatable so it looks ok, the user can add records: the problem is that if the user cancel one record from the query then the record is cancelled from both tables, which should be absolutely avoided. I would like to have the record cancelled only from the left table, i.e. tblSmall.
I think that this can be solved with temporary tables and some programming, but I wonder if there is a quicker way to do it by just using queries and a form using query as data source of the form.
Any help is much appreciated.
I have a simple LEFT JOIN query like below. The left table (tblSmall) is a from an SQL server (1000 records), the right table (tableLarge) is from a Oracle back end (200k records).
I would like to use this query as the data source of a simple form in datasheet view where the user can see the records of tblSmall with some fields from the tblLarge.
The query as it is shown comes out as "not updatable", so I tried to change its property Recordset Type to "Dynaset - not consistent updates". This make the query updatable so it looks ok, the user can add records: the problem is that if the user cancel one record from the query then the record is cancelled from both tables, which should be absolutely avoided. I would like to have the record cancelled only from the left table, i.e. tblSmall.
I think that this can be solved with temporary tables and some programming, but I wonder if there is a quicker way to do it by just using queries and a form using query as data source of the form.
Any help is much appreciated.