I have two tables. One holds the information of the number of keys in inventory. The other stores the keyrings and the specific keys that reside on the ring. What I am wanting to accomplish is that when a key is assigned to a keyring that it is automatically subtracted from the inventory table.

Any suggestions in solving the mystery would we greatly appreciated.

An Update query to reduce the count by one should do the trick.