I'm not finding the exact answer to my question in the posts I've read so please forgive me if I'm repeating a question.

I need to create a record in another table from a current table behind the scenes (the user doesn't see and get confused. ) I want the computer to create it because there needs to be a relationship inherently made. (not relying on the user)

In 6, I put a script in table 2 named "New Table 2 Record" consisting of the command "New Record/Request".

In table 1 I put a script "Create New Table 2 Record".

In "Create New Table 2 Record", I would set "g_Table 1 ID" with "Table 1 ID", call "Table 2: New Table 2 Record"

Then set "Table 2: Table 1 ID" with "Table 1: g_Table 1 ID"

Here's the problem in 7: When I call the "New Recod/Request" command in Table 2, it creates a new record in Table 1. I can understand why it's doing this, but I don't know how to work around it. What do I need to do so that I'm creating a new record in Table 2 and setting the field properly in FMP7?

Thanks All!

Sabrina

Sabrina, scripts apply to the Table Occurence of the LAYOUT. Be sure you switch to a layout based on Table 2 before the script creates the new record.