Hi Darcy,
The PROMOTIONTARGET table links a PROMOTIONNOTICE object and the target objects the notice "collects" for promotion. Furthermore, the "role A" objectwithin the PROMOTIONTARGET table is the PROMOTIONNOTICE object and the "role B" object is the target object (in this case, your EPMDOCUMENT object).
For example, from a SQL standpoint,
...
PROMOTIONTARGET.ida3a5 = PROMOTIONNOTICE.ida2a2
AND PROMOTIONTARGET.ida3b5 = EPMDOCUMENT.ida2a2
AND EPMDOCUMENT.ida3masterreference = EPMDOCUMENTMASTER.ida2a2
AND PROMOTIONNOTICE.promotionnoticenumber = <your input=" to=" the=" query=">
....
I hope that helps!
Anil Patel
Global PLM Process Owner
SRAM, LLC
In Reply to Darcy Hodgson:
Hello Everyone,
I am looking for some help into the relationship of the PROMOTIONNOTICENUMBER from the PROMOTIONNOTICE table and the DOCUMENTNUMBER on the EPMDOCUMENTMASTER table.
I would like to be able to do a database query by PROMOTIONNOTICENUMBER and get a list of all EPMDOCUMENTMASTER DOCUMENTNUMBER's contained within that promotion request.
Can anyone tell me where that information is stored?
Thanks,
Darcy
