Trying to update table "items" bases on the contents of table "temporaryitems"
what i need to do i to go and check if first record on my subform called "temporaryitemsqrysub1" already exists then go and update in table "items" but if does not then go and add it in table "items", then got to second record on the subform and check again so on till the end.
i'm attaching a sample of my database which i can not get it to work
using access 2016
thanks
what i need to do i to go and check if first record on my subform called "temporaryitemsqrysub1" already exists then go and update in table "items" but if does not then go and add it in table "items", then got to second record on the subform and check again so on till the end.
i'm attaching a sample of my database which i can not get it to work
using access 2016
thanks