FIND record base on different Parameter

leopdurr

Hi I have a form call CharterLookupParam

I want to search for record base on certain condition/parameter below is my rule for my Query, but it does not return any record, can someone look at this for me please. This rule is inside my Query.

FIND Charter WHERE ((Charter.ResState=CharterLookupParam.CharterStatus AND Charter.StartTime>=CharterLookupParam.StartDate AND Charter.StartTime<=CharterLookupParam.EndDate) OR (Charter.ResState=CharterLookupParam.CharterStatus AND Charter.fk_myClient=CharterLookupParam.ClientName AND Charter.StartTime>=CharterLookupParam.StartDate AND Charter.StartTime<=CharterLookupParam.EndDate)) OR (Charter.ResState=CharterLookupParam.CharterStatus AND Charter.fk_myVessel=CharterLookupParam.BoatName AND Charter.StartTime>=CharterLookupParam.StartDate AND Charter.StartTime<=CharterLookupParam.EndDate)

tford

I would break it into simpler FINDs to problem solve it.

leopdurr

So are you suggesting that I create a Query for each find result?
Can I use 1 query with atlease 3 FIND [.... ] command or functions?

tford

I don't know of any limit to the number of items in something like this.

I am just suggesting that for problem solving purposes break the puzzle down into smaller pieces & make sure you get the data you would expect from the smaller query. After verifying that the pieces work (I'm guess that maybe one piece does not), you can put the puzzle back together.

leopdurr

ok thanks.

I will try this