Find on multiple layouts

[Robbydobbs]

I have a database that has 3 different layouts that I use for inventory.

(1) Consignment Vehicles

(2) State Vehicles

(3) Miscellaneous

Is there a way to do a find on the ID_NO and have it look in all three layouts to see if it is there?

[Ugo DI LUCA]

Hi,

Use relationships for that purpose.

Well, not sure what your file structure may look like, but if all records in this file are attached to a value list field (with these three categories), you should create a selfjoin with g_record_ID::Record_ID where g_record_ID is a global field used for the search.

Then use a script :

If IsValid(your relationship)

Go to Related records (show only related)

External script (same file)

If Category = "Consignment Vehicles"

Go to layout "Consignement Vehicles"

End if

If Category = "State Vehicles"

Go to layout "State Vehicles"

End if

If Category = "Miscellaneous"

Go to layout "Miscellaneous"

End if

End If

Else

Message = "No matches for this ID)

Freeze Window

[Robbydobbs]

thank you for your help, I will certainly try this.