Complicated finds

[Chalkster]

I am not sure if i can do this or not

I have attached a file with what I am trying to do which is to perform finds as an OR statement on certain fields.

The table contains part of airfare rules at a farelevel (all other rules, seasons routings etc are drawn from other related tables )

Within this table i wiant to perform finds on a number of fields at the same time . I use globals to set search values and then switch to find mode insert the globals and perform find.... that part works.

But it is commont that in some fields users want to be able to use the equivalent of OR statments. For example they may need to update all fares from ATL or IAH that go to CDG or FRA... possibly in classes T or S and to display the results in one list. (this is an example.... finds may actually involve up to 5 deparure points and/or 5 destination points and up to 3 classes

how would i manage to do these sort of finds using FMP... is there any way of doing such searches in one step?

Or do I need to run multiple searches on permutations of the values eg

ATL CDG H

ATL CDG T

ATL FRA H

ATL FRA T

IAH CDG H

IAH CDG T

IAH FRA H

IAH FRA T

I guess one solution would be to use a number of searches extending the found set each time but I havent been able to get his to work for me... each time i end up with the set from the current find only.

In the example file there are two layouts for search forms that could do the job.... the first one would work if I could get the constrain/extend script steps to work... the second would be my ideal layout (I know I have repeated the same fields a number of times, that was just to show what i was looking for if it can be acheived, I assume that if it is possible i would need a bunch more global fields.

Any advice would be appreciated

fbc.zip

[Lee Smith]

Hi Chalkster,

I downloaded your attachment, but nothing seems to be in it? What kind of file is this (I.e. a FileMaker file, text, PDF, Screen Shot)?

[Chalkster]

oops... this one definitely contains data:)

I have worked out what i was doing wrong when trying to extend or constrain a search by script... I forgot the modify last find scriptstep.... so that part is not an issue now.

But I would like to see if there is some way of using a search form similar to the third layout in the file with multiple fields to be able to search for value1 OR value2... etc in a field in one search.

The layout shows what I am aiming for but have just copied te global field over and over because I am not sure if it is possible , and if so how to go about it... do I use global fields or other type of fields?

FBC2.zip