Value Lists

See the attached file. Users enter in names with different formatting which looks ugly in a drop down list. For consistency (all caps) I created a calculated field combining first and last name. I formatted the calculation to be uppercase. However when creating a drop down list on data_entry_field based on this calculated field (cap_combined) the formatting is lost. Some names are caps, some lowercase etc. Is this a filemaker flaw? test5.fp7.zip

Hi, I'm trying to learn how to set color attributes in value lists. I have a field called "Actions" that uses a 5 item list: (Out, Resend, Accept, Revise, Withdraw). Right now I'm setting text attributes manually. I'd like to know if I can auto-format the color of the value list items. Via a calculation? Note: I'm not a total newbie but I still have a very limited understanding of calculation and summary fields. I can't seem to follow the syntax...

I created a Value List based on the values in a field (say "color"). FM8 sorts this list in alphabetical order (blue, green, orange, red, violet, yellow). Since I want the Value List in rainbow order, I added an "order" field and manually assigned numbers to each color. Then I changed the Value List to use both fields, order + color, and specified "Sort by first field." That works fine, except I don't want to see the numbers in the menu that uses the Value List (1 red, 2 orange, 3 yellow, ...). So I checked the "Show values only from second field" option. That seems like it would do exactly what I want. HOWEVER, checking that option (1) changes the sort…

Here is my problem: I have a field based VL. How can I set it up in such way that once a value has been chosen, it is no longer available for the next record. For example I have a coaches table and a players table. Once players have been associated to a coach their names should no longer appear in the value list when I want to associate other names to another coach. This way the list becomes shorter and shorter as assignments are completed. This is to prevent a player's name to be linked to 2 different coaches. Thanks for any suggestion.

I have a perfectly working lookup for field2 that comes from related table based on values for field1. Now it turns out field1 that defines the realtionship for this lookup needs to be field1:: table2. This breaks the lookup. So, I have created calcfield1 (results in text that gets the value from the field1::table2) and that calc works just fine. But when I try to build the lookup on a relationship with calcfield1, but the lookup won't work. I noticed that a relationship based on a calcfield1 won't allow indexing; so, I tried to use textfield1 with a calculated result (which can be indexed) based on the calcfield1 value but no values show up in text…

I was just wondering if anyone else experienced this problem in 8. When you use a field from a different table for the second field in a value list (even if the relationship works great), fm 8 gets hung up and crashes as soon as you go use the value list. This didn't seem to happen in 7. I am shying away from using a value list with values from more than one table . Instead, i create an indexable field in the main table to show instead. This seems like a step back. Anyone experience this quirky behavior?

I am using both radio buttons and checkboxes. At first everything displayed correctly, but now the text of the lists is now showing up without the buttons and boxes! I can see see my options, but they cannot be selected. The same fields used in a different layout are still ok. Does anyone know why this is happening? I would be very grateful. I've been using Filemaker for years and have never had this problem. Thank you.

all conditional value lists i have done have been baseed off one other field....how can i set it up that when two different fields equal a certian criteria a thrid feild is populated

I have defined a field as a radio button using a value list with the option checked "allow other..." I am trying to see if I can have the text entered into the "other" pop-up window display in another field. I can't seem to get it to work. I have made a temp solution but would prefer to have it work differently. See attached file for problem and my work-around so far. Radio_Button_Test.zip

Ive made a test file with 2 valuelist... One with a Company Name and one with The State of the companys location. I have 2 company names in my test app Kmart and Sears. Kmart has 0 locations in my test and Sears has 3 NY NJ and FL. Heres my issue... Lets say I pick Sears as the company and Pick Location NJ. Then I pick Kmart (which has no location) NJ is still picked in the valuelist.. Is there a way to somehow clear the Location value list if the company changes? I attached a file too. Thanks alot. locationstest_2.fp7.zip

Hi, I have a sendmail script that needs to pull information from a value list and output the data into the sendmail messagebody. In this case, we will say the db is named "myDB" and the value list is named "myVL" and the values are "1st class" , "3rd class" , "Airmail" , "No Mail" I have a mail field that uses the checkbox format. Using the code I have, let's say the user selects "1st class" and "Airmail" In the message body using the sendmail feature, how do I pull "the checked data (in this case 1st class and Airmail") and post it into the message body. This is all I have so far. I spent too much time on this and am stumped. Thank: Trim…

Hello, i am runnin FM 6.0, i am want to use conditional value list base on to list, they are Location and Year, the other field involve id call Program Name. The two DB are Students and Program. Basically, when a user choose the location, year, i want this other List to show all the program name base on that. example. if i have Austin, 2006, i want to see all the program name base on those. i got to work when i choose the city it show me all the program name base on that city, i need to break it down now by the year also. thank you. victor

