Hello, I am an insurance broker and I’m trying to create a client management database that will track my clients and the products I have sold them and also track my commissions as they are paid to me by the various insurance companies.
So there are ...
Thanks Alex… much appreciated. So if I did it how you are suggesting are you saying I would have a “sales” table in addition to a “products” table? or in place of a products table?
Thanks
Thanks Jeremy. The commission part is pretty static. for the most part they are flat fee commissions that are paid either annually or monthly depending on the product and while they can change from year to year I’m just looking to have a place to g...
