So I am trying to design an license tracking type tool in SF. I need to have a license custom object and then a list of users or contacts who the license applies to. There would be a set number of seats so I need to be able to track seats available and seats used.
My first thought with this was to add a checkbox field on contact like 'Licensed User'. But I need to be able to roll up sum those from the license object. I can't seem to do that. How would I go about getting the seats used and seats available would I have to create my own custom licensed user object for each user then add that as a detail in master-detail relationship on the license object? Is that the only way? I guess I really wanted to utilize the existing contact object.
Any thoughts on this approach or a totally different idea would be welcome.