So i have a form who's record source is a query which is looking at 2 tables to filter out by product. with the two tables within the same query i am unable to update the records and get this error, if i remove once of the tables it all works fine, so how do i get around this.
Is it best to Copy records to a temp table update them and then move them back - if so how do i do this without create a duplicate:?
Is it best to Copy records to a temp table update them and then move them back - if so how do i do this without create a duplicate:?