Value Lists

I have a data entry layout in a Student table which requires the user to select a language in each of 19 different language fields (pop-up menus). 8 fields come from the Student table, 8 fields come from the Parent table, and 3 fields come from the School table. I’d like each Language field pop-up to offer a list of common values (e.g., Spanish, English, French…Other) that will grow when “Other” is selected and new language choices are added. This way, data entry would be a simple process of selecting choices from pop-ups with an occasional new value/language added to the list (via “Other”). I have a Language table with one text field (languageName). The Language tabl…

I'm trying to create multiple conditional lists on the same layout so that multiple options can be selected in a conditional relationship. I want the same options for each list without duplicating what is in the field above it. Let me try to illustrate: Since countries seems to be popular, I'll use countries. I want one value list to display the continent, and the other to display the countries of that continent, ie. Europe > France Africa > Kenya Europe > Spain Asia > China Etc. A simple conditional values list (which I have figured out.) The trouble I'm having is that I want more than one field showing the same value lists. For exampl…

Hi I try to filter lists from field to field. But the field before the last can be full or empty +++ The last field returns a code an the text that matches the code TIA Regards Patrick Odelin CVL_TEST.fp7.zip

Hello, I have a value list with 20 soccer teams....for each team I have a graphic in a container field representing their jerseys...my question, is if I can have FM automatically pull up the graphic of the jersey when I select the team from a pop-up menu. I am trying to make a weekly schedule of the games that would graphically show the team jersey along with the team name when selected. Anyone have any suggestions on how to accomplish this?? Thanks, Tom

Hi, I have been using a couple of FileMaker databases for many years but I've just started to learn developing my own. They were always flat-file db's before. I have several relational db's that I'll be working on, eventually. But right now I have a fairly simple, one-table, db I am trying to get set up. I need to have a couple of fields with a single checkbox in them. When they are checked, then another field or fields would ungray and allow for entry. If they are not checked the additional fields would stay grayed-out. Does this make any sense? Ex.: "Deceased" - if checked, then "Date" ungrays. "Registered" - if checked, "Number" ungrays. Then I als…

I want to concatenate several value lists, called produce, baking, dairy, etc, into one large list called grocerylist. Is this possible? If so, how? I've already tried to concatenate the fields and that doesn't appear to work.

I've read something over this past year that made mention of extracting user names and passwords into a Value List -- but now I can't locate the post. As system administrator, if I'm logged on will full privileges, can I build such a value list and how? Thanks for any help.

I am using FileMaker 8.0. I have a database with a value list field whose options are "Yes" or "No". I would like to write a script that will go through all records in the database and change any instances of "Yes" to "No". Is this possible? I tried doing it the following way but was unsuccessful. Show All Records Go to Field [Contact::RSVP] Set Field [Contact::RSVP; Contact::RSVP = "Yes"] Go to Field [Contact::RSVP] Perform Find/Replace [No dialog; Contact::RSVP = "Yes"; Contact::RSVP = "No"; Replace] Thanks for reading!

Hello to all, I'm finishing a small internal FM9 database of hotels, services and prices (I have a tour operator business that organizes tours to Chile and Argentina). At one point, our operators ahve to use several drop down lists with the services that hotels offer (pool, internet,massage, etc). But if they make a mistake and want to leave the field empty, they just can't. How can I do this? Can I somehow create an "empty" value that would appear in the drop down list? Thanks for the help, Mark

Hi everybody, I have a problem with check boxes.They are normally used to select multiple choices but I can,t check more than one box. I have to uncheck it to be able to check another one. Can anyone advise me about this? Thanks in advance for your help ;)

Hello If I have two fields side-by-side on a form where each contains a pop-up list of values, and the value lists are related in a parent -> child relationship, is there any way I can dynamically create the second field's values based on the value list item selected in the first field?

Hello Guys! Only a quick one: How can I make a Value list show a predefined language from a separate File? I've used this solution for the lables: http://www.fmforums.com/forum/showtopic.php?tid/183314/ Regards Ron

I have a table with 20 fields. I want to eliminate 8 of them and add instead two fields to hold the data of the eliminated fields. Say my fields are: FirstName, LastName, PhoneNumber, Department1, Address_Dept1, Department2, Address_Dept2, Department3, Address_Dept3… I want to delete Department1, Address_Dept1, Department2, Address_Dept2…and instead add only two fields: Department and set it to be a dropdown where the options/values would be Department1, Department2, Department3… and an Address field to hold the address. This way data entry person can choose Department from the dropdown and put the address in the Address field. My problem is that I need to …

hello I'm new to filemaker pro and I need some help with my database. I was wondering if it is possible to create a value list than contains the current date as well as a few of the dates after it. If it is possible I would appreciate anyone showing me how to do it. :)

