Muliple field key in relationships

[pmconaway]

Here is my problem. I want to display only the current school year information from a related file.

My key field is defined as a calculation "schoolID&Year" this is the same in both the main file and the related file. Now I've tempararyly added a field to the record view that has the current year value. I'm planning on making it a global/preference type of field. When I change the current year field my portals display the related records for the correct year. Now I was thinking I would like the user to be able to update/create records in the related file as necessary. (The related file contains the dates as to when the school has submitted paperwork as required by the grants that we are administrating.) When I go to type in the field in the portal I get the "The relationship 'Documents' is not valid and must me corrected before this field can be modified" This is true since the related document hasn't been created yet and the the schoolID and year fields would not have a value yet.

My question is what is the recommended way to great around this problem?

I suppose that I could have the user go to the related field and enter data directly there. But I had hopes that I could work form the main database using portals.

Paul

Version: v6.x

Platform: Mac OS X Panther

[Fitch]

Create a script in the related file that creates a new record and sets the fields as needed. In the main file, put a "New" button next to your portal that calls the external script and puts you in the appropriate field/row of the portal.

[pmconaway]

I've done that before. I was just hoping that there was a way that I could make the change directly in the portal view. It would work better in the solution I am designing to be able to just type in the portal makes more sense. Thanks for the suggestion.

On second thought. I only want to create a related record is there isn't one present. My related file has dates for multiple items. There are 7 items due during a school year for the holders of the grant. What I want to happen is when the first item is received I want to create the record and then for the remander of the items just add the date received in the appropriate date field. I was think that I could have a script that I run at the beginning of the year to create a record for each school and then the records would already be there. But that solution seems kluggy to me. I suppose that I could have the create new record script only create a record is there isn't already one there instead of always creating a new record.