Solved

lookup

Posted on 2002-06-04
8
215 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
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
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 

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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
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…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

856 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