rob - 2009-07-30 18:38:23
having helped a friend with his website i also decided to help him with a simple intranet - again no problem there.
now the question he then asked was , is it possible to have a 'system' and by that he went into detail as shown below;
1 - can i create a database of clients
2 - everytime they ask me to do work on them can i create a "file" for them as under their client code
3 - can each "file" contain a record / history of events
4 - can each item in the record/history relate to time spent & costs
5 - is it possible to link to a typed document - either in MS word, open office, etc, but to effectively pull through content, and by that i mean having a document and extracting/populating the database information of a client details (such as address) and for each "file" i can call the same document and it will pull through the relevant information stored for that person.
there were a few other points mentioned but i was under the impression points 1-4 are fairly straight forward to implement, it is point 5 that i am having most of my problems with. this is mainly as im still a php newbie and havent noticed any modules or any kind linking to documents before, i have also taken the assumption that php may not also be the best language to achive what i want to, but if that is the case im sure someone will be able to advise me otherwise?
i eagerly await replies
thanks,
R.
