Hello everybody

I was browsing the internet for some solution on attendance DB tables design. There are more solutions, but i think my issue is more specific.

Look at the attachment. There is a picture of report.

There are some fileds:
- employee ID
- Employee whole name
- Date according to month
- and fields of kind of absence:
- kind of absence (e.g. Holiday, Present, Silk, .... etc.)
- number of document where is typed permission for Holiday, Duty trip.... etc (eg. 123/2009)

Look at the next attachment. There is an example.

I have tried this:

Using VerticalGrid can be solution.

Table structure:

Fields:

- date - date of event, absence.....
- employee_status_SUFFIX


- employee_permission_SUFFIX

Last two fields are cumulated for every employee, ehere SUFFIX is replaced with Employee ID.

So, the result is:

if we have 20 employees, table will have 40 columns(fields) + date field

it is not optimal solution, but please help me find better or the best.

Thank you for your help.

Mike