Lookup From A Grid

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
Andrew HarrisonAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

javiertbCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Andrew HarrisonAuthor Commented:
Edited text of question
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Delphi

From novice to tech pro — start learning today.