Value Lists

Thank you all in advance for your help and comments! I have two related tables (1 and 2). I used the LIST function on the related table's records to make a list of all the docs in that table (2). I then used a FilterValues function to compare the related records list to a list in the context table (1). The filterValues function results were not correct. Before using the List function (which I thought would be a lot faster), I used a looping script to make a list from all the records in table 2. The filter Values result comparing the scripted related records list from 2 to the list in 1 WAS correct. But I think this looping script could take a long time once table 2 st…

I have a layout in my email address table which has a contact id field and Contact full name that displays based on a lookup. The problem is when I click on the contact id field the drop down lists all of my 100K+ records. I would like to filter this dropdown list since not all of my records have a full name given. I would like to filter only on those records with a full name entered but not sure how. NOTE: The contact id field on the layout is set as a dropdown list and currently get the data from the contactid field in the table.

Okay, take a look at this file. If you press search button enter a value in the field Type/Shape and then look at the Modifier field next to it. It is meant to be a conditional value list. It does not work if I set it up as such unless I change the table for the layout to dieline usage. I need my found set to be shown on the Preview Layout which is based on the Dielines table. This means I can not show my found set there. Can someone tell me how to fix this. I can fix either problem, but can not fix both. Note: I can display a value list if I do not display related values only. Is there a relationship fix? I am not a professional so feel free to speak in laymens terms. Ap…

I need help to create list based off of a selection in a field. For instance. If an employee selects that a client is "confirmed by phone" I want it to populate that record in a list on another page layout that I create. Or if an employee selects "confirmed by email" it should populate another list. I have a few other selections to, but that is the idea. Thank you!!!

Hi all, I have searched far and wide to no avail... can anyone confirm for me that there is no simple way to sort a value list descending instead of ascending numeric or alphabetical? It's a relational value list that just uses one relationship, and even if I sort the appropriate field descending in the relationship, the value list still appears ascending. We have sort options up to wazoo for everything else; am I just missing something here? Thanks in advance for any assistance!

Hi, In my current layout, I would like to create an overview of all values in a valuelist. When clicking on a value, the first record using that value must be shown. Does anyone know how ? Can this be done usigin a repeating textfield ? Or is there something better ? Many Thanx

I'm using the Format As Boolean option for a numeric flag value, with the displayed values being simply "Yes" and "No". I defined a value list so the user can make their Yes/No selection. Currently, the options that are shown to the user are "1 = Yes" and "0 = No" -- and everything works fine. However, I would like to offer simple "Yes" or "No" choices. Is there a way to define the value list to display only the words but still set the numeric field without having to define a table to hold the choices? Thanks for any help.

I'm in a bit of a tizzy because I'm trying to keep my list values in the order that they originally are (list from a field)---but FM is reorganizing them. How can I not have FM reorder my list? I have a table of records with a TIME field and a RECORDSERIAL field. The records increment in time as the RECORDSERIAL goes up. Wrench-in-the-spokes #1) I have the records sorted by RECORDSERIAL because my "day" doesn't start at 12:01AM---I have the day (record RECORDSERIAL #1) starting at TIME = 6:00AM and RECORDSERIAL #(Last) being TIME = 5:45AM the next day. Wrench #2) The start time and end time of the day are variable (they can change to 7:00AM till 6:45AM if I so …

I'm new to filemaker, so please bear with my "technical" terms. It looke like I'd have to build a relational database. Oh, what a headache. I have a table of clothing styles. I have a table of trims. A style uses more than 1 trims. A trim has more 3 dimensions. Is it possible to create a drop-down that lists values from dimension1 field and dimension2 field? Here a URL to my layouts:

I have a company record which has a sales exec field. I want to force users to select an appropriate sales exec from a value list (a pull down menu). I have implemented the value list and pull down menu, but I don't want to store the person's actual name in the company table. I want to store the ID attached to the name from the sales exec table. I would also like the sales exec field in the company table to display the sales exec name based on the id. So far, the only thing I have been able to accomplish is storing the person's name. But this could pose problems down the road if someone's name is misspelled etc. Can any one point in the appropriate diretion to solve this …

Is it possible to edit records from (or add records to) a VL that is linked from another table?

There may be a very simple solution to this - but I can't seem to figure it out. I have a layout that has a field with 10 or so check boxes. In another layout in the same database, I want to display this field as an Edit box field (i.e., not check box), and display the values one after the other, seperated by commas (or soemthing like that), instead of the default, one line per value. Any toughts to easily accomplish this? Thanks, Tom

I've spent enough hours on this to know that I'm not "seeing the forest for the trees." Attached is a sample file. I want Results::RecProducts_c to equal the value list "RPs". It works fine on the first Result record, but not on the second. What obvious thing am I missing? I'm not using 8.5's list function, bcs I'm still in 8.0v3 and so is my customer. TestValueList.fp7.zip

