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!

Outcomes