Hi @atuljainajm ! This table displays all the components for me, but I would make sure you aren’t putting it into a grouping section.
I joined INKitSpecHdr to INKitSpecStkDet and it shows one iteration of the kit for each revision unless I condition to specify a revision.
Can you share some screenshots of the issue you are seeing?
Thanks @BenjaminCrisman .
Please see below:
JE178882 has two components.
below the first JE08352TK is coming from kits spec which has 2 items, it doesn’t display the second item. ‘Number 2’ below unit price is the number of lines on the kit. I did that to check existing lines.=Count(=INKitSpecStkDet.LineNbr])
@atuljainajm I am just using the two tables, INKitSpecHdr and INKitSpecStkDet:
Thanks @BenjaminCrisman
Can you please provide me the join information as well?
Thank you
@atuljainajm The join is on KitInventoryID = KitInventoryID and RevisionID = RevisionID
@BenjaminCrisman It worked. Thank you.
Can you please help me with another query?
I am trying to get a field from cross reference tab shown below:
JE08352 is a component of JE17882, I can only pull alternate ID field of JE17882 not JE08352.
Is there a way i can pull the field of JE08352
Thanks
@BenjaminCrisman Can you please help with the question mentioned above?
Thank you.
@atuljainajm I you would need to join INItemXRef to the INKitSpecStkDet to get the alternateID for the component item. If you join to the header INKitSpecHdr table it will only link to the kit item, not the components.