Adding data to the correct record

[susan]

I'm fairly new to working with portals...this may be one of those "duh!" questions...

My solution keeps track of standards scores for K-6 students across their elem school career. I have a Students file and a Standards file. Both are related to the Reports file. I have my relationships set and my portals created, and everything works great when I import data from the spreadsheet where it is currently stored.

However, in the future I want to be able to enter the data directly into the Solution. I have the relationships set to allow creation of new records. I want to be able to enter a Teacher-Standard-SchoolYear and get a list of that teacher's students with blank or no records for the standard and score and then be able to enter the new data. How do I do this?

Thanks.

Susan

[Kurt Knippel]

Define a calculation in the main file such as: not IsValid ( Relationship::AnyField).

This will give you a "1" if there are no records in the related database. Simply perform a find on this field and you will have all the records which have no related records.