full text searching

[kiwiora]

Hey guys,

Is there an easier way? I'm wanting to do a search across all fields. Not a request search because I dont' know which fields my information would sit in (i.e there's 6 directors i want director Joe Bloggs, is he director 1,2,3,4,5 or 6?

Therefore I've created a "full text" field that concatenates all information and it's pretty scary (see below example - i just had to add it for fun ). The user will then do a search in this field alone. Is there a simpler/better way?

Company & " " & CompanyACN & " " & CompanyACN & " " & Director1BirthDate & " " & Director1BirthPlace & " " & Director1BirthState & " " & Director1BuildingName & " " & Director1Code & " " & Director1Country & " " & Director1FormerName & " " & Director1GivenName & " " & Director1State & " " & Director1StreetNoName & " " & Director1Suburb & " " & Director1Surname & " " & Director2BirthDate & " " & Director2BirthPlace & " " & Director2BirthState & " " & Director2BuildingName & " " & Director2Code & " " & Director2Country & " " & Director2FormerName & " " & Director2GivenName & " " & Director2State & " " & Director2StreetNoName & " " & Director2Suburb & " " & Director2Surname & " " & Director3BirthDate & " " & Director3BirthPlace & " " & Director3BirthState & " " & Director3BuildingName & " " & Director3Code & " " & Director3Country & " " & Director3FormerName & " " & Director3GivenName & " " & Director3State & " " & Director3StreetNoName & " " & Director3Suburb & " " & Director3Surname & " " & Director4BirthDate & " " & Director4BirthPlace & " " & Director4BirthState & " " & Director4BuildingName & " " & Director4Code & " " & Director4Country & " " & Director4FormerName & " " & Director4GivenName & " " & Director4State & " " & Director4StreetNoName & " " & Director4Suburb & " " & Director4Surname & " " & Director5BirthDate & " " & Director5BirthPlace & " " & Director5BirthState & " " & Director5BuildingName & " " & Director5Code & " " & Director5Country & " " & Director5FormerName & " " & Director5GivenName & " " & Director5State & " " & Director5StreetNoName & " " & Director5Suburb & " " & Director5Surname & " " & Director6 & " " & Director6BirthDate & " " & Director6BirthPlace & " " & Director6BirthState & " " & Director6BuildingName & " " & Director6Code & " " & Director6Country & " " & Director6FormerName & " " & Director6GivenName & " " & Director6State & " " & Director6StreetNoName & " " & Director6Suburb & " " & Director6Surname & " " & DirectorTotal & " " & fileno & " " & PPBBuildingName & " " & PPBCode & " " & PPBLevel & " " & PPBOffice & " " & PPBState & " " & PPBStreetNoName & " " & PPBSuburb & " " & ROBuildingName & " " & ROCareOf & " " & ROCode & " " & ROLevel & " " & ROOccupier & " " & ROOccupierName & " " & ROOffice & " " & ROState & " " & ROStreetNoName & " " & ROSuburb & " " & ShareHolder1 & " " & ShareHolder1ACN & " " & ShareHolder1BuildingName & " " & ShareHolder1Code & " " & ShareHolder1Country & " " & ShareHolder1Level & " " & ShareHolder1Office & " " & ShareHolder1ShareAmount & " " & ShareHolder1ShareClass & " " & ShareHolder1ShareNo & " " & ShareHolder1SharePaid & " " & ShareHolder1ShareUnpaid & " " & ShareHolder1State & " " & ShareHolder1StreetNoName & " " & ShareHolder1Suburb & " " & ShareHolder2 & " " & ShareHolder2ACN & " " & ShareHolder2BuildingName & " " & ShareHolder2Code & " " & ShareHolder2Country & " " & ShareHolder2Level & " " & ShareHolder2Office & " " & ShareHolder2ShareAmount & " " & ShareHolder2ShareClass & " " & ShareHolder2ShareNo & " " & ShareHolder2SharePaid & " " & ShareHolder2ShareUnpaid & " " & ShareHolder2State & " " & ShareHolder2StreetNoName & " " & ShareHolder2Suburb & " " & ShareHolder3 & " " & ShareHolder3ACN & " " & ShareHolder3BuildingName & " " & ShareHolder3Code & " " & ShareHolder3Country & " " & ShareHolder3Level & " " & ShareHolder3Office & " " & ShareHolder3ShareAmount & " " & ShareHolder3ShareClass & " " & ShareHolder3ShareNo & " " & ShareHolder3SharePaid & " " & ShareHolder3ShareUnpaid & " " & ShareHolder3State & " " & ShareHolder3StreetNoName & " " & ShareHolder3Suburb & " " & ShareHolder4 & " " & ShareHolder4ACN & " " & ShareHolder4BuildingName & " " & ShareHolder4Code & " " & ShareHolder4Country & " " & ShareHolder4Level & " " & ShareHolder4Office & " " & ShareHolder4ShareAmount & " " & ShareHolder4ShareClass & " " & ShareHolder4ShareNo & " " & ShareHolder4SharePaid & " " & ShareHolder4ShareUnpaid & " " & ShareHolder4State & " " & ShareHolder4StreetNoName & " " & ShareHolder4Suburb & " " & Shareholder5 & " " & Shareholder5ACN & " " & Shareholder5BuildingName & " " & Shareholder5Code & " " & Shareholder5Country & " " & Shareholder5Level & " " & Shareholder5Office & " " & Shareholder5ShareAmount & " " & Shareholder5ShareClass & " " & Shareholder5ShareNo & " " & Shareholder5SharePaid & " " & Shareholder5ShareUnpaid & " " & Shareholder5State & " " & ShareHolder5StreetNoName & " " & Shareholder5Suburb & " " & Shareholder6 & " " & Shareholder6ACN & " " & Shareholder6BuildingName & " " & Shareholder6Code & " " & Shareholder6Country & " " & Shareholder6Level & " " & Shareholder6Office & " " & Shareholder6ShareAmount & " " & Shareholder6ShareClass & " " & Shareholder6ShareNo & " " & Shareholder6SharePaid & " " & Shareholder6ShareUnpaid & " " & Shareholder6State & " " & ShareHolder6StreetNoName & " " & Shareholder6Suburb & " " & PublicOfficer & " " & Auditor & " " & AuditorCompany & " " & ChairPerson & " " & Shareholder1StateFull & " " & Shareholder2StateFull & " " & Shareholder3StateFull & " " & Shareholder4StateFull & " " & Shareholder5StateFull & " " & Shareholder6StateFull & " " & Shareholder1TotalShare & " " & Shareholder2TotalShare & " " & Shareholder3TotalShare & " " & Shareholder4TotalShare & " " & Shareholder5TotalShare & " " & Shareholder6TotalShare & " " & DirectorsServiceSalutation & " " & DirectorsServiceAddress & " " & DirectorsServiceSuburb & " " & DirectorsServiceState & " " & DirectorsServiceCode & " " & ShareHolder1ShareCert & " " & ShareHolder2ShareCert & " " & ShareHolder3ShareCert & " " & ShareHolder4ShareCert & " " & ShareHolder5ShareCert & " " & ShareHolder6ShareCert & " " & DirectorsOther & " " & ShareHolderOthers

[George]

It appears to me that this should be a Relational type question. Why don't you have a directors db?

[BobWeaver]

A global field gSearch that the user enters the search text into, and a script:

  Go to Layout [someLayoutThatContainsAllTheSearchFields]

  Enter Find Mode  [no restore, no pause]

  Go to Next Field

  Set Field   [   gStartField  , Status(CurrentFieldName) ]

  Loop

    Insert Calculated Result     [ gSearch ][ Select entire contents ]

    Go to Next Field

    Exit Loop If     [ gStartField = Status(CurrentFieldName) ]

    New Record/Request

  End Loop

  Perform Find  [no restore]

  Go to Layout   [ original layout ]