Remote Database Creation

[chevell]

I was under the understanding that if i did a script step "insert calculated result" into a remote field in a related database, the remote database would create a new record with that related content in it. I can't get this to work. Can someone walk me through this? I used this all the time in FM6, but with FM7, I can't seem to get it to fly.

[Wim Decorte]

No, it functions like a "Set Field", it just populates a field in an existing record.

If you want a new record created you'll need to do that explicitly with the "new record" script step. Or do it in a portal that allows the creation of new records.

[chevell]

Ok, gotcha. A portal would be perfect. Not sure how to go about actually creating a new record using the portal, but I should be able to google it. Thanks!

[Wim Decorte]

Allow record creation is a setting of the relationship. if you toggle it on there, the portal will always show a "blank line" as the last row. When you type in it, it will automatically create a new related record.

In a script you need to use a Goto Field (a related field in the portal), followed by a Goto Portal Row Last and then you can use Set Field.

[chevell]

Ok, i got it, but I want to create more than one entry in the portal using the script based on a calculation. So, basically, if Quantity > or = 1, goto related field, goto last portal portal row, insert data, loop. It seems to be putting the data into the same single record instead of creating new ones. Ideas?