Set Field Name by variable

[chrisknight55]

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 []

[comment]

How can I write:

Set Variable [$aidtype; "Pellgrant"]

...

Where will the string "Pellgrant" come from?

[chrisknight55]

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.

[comment]

I am afraid I don't follow you: if it's hard-coded, why not hard-code the target field instead?

[bcooney]

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.