Value Lists

Maybe I designed this wrong....I have a database of survey results. 10 questions (fields), each pulling from a value list (SA, A, N, D, SD) displayed as radio buttons. I would like to calculate the number of responses per field, e.g. for question 1, how many respondents answered SA versus A versus N, etc. It would be easy if I had 50 fields (1SA, 2SA, etc.) but it seems like there should be a way to calculate the count of Field 1 equalling SA, etc. Any thoughts? Rick Metheny

Is there a simple calculation which can evaluate whether a number is odd or even?

Hi all, i'm very new to filemaker & cdml and i have a q: how to use a valuelist with two values ID and Description, show the description but store the ID? ... it should be sooo simple, but i cant make it work thanks in advance

It’s easier for me to give an example. Let’s say I have 3 files: A, B, C. On file A: use to display/edit multi records of file B: how to do it? make a relation between file A and file B, then use portal to display multi records of file B on file A. so far so good. One of the fields of file B called ItemField that lay in the above portal is assigned by a value list. And the value list comes from one field of file C. Let’s say A and B related by a key field called ID. WANTED: The item of the value list is allowed to be selected only ONCE per ID. For example the value list contains: 1, 2, 3, 4. If I select 1 for ItemField of the first record on …

I have two radio buttons: 'print' and 'complete.' When the 'complete' radio button is clicked, I want the 'Days Past Due' field (which has a calculation) to clear (or show zero). How do I do this? thanks!

Hi! Truly a beginners question: I have two radio buttons, "Yes" and "No". I want the "Yes" alternative to show from the start. How do I do? Thanks in advance! Fredrik

I'm creating a database in File Maker Pro 5 that will be used for a web site. I have never done a database in FM before (only worked a little with Access), so I hope someone here can help me out a little. I've come as far as creating several database files (one master file and 3 related files). So far so good (I think, lol). The database is supposed to display projects by an architect firm and so I've created the following database files: - projects.fp5 - employer.fp5 - category.fp5 - images.fp5 In projects.fp5 I've entered information on some of the projects in order to have something to test with. I have also added some images in images.…

I am looking for suggestions on the best method of looping through valuelist items. Currently I am using the count of "

There are a whole bunch of ways to do this depending how your database is set up. The most general approach is to have an override field that you can manually enter the tax amount into. If it's empty the tax calculates the normal way, and if it contains a value, then that value overrides the normal calculation. So, you change your tax calculation formula to: Case(IsEmpty(TaxOverride), ...insert your original tax formula here... ,TaxOverride) To make it look more professional, you can un-check the "allow entry into field" option from the original calculated field, and superimpose this field directly over the TaxOverride field. Make sure that you send the Tax…

i need to 'combine' two separate product files into 1 value list showing product_code, product_description fields which are in both files. any help appreciated.

I have gotten the idea behind (conditional) valuelists and they work fine. Now I want to display the result, not in a pulldown-menu or checkbox, but just as regular text. How?

Hello, I have one file that contains items, and another one that contains customers. The customers can have a lot of items. An item can only have one customer. So I've set it up so that you choose a customer in the items file, and in the customer file you can display all items that have the current customer. But when I change an item to belong to a different customer, this is not updated in the customer db. How do I update this? thanks!

Hello, Pretty new to FM. I am building a sort of accounting system where I have one file with Customers and another one one that contains simple economic information. In this file I would like to have the customers shown as a dropdownlist where you choose a customer. So I create a field, define a new valuelist with the values of the field from the customers file. But when I run it, nothing appears in the menu.. thanks, /Niklas

I have a field (List of Suppliers) that I use as pull down list in a web search interface. I have also allowed editing of this field, however the edited fields always give an error message from the search page. The index still contains the original information and not the updated information, while the field values contain the updated information. Is there any way I can force the index (FM 4.1) to update, so that the List values corrispond to the index value? Ger

I have a pulldown with values assigned to names. When they are selected and entered in the field in the database it has an extra blank space under the value. I can manually go in and delete these but prefer not to. When I display the value on a webpage it displays it with a space at the end which is not good if you are trying display a period at the end. Here is an example of one of the options: code: <option value="Connie Anderson, (707) 555-1234 or [email protected]">Connie Anderson</option> Is my problem the way I have written this or is there something with that field I need to do in the database? Thank you Kent

Hi everyone, Does anyone know if it's possible to format the field to show the "Other" option at the top of the list, rather than at the buttom? I know this is an option added by the system, but can I specify where I want it in the list? Thanks and have a nice weekend.

