I have created a database to track inventory control. One form accepts input about a specific computer, which then links to another form to enter the software on that computer. This information is linked together and stored in two tables. I have another table that keeps track of all company software purchased with the number of copies purchased and the number of licenses available and used for that product.
I am looking for a automatic way to add/delete to the number of copies/licenses used when a specific software is added or deleted from the computer database. So, when I add “Software 1” to a specific computer, the number of used licenses increments by one. Are there any suggestions on how to do this?
