× Discuss about Archiving, Close of Business, Delivery Setup, Security Management System, Global Processing etc…

How to display Customer Accounts in a dropdown

  • anpal
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 31
  • Thank you received: 1

anpal created the topic: How to display Customer Accounts in a dropdown

In a version, given a customer ID, I want to display in a dropdown the related customer accounts?
How can I do that?
Normally an enquiry would show the record results, but in this case the file that has this information is F.CUSTOMER.ACCOUNT which is a concat table (only one record exists with the multivalue account numbers).

Thanks
#17002

Please Log in or Create an account to join the conversation.

  • Posts: 2845
  • Karma: 512
  • Thank you received: 647

jpb replied the topic: How to display Customer Accounts in a dropdown

If the selection via field CUSTOMER in ACCOUNT itself is too slow you can create an ENQUIRY on ACCOUNT with only selection field as CUSTOMER and attach a BUILD.ROUTINE that reads the concat and returns the accounts as the active selection list.

Like
    LOCATE "CUSTOMER" IN ENQUIRY.DATA<2,1> SETTING C.POS THEN
        Customer = ENQUIRY.DATA<4,C.POS>
    END
    CALL !HUSHIT(1)
    SEL.CMD = "QSELECT ": FN.CUS.ACC : " WITH @ID EQ " : Customer
    EXECUTE SEL.CMD
    CALL !HUSHIT(0)
#17004
The following user(s) said Thank You: gm.saran, anpal

Please Log in or Create an account to join the conversation.

  • anpal
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 31
  • Thank you received: 1

anpal replied the topic: How to display Customer Accounts in a dropdown

Thanks, this worked fine!!!
#17010

Please Log in or Create an account to join the conversation.

Time to create page: 0.120 seconds