Hello, Is there a way to have a dialog box where the user can choose which columns they would like to have, be able to rename them and choose how many characters they need in each column to determine the column size? Thanks, Tom

Hi. I'm having a little bit of a problem with my first Filemaker file. I am switching from Lotus Approach Millenium. I'm trying to set up an invoice program. In Approach there is something called a repeating panel. You can place a repeating panel on your form and then you can add fields from tables into the form. The panel can display as many lines as you want and then if more lines are needed it scrolls down. I normally set up my repeating panel to include productID, Qty, Description, Cost and Total. Then all I need to do is fill in the product number and it fills in the rest of the infomation. Then I tab down to the next line in the repeating panel and continue adding i…

Hi, I have a drop down list in my invoice section that allows me to select the day the service will be provided. The drop down list takes the data from a field called Date and i would like the drop down list to only show the dates that has yet to come. For example, I have 52 entries in this date field which are the 52 saturdays of the year. we are 23rd feb so i would like the drop down list to show only the saturdays to be coming and not the ones that already happened... Is there a way of doing this ? I'm quite unexperienced so i would appreciate an English version of the things to do ! :-) Regards.

Hi Guys, I've got a number of fields in a portal, that are displayed as drop-down lists, from various value lists as appropriate. I'm not able to select the "Auto-complete using value list" check-box for the fields inside the portal, whereas fields outside the portal can auto-complete from the value list. I don't usually have a need to auto-complete value lists from within a portal, so haven't come across this before, but my client has now decided it would be nice to do. Before telling them it isn't possible, I wanted to check that I haven't missed something glaringly obvious. Thanks in advance for your insights! Regards, Dan

Hi, I have customers invoices and invoice payment tables, my question is how I can get, in the invoice payment to show only the invoices with balance > 0. Thanks in advance.

OK, I am FINALLY moving a fairly involved solution from FM6 to FM8.5 and in the process consolidating about 8 files into a single file with 8 tables instead. For the most part I am getting just how much better and easier it is to do what I need to do, but even with dozens of great workflow improvements, I still have 2 things are still eluding me. The first is that I can't seem to figure out how to redo the conditional value lists I had working in FM6. A simplified version of what I am trying to do: I have one table (events) that was related to another table (venues), the name of which I used to have show up in a value list which was conditional to Country (so…

Is it possible to add a table from a joined database onto a form and select items from the table to be filled into the form? For instance, if I want to let users see a list of stamps in the table, then have them click on the stamp name or number to add it to their collection and have it fill in the information on the form. I don't seem to see any information on this. Thanks for the help.

I hope someone can help me with a script that I'm trying to write. While in my Customer database I would like to select the account number of the current record then open my Orders database and copy the account numer into the Account No. field. I tried the following script: Copy [select; Customers::Acct No.] Open File ["ORDERS"] Go to Layout [original layout] New Record/Request Paste [select; ORDERS::ACCOUNT NO.] but all it does is open a new record in Orders and places the cursor in the Account No. field. I know I'm overlooking something, but I don't know what. I've tried different things with no luck. Thanks.

Is there any way to use colored text in a Value list and dropdown menu ?

I have been trying to work out a way to trigger a language change in "NoTrigger" in order to make it work like "IsThisJustBetter". I suppose i would like a way to make the first file work but at the same time am asking "IsThisJustBetter"? I suppose i would like to try and keep the language database centralized. best Stuart NoTrigger.fp7.zip IsThisJustBetter.fp7.zip

I have a portal in Companies that shows all related Contact. In the Contact file I have checkboxes for MAIN, SPECIALS, PRICING... I would like to have the portal in Company file sort these on the value list for the checkboxes (MAIN, SPECIALS, PRICING). This works fine when 1 checkbox is selected but as soon as the Main Contact also receives specials the person goes to the end of the list. Does anyone know how i can fix this?

I just *know* I'm missing something obvious, but I've never done this style of value list before. Apologies in advance if I don't post my file, but it has my company name splashed all over it and it's internal... I have two tables. One of them is designed to hold onto values to be used as a value list in the other table. The idea is if an edit is made to a value, that value changes everywhere it was used in the other table (i.e. the field value changes but the key value remains the same): TABLE: networkPortLocationList __kp_networkPortLocationID (primary key) netPortLocValue (list value) TABLE: networkAccessTable __kp_networkAccessID (primary key) …

I have a table and layout devoted to 'Courses' which has a Course ID, Course name, room number, etc. Also, courses are given a "Status" as either Active or Inactive. I then have a 'Registrations' table and layout where I pull courses into via a value list. The value list is comprised only of the Course ID and Course Title...and it works fine. I'd like the value list in the Registration layout to only display those courses which are Active. I tried doing this: If (Status = "Active" ; CourseID ; " " ) along with this: CourseTitle&" "&Section&", "&Program The idea was to create a value list based on these two field calculation…

