Not sure if I understand your question . . . A FileMaker portal can show any field in a related table and you can even pull data from "multiple" hops away depending on your data and TOG. Perhaps you can give a few more details including how your relationship graph is set up.
In layout mode double click on the Industry Group ID and in the Specify Field dialogue choose the field you want to display data from. Same for Functional Area ID if that is not what you wan to display. This is based on the assumption (always a bad thing) that your list is a portal row and that you have a field that has a name for ID 9 and a field that has a name for ID 5 (using the 1srt row as an example).
Is that what you are asking?
Here are several ways to display related data.
However, your statement "there is no direct connection" is a little confusing.
The two tables DO have to be related. After all, that's what the idea of the "foreign" table implies.
1. Just display the field from the related record.
2. Display the related field - but display as merge field.
3. Display the related field by using the placeholder calculation feature.
Pull the data into the foreign table. I suspect this what you do not wish to do.
("no direct connection")
4. Create an auto-enter field in the foreign table
5. Create an unstored calc field in the foreign table.
ShowField.fmp12.zip 29.5 K
I mean the same way as a dropdownlist, and view one extra field. But it is just the first value that actually get placed in the field
Use a popup menu and look at the options for that Value List. Check the two boxes that have "second field" in their description.
Do you have an example? When I:
1. edit the dropdownlist
2. and choose "show values only from second field"
It still just show the first value, the number
This is pretty much what I was wxplaining to you in your other question.
No, this is how to change the visible value in a portal. Convert the number to the related name for example
There are two "list" types:
Place both types on the same field (two copies of the field) and compare which on shows you the "values from second field".
A little testing on your part will help you see what happens.
Use a sample/dummy database to test if you wish. Several people have explained, but you need to see it for yourself.
I agree with Beverly. You should do the comparison as she described so you can see the results.
Take the time to see what you are looking at. That is advice I use myself with everything.