I am working on a windows application that allows a system
administrator to assign users to specific software titles. Let's say
that there are 5 available licenses for Visual Studio but 6 users need
the software at one time. What I did was create an OC table
(out-of-compliance) and added the 6th person to that table. I've also
created a feature in the software that allows the admin to add
additional licenses to the database. Is there a way to configure the
tables to add 2 users from the OC table to the SoftwareUsers table when
additional licenses are added? I'll try to explain it more in-depth:
3 licenses available for VS
4 People need VS
3 People written to SoftwareUsers table
1 Person written to OC table
System admin adds 1 more instance of VS
Person in OC gets moved to SoftwareUsers table
I can see this using some sort of SELECT TOP X where SoftwareTitle =
"VS...." but don't know the easiest way to implement it.