AnsweredAssumed Answered

Finding a record in an unrelated table

Question asked by RickRobbins on May 13, 2014
Latest reply on May 14, 2014 by RickRobbins


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