Help with tables

[crcastilla]

Okay, I'm really stuck at this.
I will try to explain my best.
I have two tables. The first one is as follows:

MP No (Primary key), Sales, Date Entry, Specs, Email

The second Table is as follows:

MP No, Quantity, Description, DWG, Price

There is a "one-to-many" relationship between the two tables through the MP No field so whenever I go to the first table there is a sub-table for each MP No. Correct?

Now, my question is, can I create an extra sub table under the sub table already created?

 

[Isskint]

simple answer is yes. At table level viewing it would have to be related to the second table (in table view if there are more than one related table you have to decide which to display). On a form it would not matter so much as you could show different related tables in subforms.

 

[Libre]

I'm not sure I totally understand your question, nor am I clear about the answers you've gotten so far.
But, IMHO, the best place to establish relationships between tables is in the Relationship editor/creator (not it's technical name).
This utility is under Tools/Relationships.
I'd show you a screen print but I don't know how to paste a graphic in this text window, so you have to imagine it.

You can have a table related to many other tables, and those tables can be related to other tables. You can set all this up in the Relationships editor, and then the relationship will be HARD (in other words, is ALWAYS in effect) or you can define them in a specific query and then the relationship is only in effect for that query.

I don't know if this helps. If not, never mind.

 

[crcastilla]

Okay, thank you so much for all your help!

I have successfully done it.

I did what Pat told me to do. I added a primary field in the second table with was a autonumber then I created my third table and made the foreign field to relate by second and third table. I don't know if you understand what I mean.

Anyhow,

Now one more question. If I open my second table I will see my sub-table (third table). I created a query based on my second table so I could a calculated field named Total. When I run the query it works fine but the sub-table does not appear anymore. I want it to be included in the query as sub query? I don't know the term

 

[crcastilla]

Well, this is what I really want to do.
You know how when I open my second table there is a plus sign for each row and when I press it the sub table appears (third table)?

I want that to appear on my form. I tried to put a sub-form and I select my second table but it does not appear with the plus sign.

 

[crcastilla]

That worked great! When I go to print preview the information on the sub datasheet (third table information) doesn't show though. Anyway to fix that?

 

[crcastilla]

Anyone help?