Multiple products

[zab]

Hello again

I need to build kits of items and I can't figure out the right way to do it.

I have a product table with fields like ID, item, price etc.

Now I need to build kits that would include many items from the product table. I'm not sure if I should make a new table to compile those kits.

If it's the way, how can I bring it back to the product table?

If there is a way to make it directly into the product table.

What is the usual way to do it?

Thank you

[myopus]

Hi,

the best for that is actually to let your composite products in the product table.

You can attach the components products to the kit product with another occurrence table (from the same products table)

Gilles

[Brent Durland]

A kit is a sellable product. Are the components sellable products? If not, they may belong in a separate table. Either way, the components need a field like "Kit ID".

Let's say you have a kit, which is product #32. Each component of the kit has the value "32" in its Iit ID field. Then you relate the kit to the components by those fields.

[zab]

I'm trying to build this in the same table with another TO (and another layer to select the products included).

Yes the components are all products existing in the product table.

So what is it you suggest?

I'm trying to add many fields (KitItem1, KitItem2, KitItem3) with value list to get the items ID. work good. But How do I get the price ?

I'm a bit mixed up in the way to do this.

Brent if I connect my component with the ID of the kit in my product table, I guess I need a LineItem of those poduct. Because I can't just add the id to the existing table because this same product can also be part of many different kits.

I'll think of this over lunch.

Thank you.

Isa

[zab]

I have made a TO from my original Product table. (itemID, Kit_item_id)

I have made a line Item to compile the kit items. Related by the Kit_item_ID.

In the TO there is a portal to add kit items and a summarize field (from the Line Item) to give me to total.

It works just fine.

Now my problem is: how to bring the summarized total to the Product table.

Any idea?

Thank you

[zab]

OK I did it and it works perfectly. It's all integrated to my products.

My relation wasn't right.

Thanks for the tips everyone.

Isa