I have two tables I want to search. One is keyed by date (an integer field) and also contains a claim number and worksheet number. (I want to search by that date.) The other is keyed by claim number and worksheet number and I want to search on a non-key field if the claim # and worksheet # are in the first set. Is there any way I can setup my selection formula so that it searches the first table by date and then the second table only if the data is found in the first table? (meaning I don't want to search on a non-key field if the first criteria is met?) I've tried
table1.date = 20011210 and table2.date = 20011210
but that takes hours. (table2.date is the non-key field) If I remove the table2.date part it only takes a few minutes, and I have a feeling there is a better way to do this. Any suggestions?
Thanks,
Dave
table1.date = 20011210 and table2.date = 20011210
but that takes hours. (table2.date is the non-key field) If I remove the table2.date part it only takes a few minutes, and I have a feeling there is a better way to do this. Any suggestions?
Thanks,
Dave