subforms

[agmorgan]

Hi. I am a new ish user of Access, I have used it for simple databases in the past. However, I want to get a bit clever and I am starting to drown.



I have a number of tables with core information / lists. In my case this is types of material, Flat bar, angle bar round bar as an example. In another table I have a list of these materials broken down in to sizes and cost. i.e Flat bar size 10x4 $6, Flat bar size 10x6 $8 . Clearly this particular list is very long.

I want to create an order sheet. therfore in a form I choose the material and in a subform a list of the avalable products comes up. Which is great.

BUT I want to save this all in a new list and for the life of me I don't get it. My understanding is that if I make an alteration in this form I am clearly altering the core data list.. Not recording it in a seperate list.

I have set up a seperate list but can see no way of linking this great looking form with the area I want to record the data.

The microsoft book I am working through show me how to do all the little elements but no where does it show how the record is saved. Clearly I am having a mind warp Can anyone point me in the right direction.

Andy

[orange]

Here is some info on bound forms. See if it helps.
Bound forms are tied to an underlying tablr or query.
http://www.dhdurso.org/articles/ms-access-forms.html