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