You can do two make table queries even if the data is not updateable.
Do a make table from items. You can do that in the current database or as
@moke123 in a side database. The benefit of the side database you do not have to account for bloating of the current database..
Now you do not update tblItems since you can quickly link to the temp table.
If you do it in the local database then you might not want to constantly add and delete or you will bloat the database. You would have to update the temptable. Now you added a level of complexity. The side database is nice because you save the temptable, but "blow it away" when done. No concern about bloat.
To see this done
Hello, I need to create a temp table for my one subroutine to work. I have a sub on form load even which checks if temp table exists or not. If it doesn't, then it creates it. Should I delete the temp table while closing the form or let it remain for next time usage? Will creating and then...
www.access-programmers.co.uk
But bottom line do not store this calculated value in the main data table. Store it in another table.