susan Posted October 22, 2001 Share Posted October 22, 2001 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 Link to comment Share on other sites More sharing options...
Kurt Knippel Posted October 22, 2001 Share Posted October 22, 2001 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. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8220 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now