Subform Question

[aporkalypse_now]

I have fairly limited knowledge of access.

I have a form that I have created to process purchase orders. I have tried to no end to insert a subform that would let me add multiple line items qty cost and total cost, that will let me add as many records as I want and give the grand total as part of the main form.

I am stuck with using the main form and a set number of fields to do this calculation. If I don't have the max number of line items, I have to zero fill the qty and unit price to give me a total price calculation per line item and a master grand total for the whole form. Can I create the aformentioned form on 97?

Thanx to all

 

[Jack Cowley]

Look at the "Orders" form/subform in the Northwind database that comes with Access. This is what you are after. Also search help for Relationships and read up on One to Many relationships....

 

[aporkalypse_now]

Jack thank you but I still have this problem after studying the Northwinds example.

Is there anyway I can create a subform without preset items that will perform the function that I need?

 

[cindyareed]

I also have a question regarding subforms. I am trying to learn Access and have run into a couple of things that I may not have done correctly. I have created a Student table with the student first and last name as the PK. This file also contains Parent 1 First and last name and Parent 2 First and last name. The parent table has Parent First and last name as the PK to that file.

I have created 2 relationships between the student and parent files. 1st is the parent 1 F&L name to the parent table F&L name and another relationship of parent 2 F&L name to parent table F&L name.

When I create my sub-form, it has parent info as the main part of the form with the children listed below. The problem is that it will only list children for the Parent 1 information. The strange thing is that Parent 2's child record has the 2nd parent information in the 1st parent fields on the sub form. Can Access handle this type of relationship?

I did not get what I expected from my query either. I ended up creating 2 queries by establishing the relationship at the query level for each. The problem with this is that they still have to be linked back together somehow if you want to print labels for instance.

Any help will be greatly appreceiated.

thanks Cindy