Solved

Use Combo box like MS Access 2000

Posted on 2002-05-24
3
275 Views
Last Modified: 2010-04-04
I am trying to convert from MS Access 2000 and am running into a small problem with the combo boxes in Delphi.  In access if I have an employee maintenance form and on that form is a status field that has a combo box filled with (Active, Inactive, ect.) it is set up by telling the combo box where to get it's list and the column properties and then telling it what data field on the form to be bound to.

However, I haven't found out how to duplicate this behaviour in Delphi yet.  I can get the combo box to bind to the status field correctly, but how do I get it to populate with the valid options (They are in a table) and how do I get it to display multiple columns?
0
Comment
Question by:header
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 2

Expert Comment

by:freshman3k
ID: 7033341
Hello!

Use a DBLookupComboBox(included with delphi). ListSource property is data source and set ListField and KeyField to the field you want to display in drop down.

or you can look on this website,they have alot of free DBLookupComboBox's with different features,Just in case the DBLookupComboBox included with delphi dosent have enough features that you want:

http://www.torry.net/db_lbcb.htm

Good Luck :-)
0
 
LVL 2

Accepted Solution

by:
freshman3k earned 100 total points
ID: 7033491
Hello!

Use a DBLookupComboBox(included with delphi). ListSource property is data source and set ListField and KeyField to the field you want to display in drop down.

or you can look on this website,they have alot of free DBLookupComboBox's with different features,Just in case the DBLookupComboBox included with delphi dosent have enough features that you want:

http://www.torry.net/db_lbcb.htm

Good Luck :-)
0
 
LVL 2

Author Comment

by:header
ID: 7220364
Sorry, I forgot about this question.

Thanks!
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

707 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