thanks eric, i know it might not make much sense.
basically the app is a backend system that sales will store clients details. however the products that they sell range from car insurance to house insurance so not every product has the same fields in the db or the form that will be used to submit the data.
using dataassist, css form builder and security assist i want to be able to have sales go in log clients. so a salesman can have multiple clients, the client can have multiple products sold to them.
i just need some guidance on how to setup the db for the products as it is not same for every product will it be a table for each one?
any help would greatly be appreciated eric.