Hello everyone
I am a lawyer working in a company and i need to develop a database to store the cases in. I created the table (attached) which contains all the fields i need. However, there is a certain field that i can not do, which is about the adjournments of the cases' hearings.
Now lets say that for each single case (record) i have these fields: Case no., company name. opponent name, strategy, notes, next hearing & decision, the problem is at the last two fields:
lets imagine scenario:
the first hearing of the case is on:
01/01/2016: first hearing then adjourned until:
05/01/2016: to serve the summons to the defendant: ...
10/01/2016: for the defendant to prepare statement of defense
and so on
The most recent date should be always in the future, and on the top.
So how can i create multiple (anything) in one field?
I will appreciate if someone can do it on the attached database with some explanation.
One more thing, I want to create a form based on the table to see how it will look like.
Additional ideas will be appreciated.
Thanks in advance
Regards
Muhammad