LOV problem

[system]

Has anyone come across this one?

The identifier is text and is the same for 3 HEORG_REFNO
e.g.
Identifier HEALTH_ORG
Hamilton 84845
Hamilton 84555
Hamilton 85451

I thought the prompt below would ask for the Identifier(“Hamilton”) and give me back the 3 HEALTH_ORG 84845,84555,85451

A_ALLOCTO_ORG.HEORG_REFNO in (SELECT dbo.D_ORGANISATIONS_IDS_V.HEORG_REFNO FROM dbo.D_ORGANISATIONS_IDS_V WHERE dbo.D_ORGANISATIONS_IDS_V.IDENTIFIER In @prompt(‘Enter value(s) for Identifier:’,‘A’,‘Prompt Variables\Identifier LOV’,Multi,Free,Persistent,User:0) )

Any idea’s?

---

SteveBramwell (BOB member since 2011-03-02)

[system]

OK solved it. I didn’t have the correct sintax for the SQL statement. It should read.
A_ALLOCTO_ORG.ORGANISATION_KEY in (SELECT D_ORGANISATION_IDS_V. ORGANISATION_KEY FROM D_ORGANISATION_IDS_V WHERE D_ORGANISATION_IDS_V.IDENTIFIER In @prompt(‘Enter value(s) for Location:’,‘A’,‘Prompt Variables\Identifier LOV’,Multi,Free,Persistent,) )

Works a treat now. 8)

---

SteveBramwell (BOB member since 2011-03-02)