Scripting to create related record

[Ben Heneghan]

I have a "People" table and a related "Status Log Entries" table. On the People table is a button to create a Log Entry record for that person. How do I script it to get the Person's ID# into the Log Entry record without using copy/paste?

[comment]

Use a script parameter or a variable. For example:

Go to Layout [ Log Entries ]

New Record

Set Field [ Log Entries::PersonID ; Get (ScriptParameter ]

...

The button needs to be defined to pass People::PersonID as the parameter.

[Ben Heneghan]

Thank you. That was just what I needed.

[Woodnote]

Use a script parameter or a variable. For example:

Go to Layout [ Log Entries ]

New Record

Set Field [ Log Entries::PersonID ; Get (ScriptParameter ]

...

The button needs to be defined to pass People::PersonID as the parameter.

this works for me except that it appears that all the indexes aren't updated correctly—that is to say none of the portals on the second layout display any information unless I save a compacted copy, then open that copy. Then the portals display just fine....any thoughts?

I've also noticed that if I create the records in the second table via a portal, everything is fine too...

[comment]

none of the portals on the second layout display any information

I don't understand your description.

[Woodnote]

I don't understand your description.

sorry...no worries though.... I was able to fix it by adding a "refresh window" script step that also cleared cached join info.