Create new record in linked table.

[J]

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

[Mike D.]

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

[J]

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.

[oilman]

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