Report for Kits conponents

Dan,

For both of your questions concerning kits, we can help you. contact me via e-mail.

Marc cott> I would like to have a report the outline's what each kit is made of....

I would like to have a report the outline's what each kit is made of....

Sample sql so far:

select i.itemlookupcode, i.description, i.price, k.componentitemid, k.quantity, k.quantity from item i, kit k where i.id = k.kititemid

This is getting me closer but how do I get the k.componentitemid to be the actual itemlookupcode for that item.

Dan

Try this:

select i.itemlookupcode, i.descripti> I would like to have a report the outline's what each kit is made of.... >

k.quantity, k.quantity

actual itemlookupcode for that item

outputs: i.itemlookupcode i.description i.price k.componentkititem k.quantity

12-1020 Rope Kit 12.00 234 .25 12-1020 Tie 12.00 436 1

What I would Like as output, the ILC for the kititem componentid i.itemlookupcode i.description i.price ILC k.quantity Price kit component

12-1020 Rope Kit 12.00 12-1224 .25 4.00 12-1020 Rope Kit 12.00 11-123 1 8.00

why not join the item record of the component to find that info:

select i.itemlookupcode, i.description, i.price, c.itemlookupcode, k.quantity from item i join kit k on i.id = k.kititemid join item c on c.id=k.componentitemid

"Dan-902" wrote:

I would like to have a report the outline's what each kit is made of.... does just a thing exist?

Dan