Searching Records based on multiple paramteres?

[Mitesh]

Hi,

Customer --< Jobs.

I have got a layout based on Customer where bascially user enters the search criteria and it contains a Drop down list of all the Customers & 2 date fields that are both associated to Jobs::StartDate and a find Button.

When find button is clicked i want to search/display all the jobs in a different layout for the selected company where job start date is between the selected date range. The reason i want to display in different layout is to print the found records.

Thanks in advance.

Mitesh

[Søren Dyhr]

I kind of dislike the idea of having extra fields to facilitate this, why not make dialogs during the run of the script:

Go to Related Record [ From table: “Jobs”; Using layout: “Jobs” (Jobs) ] [ Show only related records ] 

Enter Find Mode [  ] 

Loop 

      Show Custom Dialog [ Message: Case(Get ( RequestCount )-1;"Enter an end date for the search";"Enter a start date for the 

search"); Buttons: “OK”; Input #1: Jobs::StartDate ] 

      Go to Field [ Jobs::StartDate ] 

      Set Variable [ $criteria; Value:Get ( ActiveFieldContents ) ] 

      If [ Get ( RequestCount ) = 1 ] 

              Set Field [ ">"  & $criteria ] 

      Else 

              Set Field [ "<"  & $criteria ] 

      End If 

      Exit Loop If [ Get ( RequestCount ) = 2 ] 

      New Record/Request 

End Loop 

Constrain Found Set [  ] 

--sd