New Record script

[Erikj]

Hi all

I have two databases. One database is the client info database and the other is a tech support database.

What I'm trying to accomplish is create a script which would create a new record in the tech support database from the client info database. At the same time populate two fields in the tech support database with the info from the client info database. The two fileds are Client ID field and Serial number field.

Thanks in advance

[Philland]

Well to do it specifically as you've asked, I would create two global fields in the client database; G_ID and G_SERIAL. I'd create a constant relationship between the client database and the support database.

Then write a script that

set field G_ID = Client ID,

set field G_SERIAL = Serial Number

Perform External Script Support::New_Record

In the Support Database I would have a script

New Record Request

set field Client ID = Client::G_ID

set field Serial Number = Client::G_SERIAL

But, without knowing anything more about how this is intended to function, wouldn't this be easier to accomplish through a portal set to create new record upon entry. You could base the portal relationship on a concatenation of the ID and Serial numbers then place the two fields, ID and Serial Number into your layout in the Support Database based on the relationship to the original record.

Phil

[-Queue-]

Here's a thread that may be of interest to you. You don't have to use any scripts in the second db or globals to pass the data. It can be done using one extra calculation in the main file and an extra text field in the second.