160
I am getting the following error with a custom lookup method.
"Failed to execute query because no root data source on the form matches the root datasource on the query"
The main datasource in the form is a temporary table, and the filter I am implementing in the custom lookup uses a separate set of tables, albeit the return type EDT is the same.
Any help appreciated.
*This post is locked for comments
I meant something else. There is a question beside each reply asking "Did this answer your question?" and if you say Yes, it marks the thread as resolved and the reply is listed in the Only Answers view. Nevertheless it's true only if it's your thread; I didn't notice that the question was asked by somebody else than yourself.
"The main datasource of your query must be the same as the main datasource in the form.
If you want to show fields from other tables, you can use this:
sysTableLookup.addLookupMethod(tablemethodstr(tableName, methodName));
where the method is a display method and the table is the same as the main datasource!
I hope it can help you!"
Please mark the helpful reply (replies) as the verified answer.
This makes sense..Thank you
The main datasource of your query must be the same as the main datasource in the form.
If you want to show fields from other tables, you can use this:
sysTableLookup.addLookupMethod(tablemethodstr(tableName, methodName));
where the method is a display method and the table is the same as the main datasource!
I hope it can help you!
This error can occur when the wrong TableId is passed in SysTableLookup::newParameters(). Make sure you use the table you want to do the lookup in (not the table you're doing for).
Try creating a separate form that shows that data, with the same data source setup.
If that works, you'll just be able to reuse it as your lookup form.
If it doesn't, in the process you should be able to see the wrong of your ways. :)
The above sounds incorrect. The EDT has nothing to do with selecting the data.
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,321
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
