I have been beating my head against the wall trying to figure this out!

I want to print a record, but at the same time create a log of the record in a seperate file.

Here is my code:

Go to Field [select/perform; Office Copy Card Activity::Date]

Go to Portal Row [select; Last]

Set Field [Office Copy Card Activity::Date; Get( CurrentDate)]

Set Field [Office Copy Card Activity::Time; Get( CurrentTime)]

...

I have created a relationship between the 2 files, but everytime I run the script and expect there to be a record created in the other file there is nothing!

Please help!

In order for Set Field to create a related record, the "allow creation of records in this table" option on the relationship has to be checked. Even with this checked, only one related record can be created. Set Field will write over the existing related record without a technique for making a unique primary key value. There are ways to do this. You can see the technique in an example file called New Portal Rows. It also shows an alternative method that is much easier to understand.

http://www.filemakerpros.com/NEWROW.zip