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

Title

Finding a record in an unrelated table

Post

     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

Outcomes