Essentially my end goal is to have a quoting form as my main form (of course there will be a client dashboard where the user can perform other tasks) but the main idea is just to create a quoting form that displays individual quotes by QuoteID, where each quote has a customer and employee attached to it, a subform where pre populated items can be select from a drop down list and another control box that allows the user to put in a QNTY of that item and a control box that multiplies the lineal metre price by the qnty (calculated field).
The pre populated items will contain a description of the product "i.e. Cabinet" and also a set "Price Per Lineal Metre". So when the user selects an item from the drop down list on the quote, the lineal metre price will already be there, so all they have to do is type the QNTY. - And then of course the total price will by self calculated.
I will build all the reports and design the GUI and create all other functionality. All I need is for someone to create/manipulate tables and queries to allow user input on a subform where all they have to do is select an item from a pre populated list and type in the qnty.
One last thing that I will require is for there to be a "margin" field on the main quoting form where is allows either a percentage or a float number that multiples the total amount from the selected items in the quote by the margin. And two other fields that state the total without margin, total with margin and total profit (difference between total without and total with margin).
If there are any concerns or you require more information, I am happy to provide annotated screenshots so that the scope of works is understood correctly.
I have provided a JPG image that details what the quote should look like. I hope this helps understand the scope and the functionality required.
I will also need to pull the customer email address so that I can send a copy of the quote minus profit margins to their email address.