Adding records to a related file

[kcrossley]

Hello,

I have two related databases, [Customers] and [Publications]. To switch between them I'm using the "Go to Related Record" command. This works fine if related records exist.

However, when a related record does not exist I want to create a new record. I'm assuming I need a conditional statement to trigger this. Which command should I use and how should it look?

Thanks,

Kelly

[danjacoby]

Best way to create a related record is through a portal. That way, you can be certain that the relationship is properly created.

If you just want to create a new record in the other file, create a script in that file that creates a new record, then in the first file create a script that performs an external script -- you can guess which one.

HTH,

Dan

[LiveOak]

You can detect an error resulting from the "Go to related records" failure and use that to trigger the creation of a new record.

Go to related record

If (Status(CurrentError) = 101

Perform Script (your new record script)

else

.

.

.

end if