I am trying to create a formatted search that will bring up a list of a BP customer's Equipment Cards. Syntax below.
SELECT T0.[internalSN], T0.[itemCode], T0.[itemName] FROM OINS T0 WHERE T0.[customer] = $[OCRD.CardCode]
Even through I am using the OINS table when I click the golden arrow in the results I takes me to the Bill of Materials, then I click the Item again and I go to the Item Master, even though I am using the OINS table. Does anyone know if there is a way to change the path of the golden arrow in a formatted search?
Barbara, the golden arrow is flagged in a query automatically based on the table structures that you are using and the content in those tables...no surprise or secrets there right?
The Equipment Card itself has a record number and thats what you need to add you your query so it looks like this...
SELECT T0.[insID], T0.[internalSN], T0.[itemCode], T0.[itemName] FROM OINS T0 WHERE T0.[customer] = $[OCRD.CardCode]
I hope this helps