I found this little windows program and gave it a shot. I am a novice at database design and forms using php and MySQL. The trial version of this program allowed me to create only 4 tables, but for $35, I guess its a very good investment that saved me a fortune hiring a programmer to do it. The only problem that I found was with the date fields, which you have to view and edit using the weird format "year-month-day", but it wasn't a big issue though. I wish the reports were easy to create inside the prog instead of writing the sql code myself. With the help of the author (who provided surprisingly rapid support), I was able to insert images in the tables and create some helpful reports.
For example, I can define suppliers in a single table and then have all spare parts, raw materials and other items tables see the suppliers as a drop down menu that is automatically updated when I update them in the suppliers table. What's really unique about this program (something I didn't find in any similar program) is the ability to easily create relationships between tables, somthing like the lookup wizard of MS Access, and it's even easier to use. The scripts ran smoothly after setting up the db (using one of the scripts) and every employee was able to access the data from anywhere via the net and search easily using the cool filters provided. Each version with its own permissions that allow employees to view and/or modify the records according to their authorities. Using this program I was able to design my 26 tables inventory and supplier chain management database, define relationships between tables, and generate various versions of my db front-end. Search Engine Optimization (SEO) Plugins.