Finance forum

Create Custom Lookup

(0) Share

Report

Posted on by Rangga Pramana

245

Hi,

I create a custom lookup with multiple table on lookup field

This is my code :

[FormControlEventHandler(formControlStr(smmOpportunityTable, PartyGroup_Name), FormControlEventType::Lookup)]
    public static void PartyGroup_Name_OnLookup(FormControl sender, FormControlEventArgs e)
    {
        FormDataSource fds = sender.formRun().dataSource("smmOpportunityTable");
        smmOpportunityTable opp = fds.cursor();
        Query                   query = new Query();
        QueryBuildDataSource    qbds, qbds2;
        QueryBuildDataSource    qbdsJoin;
        SysTableLookup          sysTableLookup = sysTableLookup::newParameters(tableNum(DirPartyTable), sender);

        qbds = query.addDataSource(tableNum(DirPartyTable));
        qbds2 = qbds.addDataSource(tableNum(smmBusRelTable));
        qbds2.addLink(fieldNum(DirPartyTable, RecId),fieldNum(smmBusRelTable, Party));
      
        

        sysTableLookup.parmQuery(query);
        sysTableLookup.addLookupfield(fieldNum(DirPartyTable, Name), true);
        sysTableLookup.addLookupfield(fieldNum(DirPartyTable, PartyNumber));
        sysTableLookup.addLookupfield(fieldNum(smmBusRelTable, BusRelAccount));
        sysTableLookup.performFormLookup();

        FormControlCancelableSuperEventArgs event = e as FormControlCancelableSuperEventArgs;
        event.CancelSuperCall();
    }

This is the result :
7180.1.png

Thanks

Categories:

Development / Customization / SDK

All responses (5)

Answers (2)

Sort by

André Arnaud de Cal... 307,786 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi Rangga,

You have to add a command called sysTableLookup.addSelectionField(fieldNum(....,...)). This line is missing.
Rangga Pramana 245 on at

Like (0)

Report
Copy link

Link copied!
I wrote my code like this :

[FormControlEventHandler(formControlStr(smmOpportunityTable, PartyGroup_Name), FormControlEventType::Lookup)] public static void PartyGroup_Name_OnLookup(FormControl sender, FormControlEventArgs e) { FormDataSource fds = sender.formRun().dataSource("smmOpportunityTable"); smmOpportunityTable opp = fds.cursor(); Query query = new Query(); QueryBuildDataSource qbds, qbds2; QueryBuildDataSource qbdsJoin; SysTableLookup sysTableLookup = sysTableLookup::newParameters(tableNum(DirPartyTable), sender); qbds = query.addDataSource(tableNum(DirPartyTable)); qbds2 = qbds.addDataSource(tableNum(smmBusRelTable)); qbds2.addLink(fieldNum(DirPartyTable, RecId),fieldNum(smmBusRelTable, Party)); sysTableLookup.parmQuery(query); sysTableLookup.addLookupfield(fieldNum(DirPartyTable, Name), true); sysTableLookup.addLookupfield(fieldNum(DirPartyTable, PartyNumber)); sysTableLookup.addSelectionField(fieldNum(smmBusRelTable, BusRelAccount)); sysTableLookup.performFormLookup(); FormControlCancelableSuperEventArgs event = e as FormControlCancelableSuperEventArgs; event.CancelSuperCall(); }

It's doesn't work :(
Suggested answer

Hossein.K 6,650 on at

Like (0)

Report
Copy link

Link copied!

Hi Rangga,

there are two ways:

1-

community.dynamics.com/.../how-to-create-form-lookup-lookup-multiple-tables

2-

kashperuk.blogspot.com/.../sysmultitableloookup-dynamic-lookups.html
Verified answer

Rustem Galiamov 8,072 on at

Like (0)

Report
Copy link

Link copied!

Hi Rangaa!

SysTableLookup does not support more than 1 datasource.

There are few possible workarounds:

1. Use open source solution SysMultiTableLookup as Hossein Karimi was suggested

2. Create view that contain needed tables as a datasource

3. Create display method and using it (sysTableLookup.addLookupMethod())
Verified answer

adam260 1,871 on at

Like (0)

Report
Copy link

Link copied!

They dropped the class/ability to use SysMultiTableLookup in 2012 R3. IMO the best way to do this is just create a view and use that as your single datasource