I need similar database template example for licence evidence

[salonikije]

Dear,
I'm trying to create new Access app for licence evidence.

I imagined it in the following way:

1. I have to have a list of licences in which it will displayed columns with name of licence, initial state number, current number and difference between these states. Also, i have to have an option for adding new type of licence;



2. I have to have an institution register which will be licenced;

3. I need a functionallity to enter data when some of institution need to obtain some number of licences so it's related with number of licences (for example, if someone need 10 licences of Windows 10, when I enter data for that institution, it will be automatically removed from the current state).


I can do most of these things myself, but I need an example with (3) functionallity...

[alansidman]

See if you can find a similar template at this site.

http://www.databaseanswers.org/data_models/

[salonikije]

See if you can find a similar template at this site.

http://www.databaseanswers.org/data_models/

Dear, thank you very much! I'll try to find something interesting...