I am a new user to filemaker and have used MS access extensively. I have a primary key of a table Called Dealer as a FK in a table called staff. Now, in Access you can have a FK in a table that can be a drop down (listing all the pk's from another table, but the value displayed to the user is another field from the fk's table), but when they make a selection from that field the matching pk from the same table should be selected in the background. I haven't found any help with this in the instructions that come with filemaker, the help is useless for this. I am wondering how I can do this in Filemaker, or is it even possible? There is no point in even having a…

Hi, I am thinking of setting up value list based on field values, but I am not sure my procedure is correct, or even recommended. I do not like to allow users modification of standard FM value lists. My thoughts are: 1.- Create a ValueListNames (VLN) table. This table would hold the value list names. 2.- Create a ValueListData (VLD) table. This table would hold the values associated to the ValueListNames table. 3.- Link both tables using the VLN key, to allow me to create records in VLD linked to VLN. 4.- Create a layout in VLN with 2 portals. The first (portal1) one would be a self relationship to show all records in VLD. The second one (portal2) wou…

I'm sure this is simple, but it seems I haven't had enough coffee to see it.... On the main layout of a report form I have a Value List named TimeOfIncident for various school time periods-- value list values are Period 1, Period 2, etc. On a report layout I want to have a listing of how many records there are for each time period; I have a field defined for each period called Period1Count, Period2Count, etc. The report would show Period 1: 7 records Period 2: 2 records ...etc... - where the number shown is the value of Period1Count, etc. In English, the value of Period1Count equals the number of records where TimeOfIncident = "Period…

I've got a field formatted as a radio button which indicates which day of the week a student is registered for a class. Each class is registered separately in its own record. I'm trying to find to show all of the days a student has registered for a class. This database has a class table, student table and a separate table to hold registration records. Any help would be appreciated!

I have a valuelist that u choose a value from and then push a button that triggers a script. Then later in the script I copy that value from the field but then the valuelist drops down again and that takes time, can I avoid that in some way? Regards Jocke

How do I make 1 value list based on the results of 2 portals?

Hi, I thought I had this tucked under my belt but seem to be having a problem! I have a layout based on tbl_Quote and when I input a company code I want to be able to choose a Job No which is related to that company. I've attached my relationship diagram and the value list dialogue box. Incidentally, I'm using a trial upgrade to Pro 8 until the CD arrives - just can't wait. Many thanks in advance. Quote_Job_No.pdf Quote_Relationship.pdf

I have set up a conditional value list for the attached file. There are three fields, Country, State and City. When users select a value in Country, the available values in State will show up, and when users select a value in State, the available values in City will show up. This works for countries containing values for all three fields. But problems exist for countries with no value for State. For example, when users select France in Country, no value shows up in State and in City as well. But I want cities of France to show up in City. Is there a way to do that? Thanks in advance for any input. test.zip

Hopefully someone can set me straight on this. I've got a checkbox set for a field, using a value list. I want to be able to predefine which items are checked off, based on other info from the record (i.e. Province) In order to do this, do I need to create seperate fields for every check box item rather then using a value list? Example... Poster types. Value List: Poster 1 Poster 2 Poster 3 Poster 4 etc... If the Province is BC... I want Poster 1 and poster 4 to be checked off. Thanks, Scott

Is there a way to force the user to choose from one of the drop-down list options and disable his/her ability to type anything into the field? Also, is it possible to make the box that appears around the set of drop-down items size itself appropriately to the number of items in the list? Thanks.

OK so I have a Contracts table related to a Company table by a CompanyID and the Company table is then related to a Contacts table by the CompanyID. I have a layout based on the Contracts table where I can enter a CompanyID from a value list and then have only the Contacts associated with that Company show up on the ContactID value list. However, it only seems to be working with values already existing in the list. I want to be able to include a button on the layout so that if the user finds the Company (or Contact) they are looking for isn't already included, they can click the button and go to a layout to add the contact, then return to the Contract layout and …

Is there a way to translate in another language the edit and add that exist in a value list (or change the name....)???

Is it possible to make a relation into a table with a literal value. I can do it by putting that literal value into a global field and matching on that field, but direct from a literal would be tidier. I want to put different product options into value lists, from the same table but selected by an entry_type (option) field value. I could do this with a table per option type, but then loading the data would be a nightmare. David

I have not been in the forums for a while now... sorry all. So I have a lot of catching up to do. I did not find this in a quick search, so if it has already been answered maybe I can be pointed in the right direction I have a value list which displays 2 fields side by side. I want to be able to put field A with a spacing between field B... giving the appearance of a tabbed 2nd field so everything aligns nicely. Currently the 2nd field is butted up against the 1st field with only a single space between it giving a very ragged look to the value lists. Microsoft Access gives the ability to display a 2nd field by a given width. Why can we not do that …

