Solved

List of a Combobox

Posted on 2002-07-10
4
204 Views
Last Modified: 2010-04-04
Table1: List for the Combobox
Table2: Table to be updated
How do I get the items/list of a combobox from Table1 so as when TAble1 is updated all the combobox connected to that table will also be updated? The combobox will also be used to update Table2, like when I click an Add button and choose an item from the combobox and then click Update button, the item from the combobox together with other fields will be added as a new record for Table2. Hope somebody could help me ASAP. Thanks.
0
Comment
Question by:sharol
  • 2
4 Comments
 
LVL 27

Expert Comment

by:kretzschmar
Comment Utility
maybe you need to
use a tdblookupcombobox

0
 

Author Comment

by:sharol
Comment Utility
im just new in delphi, please explain further. thanks.
0
 
LVL 3

Accepted Solution

by:
marcoszorrilla earned 100 total points
Comment Utility
As Kretschmar say you must use a TdDlookupCombobox, because this component has a Source and Target.
DataSource:The Table where the field to update is located.
DataField:The field to Update.

ListSource:The Table where the field is located.
ListField:List of fields to show separeted with ;
KeyField:The Field to Update in the source.

Best Regards.
Marcos.
0
 

Author Comment

by:sharol
Comment Utility
Thanks also to kretzschmar, you're idea was very good. But it was marcoszorilla who explained it in detail that's why I was able to make it work. thanks a lot.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

In this tutorial I will show you how to use the Windows Speech API in Delphi. I will only cover basic functions such as text to speech and controlling the speed of the speech. SAPI Installation First you need to install the SAPI type library, th…
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…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

743 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