Quote:
Originally Posted by Tempest
Not true unless he will only ever have 1 of each item on the "shelf".. If there can be more than one then he needs the third table to do it right.
Third table "list" doesn't need nor should it have the ID field though. Should have a unique index though on sID,iID
|
The idea here is that I can add unlimited number of items on my shelf.
The "list" has a unique idea because it's a force of habit, and makes it easier when I have to destroy that connection.
I think I'm leaning towards the stored procedure, then dump into a storage table for fast display.
Thanks all for giving some ideas out!
J