You could build a relationship that matches selected fields in the student table with fields in the scholarship table. The matching scholarships could be listed in a portal and scripts could be devised so that clicking a listed scholarship brings up the full scholarship record.
Your relationship can use inequality operators for range data (as you've described in another thread) and you can pair up multiple fields so that all relevant criteria is used to match the student data against the scholarship requirements.
Another option is to write a script that performs the find for you by capturing relevant data from the selected student data in either variables or global fields and then using this data to build and perform the find.
In rough outline this script would work like this:
Set variable [$Criteria1; Value: StudentTable::Field1]
Set Variable [$Criteria2; Value: StudentTable::Field2]
Go to Layout [Scholarships (Scholarships)]
Enter FInd Mode
Set field [Scholarships::Field1Min; "> " & $Criteria1]
Set FIeld [Scholarships::Field1Max ; "< " & $Criteria1]
Set Field [Scholarships::Field2 ; $Criteria2]
Set Error Capture [on]
Thanks Phil, but I think I'm in way over my head now! I felt pretty good yesterday after creating the database and my tables and fields, but now I'm completely lost about what to do next and unfortunately, I don't know anything about scripts and portals. Maybe I will just try to find somebody to hire that can set it up for me.
I really appreciate all your help though!
Check the little white envelope icon in the upper left corner. With a post like that you'll likely receive a number of offers from consultants who want your business.