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.