AnsweredAssumed Answered

Finding number of rows in a portal

Question asked by med on Apr 5, 2013
Latest reply on Apr 8, 2013 by philmodjunk


Finding number of rows in a portal


     I have designed a layout to search for names. The layout is based on a globals table which has searchname and type as feilds, the protal comes from the student tables which is related by

     globals::searname x student::name and globals::type=student::type

     the searching will be by entering the type into the layout (globals::type) and then entering awhole or partial spelling of the name into the layout (globals::searchname)

     I created a calculation field in globals to count stdent::name and I thought this will give me the number of matches but apparently it gives me the number of all student having the value entered for the type not of the name matches.

     How can I modify this to obtain the number of name matches.