I know I've been half heartedly talking about this CRM system I've been building and directing people to a .zip file, well I finally took the time to put up a live working example on my site. I would really appreciate it if anyone who looks at it, if they would enter in a few contacts, departments, companies, whatever to help flesh it out. Obviously I couldn't post up the real data and I don't have the time to re-create a bunch of fake data to see it in all it's glory; so I rely upon ya'll. I would appreciate if people didn't do malicious things to this online demo as I don't have the time to continually clean the database. I encourage you to INSERT new records and play with them, but please don't change the "test/test1234" or else nobody will be able to login and play too. I have disabled 'delete' at the database level, so that should help a little bit. Honestly, this looks much more impressive when there's more data in it. Some portions (like the contract/invoices) are not fully done. I've temporarily halted work on this project. Anyone want to donate me some nice icons/graphics for the missing parts, I'd love that. I'm no artist, and I pretty much stole all the graphics from various other programs and websites. The Appliance part is pretty damn cool. While not live on here, for our real CRM, our appliances check into this every day. I'm very proud of the code and underlying layout, and would encourage people to downlaod the .tgz and examine how it's structured so they can make more efficient code. To me, Code is an artform. The code is just as sexy as the final product the user sees. I hope you'll agree... http://daevid.com/examples/crimson/ Login as "test" and "test1234" for the password. Add yourself as a new rep if you like. Add new companies. The trick to remember is that companies are global, and reps own departments. Departments own contacts AND contracts. Contracts own invoices. Invoices own sku's and pos... Daevid. "Ezekiel 25:17. The path of the righteous man is beset on all sides by the inequities of the selfish and the tyranny of evil men. Blessed is he who in the name of charity and goodwill shepherds the weak through the valley of darkness, for he is TRULY his brother's keeper and the finder of lost children. And I will strike down upon thee with GREAT vengeance and FU-U-U-URIOUS anger, those who attempt to poison, and destroy my brothers! And you will KNOW my name is the Lord, when I lay my vengeance upon thee!" -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php