Conditional Index Tag
Posted: Mon Jun 06, 2005 12:40 pm
Is there a way to conditionally scan a table using different index tag? We have two tables, Master A and Child B. Master A can link to Child B with either Index A or Index B. Right now we have manually switch between Index A and Index B, is there a way that we can conditionally using one or the other like IIF(Index = "A", IndexA, IndexB)?____Thanks in advance.