Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › setup products table mysql database

setup products table mysql database

Thread began 1/15/2010 9:33 am by mr hankey | Last modified 1/25/2010 4:34 pm by mr hankey | 2328 views | 9 replies

1/25/2010 4:34 pmEric Mittman

You are exactly rite about the relationship between the users and clients. Since user's can have more than one client, but clients do not have more than one user you should add in a user's column to the clients table. This will be a foreign key in the clients table that relates back to the users.

As for the clients and products I think it would be best to have a separate table that joins the clients and products.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.