I apologize for posting this problem which I realize has been posted many times before, however I am stumped as to why this does not work. On the table called "WO_Entry" I want to be able to select a brand from a pop-up menu. After selecting this brand, I want to be able to select a specific item from another pop-up menu, only displaying the items which relate to that brand. I have created the self-join relationship for the "Brand" field in the "Item_Entry" table. I have connected the "WO_Entry" table to the "Item_Entry" table using the LineID field as the match key. My value list is based on the "LineID" field in "Item_Entry" and only shows related v…

I have a runtime file using two values lists. Depending on which category value is chosen on one list then the other list displays a list of values available for that category. This works fine except I now notice in FM Advanced that the value list appears to drag, usually displaying what looks to be multiple copies of the 2nd value. Of course chosing it makes the copies disappear. I think this must be a screen refresh problem that has just crept into the new version. It certainly never happened in Developer 7. Any ideas how to fix this?

Thoughth this would easy but I can't seem to get it to work... I want to store the data a 0s 1s and display as No or Yes. Works great for data in place but I would like a Radio button that allows the user to use Yes No but place the number. I thought about using the "Show values from second Field" but then I'd need a table for that.... or is the solution staring at me ferociously? Any ideas? Thanks!

using fm7 Pretend I have not been using since v1.0 I have an xl file set up as follows: style model xprice xaprice sprice saprice Arthur dining 75 100 na na Arthur pub na na 25 40 Arthur whatever na 30 na 39 Trevor dining 99 115 na 100 blah blah blah What I want to do is have an order entry database where when I select "style" it will give me the list of styles (easy) What I can't figure out is how to have a value list based on the model I just selected...i.e. to give me only "dining, pub, whatever" for "Arthur". Then I want to have a value list based on the 4 price co…

this is all being done in fm 8 advanced, despite what the profile says. i have a file with a conditional value list. it is working fine, however, i have set the layout to auto save and still when i exit the field that the condition is based on which is the client field, the matter field will not show the correct matters until i click out of all the fields, sometimes it takes several clicks outside the field. the way the condition works is this: there is a calculation field that automatically names a record based on the type of client entered. if it equals that in a matter database, then those corresponding matters show up in a matter field on the main table. th…

I am using the FM7 demo for Mac OS X and I've been trying to make a db with greek characters in the fields, values etc. Everything seems to be working fine for text input with the unicode greek keyboard and unicode fonts (eg Lucida Grande) except from the pop-up menus that take their values from a value list written in greek. When pressing the pop-up menu the values list displays only questionmarks " :?: ". Strangely the problem is only with pop-up menus and not with pop-up lists that show the value list perfectly. It seems like the pop-up menus cannnot display unicode fonts but only 8bits ones as was the case with previous versions of FM. Has anyone had any similar …

I have a rellationship to show a field in a value list from only some of all records in a table. If I tell the valuelist to show all values (7400) it goes fast, if I show the values from a limited rellationship then it goes dead slow, slow like we can go and take a coffe break wile we wait, and thats is just 3800 values! How can I make this faster?? Plz need help!! Regards Jocke

Hello, I'm not referring to the options in the Sort Records dialog box. Hopefully, a simple example will illustrate. Suppose I have a table called colorTable, with one field called colorField, and suppose I have the following three records in it: red green blue If I define a value list called "Favorite Colors" and base it on the values from colorField, whenever I choose to display this value list (perhaps as checkboxes), Filemaker will automatically sort the colors alphabetically, so I'll have: blue green red How can I override this default sort order without having to enter custom values in the Define Value Lists dialog box? I'm going to h…

Greetings, I would like to be able to have my value list sort by the most popular items. I have a solution for my photography studio, and as we make new orders for clients, it is a pain to sift through all of the products for every single line item. I do currently have it set up so that within the product area, I can see within each individual product which invoices have had that particular item on it. I am wondering if there is someway to 'count' these occasions. So basically any given product would have a number cooresponding to it that is based on total sales. And then to somehow have my value list 'sort' based on this number?

Here's a brain teaser that kept me awake all night yesterday: In my example, I have a simple order system, where you select your items by selecting the item number from a pulldown menu. Most items are for any customer, but some can be made expecially for one customer and are NOT availlable for other customers than the one it was made for. The pulldown menu now shows all the items in the items table. But... I do NOT want to show the items that have a customer-restriction in that list. But I DO want to show the items that are resticted to the current customer. AAAAAAAAAAAAAHHHHHHHHRGGGGGG I cannot figure it out! Any suggestions? Reg. Herri…

I have developed a runtime solution. Everytime I make a change, I do this: bring it to the client, install it, import all records from previous version. Now the problem...anything that was added to value lists is lost. Is there a way to bring these value lists over along with the new added records? Thanks!

I have people and organizations, and I need to be able to pull up a person and find out what orgs they're with and pull up the orgs to find out what people are members. Here's the problem: I want to be able to directly add organizational affiliations to individuals, by name, from organizations previously listed in the DB -- via a value list containing organizations. Also vicea versa, adding directories of individual members to records of organizations -- via a value list containing all records of organizations. I can get this working, but the value list won't show each name as a unique records. So if I have 2 "kevin Sloans" in the people DB, they are t…

