Has anyone on this list used MySQL for time recording? I am a lawyer considering using it for recording time spent on cases where there are many to many relationships between cases, caseworkers, and charge-out rates.
I posted to the list under the subject "lookup" and I learned that one cannot dynamically link tables so I am enquiring if anyone has done it before / reckons they know the best way to go about it. case1 is worked on by A for 30 minutes + B for 60 minutes whose charge out rates are £10 per hour and £15 per hour; -what is the most efficient way to get -£20 due on case1; -£5 work value due to A; -£15 work value due to B. given that caseworkers might go A-Z and beyond, any combination of caseworkers might works on any of the cases, there might be a large number of charge-out rates, and these might be related to different case types and different grades of caseworker. I realise this is essentially a design question, but given the way MySQL works I just wanted to check if anyone out there has done something similar. Any (friendly) suggestions would be welcome. Simon Tierney --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php