Good afternoon,
I have a form with a nested sub form to create delivery notes
The parent form links to a single table and creates a delivery note number, logs the customer and the date.
The sub form is based on a query that contains 2 tables, both tables have the same data in a field in each, table 1 "Job No" and table 2 is "insightJobNo"
The join is correct and has always been include records which match both tables. I have altered this to include all from table 1 and matching from table 2 but this has made no difference.
There are no calculated fields in the tables - this is all done on the forms.
This has happened previously and deleting and replacing the users front end file has sorted it in the past - not this time though!
I have an archive version of table 1, which every so often I archive records from table 1 into the archive in order to keep the size of table 1 down to around 12000 records.
I have archived today and this issue seems to have started after this, but it's never been an issue before.
If i create a new query with table 1 and table 2 the recordset is not updatable deleting either table from the query and the table is obviously then updatable.
Any clues where on earth to start diagnosing this one?
I have a form with a nested sub form to create delivery notes
The parent form links to a single table and creates a delivery note number, logs the customer and the date.
The sub form is based on a query that contains 2 tables, both tables have the same data in a field in each, table 1 "Job No" and table 2 is "insightJobNo"
The join is correct and has always been include records which match both tables. I have altered this to include all from table 1 and matching from table 2 but this has made no difference.
There are no calculated fields in the tables - this is all done on the forms.
This has happened previously and deleting and replacing the users front end file has sorted it in the past - not this time though!
I have an archive version of table 1, which every so often I archive records from table 1 into the archive in order to keep the size of table 1 down to around 12000 records.
I have archived today and this issue seems to have started after this, but it's never been an issue before.
If i create a new query with table 1 and table 2 the recordset is not updatable deleting either table from the query and the table is obviously then updatable.
Any clues where on earth to start diagnosing this one?