I have to do this for my boss,but have no idea where to start. I need to build a packing list, and here is what i want to do. If we are sending 100 shirts, but can only fix 60 in every carton. how can i make it so that all i have to put is the Qty per carton, and the Qty that im shipping and the item number and have the program do the math. I want to able to see box 1 with 60 shirts for item number ASM001, and have box 2 with 40 shirts for item number ASM001. ANy Ideas.

Hello, I would like to know whether this is possible. My "client" wishes to have three fields: General Industry Sub Industry Job Title General Industry with be a value list with say 5 values (i.e. Music, Film, TV etc). Now, each value will have a sub industry value list (i.e. Music = Recording Studio, Mastering, Promotion, etc.) Each Sub Industry has a corresponding value list (ie. Recording Studio = Runner, Assistant Engineer, Engineer). He would like it so that when you choose the initial General Industry value, the value list for the Sub Industry field changes accordingly to match the General Industry value. So, if Music was c…

why is fm doing this to my valuelists.....i never thought something so small could make me so mad..why is it cutting off my values cutt off vlist

Hello, Many thanks to everyone who has tried to help me in past posts. As it stands, i've got a database which is going to be a membership database. I have a layout called 'Factory' which allows me to add/edit/delete factories on the database. Fields include Factory Number/Name, Address, etc... I need one field - the Factory number/name to appear on another layout in a dropdown list. As factories are added/deleted - i want the dropdown list to change to suit. I have created a Membership table (all the details to suit a member) and a Factory table. I can add and delete factories, but when i go to amend the member data - eg: change factory…

This is strange... It only happens when I am using the FileMaker 7 server version, connected to a remote host--not locally. When I click on a field that is set to display a pop-up menu with values from a value list, it works fine when all records are displayed, but if I perform a Find to limit the number of found records and do the same, it turns the cursor into an hour glass and I have to delete the FileMaker process. This happens on more than one pop-up with other value lists, so I don't think it's a problem with the lists. Ever heard of this before?

First off I just wanted to thank mr_vodka publicly for already helping me make tremendous strides in my database. I really do appreciate it. I have clients who own multiple homes: Smith owns: 1 A 1 C 4 D 6 J etc. Johns owns 1 X 3 D 8 F etc. This is all solved outside of the computer world because we assign ID numbers to each of the properties, but no one remembers the ID numbers so I want to first reduce the options by name and then to property. I have a layout where the clients call in and request maintenance to their properties. The office manager will get their last name (currently a pop up related back to the property layout-wor…

Hi All, In v7, I was able to get around the forced alpha sort in value lists by defining a second "space" field and sorting by that. In v8, it looks like that no longer works. Take a look at the attached in 7 then in 8. In 7, the list is sorted in the order the records are entered. In 8, they're alpha sorted. My goal, of course, is to be able to have a non-sorted dynamic value list with only one field being displayed. Since the sort option is disabled when displaying values only from second field, I can't see another way to do this. It looks like 8 killed one of my favorite workarounds. Anyone come up with a new/different way to do this in 8? T…

I am sure many of you have seen the new option in the value list dialog which allows you to display one field's contents and return another field's information. It's the check box named "Show values only from second field" in bottom right-hand corner of the Specify Fields for Value List dialog. I am trying to use this option in the following scenario: Tables: Items (contains records of items) Seasons (contains a list of different season in a year) Seasonal Item (a table that contains keys of the item and season records. A join file) Relationships: Item::ItemID_pk >> Season Item::ItemID_fk Season Item::SeasonID_fk >> Seasons::Seaso…

I asked this a year or so ago, but I'm hoping more elegant solutions have been done. Given: Table A with serial # key field and some text field. Value list of Table A where the first field is the serial # and the second is the text. Table B with a # field set to display the TableA value list as a popup menu or list. Issues: 1) The popups don't display the second value list field if the layout field is not popped up. 2) Seeing the serial # is ugly, especially when sorting on the second field. Putting a calc field with just the 2nd field's value over the popup isn't elegant. 3) A reverse relationship where only the text is in the value list and a lookup o…

I haven't been able to find an answer to this in the forums, but hopefully it's a very easy question. I created a field with a value list of four different options for mailing lists, and then used checkboxes (so that one person could be on four different mailing lists). However, when I go into Find Mode and select one of the mailing lists in the checkbox (to find all those people with the box checked), it returns tons of people who aren't necessarily on that mailing list. WTF?! I can't right-click the field in Find Mode for any kind of Field Behavior thingy... I don't know what to do. Please help? Thank you. (I'm smart but don't have any experience.)

