• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 220
  • Last Modified:

lookup

i have situation in which i have to show a lookup field in a form .if i am using a TDBLookUpCombobox I am facing a situation where in the view i am not able to restrict the view of look up records other than the keyone .but during the insert mode i have to show all the records so that the user can select the req one.
how am i supposed to proceed on this
pala
0
palabros
Asked:
palabros
1 Solution
 
kretzschmarCommented:
TDBLookUpCombobox does this for you automatically,
if it is correct configured
0
 
palabrosAuthor Commented:
can u explain the config
i have tried with readonly and all
pala
0
 
kretzschmarCommented:
maybe i understand your q not correct,

but just supply the properties

-databasename
-datafiled
-lookupdataset (or similar name)
-keyfield
-lookupresultfield

with proper values

meikl ;-)
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
palabrosAuthor Commented:
let me explain .My situation is that
i have a view and insert in the same form.
1)during view menu click  of a particular record i just want to show the look up corresponding to that record.
2)but during the insert mode i should be able to show the entire look up records.
the second part i am able to do with a TDBlookupcombobox.
but that TDBLookupCombobox Shows the entire records in the view of a particular record also which i don't want .
hope u understand .
i don't want to disable the TDBlookupcombox can change it view style to cssimple as in TDBcombobox.with some code.
with warm regards
pala

0
 
nestoruaCommented:
HI,
I still don't understand you exactly, so I try to ask you:
1.When you SHOW (or view as you said) the Field Value, (and maybe EDIT)
you use TDBLookupComboBox.
2.When you INSERT a new record you want to give the user to choose from another list of values.
If so, simply change the corresponding LookupDataSet
(and maybe KeyField, ResultField).
Sincerely,
Nestorua.
0
 
palabrosAuthor Commented:
Hi nestorua
in My view mode i don't want the user to see the entire lookup  options but only the corresponding record .but in the edit/insert mode i want the user to be able to see the entire look up options.
presently i am trying it loading the entire options to a TDBCombobox in the insert/Edit mode
while in view mode i make the style of TDBCombobox =csSimple
0
 
pnh73Commented:
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

PAQ and Refund

Please leave any comments here within the next seven days.
 
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
 
Paul (pnh73)
EE Cleanup Volunteer
0
 
MindphaserCommented:
Force accepted

** Mindphaser - Community Support Moderator **
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now