Solved

lookup

Posted on 2002-06-04
8
217 Views
Last Modified: 2010-04-04
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
Comment
Question by:palabros
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
8 Comments
 
LVL 27

Expert Comment

by:kretzschmar
ID: 7055452
TDBLookUpCombobox does this for you automatically,
if it is correct configured
0
 

Author Comment

by:palabros
ID: 7055458
can u explain the config
i have tried with readonly and all
pala
0
 
LVL 27

Expert Comment

by:kretzschmar
ID: 7055853
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
Independent Software Vendors: 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!

 

Author Comment

by:palabros
ID: 7055925
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
 
LVL 4

Expert Comment

by:nestorua
ID: 7056958
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
 

Author Comment

by:palabros
ID: 7071956
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
 
LVL 1

Expert Comment

by:pnh73
ID: 9010458
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
 
LVL 6

Accepted Solution

by:
Mindphaser earned 0 total points
ID: 9101857
Force accepted

** Mindphaser - Community Support Moderator **
0

Featured Post

Independent Software Vendors: 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!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
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…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

707 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