Script for new record but in the same table

[smsaw]

I've gone through many pages of the forum and also did some searches but I haven't found what I was looking for.

My current database which is a Prospect management currently employ a table occurence of itself to show subsidiaries (child companies of the prospect). I would like to know how to create a script that will let me add a second new record while I'm already in the process of adding new one.

Prospect.zip

Edited November 29, 2005 by Guest
Forgot to post the file

[smsaw]

I should maybe give an example,

I'm entering a new record (parent company) and now I want to enter the names of the subsidiaries (child companies) as well.

So that it shows up in the portal of the subsidiaries.

I should mention that the fields are written in french but the design is in english, hopefully you guys will understand it.

[Wim Decorte]

Your basic script works. Except that you need to return to the original record when the new record is created.

Also why do you ask for the parent ID in a dialog? You're doing nothing with the value that one enters? And you don't need it because you're passing the parent ID as a scriptparameter.

A non-scripted way of doing this is to set the relationship to allow for creation of related records. Then you can just type the name in the empty bottom row of the portal...