Hello to everyone,

I try to realize the custTable down to one table, with one of my own tables but it’s not working and I don’t know why. I try to put an integer Extended data type but it’s not working.

Can anyone help me please, I know that it’s very newbie but I can’t realize it.

Hellou I half solve my problem.

  1. I have changed the IdMachine (ETD) from integer to string.

  2. Put new Relation in ETD idMachine with Eve_Machine.IdeMachine.

It works (picture added) but only with one field (IdMachine) , how I can put more fields from table EVE_Machine than it have 3 more , like in previous post/image ?8156.desplegable_only_one.jpg


Override the look up method for that field and add lookup fields what you feel to add along with machine id to display.

For Example:

sysTableLookup = SysTableLookup::newParameters(tablenum(PurchTable), this);
sysTableLookup.addLookupfield(fieldnum(PurchTable, Purchid));
sysTableLookup.addLookupfield(fieldnum(PurchTable, PurchName));
qbds = query.addDataSource(tablenum(PurchTable));


Kuppusamy S

Hi Spulit,

If u want to change the lookup for a Particular form Need to Override the the lookup what kuppysamy suggested.

if u want to get the lookup for entire application You need to add the fields (what u want in lookup) to AutoLookup in Table.

Example: custtable → Fieldgroup → AutoLookup

It may help you…

THANKS TO Kuppusamy S AND Roshan.

Both answers help me on the solution, I try with the override of method and drop the fields in custtable → Fieldgroup → AutoLookup and it works. I am really grateful.