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

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

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