I cannot seem to figure out how to get a button to show a popup. Are these only available to fields? That would be a bad interface assumption on FileMakers part. I hope that is not the case. I have a row of buttons at the top of the window that run scripts. One of these buttons ( I had planned ) was to have a popup that displayed a value list (already created) that had a list of the other records in this table so that the user couid jump to the another record in the list. Thanks in advance.

Hi, I'm not sure if I can do this, but I've learned that if you can imagine it, there is generally a way to do it. What I would like to do is have a value list of layouts. The idea being that the user could choose a layout and go to it (via a script based on the number value of the layout). The list would only be some of the layouts in the database also the list would have to be self editing to grow or shrink as layouts are created. I thought of having a database which contains just the layout titles and a way of distinguishing which should belong to the value list, and then have a calculation field based on the content of the selected layout. Not sure if this make…

I have just converted a file from version 3 to version 7. It seems to be working largely as expected except the pop-up lists are so slow. For example, I have a custom value list with 5 numbers in it. I click or tab into a field set up as a pop-up list taking values from the value list and it takes 2 to 3 second for the value list to appear and then once I have chosen a value it takes another 2 seconds to drop into the field (all times approximate). So something that I used to do in a second or less in version 3 is taking about 5 seconds in version 7. I have changed the format to pop-up menu and that is as fast as always. However, that option is not open for most of my val…

Hi I've been struggling with creating a dynamic value list, based on selected options. The short story is that I've been trying to create a database, that list available translators, based on their language skills and what language the project is for. I finally managed to create this list, which updates as soon as I change the from/to languages. For this purpose, I've created two files/databases. 1: Employee database It contains information about the employees. The ID field is the short name for the employee. It also contains 10 x 2 Pulldown-menus for selecting from and to languages. (10 possible language combinations). An extra fie…

I am trying to build a report that tells me how individuals have paid (ie, check, charge, po, etc.) Each of these is set up as a vlue list and set up with radio boxes for easy data entry. I need to build a report that lists each customer by name and then tells me which way they paid -- but I need each value to be it's own field. See below for a rough example of how the report would look Name Check Charge PO John Doe X Jane Doe X Josh Doe X I know (or think) that I will need to set up a container field for each "check", "charge" and "po." In each of those container fields would I do a I…

I know this is probably easier than I think, but I have a value list with radio buttons. How do I set it up so the user can choose more than one option? Embarrased and grateful.

Hi, I am trying to create a dynamic value list using a related table but have a bit of a twist. Here’s the scenario: Two tables: Products and Invoices What should happen: Invoices table – user enters in a product ID, the product description is pulled in from the products table using the product ID as the key field, the user then needs to select the color of that product through a pull-down menu. The colors that are available for that product are generated through a value list using the related records option. The twist: In the Products table, there is one record for each product (i.e. there’s no duplicate records for each product); each product has a p…

I have created a value list that I use for check box set that lets me set different status' of records (active, inactive etc...) Question is: How do I set it to default select a specific value? ie; everytime I create a new record I'd like it to default to checking 'active' from the value list.

How do you create a Value List that only shows value related to the record your viewing? For example: Table 1 has A field labeled City that you type in the name of a city. Another field labeled qualities is a pop-up list with qualities of that city. So If I type in St. Louis in the city field, the options Arch, St. Louis Zoo, and so on would show up in the pop-up list in the qualities field. If I typed in Orlando instead, the options Beach, Disney World, and so on would show up in the pop-up list the qualities field. I assume I have to have another table with all the cities and there qualities. Thats no problem, I just don't know how to filter the pop-u…

I have a portal that shows all boarding reservations for a given date. Active reservations are given a pen number, and some reservations (like No Shows and Cancellations) are not given a pen number. I'd like to show ALL of the reservations, but make the active reservations show up on the top, and sort by them by pen number. In technical terms... When I simply sort by [pen_number], records with blank [pen_number] fields show up on top (obviously not what I want). So, I believe the correct method is by using the "Custom order based on value list". BUT, I do not know what to enter in my value list to sort ascending, THEN blank values... Any suggestions? A sp…

[color:blue]I have a field called "rfi_category" that is formatted as a checkbox with 8 values. "CC", "CI", "CL" "CODE", "DI", "IR", VI", "WM" are the values. I have created calculation fields for each that state: If (rfi_category = "CC"; 1;0) [color:blue]I have also created summary fields for each that state: Total of "count_cc" (running) The summary fields are the ones that I have placed on my layout, however all of the fields show "0" even if all of the check boxes are checked. Am I missing something?

Dear FM Experts, I have a major problem with my database with needs to be web published. I've defined value lists that displays values from 2 fields, it works perfectly fine until I web published it. Only values from the first field showed up. For example, I have a departments value list, with the first field being the department number and the second field being the department name. I can't just display the department name only because I used the department number to look up other things about the department. Also I've defined fields such that when I select the department, a description for the department is automatically entered. This functionality is also go…

