I have three files. The first is called IngredientCategories. It contains to fields.
1. ING_CAT 40 C
2. ING_SUB 40 C
My Second file is called IngredientInformation it contains
1. ING_CAT 40 C (To Enable a master detail form)
2. ING_NAME 30 C
3. ING_MSRE 2 C
My Third is called IngredientMeasures it contains
1. ING_MSRE 2 C
I wish to read from this and do a lookup on a grid. I wish to use The ING_MSRE from the second file to read from the third. How is this done? It just won't work for me.