I have a table containing global fields called GLOBAL_FIELDS with one field: G_SEARCH_SSN. I have a layout called SEARCH based on the GLOBAL_FIELDS table with that one field on it. This is the default layout opened with the file is opened.
I have another table called EMPLOYEES with its own layout.
Both tables are unrelated.
I'm trying to PERFORM A FIND (EMPLOYEES:SSN=G_SEARCH_SS
N) from the SEARCH layout on a field from the EMPLOYEES table. If found, GO TO LAYOUT (EMPLOYEE) then GO TO RECORD. If not found, CUSTOM DIALOG "employee not found":
IF (CODE(GET(TRIGGERKEYSTROKE) = 10)) Then //enter key
PERFORM FIND (EMPLOYEES:SSN=G_SEARCH_SSN)
IF (GET(FOUNDCOUNT) = 0) THEN
SHOW CUSTOM DIALOG <-- "no employee found"
GO TO LAYOUT (EMPLOYEE)
GO TO RECORD <-- I want to go to the one in the found set
When I try this, I get an error: "this operation cannot be completed because the target is not part of a related table"
How would I accomplish this???
Thanks in advance.