AnsweredAssumed Answered

Simple Find

Question asked by rmittelman on May 5, 2011
Latest reply on May 6, 2011 by rmittelman


Simple Find



I'm a total newbie to FM Pro 11.  I have a "Students" layout.  I want to allow users to find student by, say, last name.  In Access, I can put an unbound textbox on the form and put code behind to find the proper record(s) when the user types in part or all of a name.  I can't figure out how to do this with FM Pro 11.

Can you have a portal to the same table?  Sounds funky, but if I had a list at the top of the "form" which showed the student records (name, ssn, etc), and I clicked on one of them, I would like to bring up that record on the "main" part of the form.

With a LOT of students in the table, the text field I referred to before should cause the portal mentioned above to scroll itself to that area of the alphabet.  So if you type in "jon", then the "Jones" records would appear in the portal list.  Clicking on one of them would cause the correct "Jones" record to be selected.

All this stuff is easy in access but not so much in FM Pro.

Can anybody help with this?