Bypassing no records match Until the Match occurs

August 23, 200421 yr

We have a database with 200 records in 5 tables labeled A Lane, B Lane, C lane, E Lane, and J Lane.

The records within those five tables have been somewhat populated. I have a new field called "Dealerfind" and the user will type in a dealer ID number and I want to write a script that will take them to the first found instance of that Dealer. The problem is - that as the search is in progress , It says "NO Matches" for each table where there is no match. Is there a way to bypass that and just get to the first found set in any of those five tables?

THanks

Stann

August 23, 200421 yr

Either Set Error Capture [On] at the beginning of the script to suppress error messages or don't use a find at all. You could use a relationship between a global field where the id is entered to the id field in each of the other tables. Then

If [not IsEmpty(rel1::serial)]

Go to Related Record [show, rel1]

Else If [not IsEmpty(rel2::serial)]

Go to Related Record [show, rel2]

...

End If