In DE 6.53 a lookup list field can be specified without need for a lookup derivation formula.
The option is available in DE8.5 but either i'm missing something or it is not working?
The relationship is selected and the field from which to return a value but it gives an error "please specify the Bound Column to create Lookup Field"

The bound column is the column that will be the return value for the Multibox. You have to select one.

Take note of the screenshot - the bound column is selected.

Try to unselect it and select it again. 

Multibox was one of the "innovations" in DataEase 7 and maybe not the most thought through idea. It has been much improved in DE9/LE9. 

Unselect / reselect as many times as you want - still the same error.

This is on a new application although the problem was first identified on the app being migrated.

This is a massive problem as the app being migrated contains many lookup fields.

Some fields work ok after migration but others do not work.

What was also noticed is if a form contains a working lookup field and an edit is done on the defining form then the lookup field definition does not show the lookup and the form is saved after edit then the lookup no longer works. The lookup can also not be fixed as this 'bound' error occurs.

That figures.

Migration has always been the "downfall" of DataEase. Sadly the problem was done in 7.x and since then its all about trying to make square pegs fit in round holes.

The lookup fields in 6.x was fit for purpose so the idea to then change them into this "multibox" idea was disastrous. Suddely a simple lookup field should also be CTRL-F10 and a jack of all trades, and the way its defined is changed radically.

8.5 is out of development and migration from pre 7.x is no longer a priority for DataEase so obviously this is not ideal for you but there is limits to how much resources we can put into migrations as whatever we do at this stage, a significant effort from the user will be necessary to get a good application.

Ok, i can understand that there are challenges with migration and issues must be resolved.

The real problem is this does not even work on a new non-migrated app.

Multibox leave a lot to be desired but in general it has worked so I'm not sure what goes wrong here. Can you send an example of what is not working?

Test app attached.
user name = DEV 
pwd = de85
Form: Usage
           Field Instrument must be set with lookup using relationship rI_U to list selection values from Instruments table.

Any idea how to resolve this?

Hi,

You need to click on Instrument_nm and then click on Bound.

Kind regards

Josef

Thank you, it works now.

This was not required in DE6 which implies that all old forms with lookups will have to be updated manually.

Is there some other new option now other than 'bound' which requires 'bound' to be selected for lookup?

Not sure what you have done, but we made an app in 6.53 with a lookup field, migrated it to 8.5 and it worked perfectly without any intervention on our part.

Did you run the re-compile option after migration?