edcasati wrote: > Thanks to everyone for the answers. It's reassuring to know that I'm > on the right track. Concerning tracking multiple events, I really > don't like 'freeform' text, so I will probably add an additional table > for 'type of work' and make it a lookup table for the tracking table. > If I allow freeform text, it's actually more work in the long run, > since I can't just pick an option, I have to type. And it makes > searching less reliable to allow freeform text. So now I have 5 > columns: client, employee, type of work, date start, date end. Things > get complicated quick. And this is just the beginning. Whew!
I have some pdfs about designing a database. I'll send it to you if you want. In addition, google for "database design tutorial". -- Anggie Bratadinata |Web|Flash|Graphic| Jl. Raya Langsep no.21 Malang - East Java I N D O N E S I A www.nextrand.co.id ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/CefplB/TM --------------------------------------------------------------------~-> The php_mysql group is dedicated to learn more about the PHP/MySQL web database possibilities through group learning. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php_mysql/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
