2 Replies Latest reply on May 14, 2014 11:21 AM by RickRobbins

    Finding a record in an unrelated table



      Finding a record in an unrelated table


           I just can't seem to resolve the following problem:

           I have set up a preferences layout, so that my users change set-up and maintain their preferences for using the application.  For example, their e-mail address, smtp server, etc.  I have a button on each screen which allows them access this layout.  

           The button runs a script that brings up a modal window with a new record/request if there is no record for this user in the table.  My problem is that this table is not related to any of the other tables in which I am running this script on.  Is there a way to find out if there is a record for this user (acc_name) in the table and if yes show that record?

           By the way, I have tried with a find and with go to related record but both do not work.  They do not "find" the users record in the table.

           Any help would be greatly appreciated.

           Thanks. Rick