Form Issue

[crcastilla]

I really hope someone can help get through this. I been trying to play with database for a while now and I can't do it. I'll try to explain it my best.

First I have one table that has the following fields:
MP No. (This is my primary key) Field Type: Number
Entry, PO, Contact, Phone, Terms, COC

Now, I have another table with the following fields:
MP No., Quantity, Heat No, Size, Price

Now, because I wanted a field that will automatically give me the total (Quantity * Price) I created a query as follows:

MP No., Quantity, Heat No, Size, Price, Total (In design view I put "Total: [Quantity]*[Price]"

Now after that I went into relationships and put the first table I made and my only query. My relationship is MP No with MP No. No force referential or anything.
Now my first table looks this and I can input information as follows:


Each MP number has more than just one quantity or heat or size.
Finally, I want to create a form in which each form the whole information of EACH MP No. is in there individually.
So in a form the MP 29500 would have all of the information like order entry, contact, quantity, total, etc. How in the world could I do this?

 

[crcastilla]

Thank you so much.

I have a couple more concerns but I think are easy to solve.

When I create a form from a query the information appears in one whole "block", is there anyway that I can separate it to move around the information to put it wherever I want.

Also, when I create the sub form it appears in the form view as a table. Any way to change that?

Thank you once again