I want a value list to display one value and enter another. Is this possible? I've set up a value list that pulls a Title from one field and then an ID# from a second and diplays them on a single row, like this: Title1 #1234 Title2 #5678 Title3 #2345 Searching by title is the only way to go, as the number of items in the list is 500-600. But I need to enter the ID# and not the title. It's easy enough to create another value list with the ID# as primary and the Title as secondary field, and then change the sorting order so that the list is still sorted by Title, but it's not only ugly it also renders the keyboard search useless (so you'd have to scr…

Hope someone can help me out with this. I have made a score field in my DB (edit box / number). I want to be able to fill in a score like 50% or 100%. The percentages correspond with the status of a project. I would like to link the percentages to a layout. For example if a score is filled in of 50% the project status I would be in Phase 2 and I would like it to show the phase 2 layout. Have no idea how I would be able to do this. Through a calculation perhaps? Dutchy

I'm having a problem with one of my layouts. I am pulling fields from two joined databases. The information from the fields in the one database show on the screen correctly, but the information from the other database only show when the field is clicked on and then disappear again. What am I doing wrong? Thanks for your help. It's a columnar layout.

Hello, very new to filemaker actually just got 30 trial version today i cannot figure out how to create the drop down boxes i can set the edit box to read drop down with scroll bar but cannot proceed to enter any options in the box .help please jacky

I've read a couple of threads that might relate to this question but the solutions seem rather complicated. I have a very simple (and flat) database listing some fabrics. I have a checkbox field where I check who has chosen a given fabric. At the end of the day, I'd like Filemaker to give me a total of how many accounts have chosen each fabric. Is there any way (without completely redesigning the database) to have Filemaker simply count the number of "checks" for each fabric and return the total in a field? When I tried a calculation using the Count function, it would only return "1" for each fabric regardless of how many boxes were checked for that fabric. Thank you. …

Good morning, everyone, After working all day on my database I have come to several conclusions. First off, I appreciate the help that everyone offers on this site. Without it I think I would be totally lost. I come from using Lotus Approach. Which is still the database that I use most often. The main reason I try to use Filemaker is if I want to distribute my finished product. Something that Approach sadly doesn't support. No runtime version. I read many nice articles about FileMaker and it's ease of use. Well, here's what I find. In most everyday situations I find it to be on an ease of use par with Approach. What really annoys me is the simple things are made SO d…

Hi, everyone, I'm trying to make up a database of my record collection. I hav the fields YEAR, LABEL, TITLE and ARTIST. I can get my conditional value list to work so that when I click on LABEL it brings up the lables for the YEAR that I selected. My question is, how can I get the TITLE to show only the titles for the label and year previously selected and then have the ARTIST field display only the artists for that TITLE, LABEL and YEAR? I would really appreciate any help with this.

I have two separate files. One is a Sales Order.fp7 containg records holding my sales data. The second file is an Inventory.fp7 containing my product inventory. My inventory is setup so that each item has a category. For example, Main Category --> Fruit, Item --> Apple. I have setup on my Sales Order screen the ability to choose the Main Category using a dropdown list. I now want to filter the choices based on the Main Category selection. Is this possible across two seperate files, or do both tables need to be in one file? Thanks!

Hello, I have 6 different tables a;b;c;d;e;f...and each table has a field named source code. Is there a way to combine all the source codes from each table into one value list?? Thanks, Tom

I can't figure this out. How can I turn the selections made in a check box field into a sentence. For instance in a field I call "Flooring" I check off hardwood, ceramic and carpet and shows up in another filed as "Flooring is hardwood, ceramic and carpet".

Hello, How can I make my inputs into a field automatically show up in a value list so I can access them from a pull down menu for future entries?? Thanks, Tom

Hello, I am trying to create a list of checkboxes. I have a value list with 5 entrys each seperated with a carrige return. My field's control style is set to display as checkbox set and is set to display values from my valuelist. Now the field in question does display the selection properly however the checkboxes are not selectable in browse mode. They are there because when I "Click & Hold" where they should be I do get the outline of a checkbox they just dont display as selected or unselected. Any idea what I may have done wrong? Thank You, Eric G.

I have a checkbox field with 3 choices in it ("Math", "Science", and "GLOBE"). I want to get a summary of how many records in a found set have a particular choice selected. Some records have more than one choice selected, so I would want that to be reflected in the summary for each choice. How would I do this?

I have seen references to this but really need a bit of a startup. I am developing a survey with radio button responses eg yes, no maybe I need to score these responses, (which vary - some questions yes is worth 1, some its worth 3) and then sum the scores I have seen postings referring to 3 tables for survey, questions and answers but don't understand how to relate these. If someone could post a basic structure, I will be able to learn from it

When using a value that gets the values from two existing fields is it possible to have the field that is a pop up menu showing the values display both values after selection. Right now I have a pop up menu and when selected it shows both fields values side by side. When I release the mouse to chose a selection the field only displays the first fields value. Any way to show both values after selection is made?

