autocomplete

[KyleMcAfee]

I have a list of shippers and consignees and I need the user to select 1 shipper and 1 consignee and save this value into the cargo table.  There is aprox 3000 different address to pick from for each field (shipper and consignee).  How do I do a multi column look up.  I read someones post that mentioned making a formula field that adds customer, city and state.  I did this and it works but I can not get this field (calculated) to be used as an autocomplete in the dataform.  Basically the forms do not allow you to bring over calculated fields.  Work around? 

[Aether]

Hello @KyleMcAfee,

I had a same issue when I tried using formula field on the lookup for (auto-complete, dropdown, etc.). When I contacted support, they advice me to enclose the formula used and convert it to varchar(255). For example:

CONVERT(VARCHAR(255), ([@field:FirstName] + '  ' + [@field:LastName]))

After that the formula field is selectable on your lookup. I hope this helps