I have found that I need to use conditional value list for my problem. The example that I found consisted of two files. However, I have only one file with the same two fields as the example, Category and Item. I followed the example and I got a bit confused because they were using two files and I am only using one file. In the example from www.databasepros.com (I conducted a search on conditional value list), the two files they used were Menu and PopUp. In the Menus file, the only two items were Category and Items. Both were text and indexed. The same two fields in the PopUp file were not indexed. So, since I had only one file, I made them indexed text. Now, whe…

I'm trying to produce a pop-up list to enter the ID of a record from a related file of people's names. These IDs are not very informative so I'm entering the persons name, calculated from surname and first name fields, as the second field on which I wish to sort (I've concatenated surname and first name in that order). When clicking "OK" on the 'Specify Fields for Value List' dialog box I get the following error message "This value list will not work because the field "SortName" cannot be indexed. Proceed anyway?" On clicking "OK" several times to get out the pop-up list works OK but is not sorted correctly and I guess when/if I have a lot of entries will wor…

I have two values list and I want to base the results of the second list from the first list. Since I am dealing with a paintball shop, I am going to use it as my example. For example my first value list is category. I have Paint as a category. When I select Paint as the Category I want the second value list which is Product Name to list only those items which fall under the category of Paint. Any help is appreciated!

Hello! In FM 5.03, when accessing and copying data from a third file that has several records with the same matching field, it copies the values from only the first related record, yielding unexpected or inaccurate results. (Users Guide Chapter 8-6: "Important: When the same value exists in the match field in more than one record on the related file, FMP copies the value from only the first related record, ......" Also Chapter 8-14 : "Accessing related data from a third file ) Is there a way to copy the values from the record that is directly related? Thank you all in advance!

FileMaker Pro 5.0 for Mac. I have a Contacts database which holds company data, including up to 6 individual contacts per company. I'd like to create a value list that pops up only the six contact names in that particular record, not the entire database. Is this something that the "Only related values" option could help me out with? Because I'd be dealing within the same database for my application. Thanks.

I've inherited a Filemaker database originally created in Filmaker 2.0. Its been converted to Filemaker 5.0 but several value listsare currently lookup lists referencing a separate database field. The only thing in these separate databases are one field of values. I'd like to convert these to custom value lists instead and eliminate some of the databases I'm serving. Any issues I should be aware of? Will old records maintain their current information after this switch? Thanks for any help. Erik

Hey people, I have this record that has three fields. Any way I can create a value list that has the three field values underneath each other. As in Field 1, 2, 3 in "Field 1" "Field 2" "Field 3" Thanxs, Steve Griff

I use filemaker to send our email versions of proposals. I would like to do the following: Filemaker composes an email in my email package; to, subject, message - all from filemaker fields on that particular record. This is currently done by hand, ie., a series of copying and pasting between applications. I also want to indicate in an 'attachement name' field the filename of an image I want to attach from a predefined 'drop folder' on my hard drive. That is, script will point to statis folder location, but will dynamically pick attachment based on data in the 'attachement name' field on that database record. IS THIS POSSIBLE? I would imagine a dose of …

Hi everyone, Question from a FM Newbie... Is there a simple way (or any way) to have a pop-up window that, when you select an item from its list, will load a piece of data in another field. As an example, my pop-up's value list reads: Hat Shoe Sock If you select "Hat," say, a second field is populated by a number, like 3 (relating to the price of the hat perhaps). I'd appreciate any advice! Thank you much! Ben

If you create a valuelist on a field that relates with itself, then you don't have to use edit or other everytime you create a record and enter data it is a new value .. this is just a tip.. for the interested ones.. grtz Rick

Hi I have a db setup with several value lists. When doing a report I would like to be able to show a count of the value lists choices; value list has faculty, staff, secretarial. Want to be able to show how many faculty, how many staff, how many secretarial. Any ideas? Thanks, mrc

I am trying to Substitute Value Lists in real time? I have three pulldown lists in a row -One for Month -One for the Day of the Month -One for the year I want the "Day of the Month" pulldown list to switch to an appropriate value list that only has the correct number of days for the selected month. I setup a secondary file with a field named "Days" and I created 31 indexed records with the data 1 thru 31 in the records. I set up a "value list" named "day list" in the secondary file that uses the data from the "Days" field. I told my primary file to us the "value list" named "day list" from my secondary file and bingo ... it worked. Now I need to figur…

Hello Everyone! I'm trying to set up a value list that when you select from it the "value" appears in another field, I need to be able to select a number of "values" and all of them to appear in the other field. Just in case this doesn't make sense, I want to use it to code up skills for individual and be able to choose multiple skills from a value list to build up the individual's skill profile which could them be searched on at a later date Hope someone out there can help Thanks Nick

Hi, I am struggling with a field calculation. I have a field "date of next review" and I want to make it a calculation field, so when ever a person edits a record and the auto input command inputs the " date of modification", It automatically calculates the "Date of next review". Say 2 month from the modification day. Thanks in advance for all help. Jaime

Am still trying to find my ways out in filemaker and i would appreciate any help. I have this file with a starting layout that contains this field-outgoing, this field get its values from a pop up menu,contains- a.stationery b.chairs c.expenses i would like to make it posssible to have the outgoing field in onother layout(data entry)when starting new record, and this field should contain the results of the value list in the start up layout. I know it sounds easy but i've tried calculations, relationships but all in vain. thanks…

Im an absolute newbie with filemaker and am using this program to contruct a mediacal database to help my Phd project. I allready posted this question in another of the forums, but i think it should be here. Im using Filemaker to input patient data, and i want to use it later in SPSS for statistics. My biggest problem is the following: I have a list of questions that can be answered by "yes" or "no" For instance: "Hypertension"(this is a field) and then radiobuttons with yes and no (using a value list with yes and no in it) In my report i would like to see for yes a "1" and for no a "2", but still dont know how i should do this. (all these questions use the same v…

I have a value list, each item in this value list has its "weight" value, which is defined in another field. For example, The items in value list is A,B,C,D. "A" has its weight value, say "1", which is stored in another number field named "Weight". Maybe in future there should have some calculations on field "Weight". My question is: how can I set up relationships one by the other on the items in the value list with the other fields in the same database. Thanks in advance! Catty

Sorry if this is a common question, but... I am trying to make a "drill down" UI for users to see only what is relevant. Here's the structure of our data. This Weeks Books to Print .....Book Names ..........Sets (group of pages that is manageable in quark, about 8) ...............Page Number So every week we have different books that print, and throughout the year books will print 6-12 times. The Sets can have any number of pages, and won't come to us in numeric order necessarily. Each set can have different page numbers in it. I understand portals and have 3 files linked to our main "viewing" file. In the Viewing file, I have created globals and calculations t…

Hi, I'm using FMP 5, and have a layout that uses a look-up/pop-up MENU. The list of items in the menu is large, and has potential to be much larger. QUESTION: Is there a way to limit the number seen by the user, and add a scroll bar? Thanks in advance, -KJ

how do i program a value list or should i say pop up list to be able to select multipal values... for example... i have a list.. A B C D i want the user to be able to pick one of the letters or as many as they would like.. when i go to print i'd like each record to show which had been picked...

I have a Value list attached to a field, called Action List. I was wondering if it was possible to make the field so that only ONE checkbox could be checked at a time. Right now, you can put a check next to any of the value list entities, and I want the user to be able to only check one box at a time. If the user wants to change his selection, he can click another box, and the check will disappear from the previously checked item. Does that make sense? Thanks for your help Ken

My situation explained: I have 15 fields I need to use information from (3 rows of 5): Product01, Product02, Product03, Product04, Product05 Quantity01, Quantity02 ... Quantity05 ID01, ID02, ... ID05 My fields are set up like this: | Product01 | Quantity01 | ID 01 | | Product02 | Quantity02 | ID 02 | | Product03 | Quantity03 | ID 03 | | Product04 | Quantity04 | ID 04 | | Product05 | Quantity05 | ID 05 | A possible scenerio would look like this: | Baseball Glove | 20 | BG001 | | Football | 5 | FB001 | Volleyball Net | 20 | VB001 With hundreds of records with these fields and information on them, I need to find out how I can display the total quan…

i am using an fmpro 5.5 database for our company's timesheets.. i have a value list for start time and end time with time in increments of 15 minutes and i have the next field calculating the start time from the end time to reveal total hours... i have the start time and end times list in military format and when entered the field changes to 12 hour regular format.. however is there a way for the value list to just show 11, 12, 1 and not 11, 12 13 AND still calculate the end time from the start time correctly? thanks

OK, I'm totally new to Filemaker from a layout perspective (just created basic layouts...no value lists). I've followed the various instructions for value lists, but I'm still having problems figuring out how to do the following: I have a database for creating a delivery memo. A basic field at the top of the memo is a "Vendor" field. Since I use a fairly regular set of vendors, I was wondering how I would set up that field in a manner that would let me use a "type-ahead" style feature or even a drop-down menu, but one that calls multiple lines of info. For example, I have 30 vendors, whose information that looks like this: IBM Corporation 1 IBM Way Atlanta, GA …

I have made a db with 2 fields that uses valuelists. The first field is the main field and takes its values from a valuelist. I wonder if it possible to, depending what value that was choosen in the first field, get a specific valuelist in the second field. For exampel, if I choose the first entry in the "main" valuelist the valuelist that pop up in the second field is valuelist A. If I choose the second entry in the "main" valuelist the valuelist that pop up in the second field is valuelist B, etc. /Mattias

I don't want the value list to show the used values (which are key fields= numbers and have no use to the user). Is there a way of doing this? Thankyou for reading and eventually answering my question.

Hello, I have one layout with list view, and all the records shown depends on one dropdown list (Go to related record). The var from dropdown list is one global field, and I created one relationship between this global field and other field in the same file. The dropdown appears at the top of the list, and it is in Header part because if not, I don't know how to classify the list depending on this dropdown. The problem is that I can't select any var if it is in Header part, so I made one script which changes from one layout to another one, and the dropdown is on Body part, then select the dropdown value and go back to the list view.... this makes the selection of th…

I am designing our company's database for work being understaken. I have a section for product/brand category, problem is the client's we do work for have (literally) hundreds of different brands etc. Is it possible under DEFINE VALUE LIST for to have more than category, for instance so we could choose brands A-C, D-F and so on?

I have a large portal showing data from specific dates. The portal is only 2 large areas with a scrollbar. Instead of making the user scroll through the portal to find a specific date I wanted to use a value list of those dates to target a portal row. i.e I select Nov 19, 2001 from the list, click a button [go to portal row number (by field?)] and (pow) I jump to Nov 19, 2001 in the portal list. The problem is, I can't find a way to get the index of a selected item in a value list to use as my target to get to the related portal row.

I have created an order form we fill in while our customer is on the phone with us. We enter the Product ID and auto enter the description. We offer quantity discounts, for example; 1- 12, 13 - 24, 25 - 50, 51 - 100. How can I get the quantity discount price to be automatically entered based on the quantity we enter in the quantity field? Thank you in advance for your help. Gary

I've run across this scenario more than once and I hope someone has a solution. I have a regular date field and then a calc field that produces just the MonthName and Year from the date field. If I specify the data type to be date then the data appears wrong. So I left it as text. But now I want to return a value list based on that calculation. When I do, the list is alphabetized by the MonthName. How do I get the list of dates to show up in order in the value list?

I am trying to creeate a new stock database for my company but I am having a simple problem.(I hope that the answer is simple.) All my stock can have up to three catagry listings, put simply this is Department>Catagory>Subcatagory. My problem is that I can not limit the lists that appear on a pop up list for entering new product lines. This will make entry a very long business I have over 80 subcatagorys in all which is too many from which to make a choice. Ideally I would like to be able to filter my list based on department and only show catagories that are in that department and sub catagories that are in my Department and catagory. This would bring my maximu…

I have been asked to produce a report from a database unfortunately the user needs it to be based on one field using the value lists for that field as the column headings. Then the value in the columns would be date information. I am not experienced enough to know if this can be done. Each record has modified/create date time but the field in question doesnot have date information. What i really want it to do is say value x was selected for client x on date x client name field | Field value 1 | field value 2 | etc... acme inc. | 22/10/01 | big company | | 10/10/01 etc.... any help greatl…

Hi there I need HELP! Choose a cover type and have the description auto-enter? In the one layout I have all the clients Insurance information e.g. Policy 1------------------Policy 2-----------------Policy 3 Cover Type________________Cover Type_______________Cover Type Cover Description_________Cover Description________Cover Description Policy #__________________Policy #_________________Policy # Insurer___________________Insurer__________________Insurer Instal Amount_____________Instal Amount____________Instal Amount Date Commenced Date Commenced Date Commenced fields, 1. cover type 1_________4. cover description 1______7. Policy 1 …

Okay.. i really tried this time Let's go... I amusing a Join file for Contact and Organization. (Yes each contact may have 0 to many related Org's and each Org may have 0-many contacts.) Within this join file I have a calculated field "Contact_Name" so I can view all contacts within the Organization file for each org. I want to set a main contact within Org based on a list of all the contacts related to the Organization. 'main-contact' is a field in Organization. I want to use a value list to choose the contact name. Organization and Contact are only related through the join file. FM Pro does not allow values lists created through a relation based on the 'unst…

Urgent! Urgent! I need to show the value list in checkboxes and the last item in checkboxes should be "Other", besides "Other", there should be a field which allows the user to type in the other values they want. When I choose "Include Other..item to allow entry of other values", the "Other.." box not only includes the new value I typed in, but also includes the values that I chose from the checkboxes, which is not what I want!! Moreover, when I publish the database on the Web, the "Other" item disappears, showing me only the other checkbox items. Can anybody help me immediately! Thank you very much in advance!

I've got a nagging minor problem that I cannot figure out. I have a series of fields that I enter data into for each new record. I would like to be able to simply tab through to the next field and make my data entry process speedy. This works mostly, except for three fields that have drop down lists. I have set my tab order, and double checked it, but when I get to these three fields, the list does not drop down, nor can I enter any info into the field through the keyboard. I have to reach for my mouse and click on the field to see the drop down list. Other fields that have drop down lists work fine, it is just with these three. Probably important to note tha…

I have the following problem. File A : ProductTypeCode / ProductSerial / Productdescription / Budget File A has an internal relationship between ProductTypeCode and ProductSerial File B has a ProductTypeCode field that is formatted as a value list. When user chooses a certain ProductTypeCode, the value list of the ProductSerial field (also in File : only displays the ProductSerials related to the ProductTypeCode field. So far it works. The problem is that in File B I would also like to display the corresponding ProdDescription and Budget fields. When I place the related fields from file A on the layout in file B, they display the first value from file A, instead of…

I have a field with a popup value list of 5 items. I want to archive the information as the list changes. I tried to create a script but I could not get it to work in that field. I either got the script or the list depending on which was forward. The status value field is the status of software trouble reports. I want to keep track of the trouble report status as it moves from open, work in progress, assigned through closed. So I need to somehow save the status as it changes. My current approach is to have another file where the status for a given trouble report is stored. Then in the parent file I can display all the status history using a global. So to m…

I have a value list that represent cause codes ex: ORD1, ORD2, MFG1, MFG2. Each code has a different meaning. Is it possible to have a drop down list that would include the cause code and show the meaning of the code but when selected would only leave the code as the data? In access this feature is caused a "combo box". Alain

Hello, I have two tables, one for publication types and other one where I want to show all the publication types but no the "magazines" type. For example, publication types: ID Type 001 Magazine 002 Publication 003 Small Publication 004 Book I want to show in one pop-up list all the types, but not the "Magazine", and I don't know how !! Thanks Oskar

How Can I make a drop down listbox on a data entry form default to the last chosen entry such: User clicks on addnew. User picks Company Code from a drop-down list. User finishes that record clicks add new again. This time I want that drop down list to default to the value from the previous record so my user can just tab through the field.

Using a file that has nothing but a dozen value lists, I want a revolving door for the values in a field in my main file, escpecially when the value in a counter field is triggered. Here's what I have so far: if(Global counter <= 10 set field (global text, valuelistitems (file2, field1) set field (magazine, global text) if(Global counter >=11 & global counter <= 20 set field (global text, valuelistitems (file2, field2) set field (magazine, global text) end if end if Why isn't this working? Am I mis-using the valuelistitems function?

Hi, I'm just starting with FMPro5, or any databases for that matter. I am trying to make a DB that has a set of fields with a pull down menu that has choices of foods. I also have a field that I would like to display certain numbers depending upon the choice in the pull down menu field. I'm not sure how you would do this. I figured out that if I make the second field a 'calculation' field, I can use an if statement something to the effect of, "if the food field is (lets say) eggs, then display (lets say) 3, if not, then display 0" My problem is, I have a long list of choices under the pull down menu of foods, and I want a variety of numbers to display, depending …

Hi all, I have been trying for some time to get FM doing what I need, but still struggling. Here is the scenario. Category

I am looking to create a conditional value list with more than 1 tier to it ie, I want to choose column A - that in turn, effects column B - that in turn, once B is selected, effects column C, and so on, any one know if this is easily done? I have a database that is full of relative information, starting with size, then type, then costs, etc..... It would be nice to have all my info in one outside file to import into my master, so everything can be easily updated later in just 1 simple location. I'd appreciate any help, Thanks

I've gotten great advice from some of you guys, and I wanted to give something back. If this is too newbie and obvious just ignore it and smile at my naivetie. I found a great simple solution to a problem I had. I was trying to use a value list from another related file but wanted the list to be uniquely defined in each record in the related file. I formatted the field that I wanted to have a value list to use values from the related record and selected the the field that would define the value list. I defined that field as a simple text field. In each related record, I entered the text for each value to be used followed by a carriage return. It works just like the "def…

Hi: I am using checkboxes in one file, I defined the font size in the field as 18, but when I publish this file to the Web, all the other fields show me the font size I defined except the checkbox one, it looks so small and ugly! Can anybody help me on this? Thanks in advance! Catty

Hi outthere, I have a value list and only want to view the records that match one of my value list entries, can this be done? It always shows all my records. Thanks in advance, Morning Man.

Q? - Gotta be a way to make PC like Mover Lists? I am developing a FileMaker 5.0 medical application for a client. They have requested the ability to ... 1. Push button next to an empty list box/textbox with scrollbars, database form/layout appears ... 2. Left side of database/form/layout are multiple selections from a value list (actually called/listed from records stored in third database). 3. Right side of layout is empty list. 4. Between both are the Move 1, Move All, Remove 1, Remove All - standard Mover List Buttons ... 5. Once selections have been made - select OK button on layout, all selections are then applied to the list from the form/layout/database…

Is there any way to alphabatize items in a value list? I have a simple value list of cities, it would be much easier for users if they could be sorted. I thought of having another file of just cities, then I could sort them, but on the one form that my users will use, they use the cities value list numerous times, and with different answers every time. Any suggestions?

You need to create another file (ValueLists.fp5) to store this information. It would contain EquipmentID, YearsSold. The YearsSold field can either be a single year per record or multiple years on seperate lines. Then create a value list relating by EquipmentID and showing the Years field. This will generate the value list from only the matching Equipment records in that value list file.

Let me see if I can explain this clearly. I have one database (MetaDB) that contains unchangable data. When an item comes in to recieve it there is a second database (SampleDB) that a new record needs to be created for each item of that type recieved. So I have it set up that they create a new record and type in the item number. The item number is related and it pulls up a value list for the color name. That works perfectly. The color name is a pull down that gives them the list of red, blue, or green or whatever is related to the item number. The problem is that there is also a color code associate with each item number and item color name. These color codes a…

Hello, All! I was wondering if it was possible to clear fields if a checkbox becomes unchecked. For example, I have a value list attached to a field, and the field is formatted as a checkbox. One of my value list items is "Appointment Obtained" to report that an appointment has been set. Next to that item is a date field that I want the date of the appointment to be entered. Here's my question: Once a box is checked and a date is entered, if it is unchecked is there a way to clear the date field?? Just in case the appointment has been cancelled, or something. Any help is appreciated. Ken

I am using ValueListItems function to get all the elements from a valuelist and put it into a global field and print it or export it.But I can't.I am using script setfield(VFL,ValueListItems("master.fp5","VLN")),where VFL is a global text field and VLN is the Value List Name what am I doin wrong here??? [ October 12, 2001: Message edited by: Jacob ]

I have a simple database withseveral fields that are checkboxes. I want to be able to view records in a table layout, but the results of the checkbox fields are displayed vertically - only the first selection shows and the rest are separated by hard returns. If I select the field, all entries show, buut I want to be able to print the table for people. Is there a way to replace the hard returns with spaces or otherwise display the results in a horizontal field?

I'm creating a hard copy of a database and one of the pieces of information I want to include is contained in a value list. Right now I've simply included this field as is (it is currently a check-box field). What I'd like to do is clean it up - have only those items that are "checked" to appear. So, while in that field of the database I have the options of "A" "B" "C" "D" and "E", if only "B" and "D" are checked, I'd like the hard copy report to have only "B" and "D". Can anyone help?

Here is what I have to do.I have a file which has got product no & info.A person has to browse throught the items and using a check box add records into a value list.When he is done this value list is exported to another file and processing is done by removing the items from the value list.Is this possible.Can we add and remove items from a value list based on conditions.

I created a db where I create invoices for multiple clients. I use pull down value list to find the clinic and item. The problem is the keypad does not respond to the numbers to autmatically go to the item. eg if the clinic is 169 before I would type 169 and it would go right to the clinic, but for some reason it will not work. If I use the keyboard numbers across the top of the keyboard it will work, but not with the number keypad to the right. any suggestions. My platform is PC [ October 08, 2001: Message edited by: David Newcomb ]

good morning all, i have created a layout format and want to insert a list view into a specific area of the layout. ie i need the list view to look like a portal. any help would be greatly appreciated.

I've spent hours trying to figure this out, and looking for answers... Macinotsh FMPRO5 DB1: Countries.fp5 Fields: Continent Country DB2: Contacts.fp5 Fields: First name Last name Country "DB1: Countries.fp5" has a value list for the field "Countries" that I've called "CountriesValueList". I am adding countries to the "CountriesValueList" via defining the value list as the field "Countries". This works great. In "DB2: Contacts.fp5" I want to be able to access the value list from "DB1: Countries.fp5"; this also I have figured out by simply using the "CountriesValueList" value list from "DB1: Countries.fp5". (I bet you can guess where I'm goin…

My first Database with FM pro 5.5 I have a text field with a pop-up value list of types of deliveries (I'm an obstetrician) ie. normal deliveries, various forcep deliveries and various cesarean sections. I haven't assigned a field value to any of these types of deliveries but I did out of neccessity define a value list in order to make the pop-up. My problem is that I would like to extract the data as percentages of total deliveries, ie. percent forcep type, cesarean section, etc. Do I need to go back and make a portal to the field and loose all my entries or is there some way to get at this in perhaps a running tally. Keep in mind when and hopefully if you answer …

I have a value list called "household" that contains the names of ten households in a club. They show up as radio buttons. Each member can belong to one and only one household. I need to develop a layout that shows the members name and household. But, each household name needs to print out as a different color. I know I can set the field to any given color as a general case, but how do I set the color of the text (not the field) based on the household. Basically, this is going to end up as a poster for an end of year party where people will get prizes based on the number of points they have earned for their various activities. The poster will be in order of highest poin…

I have a database that draws one of its value list from a shared multi-user file on a server. When setting up the value list it gave me the option to select values from another file on the network and I specified the IP address of the server when choosing a host. However, the IP address doesn't seem to be part of the relationship. It still seemed to work ok so I went ahead and distributed the database to other people on my team. It works fine for most of them, but a few will consistently get a Database not Found error when opening it. When I go to their machine to try and fix it, I choose Hosts to find the shared file, but it isn't there. They seem to have their mac…

I am a CDML newbie and I would like it if someone can help me or point me in the right direction regarding the following: I have a search page. On it is a search that includes a pre-determined FM value list. I know how to get the user to a search_results page after the search regardles of what search value they choose, but how would get the user to a results page that is customised to the value they searched for? Any help is greatly appreciated!!! Christine

I need to create a performance report to Washington for my grant and they are currently using Access and I'm using Filemaker! I can export my information from Filemaker to send to them via email but I'm confused on how to do the following. I currently have a database that contains student information. In my database I have created radio buttons for the following three items - school, gender, race/ethnicity. What I have to report/export to them is different than the simple x-school/y-school; male/female; White/Hispanic. Washington requires that the number 1 entered for male 2 entered for female and so on. They will not accept male or female; white or hispanic. It ha…

Hi all I want to Translate selected item in popup-list to another layout? How do i return a value from a value list to a text field or po-up list? Im doing a dokument in swedish in the first layout and a english in the second layout I want to automatize also inputed value

I would like to know if I can view a value list from another file and use it to insert values into a repeating field in a second file, also keeping the value list editable from the second file. It would be a value list of songs in file (a) which is related to file (: via date ranges/client and is used to create set lists for shows by artists I work for. I originally had numerous fileds in file (: that would contain the songs but I think I have finally found a useful and sensible way to utilise a repeating field for once as this info never needs to be separated. This mod would help me clean up file (: a bit and connect the songs to the artist in a more direct way, allow…

Hi After setting up three tiered conditional value lists I have been asked to make the lists modifiable by the user from the master file (similar to as as you would a custom value list). Is there a way to do this? I have two files, the master file and a value list file. Within the master file I have set up two relationships and two value lists to support the conditional system. When Field A in master file equals Field A in value list file show options XYZ in Field B. When Field B in master file equals Field B in value list file show options JKL in Field C. Fairly standard. I have allowed the creation of related records from the master file in the both of the relatio…

I'm trying to make a pop-up list or equivalent that will let the user select a color (1 of 10)for a record. Any simple ideas?

Help!!! I have a database that uses Radio buttons to mark some pertinent values....my problem is that they make the database pause until they refresh or something...... Anybody got any cool ideas?? Ive tried font usage, widths, etc.... Thanks in advance!!! Billy

Hey kids. Here's my situation: I have a file called Bookmark Manager.fp5, with two value lists. 1. First value list: Category from field USR_tCategory. USR_tCategory is a text field that the user either picks a category from the value list, or types in a new one. 2. Second value list: ViewAs from field KEY_cViewAs. KEY_cViewAs is a calculation field for the sole purpose of providing a value list to search USR_tCategory (through a relationship). The calculation for KEY_cViewAs is: "all by category" & "

I am new to the web companion and am using FM 5.5. On certain fields, when I create a new record and insert text in some fields, the web companion adds a carriage return to the text automatically. Whenever I even try to edit an existing record, it also adds a carriage return. I've compared the fields for when this happens and when it doesn't and I can't find any difference. I've tested this when the database was hosted by a Mac and a Windows 2000 machine. They both do the same thing. Has anyone else run into this problem? Am I just setting something up wrong?

Hey all, I need to create a value list to allow users in an invoicing database to select which show (from a shows file) the invoice is coming from. I created a value list based on all the existing shows, but I want to make sure that this value list doesn't grow indefinitely. (I don't want users to have 300 options to choose from in a few years). I would be glad to either limit the number of entries to, say, 10 shows, or to only show shows that occurred withing the past 6 months. The only ways that I can imagine doing this are rather complex, I was wondering if anyone had any simpler suggestions. Thanks. -wald

okay, i'm pretty good with FMP's so-called conditional value lists, but we all know they are actually relational value lists. here's my problem, see if you can figure an easy solution. i've tried both the built-in relational approach and also scripting, but so far no luck and i've hit my "if i can't figure it out in a half-hour" ask someone time! 2 files: Equipment.fp5 and Testresults.fp5. Equipment holds pieces of equipment with types (A, B, C, D). The testresults table holds the results of tests done on that equipment, also with types of tests (1,2,3,4,5,6,7,8). Each piece of equipment has different tests done on it. For instance, Equipment Type A can have tests 1,2,3…

Greets, I'm creating an Interim program for the teachers at my school. I've got a list of behavior in a value list, then the teachers can check off the appropriate behavior selection. The Interim printout allows for three behaviors to be checked off (if more than three are checked, it prints it outside the field on the printout and looks odd). If there a way I can validate that only 1, 2, or 3 checkboxes are marked? -Doug

Is it possible in a second pop-up menu have only some choices based on a choice made in the first pop up menu? I've got version 4 and i'm a very newbye please use simple word ... i read the latest post in this forum about how to solve this problem but i didn't understand how to ...

OK, I have a growing value list that derives from the current entries in a field. The problem...is that the list has grown so large that the pop-up menu is larger than the available area on the monitor. I know I need some sort of heirarchical pop-up menu - preferable which has "a-f" ; "g-n" etc so that users can quickly get to the entry they need. Can anyone reference me to a URL that explains how to set up such a heirarchical pop-up menu? I have FMP 5.

Okay, I've been steadily reading and reading, but I'm stuck a bit on this one. I have a value list that I am using across a number of fields. They are logically interconnected such that once a particular value had been chosen in one field I want it to disappear from the value list in the next field. For example, if the value list contained the following choices: Audi, BMW, Chevy, Ford, Honda, Subaru, Toyota and the user selected: "Honda" in the first field then I want the next field to only display: Audi, BMW, Chevy, Ford, Subaru, Toyota if in the next field "Audi" was chosen, then the third field would only show: BMW, Chevy, Ford, Subaru, Toyota etc.. The…

I have 2 fields in my database. One is a number and the other a description. A list of the numbers and descritions exist in another realted file. I want the user to choose the value they want for either field as a value list. My problem is that I need the flexibility that if a user wants to enter the number, the description will automatically be looked-up and entered OR if they want to look at a list of descriptions they can click on that field and when they select the one they want, the number will be looked-up and entered into the number field. I can get it going one way easily using look-ups, but can't get it to work the other way around at the same time. Any help much…

Okay, I'm pretty new at this, so this probably isn't terribly difficult I just can't get it to work. I have three files -- a main file containing records of sources for news stories, a second file containing a list of states, and a third file containing a list of "areas of expertise." The states and areas of expertise files are simply lists of the obvious with reference ID #s assigned to them (Alababma is 1, Alaska is 2, etc.). The state file also has postal abbreviations. I have two separate but similar problems: -- I want to be able to specify multiple areas of expertise for each source, but I want to store that information simply as the ref # assigned to each are…

hello -- can someone please tell me how to have a radio box next to a text field that when i select the radio box the text field lets me type into it -- when it's not selected the text box is not active (greyed/faded or not visable?) thank you in advance - JJ

I'm going nuts! I saw once in a Mac magazine that you can use external value lists in FM3. It mentioned that the reason all my value lists are named "x" is because there are more than allowed (100 is the max, I think). I can't find any info on it anymore and I have long since thrown out the magazine (by accident, I assure you - that was a valuable article to me). I've even tried searching the TIL at FileMaker.com. If someone knows how to do this, please let me know. Thanks.

I am trying to find a way to make a value list display only certain values from a field in the same file, depending on the contents of another field. I have a staff database. it is related to a database published on the web, but the web browsers don't like relational value lists...so i thought of a way around it...but the trick is getting it to work. in the web file, i want to be able to have a drop down menu of people belonging to certain departments. (i.e. in the Writer field of the web-published database, i want a drop down menu of only the staff members with "writer" in the department field from the staff database file. the staff file contains a repeating field s…