Missing from the value list
I have a value list which enables me to select a farm field with a crop code from the field table see screen shot 1
You will notice that there are a few fields with 2 or more crop codes
however when I try and use the drop down list in a layout "pot Book Tbl" the field only appears once.
see next screenshot
the list is defined as shown here
and here is the relationship diagram
Could someone help me with this problem
This is expected behavior for this type of value list. If you sort values by the second field, the "name" field or if you specify only showing the second field value, duplicates with this name value will be automatically omitted from the value list.
Note that if this didn't happen you'd have a cryptic situation where you'd have the same name appearing more than once and at best, only an ID number in the first field to enable the user to decide which out of several identical names is the correct value to select.
The key question would be: "are you using the value list to specify a field or a crop? You can't use one value list in one field to select both. You may need to select a field in field 1 and then use that as a conditional value list to select the correct crop in field 2. This can even be scripted such that in the majority of cases, you just select the field in field 1 and field 2 updates correctly, but a script checks for the existence of more than one crop for that field and pops up a list of those crops from which to choose.
Hello again Phil
That sounds like a great idea to get a script to check for the existence of more than one crop
how can I do that ? Thanks H
I believe that I've already shared this demo file?
FileMaker 12 or newer users: https://dl.dropbox.com/u/78737945/SimpleNameLookupDemo.fmp12
Pre FileMaker 12 Users: https://dl.dropbox.com/u/78737945/SimpleNameLookupDemo.fp7
It seems made to order for what you are doing here.
Thanks I have used this before but have not set up the script for same names so now will try "the more advanced" part !
It took a long time but I worked through this demo file and modified my DB using the tricks learnt.
Now I can pick from a list if it contains more than one crop and even update the record from the selection automatically.
Thanks again Phil
I am using a drop down list to select a farm field using a value list based on Field By NAME T.O.
similar to Products by name above it on relationship graph.
Both TO are used to generate value lists - Product list and fields. The layouts are made where the user sets Product Select field using Product List value list and Field Select field using Fields value list
The Line item layout works great but the Applications layout only shows some records
The difference between them is the "crows foot" which appears next to FieldNameANDPcode field
Is this because it is a calculation field. ??
Is the Great Phil out there to help ??
Retrieving data ...