I have a value list that is populated with values from a field. This field holds about 30 values but the pop up value list will only display 16 without additional scrolling. Is there a way to increase how many values can be displayed at one time without scrolling? Thanks, Jarvis

I have a HireDate field for each employee. I have a Pay Class field structured as a Pop up Menu with the following list values: 1. A03 2. A01 3. A06 4. Facility I also have 6 textboxes named the following: 1. Review Dates 1 2. Review Dates 2 3. Review Dates 3 4. Facility Reap 5. Facility P& T 6. Annual Review Note: Review Dates 1, 2, 3 are date fields. Question: Please help!! How do I do this? If user clicks on A03 then Review Dates 1 field should be hiredate + 35 days and Review Dates 2 field should be hireDate + 70 days and Review Dates 3 field should be hireDate + 90 days note: results should be in d…

How do you make one of the values in a value list the default value? In particular, I have a field defined with a radio-button value list, and for efficiency one of the choices should be the default. How do I achieve this?

Ok, I have to admit just switched to 7 and need to develop a new application real fast : Here's my problem. I have a table "values" with values, each value has a category. So I have 3 fields :id,category,value. ex (just to be clear not the real data where cat. are abbreviations): 1-size-mm 2-size-cm 3-size-km 4-color-blue 5-color-red Several fields in the "products" table need to display these values in a value list according to the needed category (size or color). So I have a global which changes to the category I want to appear in the value list through scripting. The relationship works fine! When I check in a portal I see the…

I need to create a value list which includes the major languages of the world. Does anyone have such a list, or can you point me to a source for one?

I am building a task management solution. It has three fields: PRODUCT > TASK > STATUS PRODUCT is populated with products from pop up value list. TASKS are generated from a value list that is related to the product value list. (If I select (PRODUCT 1) from the first list, the second list displays tasks that are germane only to (PRODUCT 1) etc.) STATUS toggles "complete" or "not complete". [color:red] Is there a way to make the TASK value list display related tasks, but only display the related tasks that are flagged as "not complete" in the STATUS field? Thanks for any help, Jarvis

As the subject states, I would like to create a value list with data from two fields in two different tables. Is this possible?

Please could someone tell me if there is a way to stop the field value list opening once you have made your selections? I have created a parts file, the first field is called category. You select the category from a drop down value list, from this selection, a drop down list opens in the next field and the next etc. this is ok but once you have selected the parts in all the fields, the first list drops down again at the beginning. Is there a way to stop this?? Many thanks in advance.

I have a field with a value list with A B C D E F each one is a zone for advertising I want a way to count how many checkboxes are checked in this field I Was trying this but does not work! Evaluate ( Substitute ( AD TABLE::GlobalMthZones1 ; 1 ; "+" ) ) Thanks! Tony D.

Hi all I have created a calculated field using the fields "process & process1" with a carriage return between them. I called this field "list". I created a relationship between the fileds called "process3 & list". Then I made a relationship between the fields "process3 and list" and then created a value list using this relatioship and chose the option use only related value then i attached the value list to the field "process3. the value list is very inconsistance. the list somtines displays the correct value, sometimes it displays an extra value and other times the value list is blank. Any ideas of what iI am doing wrong. I ahve attached an file that i have …

Hello All, At our company (packaging industry) we use couple of dozens proof printing profiles. Some of them are assigned to particular clients but some are designed for general use and the CLIENT_ID remains empty. Let's assume that we have an order from client 'X'. One of the required information is the profile. It is chosen from a dynamic list which should contain the profiles of 'X' (having 'X' in CLIENT_ID) and the universal ones (having CLIENT_ID empty). Obviously it is very easy to display one subset of the profiles but how to display both)? How to combine them in one list? I am not quite sure if my description is clear, maybe the attached file cou…

:shocked: Hi all I have attached an file I hope will explain what i am trying to do Thanks Louviere sample.zip