I'm trying to clean up someone else's data and they have created 10 fields with 10 different values lists each value list has one option. I'm going to make it one field, one value list with 10 options. Creating this is no big deal but I wondering how I'm going to get their data to transfer. Any suggestions on how to go about doing this?

I think I should give an overview of what I am trying to accomplish. I have an inventory table that has maybe 350 sku's. These skus are a part of a product line, maybe 3 or so different SKUs for different colors of products that are in the same product line. I am attempting to make a quoting module that asks for the customer name, to quote this to, and then display a list of ALL of the Product Lines, prompting the user to choose yes or no for each line, if they mark yes then the SKUs that belong to that product line will be included in the PDF that is generated. I can't seam to display the list of product lines as a portal. Is there a recommended way I shou…

I have a text field called Customer_ID_String. It appears on a layout formatted as a drop-down value-list field, with Auto-complete. There is another field, Customer_Number, defined to Auto-enter a calculation based on Customer_ID_String (via a simple relationship to the CUSTOMERS table) Ordinarily it works fine when the user does the typing into Customer_ID_String. Then I tried to give a default value ("indiv") to Customer_ID_String, using auto-enter calculation. If the user chooses to accept the default value (tabbing to the next field without entering some other ID string), Customer_Number does not automatically recalculate itself! I've tried using auto-…

Hi does anyone know how to create a simple list of numbers that dwindles as you choose them. I have one number field with a drop down list of numbers 1-10 and I want the end user to allocate a unique number to a small amount of records. 14 records max. Yes I have seen some of the examples on here, but they seem overcomplicated for my requirement. In other words far too complicated for me to understand. Thanks in advance

Hi, I am a MAC user using 8.5. I have a layout with fields each containing their own value list. Everything was working fine until today I entered a new record and one of my fields containing a popup value list will not display the list. The other popup lists appear for other fields just fine. My previous records all work fine. The problem only appears in my new records in this one particular field. I checked the field formating and can see no problems. I have recovered the file hoping that would help. Can anyone please help me? BTW, I have also had trouble sorting by last name (a field which is linked to another file). I can sort by date and other fields…

Hey all, sorry if this is a dupe question.. I did try to search for it first, figuring I can't be the first to run into it. assume I have only two databases: Parts, and Contacts. Parts have a field called "part types", where I can indicate if a particular part is a tool, pipe, or a fitting. (in the real world, there are many other options). In contacts, I want to show what tools a contact owns, what pipe, and what fittings. I would LIKE to use relational value lists for this, where in contacts, there is a checkbox set for each category (trust me, it is workable from a data entry standpoint). I set this up, and found that the relational value …

Value List looks like this: 1 = New 2 = Used 3 = Collectible ..but only enters the number, not the rest of the line. The rest is there only for the user to know which number reflects the quality.

I have Two fields named location. Location_1 and Location_2. Basically when an address is entered a location type needs to be assigned to it. Location field has a value list assigned with 4 possible location types: Main, Billing, Shipping and Other. So when an address is entered the location is chosen. I set up one more calculation field (Location_calc) which calculates Location_1 & Location_2. I made one more value list which displays values from that calculation field. In my invoice layout a new field which has a value list assigned to it (value list that shows values from Location_Calc field). When a value is chosen the address fields on inv…

Is if possible to have 2 value lists available to one field? If Field 1 = Cats Then field 2 = Cat Value List If Field 1 = Dogs Then field 2 = Dog Value List

