AnsweredAssumed Answered

Verifying a relationship to a utility table - ideas?

Question asked by ericjlindholm on Mar 1, 2018
Latest reply on Mar 5, 2018 by ericjlindholm

I have a utility table that contains all globals and a single record.


It could be consider the "connector" table in the selector connector data model. 


I prefer to generate records through relationships based on this table where a user does not need to be aware those records are created and I don't want to see a window flash.


I have run into one problem that I know is solvable. 


If I am in a layout based on a TO that is not related to the utility table, or I have a 0 found set, I cannot create records though the utility table "adder" relationships.  this is extremely rare in my system but I would like to be able to handle it.


I am trying to figure out a way to validate that I can access that TO from my current context so that I can open a new window to enable the creation of the records I need and then close that window. 


this table contains only globals to insure the single record is never locked so "set field" wont work.  plus I do not want to ever open that record


any ideas?


Thanks in advance!