>I have 4 tables; table 1 is a master table of phone numbers, table 2 is vendor info, table 3 is default accounting info, table 4 is to be filled from the others. I had table 1 as the parent with table 2,3 as childs, then table 4 as the parent with with table 1 as the child. All is fine except table 3 has a second field that determines the type of phone (etc..local,long dist,cellular).
>What I cannot make happen is having the parent tables look at the correct record in table 3. All 3 records are visible or none are. I tried to create indicies (index on ph+purtype="L" to PurL), (index on ph+purtype="LD" to PurLD), (index on ph+purtype="C" to PurC), so as to set the index based on type of phone usage, but no good. My brain has left my body, retrieval is hopeless but fresh ideas may help recovery!
>Any ideas? Thanks to all who reply

If the field types are different you have to convert them to character strings. I am not following the *="L"* part of the index.

Index on Ph + PurType tag Phone
Select TableX
set relation to Ph + PurType into TableY