Lookup feature in edit grid

[apparelbusiness.com]

How do I use the LOOKUP feature in the edit grid ?

Lookup option.docx

[Johnny Major]

Are you waiting long enough for the loading of the available grids? I just see in your document the loading mask on the listing of available grids

Screen Shot 2023-02-21 at 8.39.27 AM.png

[apparelbusiness.com]

What type of grid do I create to make it a drop down list.....can the list be hard coded so that when the user sees the field it is like a drop down list ? Is that what a Loop up does ?

[Johnny Major]

A lookup is meant to use an existing grid widget to select a value. Sounds like you want to use a dropdown with inline data

[apparelbusiness.com]

I am already using drop downs from for some of the fields referencing an SQL file for data...

What if I want to create a list say the user can select from a predefined list of values that does not come from an existing data file ? For instance I have a field in the edit grid that I want the users to select from a set of codes say Group invoice and the codes is A,B,C or D. How do I set this up so when I display the edit grid for the Group invoice field will have a drop down list with values A,B,C,D

[Johnny Major]

If I'm understanding correctly, just use the dropdown with Inline Data instead of an existing Data Source. Inline data allows you to enter your own hard-coded data rather than data coming from a table.

For example, here I've entered two lines of custom data for a dropdown:

Screen Shot 2023-02-21 at 9.15.30 AM.png

[apparelbusiness.com]

I totally missed it....thank you for your patience.....