Solved

Autosuggestion with cfgridcolumn

Posted on 2010-09-08
2
41 Views
Last Modified: 2015-10-01
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
Comment
Question by:Nathltd
2 Comments
 
LVL 28

Accepted Solution

by:
Pravin Asar earned 500 total points
ID: 33764123
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
 

Author Closing Comment

by:Nathltd
ID: 41020965
Thanks for the solution
0

Featured Post

Superior storage. Superior surveillance.

WD Purple drives are built for 24/7, always-on, high-definition security systems. With support for up to 8 hard drives and 32 cameras, WD Purple drives are optimized for surveillance.

Join & Write a Comment

Suggested Solutions

This is a guide to setting up a new WHM/cPanel Server to be used for web hosting accounts. It is intended for web hosting company administrators and dedicated server owners. For under $99 per month (considering normal rate of Big Data Cetnters like …
Most ColdFusion developers get confused between the CFSet, Duplicate, and Structcopy methods of copying a Structure, especially which one to use when. This Article will explain the differences in the approaches with examples; therefore, after readin…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now