This has been addressed in other places on this forum but I haven't been able to follow the solutions provided so I'm asking again: I have a table with an index key (sorry - i'm an access user) that is an autonumber called Physician ID, then a field called FirstName and another called LastName. What I want to be able to do is to have a popup on my layout that shows Physician ID #, lastname, firstname and when I choose one of those physicians listed I would like the other 2 fields populated (LastName, Firstname). If the physician I want isn't listed, I want to be able to input the required names into the 2nd and 3rd fields and have the first field automatically upda…

:crazy: I have a report file with 99 fields....almost all of which could use a drop down choice list. BUT FM Pro V6.0 only allows 50 files to be open at the same time. Any suggestions on how to get more value lists to work while I have 50 files open OR how not to open 50 files every time???

Hello all of you! i have a small difficult... I'm ..french and an other problem with filemaker Problem and question: I have a check boxe with numeric values I created a calcultation with result, but.. when I do a multi check, when many boxes are checked, the calculation take just the value of the first checked boxe! how to get the sum of all the values checked? im not clear, I kwnow jb thanks

Hi, friends I have a value list based on a field contents. How can I dinamically have the list shown only the values of the found set, after a "find" based on another field of the same record ?

So I'm trying to figure out this situation. I have 5 seperate name fields. I'd like to have a button script which would grab each name value and then create a value list with the results so that I could then assign said value list to another field as a pop-up menu to get a final result something like this: Gilligan MaryAnne Ginger Mr. Howell Skipper Thanks in advance for any assistance...Kirk

Hi, I would appreciate some help with this. I've got a database for some information on hospital patients. Each patient record has a hospital admission date which is manually entered and can be unique for each patient record. I need to associate dates during the admission with events that occur that are related to each patient. I would like these associated dates to be part of a value list calculated based on the original admission date. So the value list should dynamically contain a range of dates specifc to each patient, based on the manually entered admission date. The range would be (admission date up to admission date+10days) So the date value list for each pa…

Now that i have your attention. I have established a series of categories and sub categories for data entry to reduce typos. each category has specific sub categories. the category value list is a simple user defined value list, but the sub categories are a conditional value list referenced from a related table. this part works fine, when you select a category the correct sub catergories display. unfortunately the feature takes over during data entry. when one selects a new sub category filemaker changes the subcategory heading for every record in that category. not a desirable result. what am i missing? how can i make the value list so that it will display only those sub…

I am trying to create a filtered value list of students who are boys, boarding and do not have a rooming assignment. Since I cannot seem to create a filtered list with any calculated fields that cannot be indexed (ughh), I need to have more of a dynamic lookup field. The problem is when you assign a Student ID to a Bed (in the Bed Table), the Bed_ID does not automatically populate in the Student table. In order to show a filtered list of students who do not have a Bed_ID (student table), I need to be able to auto-enter this field when someone adds the student_ID to the corresponding bed. The field does not automatically look itself up because it is in a different ta…

Hi, I have an invoicing db i'm trying to write. What I would like to do is generate a list of fee types which includes approx 10 standard choices, plus whatever else the user has added to their personal list. So far I have (in short) Table 1 - FeeList; fields: {Type} (radio choose GST or NONGST) {login} (text) {Name} (text - name of fee) {join} (type & login) Table 2 - Invoice; fields: {glogin} calc field (get(accountname)) {GSTJOIN} calc field ("GST" & {glogin}) {NONGSTJOIN} calc field ("NONGST" & {glogin}) I have then set up two table occurrences between 1) GSTJOIN & join 2) NONGSTJOIN & join I have …

This is too strange so I think I'm either overlooking something obvious or there's a bug in FM7. I have two files: FileA has a value list that includes values from related records that are also within FileA. The relationship is from a global field to a regular text field. FileB has a value list defined to be the same as the ValueList in FileA. NOT values from a field in A, but the actual FileAValueList. I have a field in FileB that uses a Popup menu displaying FileAValueList. The value list (FileAValueList) displays fine in a field in FileA. But when I apply the value list in FileB to a field in FileB, I get "" when I click in the popup menu field.…

Hi I am new FM user and I am moving my excel database projects over to a more logic format. In this example I have 10000 + contacts that chose between 40 different fields of interest. All yes or no. In FM7 I would like to convert those interests into a value list with yes/no radio buttons. Is there a way to combine defined fields into a value list? They all share a yes/no answer. Thanks! -Derryl

Hi there, I'm trying to create something like a "condition list of value list". Basically, i'm creating a value list of everything in certains fields (no problems yet). What i'd like to do, is to have a list of every element of the list that are in one particular record, and omit the elements of the list that are not in. Example: I have a value list of about 100 books for ALL the records in my BD. I'd like to to see every book that are listed in only ONE record (let's say there is 25, the list would only show these 25, and not the 75 others). Basically, it means that every record would have a different list of the books comming from the same value list. Is…

I have a vaule list that is from a seperate table. I need to run a script when a vaule is selected from the list. Also need it to be conditional based on what they choose. Example: list have values 1, 2, 3, 4, 5. When choose 2, run script x and store "2" value in value list field when choose 2, run script y and store "1" value in value list field

Please help!!! I have 3 textboxes: txt1 and txt2 and txt3 I also have a checkbox with values of Red, Blue, and Green. Problem and Question: When the user checks Red, Blue, or Green in the checkbox then txt1 and txt2 and txt3 should remain empty with no data. How do i do this? Do i create a calculation in define database or do i have to create a script and if so what do i write? Please help help help. I am new to this.

This solution is for a school. There's a STAFF file and a STUDENTS file. I am working in FM7 on a solution I originally created in FM5. I want to create a value list where certain staff show up on a student's record. Ten of the 100 staffers are instructors. I only want to see those ten on the pull down. I created a field on the STAFF side that's a radio button. It enters "Writing Instructor." On the STUDENTS side I created a global field with the same value hoping to create a relationship then basing the value list format on that relationship. Zero luck! Stumped with this one as I used to know and can't for the life of me figure it out now.

Recently in a different post http://www.fmforums.com/threads/showflat...true#Post167239 I described a difficulty I had with a value list and S

First, thanks to all for the great information on these forums. I'm using OS 10.3.9 and have two FM 6 databases, Stories and Pix. The two are related by a field-generated value list in Stories whose values can then be selected from a popup field in Pix. So far, so good ( think). But the problem arises further down the road when I'm trying to generate a different value list (in Stories) of values from the related records in Pix showing up in a portal. Stories contains a field (:PicPath) in the portal, which displays data from a field in the related Pix records. It is the ::PicPath data that I'm trying to feed into a value list and can't. My ValueListItems fi…

I have a common situation - a value list to choose an ID and also showing a sorted name field. I type in the first letter of the name I want and the list always jumps to the final name on the list, I repeat the intial letter and carry on typing and there is no further problem. Do I have an incorrect setting somewhere? Is this a know problem with FMP7 (I am using v7.03). It is going to be a real PIA when this solution goes live if the problem isn't solved.

I've been fiddling around with a database for a while, and I've figured that if you make a value list using match fields in related tables you can create new records in the "daughter" table via pop up menu. But I've also discovered that this can only be done if you have fields in the "daughter" table in the layout of the parent table. But what if you wish to create a value list that only affects one field (the one in the list) and allows permanent addition of new values? Joel

Is there a way to create an unsorted value list? How about sorted based on unseen field?

I'm not sure if this is where this belongs but hopefully it is. And hopefully I'll make sense. ----------------- I'm creating a card game and I need a way to simulate multiple piles of cards. I've not had alot of experience using tables with value lists in FMP7 so any help would be greatly appreciated. My concept is this: Table: (cards) Fields: Card_ID - holds the id for the card (1 through 4 for suits, 1 through 13 for value, separated by a - ) Card_Pic - container holding the cards picture dealt - this and the fields below would hold either a 1 or a 0 played - see above pickup - see above discarded - see above Table: main Fields…

I am compiling some questionnaires, and need to calculate the percentage of each item in a value list out of the total number of records. For example, radio buttons for ages: 13 - 17, 18 - 28, 29 - 39, etc., I need to create a script that will calculate the percent of total records for each age grouping. Another example, using checkboxes for interests: outdoors, art, music, fitness, etc., where more than one box may be checked. Again, I need to create a script to calculate the percent of total records for each interest. Also, how do I deal with the "other" items? I'm thinking there must be a relatively easy way to do this, but I don't know how.

I have a value list built from records in a related file. The relationship to the related file is sorted based on an 'order field'. The value list in the parent field (based on this relationship) appears in alphabetical order. I can get it sorted, but only if I display the second field, and select 'Sort By Second Field' (kinda stupid looking to display a set of sequential numbers). Using FM6, does anybody have a clever work around? Note: I found Nightwing's Menu Simulation, which displays a valuelist in sorted order without displaying the second field, but it is a portal, which I can't use...my valuelist is attached to a field that is already in a portal. Stev…

I have an esixting database that I am working with trying tomake some changes to. I have a table called "time sheets" that has a value list pop up menu, populated by a relationship to a "jobs table" job number field. Where each employee can choose a job number to track their time against. What I want to do is, once a job is complete, keep the record, but remove the job number from the pop up menu, so that there are not so many for each employee to have to scroll through to find the correct one. Is there a way to do this without having to remove the record from the database? Thanks.. Kim

I'm using a calculated field (FMD 7) as the source for a value list. Here is the formula for the field: LayoutNames(Get(filename)). The field is stored with indexing set to automatic as needed. But when I change the name of a layout, the value list of layout names does not update because the field is stored so that it can be indexed. Is there a better approach to this? I just want to populate a value list with layout names and have the value list update if I change a layout name. Any suggestions will be appreciated! Brudderman

Say I have a value list with 5 entries and use that value list in a check box format for field x. I would like to find all records where field y equals one of the checked values. Is there an efficient sequence of script steps to do this?? I'm envisioning a loop of 'extend found set' using 'middlevalues' for each of the checked items. There's got to be a better way! TIA tomp

I am constructing a file that includes several tables, including these: 1) an Events table, and 2) a Client table. The purpose of the database is to construct a life-history database which is made up of events (records from the Events table) in a client's life, arranged chronologically. The file will contain data for several clients, but I will only be working with data from one client at a time. I want to tag the individual records in the Events table (each record is one event in a person

Hello, I have a value list set up from field size in table "sizes" which only has 3 fields (size, rate, idnum) and when I choose one of the size values i want it to look up a value from that same record, but it doesn't seem to do so... i have idnum and rate set to look up from "sizes".... is this making any sense, i'm a newbie. thanks for any clues. Dan