March 26, 201114 yr I have flag fields for types of student financial aid Students::Pellgrant Students::Staffordloan Students::Plusloan How can I write: Set Variable [$aidtype; "Pellgrant"] Enter Find Mode [] Set field [students::$aidtype; 1] // to find records where Students:Pellgrant = true Perform Find []
March 26, 201114 yr How can I write: Set Variable [$aidtype; "Pellgrant"] ... Where will the string "Pellgrant" come from?
March 26, 201114 yr Author It would hard coded, one of five or so field sets I would find and process with one script. I think I've found what I wanted: Set Variable [$aidtype; Value: "pellgrant"] Enter Find Mode[] Set Field By Name ["Students::" & $aidtype; 1] Perform Find [] If you think there's a neater way than looping thru five changes of this variable, I'd like to know.
March 26, 201114 yr I am afraid I don't follow you: if it's hard-coded, why not hard-code the target field instead?
March 27, 201114 yr My approach would be to have a single field in Students, with an AidTypeID, and a table of AidTypes. If the Student can have more than one aid type, then you need a join table btw Students and AidTypes (storing StudentID and AidTypeID). You would find in the join table for AidTypeID and gtrr match found to Students. You shouldn't break Aid Type into separate flag fields.
Create an account or sign in to comment