Quote:
Originally Posted by WarChild
No need for 3 tables here and there's no value in it either.
|
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