2 databases related thru a ID#. Main database has portal linking to the second database. As it should, when I click in a blank portal field in the Main database, a record is created in the second related database with a matching ID#.

Here is a twist...Is there anyway to click in a empty portal, and instead if it creating just one record with a matching ID# in the related database, can it create 8 of them.

Reason I ask this is I almost always created 8 records thru the portal. And instead of always having to click the last empty line in the portal to generate the next line/record, I would just like it to start of from the git go with 8 blank lines/records.

Is this even possible?

You could create a script in the main file that:

- isolates the current record

- exports the ID# to a temp file

-launches a script in the secondary file that:

- imports the ID# from the temp file 8 times (repeat the 'import' script step 8 times)

- returns to the main file

Make a button beside the portal in the main file to launch the script.

Here is a solution i just came up with regarding this.

The problem with portals is when accessing my database from Web Companion. When creating a new record in my main database, it only allows editing of the first line in the portal that is related to the second database. If you want to add more lines (essentially the same as creating new records in the related database) you have to hit the submit button, wait for the browser to refresh, hit the edit button, then you are presented with a second line in the portal to edit. If you want a third, you have to do the same process again. This can TAKE FOREVER if you have a lot if items to enter into a portal via the web.

The solution I found was a plugin called oAzium Events. To break it down to the basics, I have attached a script to the main database that does the following: If thru the web a new record is created, the script goes to the related database and creates 12 new records based on the related field between the two databases. Now right from the git go There are 12 blank lines in the portal for entering data from the web. For this example I chose 12...but it can be any number.

I know I know...everyone talks about the pitfalls of using scripts when publishing on the web. But for this particular problem this is really the only solution I found that works. (I did not want to create a link tha allowed people to go directly to the related database to enter data, I wanted to keep all the data entry in the main database withing the portal)

LR