Multiple items relationships?

[surfbored]

For some reason I'm blanking on how to do this...

I have a table with people:

Person1
Person2
Person3
..
..
..

I have a table with items:

ItemA
ItemB
ItemC
..
..
..

I want to show that the people own multiple items, e.g.:

Person1 = ItemB
Person2 = ItemA, ItemB, ItemC
Person3 = ItemC, ItemC
..
..
..

How do I set up my database to relate this basic information correctly?

Thanks for any help!

SB

[Darryl Kerkeslager]

Re: Multiple items relationships?

person
[person_id]
[per_name]

JOIN

per_item
[person_id]
[item_id]

JOIN

item
[item_id]
[item_desc]


--
Darryl Kerkeslager

[surfbored]

Re: Multiple items relationships?

Thanks Darryl:

I'll give this a try. If nothing else, I think you've pointed me in the
right direction.

SB