Scripting a find with user parameters

[agtjazz]

I have provided a sample table from a budget database that has both monthly & quarterly bills that will be due.

I am experiencing problems pulling both monthly & quarterly bills due. I would like for the user to input term (ie Fall) and academic year (ie- 2011-2012) and have the results be both any monthly bills that fall between the billing_begindate & billing_endDate and all quarterly bills that are Fall 2011-2012.

I have a script List_Billing_Monthly- and it’s working- based on the c_test=Active. I would rather not have the calculated field that says pull this monthly bill. I would like to delete the c_test field and just use a script to get the correct result set, but don’t seem to be able to do that.

Any help would be greatly appreciated.

Budget.fp7.zip

[comment]

I have a script List_Billing_Monthly- and it’s working

I don't think it's "working": I search for "Fall" "2011" and I see a monthly record that runs from January to March 2012 in the found set. If I understand correctly what you are trying to achieve, there must be a "map" somewhere of term start and end dates.

[agtjazz]

Yes it's "working"... I want all Fall 2011-2012. and all monthly that are between their begin & end dates (on 1 report). I just want to get rid of the "Active" and "Old budget Line" flags for monthly.... currently that's how the script pulls the monthly ones that fall in the date range.

[comment]

Try it this way, then:

Enter Find Mode [ ]

Set Field [ Salary_Budget::Billing_Timecycle; "Monthly" ]

Set Field [ Salary_Budget::billing_BeginDate; "≤" & Get ( CurrentDate ) ]

Set Field [ Salary_Budget::billing_EndDate; "≥" & Get ( CurrentDate ) ]

New Record/Request

Show Custom Dialog [ Title: "Term & Year"; Message: "Please Enter Term & Academic Year"; Buttons: “OK”, “Cancel”; Input #1:

Salary_Budget::Terms; Input #2: Salary_Budget::ACADYr ]

If [ Get(LastMessageChoice) = 1 ]

Perform Find [ ]

Else

Enter Browse Mode

End If

Sort Records [ Specified Sort Order: Salary_Budget::Billing_Timecycle; ascending ] [ Restore; No dialog ]

[agtjazz]

Works like a charm.... Thanks bunches