Your screen shot shows a problem in that you have selected "include only related values starting from:", but you have not selected that "starting from" table occurrence or that specific occurrence was deleted from Manage | database | Relationships after you defined the value list.
Thanks for that - but that's my point - the bug makes it impossible to select the relationship. The <unknown> shows that the current relationship - here Vendors - is the one FileMaker is trying to use, but this no longer works in 12.
Sorry for not reading more carefully.
I've used a lot of conditional value lists and have never seen <unkown> in that drop down.
See the screen shot I've uploaded of a conditional value list setup for a file you can download and examine at: https://www.dropbox.com/s/929zc4r2dqpf10o/ConditionalValueListDemo.fmp12
Given that you've seen "unknown" in this drop down in the past, but it still worked, I suggest running a recover on the file. I suspect that your file is damaged, but the damage did not affect the funciton of your file in previous versions, but that it does in your current version.
Things to keep in mind about Recover:
While Recover almost always detects and fully corrects any problems with your file...
- The recovered copy may behave differently even if recover reports "no problems found".
- Recover does not detect all problems
- Recover doesn't always fix all problems correctly
- Best Practice is to never put a recovered copy back into regular use or development. Instead, replace the damaged file with an undamaged back up copy if this is at all possible. You may have to save a clone of the back up copy and import all data from your recovered copy to get a working copy with the most up to date information possible.
Why don't you simply deselect the "Include . . . . . . Starting from"? It seems to me you don't need it . Other than that, I agree with Phil. If you want only related records a table must be selected.
Thanks for the comments
Here's a file so you can see. Have a look at the Contacts screen which is where the value list is.I want the value list on Contacts to display only the related company record for each contact record. This used to work in 11, not in 12 now.The relation I want to use to display data from is the Company relationship - the same relationship where the data is coming from. This is denoted by <unknown> when you define the value lists.ThanksMarcus
Solved now - I duplicated the relationship and used this as the Use records from: part of the popup. Now works as I wanted.
In FMP before 12, selecting <unknown> gave you the records from the relationship selected at the top of the screen - which worked perfectly.
Probably an undocumented feature and now no longer works - but now I have to create two relationships to make this work whereas just the one used to work fine!
Anyway, that's all fine - and thanks everyone for your answers!