palabros
asked on
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
how am i supposed to proceed on this
pala
ASKER
can u explain the config
i have tried with readonly and all
pala
i have tried with readonly and all
pala
maybe i understand your q not correct,
but just supply the properties
-databasename
-datafiled
-lookupdataset (or similar name)
-keyfield
-lookupresultfield
with proper values
meikl ;-)
but just supply the properties
-databasename
-datafiled
-lookupdataset (or similar name)
-keyfield
-lookupresultfield
with proper values
meikl ;-)
ASKER
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
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
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.
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.
ASKER
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
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
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
if it is correct configured