Editable Lookup

What do I need to do to make a lookup field within a dbGrid control editable?
colesrAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

javiertbCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
colesrAuthor Commented:
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
javiertbCommented:
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
colesrAuthor Commented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Delphi

From novice to tech pro — start learning today.