Hi,

I've got a question regarding designing forms. I hava a table called "Sales_Invoices" (general info about the invoice) and "Sales_Inv_Desc" (list of products on the invoice) and "Products" (list of all products, together with selling prices). The tables are linked (invoice_ID and product_ID).

I have also created a query that calculates total sum of sales for each invoice.

I have created the form for inputing invoices. This form allows to input new invoices and also view all the invoices one by one.

I would like to be able to view for each invoice the total sales amount for it. What should I do to be able to see the query result of total sales for each invoice in the invoice form? (i would like to be able to view the invoices one by one in the form view and be able to see the total sales in a separate box)

Please describe the procedures step by step, as I don't control Access very well yet.



Thanks in advance for Your help.

Regards