?
Solved

lookup

Posted on 2002-06-04
8
Medium Priority
?
219 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

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

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

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…
Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Suggested Courses

649 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