This is a brain twister for me. Below is a lookup relationship that is working. However it breaks if cloned, or if the table data is deleted (ie. in order to load data into an updated UI copy).

Global Table:

user_id_g

name_first_g

name_last_g

name_full_g

etc.

HR Table:

kp_user_id

name_first

name_last

etc.

The Global Table is a scratchpad that is used by multiple scripts, tables, etc.

The HR Table holds the personal records of employees.

The relationship is set as kp_user_id = user_id_g

The lookups are triggered by the opening script with:

Set Field [Globals::user_id_g; GetAsText(Lower(Get(UserName)))]

The lookups are:

Globals::name_first_g

. . . and

Globals::name_last_g

The Globals::name_full_g is a text with calculation that builds from the previous two.

In the original file, this works great, and is then used by multiple other scripts. The user logs in and the system, knows who they are.

When cloned, or the data from the HR Table is deleted,(then re-imported cleanly) the lookups stop working. I have deleted the relationship and recreated it, but cannot get it to come back. What am I missing?

Any and all help is appreciated.

anybody?

thanks, and will do. I'll get back