Jump to content
  • 0



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? 

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0

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 :) 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...