1 of 1 people found this helpful
List ( filename ) makes no sense.
Did you mean list ( relatedTable::FieldName )?
Have you performed a Find for duplicates on that table of values?
Yes i did mean list ( relatedTable::FieldName ) apologies
Correct there is no duplicates. What is strange though the name appears with a global to Record ID relationship and in the value list .
A find produces no duplicates
Hi Don. Another question I have: you mention that “the company name appears in the Drop down menu.” FileMaker does not have “drop-down menus”; it has drop-down lists and pop-up menus, and the two function differently. If you are using a drop-down list, it makes sense that you would only see the ID. If it’s a pop-up menu, that is definitely more odd.
Assuming you are using a pop-up, can you share the details of the relationship and the value list? Perhaps we could see where the problem lies.
Did you check both for duplicate ID's and Duplicate names? (Separate finds with ! in field 1 and then field 2)
Oh My I think i should rewrite this . Did it it in too much of a hurry
Yes it is pop-up menu and that is why it is so odd.
Yes done that way back, ne of the first things I tested
OK I didn't originally write it and i wouldn't have finished with this interface. it this is a heavily NDA system for a client so I will describe it
Layout is in Table occurrence Companies
Field to be propagated by pop-up list is in portal to a daughter table Call it sister companies
Sister Companies has a Foreign Key to Companies based on Primary Key ( all are correctly there)
Value list is: f1 Companies::primary Key f2 Companies::CompanyName
Most are there Some are not and this exactly coincides with them not being there in the List function when the list function is looking at a relation between Companies::KF X comapnies2:KF
The popup-menu shows ALL the companies but the numbers appear in some and those are the ones that list(related::Field) doesn't show the companies.
Hope that makes sense
It is a strange one!!
Are both companies and sister companies table occurrences with the same data source table? It appears so, but would like confirmation.
Getting just the ID in a pop up menu set to show the second field is expected behavior but only when the record in the value source table is later deleted or given a different ID.
I wonder if you might have a damaged index. You can turn off indexing on both fields, close Manage Database, then return and turn them back on.
companies and sister companies are two different tables int eh same file
"Getting just the ID in a pop up menu set to show the second field is expected behavior but only when the record in the value source table is later deleted or given a different ID" agreed that didn't happen
I thought damage index as well I have done what you suggested but I might move it from the server and open it locally to see it makes a difference.
Ok I have not replicated tis with the same data in a reconstructed file and reindexing then reselecting in the original file seems to work although on recovering a baked up file it finds errors.
I am putting this behaviour down to file or index corruption .
I have encountered the same problem and it is sort of down to indexing. Although the field is not set as indexed, FileMaker 15 does index it (temporarily?). Refreshing, even with all the options, makes no difference. However, if "Automatically create indexes if needed" is un-ticked, the problem goes away.