The attached script yields absolutely nothing in the dialog when executed. The valuelist is correctly named and the user has [full privileges]. I cannot see what is wrong. The Valuelist in question is based on a field showing only related values, but even when I change it to a valuelist containing only custom values I still get nothing. CAn anyone see what I'm doing wrong?

Hi All I have upgrade to 8.5 advance and I am having two problems with the value list working properly. The first problem is with the value list when it is define as display only related values. The value list works sometimes and sometimes it does not. When you click into the fields the list might appear and then it might not. If You click out of the field and click into another field, then click back into the field where the list is attached, the value list will appear and sometime it might appear at all. The second problem is that when the value list define as display only related values will not appear at all when attached to a field. When I attached a standard val…

I have a list of category codes and their meanings. Such as: rv-essentials Main Essentials I want to have a checkbox setup with all the meanings and when the meaning is checked it puts the category code into a field. How would I do that?

Our office is very unfamiliar with Filemaker and we have a system with a conditional menu that should come up only if a certain box is checked. How is that made possible? Thank you for helping out a novice.

Hello, I am trying to create a field where I can have only a single check box. I see where I can create check box and radio button SETS but I dont want a set. I want a single check box that I can either check (if its true) or not check (if its false) for example the database I am building is to keep track of my electrical motors. Some have Space Heaters some dont so I wanta field called "Space HTRS" and I want a single check box that I can either leave blank if it doesnt have a space heater or put a check in if it does. Ive read through the help files and tried to search the forum here but am coming up blank. Please help. Thank You, Jared

Hello All, I need help with FM 8v3 trying to figure out how to Lock Certain fields so only people with full access can modify them. Any help will be greatly appreciated. Knjie

I am working on a medical record db in FM 5.5. I want to check positive responses to a long list of symptoms as they are asked and then have only the checked items appear in a separate text field in paragraph form. I would like to add the results of other lists to the same text field. For example: “runny nose, stuffy nose, sneezing”, picked from a list of 20 nasal symptom choices becomes: “The patient reports runny nose, stuffy nose, and sneezing, lasting two weeks. The "two weeks" coming from a separate check list. I can create a field for every symptom and then add the ones checked “yes”, or I can pick each symptom from a table but these solutions seem wasteful. Any…

Hi all I have a text field that is functioning as a checkbox. There are three options Yes, No and Process. As it is now any or all of the boxes can be checked. I would like it to allow only one box to be checked so that if one was checked to "no" it is automatically unchecked if "yes" or "process" is selected. Many thanks in advance.

Thanks for any advice you can provide. I have a table of tour operators and the parks they can operate in: TourOperator = text, Parks = ValueList. The result is each tour operator record has a multivalued list of parks separated by carriage returns . TourOperator1 ...... Park1Park2Park3 TourOperator2 ...... Park1Park2 I need to find a way to split the multivalued list into single records: TourOperator1 ...... Park1 TourOperator1 ...... Park2 TourOperator1 ...... Park3 TourOperator2 ...... Park1 TourOperator2 ...... Park2 It doesn't seem too difficult at first glance, and I've made minor progress with a customised script, but af…

Whenever I create a new record each file increments by 1. This shows how many companies I have. EG 1 2 3 But say that I delete number 2. How can I then create another company so that it automatically numbers this as 2 and not 4? Thanks in advance if someone can help.

I would like to have a single field be able to display several different value lists based on context from another field without doing it relationally or changing layouts. Example: There are 2 fields. field#1 can have a value of a, b, or c. field #2 will then have a particular value list based on the value in field#1. In this example, there would be 3 different value lists, each corresponding to a, b, or c. Using a script, I can change the values displayed in field#2: If [table; field#1="a"] Insert Calculated Result [table:field#2; ValueListItems [file; "ValueListName a"] Set Field gives the same result as Insert Calaculated Result. Unfortunate…

Thanks in advance for reading my problem and providing your input, here we go: I have 2 test fields, Text field A and Text field B. Text field A, is set as Drop-down list and the "Include "Edit.." box is checked to allow users to add values. What I want to do is, when a value is selected or new value is added in Text field A, Text file B (which is also set up as a Drop-down list with Edit box checked) will only drop down a value list that is somehow pre-associated with the vale in Text field A and if there is none, it will just show a blank field allowing uses to Edit and add new value. Eg: User chooses "Seasons" in Text field A, in Text field B, only Summer, Wi…

