Solved

Lookup From A Grid

Posted on 1997-04-15
2
206 Views
Last Modified: 2010-04-06
I have three Dbf Files.  One is the master called IngredientsCategories.  The main index is ING_CAT it is character and is 40 long.  The second file is called Ingredientinformation.  This is the one that is for my Grid.  The third file contains a field called ING_MSRE.  I wish to look up from my Grid (ING_MSRE) and find ING_MSRE in IngredientMsres.  I can't seem to get it to work.  So, the first file is the MAIN data the one and the second is the many.  It's a one to many link.  So how do I read from the third file from a Data Grid?  What Keys do I use?  I have tried the creating a lookup field with the editor, this still will not work for me.  I don't quite see about the master key and the lookup key and the return value? Thanks
0
Comment
Question by:Andrew Harrison
2 Comments
 
LVL 2

Accepted Solution

by:
javiertb earned 50 total points
Comment Utility
You have to access the Fields Editor and create a new lookup field. Then you add this one to the DBGrid and whenever you step though this field column you'll have a list to chose from.
0
 

Author Comment

by:Andrew Harrison
Comment Utility
Edited text of question
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
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…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

744 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now