• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 71
  • Last Modified:

Autosuggestion with cfgridcolumn

I have Two tables in a database. One is the ITEM Table containing available Items with Columns (ITEMCode and ITEMDescription) and the other table ITEMSOLD Table which contains sold items with columns (ItemCode, ItemDescription, UnitPrice, Quantity, Amount). Now I have a cfgrid that can insert new sold items into the ItemSold table. And I need the corresponding column for the ITEMSOLD.ItemCode on the cfgrid to autosuggest items in ITEM.ItemCode when you type the first letters of any item. Then when an item is selected in ItemCode Column on the cfgrid, the ItemDescription Column in that row will be updated with corresponding Item.ItemDescription based on the item selected in the ItemCode Column.


Thanks
0
Nathltd
Asked:
Nathltd
1 Solution
 
Pravin AsarPrincipal Systems EngineerCommented:
With cfgridcolumn you can use values and valuesDisplay.

While editing, when cell gains focus, that cell is morphed to combobox.

<cfgridcolumn name="itemID" values="1,2,3,4,5" valuesdisplay="Item 1, Item 2,Item 3,Item 4,Item 5">

Of course in your case the values and valuedisplay will be from some sort db query.

0
 
NathltdAuthor Commented:
Thanks for the solution
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now