Customer, product, parts relationship
My vision is to be able to open a form, type in the customers name. if they are in the database already it will populate all of the customer fields. Then I will select the parts from the price spreadheet and it will calculate the cost based on the quantity I select. then with a click of a button it will output a proposal combining the information in a pdf or spreadsheet format. That should be my option. Also each section of the pricing spreadsheet should be broken down as well. ie unified dialing, voice portal etc. I dont know if they shuld all be in seaparate databases or what. Can anyone help me with that? Am confused what to do as am a new bee.