Enter new record via top row

[quillpro]

I once saw a post that explained how to create a top row portal entry solutions. I can't find it anymore. Anyone know where or have an example or explanation.

[Reed]

create an extra relationship only for the purpose of creating related records. Create the records using a temporary key that is set to null after commit. This way you can just place related fields on a layout (not in a portal), and when you enter data in the fields a new record is created in the related table and appears in the portal... and since the temp key is gone, the entry fields clear out for the next entry. (This is detailed in Special Edition: Using Filemaker 7)

[quillpro]

Thanks for the advice. It work great. The only thing I could not figure out was how to make a field "null" on commit. So insead I use a serial number auto entered on commit. And set the relationship to less than zero.

[Reed]

Here is an example of the way to clear the field after commit.

topportal.fp7.zip

[comment]

UPDATE:

This technique no longer works in v8.02. See here.