combining tables

[charliemopps]

So I have 2 tables:
Names:
Jim
Tom
Sam


Clothes:
Shirt
Shoes
Pants
Hat

So... I want to make a table from these 2 tables:

Jim's Shirt:
Jim's Shoes:
Jim's Pants:
Jim's Hat:

Tom's Shirt:
Tom's Shoes:
Tom's Pants:
Tom's Hat:

Sam's Shirt:
Sam's Shoes:
Sam's Pants:
Sam's Hat:

How do I do that?

 

[JohnLee]

HI,

You need to create a link table and a form with a subform to bring these two sets of data together in they way you are suggesting.

The link table will contain the primary keys from you Names and Clothes tables as foriegn keys.

You Parent form should be based on the Names table and the subform based on the clothes table.

That should get you started.

John

 

[charliemopps]

My question is, how do I make the link table?
I want to list ALL of these records.
Under names I have about 300 entries
Under Cloths I have about 20 entries

I have to enter this by hand?