Hello! I need some help! Im by no means an avid Access user. Honestly, I dont exactly know what im doing.
I am creating a database to manage the (in and out) inventory of a safe. The image below shows the form.
The form of course goes to a table when a new record is created. (this signifies the item being placed in the safe) Im am also going to create a Release form, which will be completed when an item is removed from the safe. I am seeking assistance with finding a way to remove the item from the Entries Table, automatically when it is added to the Release Table (by completing the release form). I know how to make a query item on the release form to allow the user to select the record from the entries table, but I dont know how to move the entire record over, from one table to another without a complicated process. This form needs to be user friendly, for those users that arent very technically savy.
Thank you in advance for your help!!