Adding Data from a form into a table

[fatmcgav]

Hi, im not entirely sure where this belongs - could be tables, reports or VBA - so im guna post it here.

Right, heres the situation.
I have a form containg two sub-forms. The main form is used to input/check order details - name & order date. The first sub-form - sfrmPond is used to input the dimensions of the pond, and calculate the pond area. The second sub-form - sfrmPondOrderDetail - contains the kit iteniary - product, quantity and price. There are 6 products that are added to each kit, 2 of which have a fixed quantity and price, and the other 4's quantity and therefore price is affected by the dimensions of the pond.

I want to be able to save these quantites and prices into the tblPondOrderDetail table, so that i can use them to create a printable report.

Any ideas on how to do this?

A copy of the database is attached for you to have a look at, but i would prefer it if u could tell me any changes etc and how to implement, cus being a novice, i always want to learn.

Thanks Again.
Gavin

 

[fatmcgav]

Anybody got any ideas?
Come on guys, ure usually brillant at dispencing the solutions.

Thanks

 

[fatmcgav]

Thanks for the reply Pat
I think I get roughly where you're coming from, but some of it i havent go a clue, dam my Access noobiness.

i am actually designing the database for a GCSE ICT coursework project. All that i need to be able to do is enter a Width, Length and Depth, then click a button and it produces a invoice/iteniary of the kit.
The problem is that the form dosent store the quantities of the products reguired, so i cant easily design the report.
All i want is for the form to store the quantites of the plants, and i can use report formatting etc to add the fountain and water lilly. A quantity of 1 and the unit price is all that is needed for those . For the liners, i need the full price, although a quantity of 1 is ok. But i need the full quantites and prices for the Underwater plants and decorative plants, because it would be too complicated to calculate these in the report.

I dont need to add any new products etc.
If you dont get any of that, let me know and i'll try to clarify.

If you could give me a guide as too what i have to do, it would be greatly appreicated.

Many Thanks
Fatmcgav