Link to home
Start Free TrialLog in
Avatar of colesr
colesr

asked on

Editable Lookup

What do I need to do to make a lookup field within a dbGrid control editable?
ASKER CERTIFIED SOLUTION
Avatar of javiertb
javiertb

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of colesr
colesr

ASKER

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.
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.
Avatar of colesr

ASKER

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.