How can I create a new record in a table that is not the main table for a form?

Script outline

* Denotes fields that need to be inserted into a new record in a linked table.

Loop

Go to layout

Print no dialog

go to layout

print no dialog

* insert current date

* insert current time

* insert current user name

* set field

go to next record

end loop

FileMaker Version: Server 7

Platform: Windows 2000

Well, the first thing I noticed is that your script does not have the New Record/Request step. Also, what triggers the end of your loop?

Mike

Exactly. How would I do it. The fields marked with an * would need to be in a related table. I would need to create a record in that "related" table then set the fields to the date time user. Basically to keep track of every time that script is performed on each record.

Thanks.

Hi jason

When you created the relationship, did you check the box that states "Create record in related file".

Write your script useing the set field command

Lionel