By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,455 Members | 2,293 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,455 IT Pros & Developers. It's quick & easy.

Multiple items relationships?

P: n/a
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

Nov 18 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
person
[person_id]
[per_name]

JOIN

per_item
[person_id]
[item_id]

JOIN

item
[item_id]
[item_desc]
--
Darryl Kerkeslager
Nov 18 '06 #2

P: n/a
Thanks Darryl:

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

SB

Nov 22 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.