forms and subforms

[Guest]

i am creating a form and a subform, which in the Form, a customer will choose
their details from a combo box, and in the sub form, the customer will be
able to choose a product and then how many they would like to buy of that
particularitem. I can get the sub form to store more than one item that a
customer is buying, but i can't make a cloumn which works out the total at
the end of each individual sale. I can create a query which works it out, but
i can't make a new column in the form which also works it ouy

 

[Allen Browne]

Open northwind.mdb, the sample database that installs with Access.
Choose Relationships from the Tools menu, and see how the tables are built.

You can then open the Orders form, and see how customer orders are handling
by selecting the customer in the main form, and entering the items ordered
into the subform. It also demonstrates how to get the total for the order.