Thanks so much Jason, so reading that you basically dont need to setup the relationships in mysql database it all gets done at applicaion level using the extensions in dreamweaver.
When you say force referential integrity would for my application this be needed:
Sales person add a lead, then converts it to a sale and sells multiple products. If he deleted 1 product from the sale or deleted the sale but wanted to close the lead to a non mover just now would this need referential integrity?
Many thanks again.