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

How to display Customer Accounts in a dropdown

Start
Prev
1
Next
End

anpal
Topic Author
Offline
Junior Member

10 years 4 months ago #17002 by anpal

How to display Customer Accounts in a dropdown was created by anpal

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

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

jpb
Offline
Moderator
retired . . . ¯\_(ツ)_/¯

10 years 4 months ago #17004 by jpb

Replied by jpb on 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)

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

10 years 4 months ago #17010 by anpal

Replied by anpal on topic How to display Customer Accounts in a dropdown

Thanks, this worked fine!!!

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

Start
Prev
1
Next
End

Time to create page: 0.033 seconds