Form design problem. pls help!

G

gz

I have the tables Orders and OderDetails.
I need create a form for data input and view of these two tables.
I'm wondering is there any wizard to create this kind of forms?
If there is no such wizard, what's the normal way to design the form? I'm
just confusion as the number of the Details are unpredictable, its obviously
inapplicable to put lots of text boxes on a form for data input.

Anyone can help?

Thanks!
 
D

Duane Hookom

Open the Northwind database and see how it is done. Normally the subform is
a continuous form on a main form. The Link Master/Child properties on the
subform control "link" the main report to the appropriate related records on
the subform.
 
G

gz

Thank you for the help!
Now I got the subform. However, I am not clear how the total is calculated.
I did not find the code to do this anywhere.
Do you have time to tell me how it works?
Thanks again!
 
D

Dale Fye

You can to the totals several ways. The easiest is to put a text box in the
footer of the subform, right under the column you want to sum. Give this
textbox a label, something like "Total", then, in the Control source
property of the text box put:

=Sum([Amount])

Replace [Amount] with the name of the field you are totaling.

HTH
Dale
 
D

Duane Hookom

How what total is calculated? You can add a calculated text box on the main
form that displays the total from a subform.

Are you thinking that you want to "store" a total in the main Order table?
 
T

Tom Wickerath

Hi gz,

Try my tutorial on this subject:

Displaying Subtotals and a Grand Total on a Form
That Displays a One-to-Many Relationship

http://www.access.qbuilt.com/html/subtotals.html


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

Thank you for the help!
Now I got the subform. However, I am not clear how the total is calculated.
I did not find the code to do this anywhere.
Do you have time to tell me how it works?
Thanks again!
 
Top