Hi,

I have a button: NEW RECORD

Now if there is already a record, I would like to change the text into: EDIT RECORD

The Problem:

I have two tables: FIRST TABLE, SECOND TABLE

The button is on the layout of the FIRST TABLE and if I klick it goes to layout of SECOND TABLE and will create a related record in the SECOND TABLE.

How could I check if there is already a related record?

(It's a one to one relationship)

THX

by

ChiSao

Edited October 5, 200916 yr by Guest

You should test for this in your script or calculation:

IsEmpty( related::ID )

ID here would be whatever you use for a primary key field, since that would always have a value. If it's empty, that means there is no related record.

It works

thx