I have layoutA for tableA related to tableB with a cartesian (by their respective uniq id's). On layoutA I have a field set up to display a dropdown using a value list. The value list is supposed to come from a field called AcountName in tableB. In tableB, these Account records have a SortOrder field, each with a unique character. In the relationship, I have tableB set to sort by that SortOrder field, but when I use the dropdown on LayoutA, the AccountName items do not appear in the sorted order. What am I doing wrong? Now I know I can pull the SortOrder field into the valuelist as well and tell the value list to sort by that field, but that disa…

Hi Guys I'm having a problem which I suspect is very simple to sort out. I normally use FM on a Mac, where I can easily select multiple items in a value list at the same time by using the Apple / Cmd key, then hit return to add all of those items to my choice. However, I don't appear to be able to do the same thing on a PC. This may be because I'm attempting to do it using Virtual PC running Windows XP rather than a seperate machine, but maybe someone can help? I've worked out that (on my Mac via VPC at least) I need to use Shift and Ctrl together to select multiple items, but when I select an item then try to select an item below it in the list, it de…

I need to remove value list enty based on a field value. For istance, I have two fields, one is text field that contains a value from the value list, and other is a calc field counting the occurences of the text field entry. When the calc field hits 10 I want to remove the value of the text field from the value list. Any ideas? Thanks, r

New at this so please bear with me. I am designing a database for work and need to recall data into one layout from another. e.g. In Quotes Iayout I have: Room A, 4.5m length, 5.0m width, 3.0m height Room B, 7.2m length, 5.0m width, 3.6m height etc, etc. In Accounts layout I wish to recall all the relevant data just by typing in say Room A and having all the dimensions displayed automaticaly. Any guidance would be greatly appreciated Thanks Rax

Hi everyone! Just a quick formatting question... I'm not sure if this is even possible. I have a pop-up list containing about 20 items. When the list pops up, it only shows around 10 items in the window -- the rest you must access with the scroll bar. Is there anyway to change the size of the actual pop-up list so it shows all the possible values? Any help would be much appreciated! :

What is the easist way to validate a field by makeing sure it is not in a value list. I have a field "Fruit" and need to make sure that the entered value is not in my value list "Forbidden Fruit" I tried to use validate by calculation, some thing like "Fruit" ≠ "Forbidden Fruit" but cant figure out how to use a value list in a calculation field.

Simple database. Tables Customers Jobs Orders Staff I have two customers in this sample database. Related to the Jobs table with League ID. On the Jobs table, I want to select the "League Name" which is the Customer's Business Name for practical purposes. I set up a Value List based on fields, with a drop down box - selecting the League ID & League Name and enabled the "return second value only" which in my case is the League Name. When I select one of the League Names, it was returning League ID instead. And, in the Customer's table, it was editing the League Name to the League ID. Now, I can't even get the drop down box to show. …

I know it's possible but I can't find it yet !! I looking for the option, maybe plugin, for a autocomplete (Microsoft description) on a field in V8.5 Adv.

Hi, First off, this is for an IWP solution... Here's the problem. I have a user defined "Find" script in which the user is first taken to a layout to set the date range in a couple of Global fields. (Thank you to Stuart, Mr. Vodka and many others for that help!) Then the user advances to the next layout, the search criteria window. (this allows the setField to calc the date range and plug it into the date to search window.) After plugging in the rest of the search criteria the user clicks the "find" button and advances to the list view with the found record set. Everything is beautiful, BUT! If the user plugs in an invalid date such as 11/3…

Hi, I am looking for a calculation which can create a value list from a found set or a relation, which I can use for a input of xmCHART. Example Record 1 Flied data = [12 ] Record 2 Flied data = [9 ] Record 3 Flied data = [17,8] Record 4 Flied data = [0 ] Calculation flied = [12 9 17,8 0] [color:red]I want to use it to draw a graph without triggering a script!

Hi Everyone, I am new here, so I searched a ways back in the archive but did not find a post explicitly about my question. If this has been covered in previous posts, I apologize and humbly ask for direction to that post. Anyway, my problem is that I have a checkbox set populated by a value list, and what I am wanting to do is tally up--across all my records--how many times each checkbox was checked. Specifically, I consult with clients about many topics in a given conversation, and I have a checkbox for each of those topics. I am trying to generate a report that shows how many times in a given year I discussed topic 1, how many times I discussed topic 2 …

Hi, I'm having trouble trying to figure out how to jump to records via a pull down menu. For example, if I had a database of records each containing a first name field and a last name field. I would like a pull down menu where you see a list of all the last names, and when you select a last name from that pull down menu, you are taken to the record containing that last name. I've included a basic demo file hoping someone could help out and tweak it so it does what I want. I can get the pull down list to show the names, it just doesn't do anything. Can anybody please help me figure out how to make it work? PullDownNav.zip

I have incorporated Filemaker Magazine's technique for creating a dynamic value list into my database. If you look at my file: www.jarrodprice.myhomeserver.com/sampledb.fp7 in the first layout called Web Interface, you can select from my dynamic value list which was built with the Categories_me table. This technique appears to require that every field has a unique name. This does not make sense. Every field has its own id, but the way it is set up, it doesnt work. To recreate the problem: If you select bracelet > bangle > amethyst the database uses the first instance of the category name amethyst in the database, rather then the correct on…

I can generate a value list of ID numbers already in use, and validate from it to verify that an ID number is in use. Is there any way to use the same list to generate an Id number that is _NOT_ in use? Alternately, is there any way to make a value list of numbers NOT in another value list, or in a specific field in a multi-record DB?

I am trying to figure out how to handle this problem, and I am sure the experts on here know the answer. I have a layout that has a value list to select the employee. The value list shows related values based on a table that filters out employees that are not mine. So when a Supervisor goes to the layout and makes a record, when he selects an employee, only his show up. The Supervisor may have 13 employees, but if i didn't do this, all 350 would show up in the pop-up list. If I am looking at one of the records and duplicate it, then go change who the employee is, I see only my employees. When I click on new record, which is what I would really want to do, I g…

I have used the infininate assignments example from filemakermagazine to create a 5 level dynamic value list. In the sample filemakermagazine uses a portal to select from that list. I am hoping to show the parent list items in 1 window, and show the children for each subsequent level in its own value list display. Hence, for a five level list like mine, there should be five windows, each one showing the available selections based on the parent. Here is my sample: www.jarrodprice.myhomeserver.com/sample.fp7 Please feel free to make any changes to the file

I'm trying to populate a drop-down list with one field based on the value of another field (both fields contained in the same table). I have a table, contacts, containing: contactID isFacilitator The isFacilitator is a yes/no dropdown box for data entry. In another table, I need to enter facilitator information. I'd like to populate a drop-down value list there with the contactID of all the records where isFacilitator equals yes. This seems like it should be pretty easy, but my googling and searching here doesn't seem to help me much. I'm a total noob to FMP, which probably explains why what I'm finding seems far too complicated. What's the ba…

I have checked all over this website and i cannot see to find the answer to my question. I use Version 6 and i have made a few databases with relationships and all. i have: Orders Customers UPS Now what i want to do is in the UPS database is make a dropdown value list that populates based on another dropdown list. (confused???) read on: in UPS Database i click on CustomerNAme and my Values are a lookedup value from the Customers Database. THis works fine but what i want to do is populate the P.O.Number Dropdown list with only the values that are associated with the CustomerName that i picked. example: in UPS Database i Click the Custome…

I need to create a series of fields with value lists similar to this: Field 1 uses value list: Vegetables, Fruits, Meats. Field 2 uses value list: tomatoes, corn, apples, grapes, beef, chicken. Field 3 uses value list: Beefsteak, Cherry Tomatoes, Corn on cob, kernel, red delicious, granny smith, red grapes, green grapes, steak, roast, whole chicken, fryer parts. Now here's the tricky part (well tricky for me - that's why I'm here). After I choose say Fruits from the first value list, I want ONLY choices applicable to fruit to appear in the next value list, in this case APPLES, GRAPES. Then when I choose one of those, say Apples, I want ONLY the following to appea…

Hi all Is there a way to attach a calendar to a date field and have the calendar popup when the user enter the date field and the user then can pick the date from the calendar. Can this be done by Filemaker or is there a add-on that can do this. Thanks for all the help in the pass and in the future. Lionel

SHORT DESCRIPTION OF PROBLEM: How do I keep the "second value" in a value list from disappearing if the relationship between the two tables is no longer valid? LONGER DESCRIPTION: I have two tables: PRODUCTS and SEASONS. Every product is assigned a season via a value list, and the season ID is the match field that links the two tables. The value list is defined to show only the "second value", which is the friendlier season name. Users can "close" seasons on seasons pages, meaning that the seasons have passed and will never be chosen for new products. I want a closed season to not be available in dropdown lists to keep the list from growing ever longer as years …

I have an invoicing database that pulls pricing information from another table. We have multiple prices for the same items depending on different criteria. What I have done is create a table that holds pricing information and this table has multiple entries for each item depending on how many different price options there are. Works fine except for one picky detail....I find that when I'm doing data entry I prefer to use all keyboard shortcuts and not use the mouse....when I tab into the dropdown list and hit the down arrow key to select a price, it selects the second value in the list not the first one. This behavior is not what I would expect and actually causes the…

I have two tables... Schools List Courses/teachers I check if the ID of the school matches the ID with the course/teacher. From there I print out reports to each school showing the complete list of what courses each teacher is going to using portals. No problems. But... The last report I did was four pages for each school, on page three I needed to show all of the teachers in the school not just ones which were allocated courses. Also since some teachers are in the system more than once becuase they are going to more than one course I needed only unique values. So I used ValueListItems (Get(FileName); "Value List") from the schools table to index the field. …

I have a value list on the current table that has become too large, so I have transferred the list to a separate table with each item being an individual record. I have set up a relationship between the two tables and a drop-down list that can access this table. My problem is that I wish to retain the existing data from that value list for the current records but be able to utilize the new method for new records and perhaps even change previous ones. Unfortunately changing the field drop-down list from the old value list to the new one causes the old data to disappear.

Hello... I have got a problem with value lists. I have got: value list with dates (for example - 13/11/2006, 20/11/2006 etc.) contain 3 years field where show this value list (open through drop down menu) and i want to view on drop down menu only values included for example 1 month in past and 2 weeks in future.. how can i do this?

I am coming from the world of MySQL & PHP and am a relative new-comer to FileMaker. The company I am now with uses FileMaker Pro 8.5. I have searched the forum(s) for a solution to a problem I have regarding value-lists but can’t find one. (Here’s my problem) I have a Company Information layout page with the following fields: “Company Name”, “Address”, “City”, “State”, “Phone”, etc… I also have a Checkbox Set (defined as “Contact Type”) with the following choices available: “Client” “Consultant” “Personal” “Prospect” “Other” I have defined value lists according to these Contact Types. When a “check-box” is marked and the record has …

Hi, I am new to FM7-8.5 (have been working on FM6 for years, but I am updating my knowledge now). I have been struggling with value lists. I would like to create a table that holds all my value lists, for my whole solution (one file). In any specific table, I would like to be able to have any field formatted as drop down (or whatever) to show only the list of values that are pertinent for that field. For instance: Table1 ID Field1 - Colors (drop-down) must show only Colors coming from Table2. Table2 ID Data (Colors, Models, Makers, etc.) Data_Code (all colors would have the same code, all models will have the same code, etc.) I un…

Hi, I'm using a split filemaker application: - GUI (layouts, reports etc) stored in one FMP file running on a client computer. - Data stored in another FMP file running on a FM Server. I've got 2 ways to define a Value List (to show the value of a field in a table) 1. On the client: "Using Values from Field" (pointing thus to a field in a table stored on the server FMP file) or 2. On the server: define a value list #1 "Using Values from Field" AND on the client: define a value list #2 pointing to that one on the server ("Use value list from another file"). I'm wondering what is the best option in terms of display speed. It all depend…

Hi, I am looking for a calculation which can change the text colour in my value list. I only have three possible text drop down options to choose from: If user selects "optionA" from the drop down,then font colour will be red, if he selects "optionB" then the font colour will be blue etc.... I have tried to use the case function in my auto enter calculated value, but no success. Any help gratefully received. Simon.

Hi I just found something strange today. In FM6 if you created a value list using values from a related file's fields with 'Also Display value from' the second field, and then when you use a popup menu, when you selected a value, ONLY the first field's value is displayed. However in FM8 once selected, it displays BOTH field 1 and field 2. In other words, lets say you have two fields that you select to be your value list. The first field is a person initials and the other one is the name. Okay if there are two names of Donald Duck and Mickey Mouse the popup list itself will display as DD Donald Duck MM Mickey Mouse So in FM6 once you select the first choi…

What types of things should I take into account when deciding between hard coding the values for a value list versus creating an actual table that holds the values that I want to populate the value list with? What are the performace issues? Also, how will one choice over the other effect my ability to sort in particular orders based on the contents of the field? I'm on 5.5 if that makes a difference. Thanks!

I have just to ask if there is a way to create automatically fields depending on a list values. Explain further: To create a layout with fields depending on a list values. Pascal

Hi all, For some months I've been using two filemakerdatabases to generate html-code. Everything was working fine until the line of code became too long. I use a portal to get the data from another database. Using a valuelist I combined the related portalrows in a textfield. What happens now is that when the line gets too long it gets cutoff in this last step. The files can be found at: http://www.worldtravellinks.com/Countries.fp5 http://www.worldtravellinks.com/Hotels.fp5 In the first record of Hotel.fp5 I put more text in the field 'Hotel'. It results in cutoff text in Countries.fp5 in de first record. Hope someone can help, Peter ps I'm…

Hi. Don't get up. I have a questionnaire (in FM8) that has about 30 questions in it with each question assigned the same radio button'd value list (named Choice) in the same table (named Audit) "YES" = 3 pts.; "NO" = 1 pt., and "N/A" = 0 pts. Some of the questions are grouped together by subject so let's examine the simplest one: Training, which has only two questions which will be subtotaled. So, if the first question is answered "YES" (3 pts.) and the second questioned is answered "NO" (1 pt.), the Subtotal will be--you guessed it--4. Here's the calc I've come up with for the Subtotal field: Sum ( If (Twelve_Month_Training_Module = "N/A";0)& If (T…

I've been struggling with trying to figure out how to do relational value lists in FM8.5, as I'm used to FM6. I made a severely stripped down example version to show you what I'm trying to do. There are 4 tables. fsp_members client_master - master list of all the clients constellation_join - a join table of all the clients and their case involvement (clients can be involved in many cases) constellation_join_relationship - a list of relationships for each fsp member It's pretty simple what I want. The left portal (layout fsp_members) is where the relationships are listed (relationship field, and relationship to whom i.e. brother - sam, father - …

Hi all, Please could someone help me out with this. TABLE1 has 16 fields. TABLE2 has 9 fields. In the 9 fields in TABLE2 I would like a value list which contains the data in each of the 16 fields in TABLE1. So for example, record 1 will contain a persons name in each of the 16 fields in TABLE1. It also has a key field called serial number. TABLE2 is related by the serial number field Now each of the 9 fields in this table should have a value list which contains the 16 names from each of the fields in TABLE1 Is this possible at all? Many thanks in advance for your help.

Here's my dilema - I have two tables - tableOne with fields to populate several value lists, and tableTwo for tracking details that use those value lists for various fields (a little confusing, I hope it makes sense). So I go through records in tableTwo and populate fields using the value lists (from tableOne). What I want to be able to do, is identify any field entries that are not pulled directly from a value list. Value list built from tableOne would be something like, 1, 2, 3, and 4. FieldA in tableTwo would use that value list. If I enter 5, in tableTwo::FieldA, I want that entry to be easily identified. I know I can create a container field with a c…

is there anyway to make a value list that when you have more then once instance of it per record only show not previous selected items. such as if i had a value list that showed 1 2 3 4 5 and in the first box i selected 2 the next one would only show 1 3 4 5 ?:)

Hi all, ******* you people are great!! I now think i have a handle on this Conditional value list thing. Its a big moment for me. I have attached the example i made and it works BUT..... I was wondering if there was a way to incorporate "all" as a selection in any point in the hierarchy and it is restrictive down only until all is selected. OR better yet just have the value list blank to do the same thing. For example I have Measurement standard Country Manufacturer Size Type Model If i wanted to select the standard and country and the manufacturer but i wanted to see all the sizes types and models. could be useful …

Hi all, I am now trying to do a conditional value list for my product catalog. I have a table called measurement standards so you can switch between metric and US standards and i want to create a conditional value list based off which is selected with my packaging table. Now i have tried to disect every ******* demonstration file on here and I have watched John Mark Osbornes Videos over and over and iam just not getting it. I want to know why people are using global fields and what are they doing? I would like to know how table occurances relate to the global fields and finally i would like someone to explain to me if the join table i have created is o…

Here is what I was doing lets see if anyone can help. First I created 4 value lists in File 1 (logicFile) Second in File 2 I created 4 values lists using the exact same names as the lists in the other file that pointed to the original lists Third I wanted to add another list in File 1 so I went into the define Value List and selected one that had a similar name to the one I was going to create hit Duplicate and then I lost all my lists Now the value list screen in both files shows blank lines File 1 has 5 lists and file 2 has 4 blank lines where the lists were. My speculation is that when I duplicated the Value List for some reason it may have keept …

How to create a list value based on two tables ? Let’s consider the case with 2 tables. The table Session : Pk_ID_Session DateSession HourStartSession HourEnd Fk_ID_ScheduleClass … and the 2 table: pk_ID_ScheduleClass DateClass HourStartClass HourEndClass … Now, I would like to create a value list where: Session::DateClass = ScheduleClass::DateSession AND Session::HourStartClass = ScheduleClass::HourStartSession Can you help how to do this ? Thank you

Hello, here is my problem: I am building database of our employees. Each record (person) has also checkbox field based on Value List, where I select some status (Contract signed, Can use company cars... etc.). Then I would like to be able to easy check status off all employees. So I created layout, one line = one person. What I would like to do, is to have all checkboxes for that person in one line. That's possible to do, but i don't want there the checkboxes value to be shown. I just would like to have only the checkboxes, not the text. I know, I can create some calculation, but the problem is, that value list is changing sometime by Edit displayed in Value…

There are a number of fields in our database that are check box style value lists. When clicking the mouse on any one of these check boxes, we get this message: " 'Name of field' is defined to contain only specific values. You must enter a valid value." After you hit okay, it puts an "X" in the check box (as it should). Can someone tell me how to get rid of this unnecessary message? Thank you!

I'm working on a database of cars. I have one database called CARS. It contains the fields CAR_ID, YEAR, MAKE and MODEL. I have another database called ENGINES. It contains the fields ENGINE_ID and ENGINE SIZE. And my final database is CARS_ENGINES. It has the fields CAR_ID and ENGINE_ID. I have a join from CAR_ID to CARS_ENGINES_ID and one from ENGINES.ENGINE_ID to CARS_ENGINES.ENGINE_ID. My database CARS_ENGINES has all the combinations of the models and engines. The problem I'm having is how do I set up my main database to do the following: I want to be able to have the fields YEAR, MAKE, MODEL and ENGINE. When I click on YEAR a list of all Years in the database a…

I have been searching for a method to let my users alphabetically sort a value list. Finally It occured to me ! You can creat a field and have the field be set to the value of ValueListItems ( fileName ; valueList ) of that value list and then use that field's content as a value list. Or an easier way is to set up a table and have only one record in that table, and keep a field for every Value list. Then make valuelists using the content of the new table's fields which will be automatically sorted. I hope this helps. Xoomaster.

I have a dynamic value list that's used in a drop-down list with auto-complete. My problem is that the auto-complete only works for the first 318 or so items. Anything after than and no auto-complete, even though the item is in the drop-down list. Any ideas? Thanks