innodes Posted August 13, 2009 Share Posted August 13, 2009 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. Link to comment Share on other sites More sharing options...
innodes Posted August 17, 2009 Author Share Posted August 17, 2009 anybody? Link to comment Share on other sites More sharing options...
innodes Posted August 17, 2009 Author Share Posted August 17, 2009 thanks, and will do. I'll get back Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5389 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now