In new database , I have a name of stuff field.
I want to not to use value list manually, but quote these value from another fm database named "STUFF" field.
So how to solution it ?
sunspot, welcome to Filemaker. Just a couple quick questions so I can point you in the right direction.
1. 2 separate FM database
2.yes, I want quote the value from that have been entered.
3.yes , just only "name" list.
sunspot2008 wrote: 1. 2 separate FM database
So are these 2 separate files?
If so do you have access from one to the other on your local device, or LAN or is it accessed by WAN?
the same LAN. I have the permission.
OK, here are some screenshots to create a basic value list and format a field to use it. For this tutorial lets call the file that you want to use the value list in "Database1" and the file that contains the values to use "Database2"
1) Open the relationship graph in Database1 and click the icon in the bottom left to add a data source.
2) Select "Add Filemaker Data Source" from the dropdown menu.
3) Navigate to Database2 and select it.
4) Login with an account that has admin level access.
5) You should now see a new table occurrence in the relationship graph for Database2.
6) Close the "Define Database" window and select File/Manage/Value Lists from the main menu.
7) Select "new" to create a new value list.
8) Name your new value list and select "Use values from field.
9) Select Database2 from the dropdown menu.
10) Select the field you want to use for the value list and click OK.
11) Go to layout mode and the layout that you want to use the value list on. Select the field you want to format to use the value list and select the control type in the inspector.
12) Select your value list in the "Values from" list.
13) Save and go back to browse mode, viola! The field is now formatted to use the value list created from data in another Filemaker file.
onefish has given you an excellent step by step on how to set up a "use values from field" value list.
When compared to other applications, FileMaker value lists are limited in someways that you don't in other apps. Over the years, people have worked out ways to get more out of the value selection process than can be done with a simple value list. I've compiled working examples of many of these methods, along with detailed descriptions of how they work in a pair of teaching files. Please do not use them yet, get comfortable with the basic value list options first. But once you find your self unable to do something with a value list that you want to do, you can refer to these files for some ideas:
Adventures in FileMaking #1--conditional value lists
Adventures in FileMaking #2-enhanced value selection
Thanks. But you may misunderstood.
I dont want to use "value list", but use field data what I have input.
Once the data source is defined, you can add a table occurrence from that source to the relationship graph and use it -almost- like any 'local' table. (I say almost because there are some refrest rules that differ, but you'll discover this soon enough)
sunspot2008 wrote: I want to not to use value list manually, but quote these value from another fm database
I want to not to use value list manually, but quote these value from another fm database
Sorry, you asked about value lists in your original question. Just follow steps 1 - 5 and then as Fabrice has advised, you can create relationships to the data, etc.
Retrieving data ...