>What I have is a Parent table named "client". One of the fields in client is status. The status field contains a code.
>
>1="Targeted"
>2="Non-Targeted"
>3="Adjusted"
>4="Adjusted with Interventions"
>
>I then have a grid on form which will display many clients. The probem is that the users do not want to see the 1,2,3,4 code in the grid column for each client's status. They need to see the corresponding english descriptions. I had handled this previously by creating alookup table and making parent(client) child(statdesc) relationship to get the english in the grid. This is a quick and easy solution for a small file with a couple of fields needing relationships. In reality I may have 40-50 fields spanned of several tables which equates to 40-50 additional open files.
Actually it means ONE open file, with an extra field.
FIELDNAME, FIELDVALUE, MEANING
Once you store the FIELDNAME in the table then you only need one lookup table instead of 50.
Does that make the problem more manageable?