Submit Find to look in two different tables

[Nestor]

Hi,

Is it possible for a find to look in two unrelated tables at the same time?

I want to type a number (10INK123) perform a find, but the find/script would look in two different tables at the same time and some how get a result if it found a record or not.

Is this possible? if so how?

Thanks

[The Big Bear]

Nestor

That is possible. assuming that you are performing one find from the table where the number is stored. You would need two find script, one for each table and using the set field command to enter the number in a global field in each table then the code for the first table would look something like this

Enter find mode

setfield(numberfield;globalfield)

preform find

if(get found count = 0)

show message (No records found in this table, press the OK buttom to continue)

else

show message ( Records have been found in this table that meets your criteria)

preform script(script from other table)

Enter find mode

setfield(numberfiekd;globalfield)

preform find

If (get found count > 0)

show message (Records found in this table

press the OK to continue)

Then you will have to decide how you want to review these records.

hope this helps

Lionel