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.