(I searched a number of different threads but couldn't find the answer to my question.) This ought to be relatively simple...I hope! I have a radio-buttoned text field and a date field. When asked if a user had filed a report, he or she would choose either Yes - No - N/A from the value list; if Yes is chosen, I'd like the computer to beep with a message to appear that says, "Enter Date" and the user would enter the date. However, if he or she changes is or her mind later and selects the No or N/A radio button, the contents of the date field would be deleted; I'd like a validation-type calculation where FM won't allow a date entered with either the No or N/A but…

Hi is there any way to use the auto complete function in value lists, with filemaker 7? thanks

I want to find out if there is anything out there that I can use in my Contact Db which would provide the list of states & provinces for all countries (particularly US, Mexico, Canada & South Africa). I want to have value lists but I don't want to input the info. Help me out, y'all!

I'm not sure if this is considered a conditional value list or not, but I need to develop a cascading popup structure that goes from Countries to First Level Administrative districts (states/provinces/etc.) to Cities. Any suggestions with supporting examples (if possible) would be great.

Hi there, I have a checkbox set of several provinces. I have created a calculation field that takes the selected provinces puts them into a list separated by commas. NOW - I am wondering if there is a way to also sort the provinces in alphabetical order. Currently the order they appear in is the order that they were selected. Is there anyway to set up a calculation that will sort the values of my province field? Alternatively, if I could script it that would be fine too. I just need my final result to be the selected values (provinces) in alphabetical order separated by commas for each record. Thanks in advance!

Hey, I am currently using a value lists for a project and quite new to FM. The value list is getting data from another table first field is our internal product id and also displaying from the same table the name of the product. A product can have the same name but a different id when coming from a different supplier. My problem is when I either sort by the second field or tick the "show valuses only from second field" some of the products vanish from the value list. The ones with the exact same product name but also ones with same product name beginning. Any advice? Thanks

HELP!! FM Dev 7 Have a database with some 70 different customers and some 2900 records that include data such as Country, Type of operation, Process, Equipment, Model number and a few others. Items such as Equipment, Model number, Process may have multiple records for each piece of equipment. What I'm trying to acheive by having a 'Checkbox Set' of Customer Names and another 'Checkbox Set' with various pieces of equipment and having someone select either one or more customers from the list and have these records 'found' in a list format with all the relevant information. I need to do the same with the 'Equipment' list and find all the relevant information su…

Hello all, I have recently implemented a new database solution for our lab, but there are some things that don't work quite the way I want them to. One of them is this. There are a number of tables that want to pull calculated reference names from other tables in a value list. If I set the fields to auto enter text calcs, it will allow me to pull them up in the value lists, however then they don't seem to update if any change is made to the originating related records. This is important as we are still in the process of standardizing naming conventions for things. If I then turn them into regular calcs, I am unable to index them, and thus unable to use them for…

I have a field with 7 checkboxes. When I do a search for one of the check boxes, some records come up that don't have that checkbox checked. What's the deal???

Hello, I have a field which contains a value list of check boxes with 7 skills which a user can select. I would like to know how many times certain items were selected and by gender. Is FMP able to perform such a summary? Thanks in advance DH

We have an employee that is reluctant or doesn't want to use the mouse drop down menu so her dates are always different making searches difficult (she manually enters rather than clicking with mouse). On those fields that are not drop down calendar style it is easy to right click->date format and set my preference (aka override hers) but when there is a drop down format it doesn't give the option when right clicking. I need two things: 1. To be able to autoformat the fields with drop down calendar when she manually enters the date as 6/22/07 instead of 06/22/07 as autoentered by dropdown. 2. To autoformat all the old entries that she has done in the p…

[color:black]I have a value list of colors: RED orange yellow green blue violet White Black Pink Tan I would like the colors to appear in a menu like below from a value list [color:red]RED [color:orange]Orange [color:yellow]yellow [color:green]green [color:blue]blue [color:purple]violet [color:black]etc [color:black]How is this done. I am not sure if I can make different color words in a value list for a drop down menu Thanks Dave

Hi everyone, I'm kind of stuck here. I'm trying to create a dynamic value list with an autoincrement number field. E.g: Field number: 20 Value list: 1,2 ..... to 20 I can't manage to do that with a calculation field because I can't use a "loop" fonction because this is not a script. Is it possible to do that? Thanks a lot!

I have two database files: Client.fp7 - Tracks time worked on client's case. Phone.fp7 - records phone call message As I get my voicemail messages, I record the information in Phone.fp7. Some messages are related to client that can be found in Client.fp7. I would like to be in Phone.fp7 and have a drop down (or some other tool) that allows me to link the phone message to a client in Client.fp7. There is no relationship between the two table I am using in Client.fp7 and Phone.fp7. All I have been able to do is create a drop down that has the 1st client in Client.fp7...it doesn't list all of them. Any ideas?

Hello: For the life of me I cant figure this out. I have a popup box on a layout. I click on the box and I see all my choices. I let go and the popup box disappears. Then when I click someplace else on the form it comes back. Any ideas? Dom

I recently came across the technique known as "Dwindling Value List" (it also goes by other names). If you search FMForums you will find a couple of examples that can be downloaded. I documented the procedure because it helps me to understand techniques (hopefully to where it becomes second nature). I am including my documentation here in a text format. Feel free to use it, correct it, amend it, etc. -dan Dwindling_Value_List.txt

Is there a way to remove or not show items selected from a value list? Example: If the value list is 1, 2, 3, 4 and in a previous record you selected 1 from the Pop Up Menu, can "1" be hidden or not shown for a series of records I'm tying to use this for a scheduling solution and once I select a persons name I don't want to have it available for a series of records

Greetings, I have a file with 3 tables - contacts, events, joiner. The joiner table has the index fields for contacts and events as well as a number of fields I want to be selected by checkbox, for example - accepted invitation, attended, declined, etc. I created a layout where Events is main table and a portal for contact. This part works fine. I have the checkbox fields, (accepted, attended, decline) in the portal but I cannot edit these. The whole field flashes and that's all it does. What I want to be able to do is allow the user to quickly go through the contacts in an event and single click on what I'm calling the checkbox field. Any sugges…

Hi, can anybody HELP! I need a way to show a list of items from about 10-100 records from a particular field. For instance if that field in a hundred records was 60 x Item A and 40 X Item B the list would show: Item A = 60 Item B = 40 Many Thanks, Des. Apple G4 OSX Tiger FM7

Here's a great rookie question. Is it possible to count the values selected in a value list represented as checkboxes? If there are 20 items in a value list and I check 6 of them, how do I represent that 6 values as the number 6 in another field?

: I have a simple database for a sports club. The tables are Player, Team and Selection. In the Player table is a field called Available. It is either "Y" or "N". I want to populate a Selection Portal for each team using a value list of available players. I cant make the value list work. It either shows all players or only players previously selected. Why can't I find the answer to my problem? What is the meaning of life? Sorry, I digressed ... : Please help! TIA Langy!

Sorry, another conditional value list problem. : After days of searching for an answer I need some help. I have managed to create a conditional value list whereby listB is restricted to items by ListA. What I need to know, there are two further fields, (attributes), that I want to auto complete based on the field information selected in ListB. I have tried selecting these fields to auto complete but they don't work. sample.zip

I have a list of values (a column of words) that I want to be selectable by clicking on the word and having a circle appear around the word rather than having a checkbox next to the word. Any ideas on how to achieve this would be appreciated

I have three date fields where a client can choose three dates for a tour. The fields are 1st choice, 2nd choice, and 3rd choice. I want a fourth field to have the date that the client actually gets. I tried using the List function, but I cannot choose or select one of the dates. I want a drop down list, but can't figure out how to use a value list in this instance. Any suggestions? Thanks. daniel

I want to put a pop up or drop down box on my layout and I would like to attach a script to it. The problem is the script runs as soon as I click the box. I want the script to run after the user makes a choice from the box. Any way to accomplish this?

Hey everyone, I need assistance grasping the List concept to generate a conditional value list a user will use to place a sample in a lane on a gel. I will take a sample (Unique Sample ID) and put it into a specific Lane in the gel (Lanes 1-12). I have two tables: Samples and Gels. From the Gels table, I look at two related tables [samples and Gels[2]] for list calculations within the Gel Table. List (All samples associated with this gel) [looking into the samples table by way of Gel ID in the sample record] List (Samples that have been put into a lane on this gel)[looking into a second occurance of the gel table to find which samples have …

Does anyone know how to create a value list that contains all the account names in the FM database? Not just the authenticated user.

Greetings, I have a table which has the two fields, Listname and ListID. The ListID is unique per record and auto-entered, the Listname is simple the name. For example a record would have a ListID of "1001" and it's associated Listname would be "Heiroglyphics Today" I created a value list with a pull down menu to populate a global field. Since "1001" doesn't tell the user anything helpful I need them to see the actual Listname. But, I need to store the ListID to assure the correct record will be used later on in scripts, etc. I can make the Listname show in the value list but once selected all I see is the ListID. I'd like to store the ListID, see the …

For reasons best not explained here, I want a valuelist that pulls from a table that contains two fields (Name and Order) that will sort the list by order but only display name. I've created an Order = Order self join and set up a valuelist based on two fields to accomplish this, but I can't find a way to hide the order (second) field when selecting from the valuelist, even though the list only gets populated with name (first) field data. Is there a way to have a list that is sorted by a field that doesn't appear in the list?

Hello Group, I hope I'm in the right place, if not, I'd appreciate some help in where to post this question. I'm in desperate need of a solution today ! My problem 3 tables 1 - Orders 2 - Lines (Orders) 3 - Products : 5 types Goal : Place a purchase in the Orders file. This file will contain 3 portals (from the Lines table) : Portal 1 : Size Portal 2 : Color Portal 3 : Extras I would like to have these pop-ups display a list of Only the “related products” when the portal row is clicked into. So, if the “Size” portal is selected, a list of all the “Sizes” will appear. I can do this easily if the all the fields concerned are in t…

Hello all: I have another head banger question here. I have a text field that displays values as check boxes from a value list. On that field I have a button script. I would like to be able to run code if the user has de-selected a checkbox. How can you find out if the checkbox was indeed unselected thru the button script. I tried using pattern count but the value of the checkbox even though its de-selected is still in the list. Is it a question of the record not being committed? Basically I want to test if the checkbox is de-selected and then run some code but when I check the field the checkbox I de-selected is still present in the list. I guess the r…

Hello: I have a field set to a value list displayed as checkboxes. I have a 2nd field with 2 radio buttons. If a user clicks one of the radio buttons I want the user to have to choose one of the check boxes. How do I set this up? Also, is there a way to set a field to be non-enterable and only enterable if there is a value in a specific field? It would be great if the radio buttons were made enterable ONLY if a checkbox was selected. Dom

I think this might be a strange one, or a simple one, I have no idea. Lets say I have two fields: Payment Amount and Payment Type These fields aren't always used so I can't make either one of them a requirement to fill out. However I would like if they enter a "payment amount" that payment type becomes required. Is there a way to do this? I was thinking a validation calculation? I'm not even sure how to approach this. Thanks for the help! Dustin

I have a table called Tenant, it has a field called Property that is a drop down value list which the values comes from the Properties table. In my table Tenant, I also have a field called Unit #, it is a look up field from Properties table. Now that would work normally except when I enter 1126 Brookeridge I would like the Unit # to show a list of the Units there (that would be 1 through 10) but instead it only shows me the first one. I know that when I specified my lookup it says that it will copy the first value from the related item. But I know I have seen other databases do this. Any help would be appreciated.

Following the creation of a new record, I use a value list (showing keys from another table) for the user to establish a link to a pre-existing, but optional, set of information -- and that Popup selection method works well for the users. The problem arises when someone changes their mind and wants to remove/clear the link. Is it possible to have the Popup Menu include a "null/empty" value that they could select to remove any prior assignment? I really don't want to have a "clear link assignment" button for such a minor usage case. And for the obvious reasons, I'd like to avoid having a dummy record with a blank ID, but that's the only way I've come up with. …

Okay, I'm still perplexed. I've read through many of the value-list posts and I am still confused. I want to create a multi-layered value list. The list is hierarchical and has up to seven layers. (The list is the state of California's educational content standards). Items in the last layer (i.e. the seventh layer) are unique and I would like them to be displayed in a portal. I am setting this up as a find and not a way to add or delete data. I have downloaded John Mark Osborne's .zip file of Countries and Autos, but, unfortunately, still unable to figure it out. I have watched Osborne's video on FMP 8 Intermediate (through www.vtc.com). His video series is…

I have a contact database that contains customers and some non customers-bill to contacts, load at and deliver to locations. Each entry is assigned a descriptor via checkboxes: Customer Bill To Load At Deliver To Sometimes one entry can have multiple descriptor. I have a set of value lists that use the contact database data. Is there a way to make each value list show only the contacts that pertain to it? For example: The Bill To value list shows contacts that have the Bill To descriptor checked - that way when the person is in Bill To, they only see contacts that have the Bill To descriptor checked The Customer value list shows cont…

I have a Customer table containing about 600 records, self-joined to filter out those 50 or so marked Inactive. I'm using a drop-down list with auto-complete to allow user to select from an active customer name. It works fine except that it's slow (the auto-complete can't even keep up with my typing). The culprit seems to be the filtering relationship: it's snappy enough when I use the unfiltered Customer table to populate the value list. Adding a new customer is rare enough that I could generate a pre-filtered Active Customer table whenever a name is added, and use that for the value list, but short of that are there any speed-up ideas for the dynamic filtering I…

Hi, Is there a db out there that I can import with all the US postal codes and corresponding cities/states? I would like my user to plug in the Postal Code and have the city and state fields auto populate. I can do the relationship easily enough, I just need to find a db that I can purchase/download... Thanks, PF

I have a layout where I show several menu items in a popdown menu and then the choices in a second popdown menu that change to reflect the choice in the first menu (only in a find layout). This setup uses an external data table (i.e. a second file) that stores the choices in the first popdown linked to the choices in the second. It works like a charm if I am using FMP8.5 directly. However, when I use this through IWP it doesn't work at all. I make the choice in the first popup and the second remains unpopulated. The second file is marked as being shared, so I don't know why this isn't working? Any suggestions? TIA

OK I understand the basic concepts of the conditional value list. But I still can't seem to be able to filter on TWO conditions. In my Cars database I can lists my years and using the conditional value list I can narrow down my car MAKES to the specified YEAR. But when I try this technique with my MODELS it shows all my models for the MAKE. I need to be able to filter this somehow so that my dropdown list for MODELS shows only the models available for the make and year selected. And then I need to filter my engines by year, make and model. I'm new to building databases and any help would be appreciated. Seems like there should be a built-in filtering system that lets you …

I want to create a Value List from a related table using only some of the records based on examining fields in the related table. The create Value List dialog box only has 3 options: 1). Use values from field 2). Use Value List from another file 3). Use custom values In order to create this list I would have to examine fields from the related file to determine if that record should be included in the Value List. Any thoughts will be greatly appreciated!.......Ray

I have been building a database with training classes. I need to take attendance and keep track of which classes who attended and how long each class was for cumulative hours for continuing education re-certifications. I am able to use pull down menus for enetring names from the personnel database, but this is clunky because I have to scroll through each list of 60 values up to 35 times. I want to develop a checkbox solution for ease of data entry. Needless to say I have been very frustrated! Is what I want to do even possible? Am I missing a simple work around? Does anyone have any advice? HELP!!!

Hi, I see no reference to being able to sort a custom value list in this forum nor can find it in my "bible". I have a Custom Value List that users can update a client list in. I cannot see where (if at all possible) somewhere to sort this custom value list. It may be custom for a reason (hence no sorting) but as users will invariably muck up the alphabetical order I need a way to sort it - even empty it of blank entries. They like the Edit... function at the end of the list so the Custom seemed like a good idea. If I cant sort such a list, can anybody give me a better way to have this list auto sort, but still the ability to update it with the Edit... too…

Hello. The answer to my question is probably already somewhere on this site, but in the half hour that I've been searching I did not manage to stumble across it yet. So... I have a user table with a field for user_ID, user_FirstName, user_LastName, and user_FullName (which is a calculated field from the first and last name). I also have a value list which contains values from the field user_FullName. What I would like to have is a popup list which displays values from the user name value list, but which enters the user_ID when selected. I'm not sure if I can do this the way I have set it up. Any ideas? I also have a second similar problem. I have a field…

Can I use a value list to find a set of records? E.g., finding all records in a table where field x is equal to one of the values in the list? What would that look like? TIA

Hi all I found the cause Lionel welder.zip

I have a cond valuelistsystem, limked to 3 fields. A choice in field1 will generate the valuelist for field2 and that for field3. It's working well, no problem at that level. The problem is when the values need to be changed. When a user change the value in field1, and exit the record for whatever reason, the values in field2 and field3 are not correct. They still show the corresponding value from field1 (now changed). Is there a way to set field2 and field3 to empty, the moment the value in field1 is changed ? And to set field3 to empty the moment the value in field2 is changed ?

I access much our data via ODBC from web scripts. When I pull a field consisting of a value list via ODBC I get all checked items in that field separated by spaces. I can then split this out and use it however necessary in my web scripts...for the most part. The problem that I'm having is with value lists that contain something similar to the following, a list of accessories included with a computer... Keyboard - USB Mouse - USB Restore CD If I pull this into a web script via ODBC I get the following: Keyboard - USB Mouse - USB Restore CD So the problem here is that if I split using a space I end up with the following: Keyboard - US…

Hi to all. Perhaps it's a stupid question but I spent nearly the whole night to get rid of it. Here's the trouble: - have three tables in the same file: Addresses, int_codes and italian_zip_city; - in the input format I have a value list made from state_name and state_code coming from the int_codes-table which I use to update the same fields in Addresses and this is OK; - I want to use the updated int_codes in Addresses to have a value list from the italian_zip_city. I have set up the following relations: - between Addresses and int_codes through state_name; - between Addresses and italian_zip_city through state_code saying to use only related rec…

I have been playing with the attached sample file for the dwindling value list, but have struck a problem in that the dwindling list only displays if there is already a value in the matchfield. If the matchfield is empty (or contains just a pilcrow) the value list doesn't display. The value list depends on an inequality (≠) relationship between a calculated field and a related field from which the values are drawn, but Filemaker doesn't seem to evaluate it if the calculated matchfield is empty, even though the window is refreshed via a script. http://fmforums.com/forum/attachment.php?attid/10308/ I have managed to work around it by having the calculation se…

Hi Thanks for reading my post. I am building a CRM and Job management system. It is split ino four sparate dbase's. Customers Quotes Job Management Purchase Orders I have all the suppliers and customers in the Customers section. I have a field which is a radio button set so when the user adds a record they select if it is a prospect, customer or supplier. I have successfully added the lookup field and pre-filled company detail fields in my purchase order database. I need to filter the companies on the popup menu of the company name popup field in the purchase order database to only show companies that have the radio button supplier selected.…

Got same problem as another thread. "Customer" record includes "Active" flag: 1 if active, 2 if inactive. Defined new T.O. called "Customers_Active"; it is a self-join on Customers where g_Active = Active. (g_Active is 1 and global.) Defined Value List called "Active Customers" using Name field from "Customers_Active" T.O. Created Invoice layout, containing Name field that uses pop-up list using values from Active Customers. But the pop-up shows ALL names, not just active ones. Any suggestions? Thanks Chap.

Hi all friends I need to have a value list filtered so that it shows products NOT used into an invoice. It can be easily made with a plugin like EventScript ( see attached file ), but w/o it ? Invoice_wo_repeating_line_items.zip

I'm still not able to write a script to generate the report using dates imported into global fields using the dialog box. The info comes in but I do not know how to set up the range. I tried using a set field with a globalrange formula but it didn't work. Any help is very much appreciated.

Hello, Where I work we have a database of items, and when possible, we note how things are made. Instead of having people free hand write down what the decorative processes of an item are, we want them to choose from a menu listing the processes (like cross-hatching, stippling, incising, etc). The purpose of this is maintaining vocab control. Is there a way to choose multiple options from a drop-down menu? I want the user to be able to choose as many options as they need, but without have to show the entire long list of terms on the page (like I know I can choose multiple things using radio buttons, but I don't want to have 20 + terms displayed outright on the…

I have two interrelated tables. One contains an insertion ID (auto serial number), and Media Name (user entry text). The other contains a creative order number (auto serial number), Media Name (value list from first table), and Insertion ID (value list from first table). The insertion ID on Table 2 is based on the Media Name relationship, so that the drop-down list will only display insertion IDs created for that specific media, instead of all existing insertion IDs. Back on Table 1, I want to create the same type of conditional value list for the creative order number. I am able to narrow it down to just displaying the creative order IDs with that same Media name, b…

Hi there I've been using FM now for about 2 years on and off mainly to produce databases primarily to manage my own projects and i'm self taught with no formal training. This is what i'm trying to do. I have two tables "JOBS" and "CONTACTS". One of the fields in "CONTACTS" is "working status". This is a pop-up menu with a value list assigned to it with the following values: Make initial contact Follow up Not interested Potential collaboration Working together In "JOBS" I want to create a pop-up menu of "CONTACTS" but I only want to list those that have a "working status" set to "Working together". Hope this makes sense. Regards

I have a drop-down list which references nearly 20,000 records in a related table. When clicking on the drop-down for the first time in a session it takes about 30 seconds to load the information. Then when I want to select, say, "harry ..." and enter the letters "har", I am taken to the first record beginning with the letters "ar", and only when I then enter "har" am I taken to the first record beginning with the letters "har". This happens every time I click on the drop-down - the first letter in my search string is always ignored. The only way round this is to enter the first letter twice, eg. "hhar". It is an annoying glitch and I wondered if anyone else has experienc…

Hi folks, Having trouble with this. It seems simple but it just doesn't work. I have a customer mailing list that must be sorted by a specific (Canadian) postal code order, required by Canada Post. Specifically, the first three digits of the postal code, which are ANA (alpha, numeric, alpha: for example J5A) The field itself is a text field, necessarily. I've got the required order in a value list. In the script, when I try to sort it by that list, it seems to work for the first few, then it seems to start over and pretty much go alphabetically. Can you explain why this is? And what the heck I can do about it? The next mailing has to go out in …

Hi everyone, I'm a first time user to FM, using FM8.5 having worked with Access and some VB previously. I am wondering if I am able to have a dropdown list that shows only a select set of values from a table. Basically, I have a list of drugs that are either "active" or "not active", this value is captured in one field. What I would like to do is show only the "active" drugs for my users to pick from. I've gone through some of the forum topics regarding conditional value lists and tested/rebuilt some myself. Those solutions refer to having the user first choose a value then having subsequent dropdown lists to display the filtered list. For this value l…

I've been checking out my FM reference books for various value list / set functions. I have a field in my database for level. This could be interpreted as grade for the people in my database but not necessarily. I want to write a utility that checks if the level is in my grade value list (is it a valid member of my set - problem 1), what is its position in my value list (grades are not necessarily numeric so I can't add 1 to them - problem 2) so I can change it to the next grade in the value list (problem 3 - easy with the GetValue function if I can take care of problems 1 & 2). Any suggestions?

I'm pretty sure what I want here is not possible in FMP, but thought I'd double check. I've got a checkbox field that is conditional. Depending on other fields, it'll sometimes show some options, sometimes others. In addition, I want it to sometimes offer no options - in other words, it should sometimes be blank. I can get my value list to be empty when it should be, but then the checkbox field, instead of being blank, shows a single checkbox labeled "no values defined". I take it there's no way to avoid that in this case, without using a layout trick like selectively hiding the field using a portal? (I was hoping to avoid that because the field in q…

Hello, I have been using the "copy all records" method to capure the found set of IDs. I think i saw another method that avoids the pasteboard but can not for the life of me track it down. Think it used a List ( ) method. Anyone point me in the right direction. best Stuart

Is there a work around for this Valuelist showing as well as field 1 / field 2 example : 100 aaa 100 bbb When selecting in a dropdown I get only 1 possibility to choose: 100 aaa Kind regards

I'm new with FileMaker and read some of the topics about filtering value lists etc. But I'm having a parent-child problem with my program: say I have a Category-table. I want to make a difference between a main category and a sub-category. When I create a new category, i need to select if it is a subcategory or a main category. In parentID I want a value list that displays only the category's that are marked 'main category'. For example (screenshot): The drop-down list should only display category's where CatType = mainCategory It's probably pretty simple..

Hello All: I am new to this forum. Hopefully I am posting this in the right spot. I have a database with a field that is set to auto complete using previously entered values. I am using this field for the names of current client projects. I would like to delete items from the index when a project is completed. But when I go to the Insert Index menu and try to delete an item, it won't let me do this. Can someone tell me if there is a way to do this? If I need to just clear the entire Index periodically I am okay with that. It will get reloaded as I enter current projects again. Thanks Suzanne

I want to create a value list of dates that will be chosen to view timesheets. I want to start with a date, have the date 14 days later, and so on, but not dates in the future. Today, it should look like: 2/19/2007 3/5/2007 3/19/2007 4/2/2007 But starting on 4/16/2007, it should look like: 2/19/2007 3/5/2007 3/19/2007 4/2/2007 4/16/2007 And I want this value list accessible from different layouts based on different tables. I'm having trouble because I can't base a value list on an unindexed field (ie a calc using Get(CurrentDate)) or a global (ie setting a global to my list of dates on opening). Any ideas?

Is there a reasonably forthright technique to populate a value list using the contents of a repeating field? I have a global repeating field that contains the current acceptable values for a particular user-entered field. The values in the global field can be modified, if ever needed, by a system administrator. There are only six repetitions in the field. I've searched, but haven't been able to find an answer to this simplest of cases. My own efforts have resulted in "this value list will not work because the field cannot be indexed". I really don't want to resort to a dedicated table for this one-field usage. Thanks in advance for any suggestions.

I have a value list (company) that has grown too big and I want to move it to a new table. I didn't know it at the time, but I should have created a separate company with a relationship and a pop-up menu from the project table to the company table. I know how to create the relationship but how do I move the company data to the new Company table and still keep it connected with each original project record. I tried auto-enter, calculated result, COMPANY::company = PROJECT::company but it doesn't seem to work across tables.

Is there a way to create a value list using the values from as many as 10 different fields? If anybody can help me here I sure would appreciate it. Thanks, Jarvis

I want to recreate the drop down layout list that's on the status bar that only shows the layouts available to each user based on their access. I tried to find other topics but did not see any (probably there, just blind). Thanks for any help.

Hi, I am a FM newbie. My database is a simple contact list, from which I create mailing labels. I have my contacts categorized for a main category ("category 1"), then a sub-category ("category 2"). I would like to not only sort but create a temporary, isolated or standalone list, so when creating mailing labels, only those relevant contacts are included. I do not want to just rearrange the whole database because quite a few records are irrelevant for certain lists. The sorted listed would only include A and 1, or A and 2, or A and 3. Or B1, B2, B3. Does this make sense? I have only been able to find sorting help (from "Help") referring to rearr…

I am trying to log when a change happen on drop down value list. i have in the list Current, Withdrawn, Graduate, incomplete. i only want to log when the value list for the drop menu get change to Withdrawn, i was able to get it to work for all of the value list when the change but no the withdrawn one. i am using FM 6.0 on mac os X. any help would be appreciate it. Thank you victor

I have done some searching around to no avail on how to do this. I am wanting one fields data to set the value list for another. I know that this requires a conditional value list but I would like it to be an editable conditional value list. Any Ideas?

This one has me totally stumped. I'm creating a database for Matchbox cars. I have a table name Catalog set up that includes: Number, Letter, Variation, Name, Color, Interior, Wheels, Decals, Etc. I have a table named Car Finder. In this table the user can enter pertinent information to find which car he has. Example: If he clicks in Number he can select from any car number. Then he clicks in Name and only the names for that number appear, on down throught the line to where her can select the wheels and description. I've got that set up to work flawlessly. Now for my problem. This is what my fields look like: Number: (1) Name: (Mercedes Truck Lorry) Color: (Mi…

Is the following scenario a feature or a design flaw in the dialog that displays when you include in a checkbox set the Field Setup/Control's "Other..." item to allow entry of other values? The scenario involves using Find mode to search for or count records that contain an "Other" value in the checkbox set. Disclaimer: I have used and believe I understand FMP's Constrain Found Set feature. Regardless, I think the following situation could be an artifact of the (mis)behavior of the dialog that displays when you configure a checkbox set to use the "Other..." item and you include "Other" values. I have a field configured as a set of 14 checkboxes (note: a rec…