Exactly which options did you select for your value list?
Are you selecting a value for a field in Orders with the values drawn from order_type?
> Exactly which options did you select for your value list? Are you selecting a value for a field in Orders with the values drawn from order_type?
For the value list, I selected "use values from field"; in specify field, "use values from first field: order_type", and "also display values from second field: order_name"; checked are "include all values" and "show values only from second field"
Both these come from the table "order_types". Is that what you meant?
Yeah that's the question I needed answered. That rules out the most obvious possible issue: the Show related values option with a relationship not defined until you commit the record.
What field have you formatted with this value list? Orders::OrderType or OrderType::OrderType?
If it's the second and this is not a mistake, then a new entry in the OrderType table won't update the value list until it is committed. Are both fields: Orders::OrderType and Order_Type::OrderType defined as the same data type? (Both number or both text?).
> What field have you formatted with this value list? Orders::OrderType or OrderType::OrderType? If it's the second and this is not a mistake ...
Aha! That was the problem! I have now changed the field to display data from "orders::order_type". I can now edit and add to this field, even with a new record.
But I have a new problem: the field shows the names (order_types::order_name) when the list is "dropped down", but when it is not dropped, it shows the numbers (order_types::order_type). I am not doing the value list correctly? I would like the numeric order_types to be completely hidden from the user..
Thanks again, good sleuthing!
When you select from a drop down list of a 2 column value list, you are entering the data from column 1, not column 2. To see the data from column 2, add that field from the related table or change your formatting from drop down list to pop up menu.
One trick you can do with a drop down list is to make the drop down field the exact width of the arrow so that the arrow is all that is visible. Then you place the related field for column 2 next to it so that it appears to be a single field. You click on the arrow, select the value and when you release the drop down, you'll see the related "column 2" value in the field next to it.
Hey, thanks Phil. Both those answers work: either using a pop up instead of a drop down, or narrow drop down with the related field next to it. (I think I will go with the second "trick")
It's still unclear why it works with the pop up, but not the drop down. When I add the column 2 field to the drop down list, I am unable to see those values in a new record, which is no good to me.
It seems rather arbitrary that it works in one, and not the other, and the behaviours are different in the two control styles, but hey, you have shown me a method that works, and that's the most important part.
Thanks again. - rick
All I can say is that this is a difference in behavior ths software engineers at FileMaker Inc. specifically built into the system. For why, you'd have to ask them and then persuade them to answer.
Having worked with other software, I'm very aware that other systems provide much more flexibility and power in what you can do with a drop down value list. Even having two columns (not just one) is a major improvement over the much older 5.5 version that I used to use but it's a far cry from what is possible with other software.