I am new to FMPro.

Problem:

Need to Find information contained within 1 or

more fields based on criteria that may not be

at the beginning of field data.

ALSO- want search to be case independant. All

data regardless of Alpha Case.

I ONLY want to see

EACH "End customer" name with the search criteria containd within one or more circuits belonging to that "End Customer"

AND

ALL of the "Circuit ID"'s that contain somewhere within them, my search criteria.

For this example, all fields are in the same table.

Example: Database: GNSC Circuits

RECORD NUMBER #ONE

End Customer: Neon Nequadics

Field1 name: Circuit ID1 Data: DDF-34343-nfd

Field2 name: Circuit ID2 Data: 233223-12212

Field3 name: Circuit ID3 Data: CGH.3323.433

Field4 name: Circuit ID4 Data: 01-ASZZ-22337

Field5 name: Circuit ID5 Data: 32.hcGs.55434432

RECORD NUMBER #TWO

End Customer: Nadia's Nutricious

Field1 name: Circuit ID1 Data: 445454022342-Dd

Field2 name: Circuit ID2 Data: 443423-12212

Field3 name: Circuit ID3 Data: CGH.3323.433

Field4 name: Circuit ID4 Data: 01-ASZZ-443234

Field5 name: Circuit ID5 Data: 32.Hcgs.554223

Desired results:

Find/Search Criteria: 223 would produce:

End Customer: Neon Nequadics

233223-12212

01-ASZZ-22337

End Customer: Nadia's Nutricious

445454022342-Dd

32.hcgs.554223

I have included/attached a database that I made as an example for search through

Hopeing someone will creater a small sample script for me to use as an example

Thanks to anyone/everyone for you help.

Nat

Example_DB-FM7.zip

test