2,426
Good Morning.
I have one field of type int 64 and having relation with cust invoice jour table.
i have added that to Form Design as reference group.
Now i need lookup from 2 tables.No filter required.
I have agged join in query and Added to Syslookupfield.addfield(2nd table field).
Then in lookup i am getting None.
How can i solve this.
Please show some ligt on this.
Regards.
Have a great day.
*This post is locked for comments
Thankyou Ievgen.
Thank you somuch
Yes,
you are correct.
Using view and overriding lookup ref will do.
I will update entire steps.
So you cannot use 2 data sources with SysReferenceTableLookup, easiest way is to use view that has tables joined as datasource instead of building query in the runtime. Another option is to use display method instead of actual field.
Hi ,
public Common lookupReference(FormReferenceControl _formReferenceControl)
{
Common ret;
Query query = new Query();
QueryBuildDataSource qbds, qbdssalestable;
SysReferenceTableLookup sysTableLookup;
;
sysTableLookup = SysReferenceTableLookup::newParameters(tableNum(CustInvoiceJour), _formReferenceControl);
qbds = query.addDataSource(tableNum(CustInvoiceJour));
qbdssalestable = qbds.addDataSource(tableNum(SalesTable));
qbdssalestable.relations(false);
qbdssalestable.addLink(fieldNum(CustInvoiceJour,SalesId),fieldNum(SalesTable,SalesId));
qbdssalestable.joinMode(JoinMode::OuterJoin);
sysTableLookup.addLookupfield(fieldNum(CustInvoiceJour, Invoiceid));
sysTableLookup.addLookupfield(fieldNum(CustInvoiceJour, InvoiceDate));
sysTableLookup.addLookupfield(fieldNum(SalesTable, SalesId));
sysTableLookup.parmQuery(query);
return sysTableLookup.performFormLookup();
}
getting unknown for the salestable custgroup field.
Not for custgroup the field to be added is our own customized field in salestable.
The custgroup is an example.
Please show some light on this.
Regards.
Have a great day.
Hi Ievgen,
Thank you so much for your reply.
What happened is.
1.Create one int64 field
2.Added relation with Custinvoicejour recid.
3.Added in form (step - 1) field as reference group field.
4.In lookup i want 4 fields from custinvoice jour and 1 field from salestable.
5.I overide lookup() not getting any changes.
6.i override Lookupreference() and here i am taling about .
how to get another table field.(4th field from salestable)
i have linked query with both custinvoicejour and salestable and
then i used in syslookup.addfield(here i placed salestable field).
I am getting none as 4th column in lookup.
Please show some light on this.
Regards.
Have a great day.
Please reply
Experts please give some clue
Experts please reply
#1
Mohamed Amine Mahmoudi
100
Super User 2025 Season 1
#2
Community Member
50
#3
shanawaz davood basha
6
Share
Report
All responses (
Answers (
