How I can create simple database for example vacation request in SP list? It will looks like that: I create probably two list. In first list is vacation days people and on the second list is vacation request and when I add new vacation request I will see how many vacation days I have and when I take new day, this day subtract from my vacation days in first list and update this list and next time will be the same...
I have SP Foundation and Designer 2010.
Thanks for help,
You are on the right tracks with two lists and a parent-child relationship.
The tricky part is to keep track of the number of days left. You could have a workflow update the count, but what if the request later gets deleted? Workflows don't run on deleted items, so you're stuck. A workaround is to disable item deletion, and have a choice field for Requested/Approved/Cancelled.
Without workflows, the easiest way is to create a grouped view (by people and year) of your vacation requests and display the totals. Then you could compare these totals with the number of vacation days allowed (first list).
That's not something which is simple in SharePoint
Without code your only option is to create a workflow on the second list which on create/update of items find the corresponding entry in the first list and updates the dates left. But it'll not add them back again if the entry is deleted.
If you extend your arsenal to include code, then you have the possiblity of adding an event receiver which can catch additions/updates/deletes. To play it safe you might also want to add a timerjob to periodically make sure everything is in sync.
If your environment don't allow server side code (even sandboxed) you might be able to have some code running on another maching periodically which made sure everything was in sync using Client Side code, but you may of cause just replace this with human intervention.
