Solved

Use Combo box like MS Access 2000

Posted on 2002-05-24
3
268 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
  • 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Internet Explorer View Settings Question 15 105
Delphi: how to implement a User Shortcut mapper? 1 93
Dev Express grid collapse 2 39
How to renew a Delphi rad-studio licence? 5 49
Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
In my programming career I have only very rarely run into situations where operator overloading would be of any use in my work.  Normally those situations involved math with either overly large numbers (hundreds of thousands of digits or accuracy re…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…
A company’s greatest vulnerability is their email. CEO fraud, ransomware and spear phishing attacks are the no1 threat to a company’s security. Cybercrime is responsible for the largest loss of money to companies today with losses projected to r…

929 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

10 Experts available now in Live!

Get 1:1 Help Now