Hi Michael,
I think you are talking about an association link. Here are some queries for the connections:
- WTPart, EPMDocuments having an association link:
SELECT pm.name WTPartName, pm.wtpartnumber, em.cadname EPMDocName, em.documentnumber EPMDocNumber
FROM WTPart p, WTPartMaster pm, EPMDocument e, EPMDocumentMaster em, EPMBuildhistory ebh
WHERE e.ida3masterreference=em.ida2a2 AND p.ida3masterreference=pm.ida2a2 AND ebh.ida3a5=e.ida2a2 AND ebh.ida3b5=p.ida2a2;
- EPMDocuments not associated to WTParts:
SELECT em.cadname, e.ida2a2
FROM EPMDocument e, EPMDocumentMaster em
WHERE e.ida2a2 NOT IN (SELECT ida3a5 FROM EPMBuildhistory) AND e.ida3MasterReference=em.ida2a2;
Not really sure what your specific use case is so it is difficult to understand what exactly would be the best way to achieve it.
Typically parts are associated via auto associate. Is there a reason this isn't working for you?
Thanks,
Jarrett
