Solved

Editable Lookup

Posted on 1997-04-18
4
294 Views
Last Modified: 2010-04-04
What do I need to do to make a lookup field within a dbGrid control editable?
0
Comment
Question by:colesr
  • 2
  • 2
4 Comments
 
LVL 2

Accepted Solution

by:
javiertb earned 50 total points
ID: 1335466
I guess there's no way (or maybe not) of editing a lookup field from within a dbGrid. What you should do is to add your lookup table apart and then you'll be able to change it.
0
 

Author Comment

by:colesr
ID: 1335467
What do you mean when you say I should "add your lookup table apart?"  I have a seperate table object that acts as the source for the lookup column.  I even have that mapped to some edit fields and a dbNavigator for entering new rows into that table.

Maybe my question was misunderstood.  By editable, I simply mean that I want the user to be able to type as opposed to being forced to select from the list.  I call it editable because in PB to make a "lookup" field allow typing, you set the "allow editing" property to true.  I just can't find the correct property to set in Delphi yet.
0
 
LVL 2

Expert Comment

by:javiertb
ID: 1335468
If you're using paradox, try setting the lookup field within the table properties (Table Lookup) and not within the Fields Editor.
This way you'll be able to type whatever you want but only lookup values will be accepted (but you don't have a drop down list to chose from). I've already tried and it works.
0
 

Author Comment

by:colesr
ID: 1335469
Unfortunatly, My users have standardized on MS Access.  Besides, the whole point was to have both the list and the ability to type.

Oh well, I guess Delphi is just weak in this area.  Thanks for trying thought.
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

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…
Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

863 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

25 Experts available now in Live!

Get 1:1 Help Now