RE: Advice wanted on Data Structure

2003-07-31 Thread Jim Smith
> -Original Message- > From: Donald Tyler [mailto:[EMAIL PROTECTED] > Sent: 30 July 2003 16:42 > To: [EMAIL PROTECTED] > Subject: Advice wanted on Data Structure > > > I have a question that I hope I can explain well enough: > > I am trying to figure out a d

Re: Advice wanted on Data Structure

2003-07-30 Thread Andy Jackman
Donald, I've done this before - it wasn't nice. The best solution I came up with was to store the kits in the item table as though they were items. So the structure is: (Lets call a 'Product' an Item or a Kit depending on the 'prod_type') PRODUCT KIT CONTENTSPRODUCT (as

Re: Advice wanted on Data Structure

2003-07-30 Thread Viorel Dragomir
Sent: Wednesday, July 30, 2003 6:42 PM Subject: Advice wanted on Data Structure > I have a question that I hope I can explain well enough: > > I am trying to figure out a data structure for an inventory system. The > system contains: > > Items > Kits (Made from a collecti

Advice wanted on Data Structure

2003-07-30 Thread Donald Tyler
I have a question that I hope I can explain well enough: I am trying to figure out a data structure for an inventory system. The system contains: Items Kits(Made from a collection of Items and/or other Kits) Now my question is: Is there any way to structure this in a databas