I've been using Filemaker for years and always used the copy/new record/paste methodfor creating additional related records in a related database. This always bugged me because you would loose whatever you had on your clipboard.

Then, I learned the portal trick (goto field, goto last repetition, set field). That is certainly better but it still requires portals in the UI that we don't want.

I'm wondering if anyone has found anything new that makes this any better that doesn't require spurrious interface items.

Thanks for your help!

Eric

Maybe I'm missing something, but you can create a related record with a simple script triggered from your UI. For example, a button that would run the script would also contain a script parameter such as the key field data that would associate the child record to the parent record.

Go to Layout[layout 1 (table 1)] <-- This is the layout with related records

New Record/Request

Set Field [key field; Get(ScriptParameter)]

Go to Layout[Original] <-- This is your UI layout

HTH, Mike