>>Is it possible to have 2 related tables in a grid control? One table has a field containing agency codes, and another table contains the descriptor data (e.g., agency name) keyed by agency code. I tried to include fields from the 2 tables while in Grid Builder, however, it appears as if only one table can populate the Grid. Any ideas ... or do I need to go back to the good ole' Browse command?
>
>Grids are fine for this...
>This is the type of situation that we often use Views for...have you experienced the Views/View Designer yet?


Bruce:

Thanks for your advice. It worked great for my two tables,
however, when I needed to include a "look-up" field from my third
table I ran into some problems. I did get a reply from Jim Booth,
the co-author of the book "Visual Foxpro 3.0 Unleashed", and he
gave me some neat tricks to do it without using the View Designer.

Once again ... many thanks! Mahalo!