What result are you trying to achieve and how does it differ from what is currently working?
I am trying to achieve the same results as when I click on a portal record and how it brings me to that related record but with the Root Word field.
Since in neither case you choose "show only related records", it is extremely unclear what you actually want.
What is the point of opening another window?
Which case are you referring to? I have the Sign Family portal showing related records from the table occurrence of DatabseSF.
I have another window opening so that I can see entire record from the portal, and still be able to access the previous window I was in.
No you don't.
You're always showing all records.
Several other problems: you don't have any record ID fields.
Your data isn't normalized; you don't have a root-word table.
Instead, you have duplicates, for example RW004, which may have an actual value in Root Word; or may be empty.
RootWord-helpMOD.fmp12.zip 160.0 K
Aren't the SF number the record ID fields? If not, because if memory serves record ID's can't be duplicated, then the sign name at the top center of the screen would be the ID, because there are no duplicates.
I may be showing all records but if I want to get to a specific record in the Sign Family, I command click to go there. I don't have to search for the record.
I will try putting Root Word in a separate table and go from there.
Thank you for your help thus far!
Well; look at your data.
ALL the SF numbers are duplicated, some with different multiples.
There are NO unique SF numbers.
There is no record ID field (unique identifier).
You appear to have at least three different entities but only one table.