Sales Quotation form

[tacieslik]

I want to create a form that will firstly display my client details (selected from one form and then automatically entered into my main form. This will create a new record. In the main form there will also be a subform. This will be related with the main forms data (one - many respectively).
This form will be used to create a sales quotation and so the subform will be where product data is entered. The product data is in a table and I need someway of displaying the products, selecting one or more and then when a button is pressed called 'Add Products', the records will be shown in the subform of the main form. I don't quite know where to start other than creating the tables. The tricky bit for me is going to be the 'Add Products' process - is it possible? I wondered if the table could have a check box enabling the products to be selected? Then on close of the products form, have the checkboxes set to false? I would value any help on this.

 

[Uncle Gizmo]

Have you looked at the northwind Example provided by Microsoft? basically, that is what you are describing !

 

[tacieslik]

No, but thanks, I'll have a look