Value Lists

I have a Table Titled "Job Ticket" I have a Table titled "Delivery Ticket" I have a table sitled "customer information" In the Delivery Ticket Table / Layout, I want to enter the "job ticket" record number into a field, and then have related information off that same "job ticket" fill 3 other fields. for Instance, I enter in the record number in field A in my "delivery ticket." That triggers field B, C and D to automatically fill with information off that same ticket. 1 more time: I enter the record number, the desciption, customer PO price automatically fill in on 3 other fields.

Hi all I have been reading comments blog (http://fmforums.com/forum/userpage.php?uid/21152/) on conditional value lists and find it extremely usefull. All though I dont understand all of the theory behind it I have managed to replicate the 3-tiered valuelist example and the 2-tiered with selfclearing into my own db. My question is now: Can anyone tell/show me how to make a 4-tiered with selfclearing - or is there a maximum of conditional valuelists? (one thing is replicating another thing is inventing ) Thanks in advance Regards Lasse

Hi everyone! Great forum, I've been going through trying to see if someone else had my problem and I've enjoyed a lot of posted samples of databases to nose around in to help get you through. Learning a lot, and at the risk of nerding out on my first post, that's very cool.. -) OK, here's my situation. (If there's a link to this, please post it as I've looked around a lot over the last couple days and can't seem to find it.) Business has multiple 'Skills' they offer and a 'Rate' for those skills. Setting up a Checkbox so for each record you can choose multiple 'Skills'. I was hoping after the checkbox is filled to create a button which auto-fills out multip…

Hi all I have a "calendar" table which includes a date field (there is an entry for every date in a year) It also includes various calculation fields relating to that that date. One of the calc fields is a Short month/year field - ie so that 1/10/2009 would be "Oct 2009" (as would 2/10/2009) I have a conditional value list of the short month names year field (based on going back a calendar year from todays date) BUT because the short month name/year field is a text field it sorts alpha - I would like it to sort in month order and must confess to being a bit stumped I have tried sorting the relationship but that didnt make any difference …

FileMaker Pro v6 I have a list of around 7000 names which I want to place into a drop down list which then lookups up a related account code. I have found that a value list is limited to a maximum number of charachters which is far less than the proposed names list. Is there any workaround.

I'm not sure if this is the right place to be asking this question, but as far as I can manage to figure my problem out, I think I must need to leverage Value Lists. I am doing a genealogy one name study which is source/event based. I know that genealogy dtabases are the deep end, but have managed to work something out to my satisfaction so far. However, I am stuck when I come to sort and finding - I want the database to know that John, Johannes, Jo:, Jhon, Jonothan etc are all exactly the same name. And the same goes for surnames, placenames, counties, occupations, titles etc. I can see how I can make a "Normalise" table create itself, where I am asked f…

I use FMP 8 Advanced. I want to incorporate text and a picture in a Values List. Is this possible and if so how to do it? Or is there an alternative solution? I use this in a template that prints envelopes. Sometimes the company logo needs to go on the envelope and sometimes the name of a person that is in the Values List. Thanks.

Hi all I have a table called PRODUCTS which contains all of our products the following fields: Type_of_customer: (young, senior, work camp, etc.) Destination: (USA, Italy, El Salvador, etc.) ArrivalDate: (ex. 12-09-2009, 09-10-2009) There a few type of customers, more destinations and plenty of arrival dates. I want to relate this table (PRODUCTS) to another table called CUSTOMERS by using 'type_of_customer' as relation. My question is how to make dynamic valuelists in table CUSTOMER where: 'type_of_customer' limits the choices of 'Destination'. And the 'type_of_customer' combined with 'Destination' limits the choices of 'ArrivalDate' i…

HI i want to know that when i am creating a value list using relationship from another table then what is the use of "include only related values starting from" in this drop down table names are lying.plz tell me what's the use of this option. i m really confused on that part.

I'm hoping to improve an interface issue I'm running up against. I've created a portal which shows a checkbox list with a global filter. What I can't seem to do is to make the checkboxes go away completely. Pardon the dopey sample file, but what it is designed to do is: allow the user to select which colors of fruits are to be described in a given bowl from a checkbox list (global value) -> choose what size of fruit we want to describe first -> choose the color of that fruit -> choose one or more fruits that fit the description. If there are no fruits that fit the description, I get the response. With conditional formatting, I am able to make a c…

How do I reference a selected check box item in a calculation? For instance, I have a value list with two items, one is "linked" the other is "master" I have another field that I would like to perform a calculation if master is checked, and if only linked is checked, then put in a looked up value. This is probably easy to do, but I can't seem to figure it out. Thanks Darron

I need to create a valueslist that combines the Year field from 2 tables. Financial contains Expense and Income records and Invoice contains Invoice records. Both tables use a transaction date. I have a "Year plus All" defined in both tables, but I need to have a values list that will include the years from both tables. For example, I could have invoices for 2009, but no expenses or income entered and maybe expenses for 2008, but no invoices. I would need both 2008 & 2009 in the valueslist. Thanks.

I have two related drop-down menus. My selection in the first menu affects what I see in the second. Produce Type (fruit, vegetable) Produce Kind (apple, pear, carrot, celery) For example, if I choose "fruit" in the first drop-down, my choices in the second drop-down are apple and pear, so I choose one of those, say, apple. Problem is, I can go back up to the first drop-down list and change my selection to vegetable. Now I've got "vegetable" as a produce type, and "apple" as a produce kind. How can I ensure that if the user changes a selection in the first drop-down, the contents of the second drop-down field are cleared so I'm forced to make another…

I would like to know if its possible to create a value list based on the selections made in a check box set, basically it would be a filtered value list eg Field Colour, as checkbox, from valuelist showing 4 colors (red,blue,green,Black) Red x Blue Green x Black I have ticked Red and Green, so for this record I would like a value list just showing red and green My thinking is this should be easy, but i think i may be losing it.

OK, here's my dilemma: I have a Field called "Message" in which I'd like to create 2 drop-down Value List choices: In each message I'd like to have a signature that includes the name address and phone number of sender. How do I get these messages to look like a "letter"? When I hit "return" during the creation of the value list, then I get all separate items in my drop down. Please help!!!!

Hi forum! This must be so easy it must be a no brainer...but Ive now spent 2 hours trying to do it to no avail. I have one Table like this with two fields sortorder and menutext like this 1 -nothing selected- 2 zzz Entry 3 aaa Entry 4 ddd Entry I want to make a value list from the text items, but one that shows in exactly the order above. I need the table so I can add in new menu items easily so I cannot use a straight "fixed value list". I want my Value List to display like this when I click on my field: -nothing selected- zzz Entry aaa Entry ddd Entry it however displays: -nothing selected- aaa Entry ddd E…

I have catalog of people, each person with a unique ID. The related child table has a field that lists individual physical characteristics for each person (one to many relationship, e.g.: ID#001 has blue eyes, brown hair, tattoo, etc.). Is there a way to have the child field display as check boxes in the parent layout so for each ID I can see all individual characteristics checked off? This would be helpful for searching for a particular person by simpling checking off those characteristics to help find an individual. I know I can create a value list and manually go through each ID and check the appropriate boxes but the database is too large.

Hello, I'm trying to follow the guidelines to create a separate file for the UI layer. But I don't know how I should implement the valuelists: I have a table with projects and a table with project statuses. Some of the statuses are marked active. Now I need a valuelist of the projects with statuses defined as active. In the separate UI file, I reference to the projects database, define a relation between the projects and statuses. I've created a table in the UI file (Active projects) with one global field 'active' and define a relationship with Project_status. Now I would like to have a valuelist with the active projects in it. But when I …

Long story short, I have to export data from a related table into a field I can then merge into a word document. Table B - Child Table I concatenate a number of fields together to form one field "display" Table A - Main Table I create a value list of all related items in Table B. In a field I then have Substitute(ValueListItems (Get ( FileName ) ; "DisbursementDescription" ); "¶"; "%|%") This works great. EXCEPT It will de-duplicate which I don't want. It has to include ALL related values irrespective of if the concatenanted data appears more than once in Table B. (as an example of the sort of data being concatenanted.. 12…

Is there a simple way to display PDF file contents in container fields without first exporting the field?

I have a table with people which can be active or inactive. I managed to populate a value list of the active people using a self-join on a global field set to "active". I need to reuse this value list in other files, multiple times. Is it correct that the value list remains empty unless I recreate the self-join relationship in every file I need to use the value list? Thank you for your feedback!

Hello. I have a largish (30k record) database. One of the fields is an Edit Box set to auto-complete with previously entered values. I'd like to be able to make this a popup list, if possible. My concerns are: 1) optimally, I'd like to be able to retrieve the autocomplete list and populate the value list with it. Possible? 2) I'm concerned about what might happen to the existing records. Not all 30k records are populated in that field (I'm adding information to existing records as I get it). More importantly, I don't want those fields already filled to get messed up by fiddling with the setup. Will I basically have to create a near-duplicate of this field …

I have a list of occupations that I need to be able to select one of. By selecting the occupation it defines a rate that I use to calculate insurance premiums. In the past I have put this rate in a global table so that it can be accessed from client files. In the past this rate was manually changed from time to time. (ie: not governed by an occupation selected on a list.) This time I want the rate to change automatically according to the occupation that is selected. The list could be in a global table which I can access from the client file to set up the rate, but I really dont want the person accessing the client side of the database to have access to the …

I have a drop-down list which users can edit and enter more values but I want to limit them to entering no more than 6 different values. Is there anyway I can limit the value list to having a maximum of 6 seperate values. I want to do this so that if users want to enter more than 6 values then they can pay for a slightly higher priced edition of the database. Any help is very welcome, sorry if I didn't explain very clearly.

I am looking to make a report to count the number of items in a given value list. For example, for each record I need to select a "Problem Classification" from my Problem Classification value list. At the end of each week, I need to generate a report for: a) showing the total number of each problem type selected, defined in the value list for all records showing the total number of each problem type selected, defined in the value list for that given week. I am VERY new to FileMaker (running version 6), can someone please be very specific and help me out?

Hi everyone, I've searched and searched the forums but can't find a solution to my problem even though it's probably fairly simple. I'm trying to add students to a roster (I choose the class, then want to choose the students to add to it). I've figured out how to create a value list that populates the foreign key but it takes too long to find each student (there are about 4500 students). I'm doing it on a "Roster" layout based on that table. Anyone have a solution? I've attached a picture of the relationship diagram. Thanks so much!

i would like to ask if the ff. is possible in filemaker and how to implement it. i have a database with a field called "degrees" to show degrees earned by the person. it's possible that a person have more than 1 degree. i want that to fill this field, the user will be presented with a window with a list of all possible degrees i define, in some sort of checkbox set, check the degrees applicable and in the end fill the "degrees" field with values separated by commas. thank you

I have a value list called "Pricelist". I have a popup showing the value list so that I can select an item. Now I want a script trigger that after someone selects a current category, only the items from this category will be displayed. If I go into the value list editor, I can select "show only related items, …) and this works fine but of course I want to do this in a script step, so that when there is no category selected, it will display all items (if I do this now, it won't display anything based on the relationship).

Hi All, I don't know if it is possible but I would like to generate a value list based on a field (Jobs::sets) with a number. If the number is 5 for example, I would like to be able to have a drop down list of numbers 0 - 5 as well as a selection for all. So it might look something like this: -All- 1 2 3 4 5 Any help is greatly appreciated

Hello, I'm trying to build a type of user permission system which will restrict access to specific records and activities (such as exporting data, emailing customers, etc) When a new user is detected in my database currently, it creates a record in a table called "User_Preferences" and stores the Get(AccountName) to the field called Username As training for my assistant, I assigned him the task of creating a new table for personnel records to keep track of employee contact information. I want to link these two together with a field in the personnel table called r_username Is there a way to build the value list so only users in the User_Preferences tabl…

Its an OrderEntry thing// I have a parent ORDER, with 1 child ORDERITEMS that gets its info from 2 child INVENTORY file All the items in my ORderItem file accrue so I can run reports of Posted items When operator checks out buyer, they select MAIN Description using list.. then they select the 2nd List or 'thePackage' ..Now, its depending on package to find the cost and stuffing it to Cost field.. Operator finishes then enters the QTY and it subtotals Can't figure for life of me.... how to get COST field to fill in when selecting the Package?? My sample attached code uses a zippscript to in the Package field and trigger that says "H…

Hi All, Is it possible to define a value list which displays one value such as 1, but stores a different value such as Yes? Thanks for any help. A

I am trying to automatically filter out items in a valueslist once a value is selected. Table 1: Animals Field: Herd_ID Field: Name ValuesList = Name from Animals table Table 2: Group Field: Herd_ID Group uses the Names list from Animals to select animals for a selected Group. When a name is selected from the list, the related Animals::Herd_ID is stored in the Group::Herd_ID field. Is there a way to filter out that selected animal from the Names list, so the user cannot select the same animal again? For example: Name List display (1st time): Adam Betty Carl David User selects Carl. New Name Lis display: Adam …

Hi, I'm trying to remove a list of items from a given value list. I tried using some custom functions like AddRemove etc but they only accept single values to remove. Can anyone help me to make a function to produce this? listOfValues = "GSX¶TZR¶CBR¶YZF¶FZR¶CBF" listToRemove ="TZR¶FZR" RemoveListFromList(listOfValues;listToRemove)= "GSX¶CBR¶YZF¶CBF"

Hello all I am very new to Filemaker, had it a few days. I have been tasked with creating a Data Capturing interface for a Film Shoot. I have managed to create it the data capture interface successfully. Yet now that it is up and running I have a problem. I am approx. 300 records/Entries in and I noticed that my FM file size was over 100MB. This is because when I have been inserting an image I have not been ticking the “Store only a reference file” in the “insert file” interface. So my question is twofold: 1) Can I turn my stored images into reference images with having to re-insert them 2) Can I make a global rule that it will by default it will ins…

Hi What I'd like to do with Filemaker is this: Instead of using several tables for static values, I'd like to use one central table. 1) I have a table which is named "codetable" with the fields "id", "domain", "value", "text", "language" This table contains different values, which are usually used for valuelists. For example for a salutation field on my address layout the codetable would have values like "1", "salutation", "1", "Mr.", "1" "2", "salutation", "2", "Mrs.", "1" If I had a status field on the same layout, I'd like to use a valuelist which takes the corresponding values from the codetable "3", "addressstatus", "1", "active", "1" "4"…

I searched the values list forum, but could not find this problem mentioned... I have a simple custom value list with 2 items: Process Now Schedule for Future When I select Radio Button to display the list, it truncates the values. I tried different fonts and font sizes and even reversed the order. I tried a horizontal and vertical display and made sure the field is large enough to fit the full value. If I add several spaces to the end of each value, it will display the values. If I add 1 space to the end of each, then it displays Process Schedule I am running on MAC, FMP 10. Anyone have this problem??

I have a table Subjects containing a list of unique values in field SubjectName. This field serves as a the value list for populating a field SubjN in a second table Articles, which is related to Subjects. My problem is that when I make changes to the values in SubjectName, the corresponding contents in SubjN do not refresh. Is there an automatic way to refresh them? There is a different field in Articles that populates automatically depending on the key that relates Articles to Subjects, so I have used only a value list for SubjN. Thanks for your suggestions.

I'm creating a database for registration purposes at a school. Students of board members are automatically placed into their first choice classes, then teacher's children are given priority, then others. If enrollment for a class goes beyond its max limit, I want Filemaker Pro to randomly select from students whose "first choice" field contains each class name. I currently have "first choice, hour 1", "first choice, hour 2", etc. on one layout. So here are my questions: 1) I will be creating a layout with fields for each class (ex: "hula") and want lists to be automatically generated with the names of kids whose first choice is in each of those classes. How is thi…

First, the background. I'm the registrar for a "Monday School" for homeschooled children. Our organization offers about 6 classes every hour for 5 hours. I have 5 value lists, one for each hour, that lists the classes offered that hour. On my first layout, I have general student information (first, last, address, phone, emergency contact) AND the classes they've signed up for (I just set up radio button lists in fields called "Hour 1 signup", "Hour 2 signup", and so on, each of which contain the respective value list, so I can click on the classes they want). NOW: In my second layout, I have a field called "Class Name Hour 1" and a second called "Class Count Hour 1",…

Hi everyone. I am looking for some ideas on how to solve 2 problems with a dropdown list. I have a layout with the customer records on it. I want to have a dropdown list that shows status. So the dropdown list will show active, inactive or all customers. My questions are: 1) What field do I use on the dropdown? I cant use the status field can I? I dont want it to update the records just to filter them. 2) How to I handle the All filter? There isn't a status for All in the table. I was thinking about an IF statement in the script to show all if dropdown = All. Any help is appreciated. Thank you Jeff

I really don't know how to write this down, but anyway I hope someone could decrypt my text­. First, let say I want to create a house building database. - Houses table, which are the houses to build. - Components table, which contains all the stuff such as windows type, roofing, doors, etc. where each record holds the standard pricing for each component. - Categories table, which is the components categories. - There are all the tables that links the houses table with the components. (selectedWindows, selectedRoofing, selectedDoors, ...) So here are my relationships By nbourre As you can see, there are multiple occurrences for components. …

Hi, I am using a EXTERNAL time sheet filemaker db to track my employee time which is related to my employees via id_employee, which is a serial num auto-created. Using a pop down list, i relate my employees (id & full name) to records in other DBs, allowing me to pull up info. This works with my "sales" sheet in the same db as my employees, however it seems not work properly with my time sheet. Since deleting several test employees and starting with a new list, the drop down continues to be populated with old employees (that are now deleted) and NOT the new ones. Does anyone have any idea why this would happen, why my value list is not refreshing in an exter…

I have a personal inventory database, and have a value list "vendor" attached to the vendor field. I pop it up and create a new entry any time I have a new vendor whom I think I might use again (for speed and accuracy of entry). But if I buy something from a vendor I doubt I'll ever purchase from again, I enter the name ad hoc (I don't enter it in the value list). Is there any best practice on this sort of thing? thanks Ken

Hi, I am using Filemaker Pro v.9 Advanced. I have database I need to get done and am having a hard time with the relations for a conditional value list. It is based off of the Issue Tacking sample that comes with the software. So what I have done is created some tables. There is the issue traking. Then I created a Company table, Address Table and a Contact Table. What I am trying to do is if a company is entered and it is already in the list it can be chosen. That works fine. But each company could have multiple Addresses and some are overseas. So in the Address Table I have these fields: Company, Attention, Address, Address2, City, State, Zip, Country, and Contact. …

Hi I have a table that has 4 fields in it that I need to display in a value list. Field1. Primary Key of the table Field2. Title Name Field3. Location Name Field4. Foreign Key I created a calculation field in the table which joins all the 4 fields. Calc field = field 2&"*"&field 3&"*"&field1&"*"&field2.I put Title Name as the first field in the calculation field since I want the calculated field to sort on Title Name. Then I created a value list which would display this calculated field. Problem is the value list displays a lot of garbage first and then displays the good values. This garbage data is not present in the tab…

Hi. I maintain an international directory. It presents a pull down list of every country represented in the data (which gets updated every week). Once a user picks a country, the next field lets him select from a pull down list of states in the selected country. Likewise for a city in the selected state. My problem is that in addition to the country list being made up of those dynamically found in a field, I also have two fixed choices - one of these I want to appear at the top of the list and the other at the bottom. Therefore my list is a combination of dynamic and fixed. I've set this up as a canned list and rely on someone to tell me when a country needs to …

: I have a large customer database of over 3,000 records. I am trying to change the showroom field from DW to JA. Is there a way to edit this all at once. instead of having to go in each record to make the change. The field is a drop down list from a table . How do I change them all at once. I can not access the table where its pulling the values from. The edit button is grayed out under tables. Please help asap. thanks.

Hi All, I am looking for some suggestions on how to work around the following: I have a table and layout for Jobs. Each job is assigned to certain employees, which is done with a popup menu in a portal that shows records from a join table between the employees table and jobs table. The portal is set to allow creation of records. Assigning an employee is a simple matter of clicking the field and selecting the name from the popup which creates a record in the join table. The popup is based on the employee ID and employee name, showing only the name. So it shows the employee names but populates the employee ID as a foriegn key. Now the old familiar issue. I have fi…

Sorry im still new here, now sure whether these questions are at the rite place.. just trying my luck.. Q1 : I was wondering is there any script that enable me to edit value list with a click of a button in browse mode? Other than the "Edit..." function.. Q2 : When we convert our filemaker file to php, how do we edit our value list? Will the "Edit..." still appear at the bottom of the value list and pop up a window for us to edit it?

Hi, I have several related value lists in my database. When I create a new record, these value lists work fine. However, when I enter find mode, the related value lists not longer work --- the only option is ''No values defined''. Does anyone know why? Thanks.

Is there a way to have a value list show (2) two fields together. Right now I have the option selected to use second field -- this only shows one field after selection is made. I need some way to show to fields in same cell after selection is made.

I have a portal where I'm building a list of parts and quantities for a model. The parts I want in my valuelist is a subset of all the parts: I just want the parts that are assemblies. assemblies have a value of 1 in the isAssembly calculated field of the part. How do I get just the assemblies? Do I somehow join the part table to itself or : I have searched on conditional valuelists and have not discovered an appropriate solution. Thanks much for any pointers.

Hiya Gang! Little new to FileMaker development and I need some help on this one. I have a table that holds different categories for a contact Table: Category Field: pk_ID_Category Field: Category Then I have my Contact table with a relationship to the Category table Table; Contact Field: pk_ID_Contact Field: fk_ID_Category === Category::pk_ID_Category Field: First_Name etc.. etc... etc.. When I designed my layout for the Contact table I wanted it to where the user would see the actual Category as opposed to the Category_ID.. I created a Value List based on the Category Table and set it to only display the second field. I assigned it to…

Hi, Any thoughts on what might prevent a field formatted as a drop down list using a value list fail to "drop down" in browse mode? I know I modified it inadvertently however I have recreated the exact settings for the field based on a working backup but alas to no avail...the current version will still not work (are you wondering why I do not continue with the backup. There has been substantial modifications to the current db from the backup unfortunately and the daily backup from the last use was overwritten when I closed the inadvertently modified file...ahh the wonders of scripting ). Any thoughts? Thanks, Jack

Hi all, I am recreating the form below in FM: http://wirenet.mcmaster.ca/indicators/wmi_form_v.html each row in the table is a species of plant that the user can check off to confirm having sighted when doing research. each species has a "U" value and a "T" value that are added to two running sums when the associated checkbox is checked. the running sums are then divided to give the WMI value at the bottom Here is an example of the Java code for a particular row: if (document.getElementById("ELAC").checked==true) { wmi_top+=12; wmi_bottom+=3; } wmi_val=wmi_top/wmi_bottom; In FM, I have two tables: WMI - has columns Species, U-value an…

Excuse the newbie question, but I'm stuck and need some guidance: I have a fill-in layout that shows a series of checkbox value lists in this manner: [ ]STUFF 1 [X]STUFF 2 [ ]Stuff 2 subvalue A [X]Stuff 2 subvalue B [X]Stuff 2 subvalue C [ ]STUFF 3 [ ]Stuff 3 subvalue A [ ]Stuff 3 subvalue B [ ]Stuff 3 subvalue C I need to generate a report with all of this information in a special format and I am trying to understand how I can test to see which value list items have been checked so I can indicate this on the report. I can't just show the value list content for each record since there is some special text formatting that needs…

Hello, I'm trying to create a solution for an online ordering system. this is for a delivery company. I'd like to know if there is a way for the client to log on, click place an order, and when it goes to the order page there is a field that displays this clients previous delivery addresses. There will be several accounts each with unique delivery addresses. So is there a way to have a field that will display only client a's value list based on the log on or only client b's based on the log on name? Not very good at this stuff. I greatly appreciate any help or advice. Thank you.

I've removed this post as the problem was more to do with my brain than with the pop up menu apologies

I would think this would be easy, perhaps I am missing what function to use. Lets say I have one table.. called products. The Products table has all of the item numbers, their item description.... along with other fields. Same Table...2 new fields. 1st field: is a "you may also like"..which is a dropdown list based on all available Item Numbers. 2nd field: autopopulated item description of what was chosen in the first field. So basically an old fashioned excel vlookup. How would I do the lookup of the Item description, based on what Item number they chose in the first field? Remember, it is all one table....

Is there a way to do this...: I have a Herd database. The animal records all have a unique ID. Each animal record has 2 name fields, a full (registered name) and a short or common name. Each animal can also have a parent relationship (ie. dam and sire.) So, Animal A can have Dam D and Sire S. Dam D and Sire S each has a full name and short name. Animal A;s record stores the ID number for Dam D and Sire S and uses calc fields for full or short name using current relationships. On Animal A's screen, the dam and sire fields each have a non-enterable calc field in front that always displays the full name. Behind that is an enterable field that uses a …

I'm currently updating my office's filemaker 9 database, but am fairly new to filemaker and so I'm having a few issues. I'll explain what I need it to do, then I’ll get to what I have already done as I’m probably using a fairly backwards solution already. What we have right now is a list of media contacts, each of whom are broken down by the kinds of publications they work for, and which clients they are relevant to. The final area we'd like to add is allowing them to be a member of a distribution list (DL). The DL list is constantly changing, depending on what press releases are circulating, so I’d like users to be able to modify the list of available DLs for the…

I have been grinding on this 'non functioning' value list for over a month and no matter what weird / exotic / unexpected methodology I try, it still acts weird. Please check it out at: http://ronaldogordono.googlepages.com/valuelist2 The database is there for the downloading. I appreciate your thoughts.

Lots of people have reported slow value lists, and often the response here has been to say, "Your value lists are too long". Well, now I have a very slow value list that is very short, so I'm hoping someone has an idea I might try to solve this problem! We index some records with a fully flexible thesaurus of about 4000 terms. So any term can be a child of any other term. In practice, there are a number of (mainly) distinct branches of the tree and to simplify selection for users, these are identified by a number field in the term record called "branch_id". So, all I want is a value list of the all the terms in a given branch. To do this, I have created a global…

maybe this is the wrong place to post this but I'm having an issues with some value list no longer working and some just disappear completely. One day they are there and working fine the next it not. When I go into view the values lists the space for the missing one is there but the row is empty. Its has not been deleted its as if it gone bad. Any one experience anything similar? As I'm the only one with Full access to the db I know it can't be something others are doing it just odd.

HI, I am creating a inventory project in which i want that after selecting radio button depending upon its value the edit box should visible to me if i don't select any value from radio button the edit box should not visible to me. i tried a lot but can't find how to do this. please help me out. Thanks, John Wiliams,

hello i what to make a conditional Value List in a portal. i try to do it but with no success. i have up loaded the file can any body have a lock please tank you dani tectop.fp7_2.zip

Greetings, I have a section on the Database that i am building, it is going to be used for the Attribs. There is actually 3 tables involved, * Attribs Controler * Attribs Value * Attribs Type Attribs Type: The idea of this table is that it allows for you to enter the type for in this case; * Colour * Size Attribs Value: This table actually holds the values of the Types, so for example; Colour Black Colour Red Attribs Controller: This is just holds the values entered for each of the products. [color:blue]Tables Attrib Controller: Attrib_ID Attrib_SortID Attrib_TypeID Attrib_TypeVal…

What would be the best way to create a global? value list? Basically I have a field which will contain same set of values always. The values that can be chosen for the field are: 1, 2, 3, 4, 5 and 10 1 = Brand New 2 = Used-Like New and so on. Should I create a preference table with 12 fields containing the mentioned values and relate that table via fKey to the actual data table and then have the value list get values that way or is there a better, more standard way to do this? I could use a value list with custom values of 1, 2 and so on but I want the user to see 1 - Brand New when they click on the field. After the selectio…

Working on my first FMP project : and I want to create a dropdown list that will only show the appropriate choices for companies in a given state. The state is part of a table of people that you will search for by name, address, reference #, etc. I want to filter the dropdown list to only show companies that operate in the state where the people are. What is the most efficient way to do the filtering? Should I just populate another table by triggering a script that will do the appropriate find and then populate the value list from there? New to this ...thanks in advance for your advice!

I am wondering if anyone else is experiencing this bug in Filemaker pro 10. I have a value list created that references a rather small table to populate the value list. I created a Global Field on one of my layouts and made it a drop down selection based on that value list. Sometimes in Browse Mode, when I click on the drop down, it freezes up. The Program is still fine. I can click other fields, but the Dropdown remains frozen and is blank. I usually have to switch to another layout, and then come back, and it will work just fine. It only happens sometimes, but enough where I would be concerned my users will freak out. Anyone know what could…

This should be easy and I looked on the forum, but could not find an answer... I have the following: Valueslist::Species Valueslist::Category Valueslist::Value I need to setup values lists that are accessible to other files, so that a global field with Species will only list categories for that species and a selected category (as a global field or calc field) will list only associated values. "All" will be valid for Species (but the global field for Species will have an actual species indicated.) I tried to set up a simple one, using just the category and values fields, but can't get it to work: The Category is Contact and the values are cont…

Can FM convert a return delimited list into values separated by pilcrows? Using the list function I obtained a field with a list of values: BLB BLG BLK... I want to use this field/list in the a Filter function. Can I use FM to convert this list to BLB¶BLG¶BLK so it can be used in a Filter calculation?

I have been reading through several posts, and this has probably been answered in some regard. But I still can't find the answer I am looking for. I simply want a value list to be displayed Chronologically. Unfortunately, when I use the drop downs, it changes the sort order completely. The value lists are Jan 08, Feb 08, etc..... I put them in the correct order on the Table that I am referencing... they also have Serial ID's in the order of earliest to latest, but the drop downs re-sort it based on English I guess. Any ideas?

I too have a hard time with the Reference ID of a particular record showing instead of its preferable known value, whatever it may be. I have read a few of the posts on this topic and many point to using Popup boxes in lieu of drop down lists others use a second field to mask the dropdown list to give an illusion of no foreign reference ID and others use a second window or form triggered by a button to make selections from a list view or portal. None of these solutions are friendly to data entry personnel who would like nothing more than to never have to use the mouse. They want to Tab into fields and start typing and Tab on to the next field. Unless they know th…

I'm having a hard time discerning whether a checkbox or radio button has been selected. The image on the screen is very faint. Is there a way make these graphics more robust? Would really like them to be bright red if selected. If that is too much to ask I would be content with just making them a little easier to see. Any ideas?

Hello all! First time poster, week long lurker. Lots to read here. I have been building a simple solution for our fire department to teach myself FM9. We have been maintaining a database of burn permits in an excel spreadsheet for years. It is time for FM! I took the contact template supplied with FM9 and chopped/diced/cut/copied....and came up with my frankenstein of a solution. My problems: 1) At the very top of the page I have setup 2 drop-down lists. I want to just "freeze" them so they remain the same on every contact until changed. The 911 operators need to quickly see if it is a burn day or not and the reason, so I thought I would j…

Ok, maybe its that Ive been looking at the screen too long, combined with my newness to FMP - but I cannot figure out how to make one single checkbox on my layout that when checked marks that record for deletion. I would like a checkbox where users can mark records... they stay marked until the button gets clicked that does a find for those with checks and deletes all the records of that find. Can someone help me? My head hurts! hahahah

Hi I am in the process of creating a database to store records of trauma patients that we look after. I want to have one layout within my database to classify wounds using the Red Cross wound classification system (see below). I initially designed something using a series of drop down menus for each variable and then used a calculation based on the chosen variables to calculate the score. This works - but as each patient may have several wound the system is ugly and I am trying to find a better way. I thought about using pop-up information windows - that give the definitions for the scoring system - but could not find how to do that. If anyone has any ide…

I have a value list built on the contents of a calculation field ("Quarter") which contains either "First Quarter", "Second Quarter", "Third Quarter", or "Fourth Quarter", then a space, then a year (2008, 2009, etc). So a typical value list might look like this: First Quarter 2007 First Quarter 2008 First Quarter 2009 Fourth Quarter 2007 Fourth Quarter 2008 Second Quarter 2007 Second Quarter 2008 Second Quarter 2009 Third Quarter 2006 Third Quarter 2007 Third Quarter 2008 Third Quarter 2009 What I want is for all the years to be together, with the quarters in logical order, like this: Third Quarter 2006 First Quarter 2007 Second Qu…

I have a calculated field that does multiple Case tests against several related tables and returns a text status value (i.e. Approved, On Hold, etc) based on the results. Rather than hard-code the status strings into the calculation, I'd like to use a value list, in particular one created from a table, but I can't seem to find a way to do so directly. I know I could use a global field with CR separated values and the various values functions, but since these statuses already exist in their own table I'd like to avoid that redundancy if possible. Am I missing something?

I have something weird going on. I have a drop down menu that refers to a drop down list. First field contains 3 char initals :FMP second field contains Name: Filemaker. "Intial" is selected from left side window, right side has "Name", both of these fields are on a separate layout with two columns with multiple rows. "Include all values" is selected, and "show all values" is checked. OK NOW MY ISSUE I have this field placed in my footer along with some other less essential fields, in this position it works well with other drop downs and i can do combination searches to narrow down my results. If I duplicate this field and place it…

Hello Mavens, is there a way to prevent the automatic tabbing to the next field when the user enters a date into a field via the drop-down calendar feature (FMP10)? I created a sham field with a trigger to commit records upon entry to the field which tabs after the date entry field but I'm wondering if there is another solution.

I have a problem that's come up at the end of several steps. Here goes: Table One is called "topics". This table has two fields "topic ID" and "topic Name". Table Two is called "locations". This table has a field with a check box style value list. The value list is generated from the other table's "topics ID" and "topic Name". This all works great. It displays all the records in "topics" table with the id and name showing. So, what I want to do now, is display the checked values on a report. If I put the check box field on the report as a standard edit box, it only displays the data under "topic ID". I'm assuming this is because that's how the relatio…

I've been asking myself this question for a while. It's about the visibility of the ID. I have a value list calling my contacts from a different table. The first field is the ID and the second is a related field calling the cFullName. Everything is basic and works fine. My question is: Is it standard to call a contact only from the ID ? Is it normal in a database to SEE that ID all over the place? I just think it's ugly , it has no other use (even if a very important one) than to relate the tables. But try to explain it to user. I'd rather have just a field showing the name of the contact and somehow hide the ID without confusing the user. Any meaningful thought …

I am looking the count the content of value list fields. There are 8 value list fields on the table that I would like to know the content count for. The value list field contains one of 10 choices and there are 8 fields that a user can populate. What I would like to find and list is the value and how many times it comes up in those 8 fields. So I am looking for it to show on a report like this. ValueOne = 30 ValueTwo = 20 ValueThree =2 5 etc. Thanks in advance for any help. I am developing this in FM 10 Adv and my users are on FM 10.

The Setup: Field Called "Prepared_For" Value list from table "Prepared_For" I know how to make a simple pull down list and I know how to make a script that adds a new entry to the table called "Prepared_For". What I want to do is combine this into one -- Let me explain. When you click on the field "Prepared_For" it brings up the list that you can choose from -- this works. Now if the name does not appear on this list then I would like to just be able to type the new name into the field "Prepared_For" and have it added to the table "Prepared_For" as a new entry. Can this be done with a script on the cell and what would it look like? Thank …

My FMP file is connected to on online store shopping cart that I have, which is a MySQL DB. One of the MySQL tables is the category names, and I'm trying to use the name field there for a value list in Filemaker. But of coarse I can't pick that table. There are two category tables on the MySQL side - the categories, and the category names (the first is the main table, the names are separate to allow for other languages - long story, don't ask) anyway, I have join table in FMP for these two, and a calculation field that equals the category name (plus dashes if it's not a top level category.) And that calculation field is what I would like to use for the value list…

I'm a bit confused about how best to implement repetitive values. My scenario is I have a "Person" table and each "Person" has a "Role". There will be a limited number of roles. In a "Person_View" layout I want to implement a filed which allows me to choose a "Role". Question is: should the "Roles" be a linked table or just a value list. I would want the interface to show the actual role, NOT just a role id, and I want the user to be able to add a new role. Currently I have this implemented as linked tables but I'm not getting how I have the popup display the role name after selection rather than the role id. Plus, I don't see how I add a new entry to …

I want to create a drop down list of organization names obtained from a field in a table hosted on an Oracle server. Making the ODBC link to the Oracle server is no problem and I can then see the entire table and all its fields in FMP. Using the x relational operator I can then create a portal showing all the organization names in FMP. However, when I try to "Use values from Field:" when creating the value list, the "Specify field" button grays out the ODBC-linked Organization table so I can't select the field I need. Is there a way to make a live duplicate of the ODBC-linked table in FMP so the necessary field will be selectable for a value list? Alternatively, …

I have a rather newbish question about value list relationships, specifically when using "only related values starting from...". If I have the value list on a layout that uses the same table as the value list's relationship is starting from, it works fine. But if I put the value list on a different layout/table, the value list shows no values. So I end up having to create many redundant value lists for each non-related tables and layout. I must be doing something wrong. My example is this: I want a value list of only those Contacts who are marked as "Vendor". TABLE: Contact1 NOTABLE FIELDS: * isVendor - a boolean field that has the value "1" for any …

I have a MySQL online store for antique radio parts, and an FMP file that interfaces wtih it. I have one layout in FMP where I want a drop down menu showing all the product categories. But here's the problem. In the MySQL DB each category has it's category ID, a parent category ID, and a sort order. What happens is, any top level category (Parts, Tools, Supplies) has a parent ID of 0. If you have a sub category (under Parts you would have Capacitors, Resistors, etc), then it's parent ID would be the categroy above it. So the parent ID for Capacitors would be the category ID for parts. I also have a 3rd level of categories, so Capacitors might have 2 sub categories i…

Hi, Is it possible to create a calculation field or number field that will display the number of entries in a value list? Thanks in advance.

Not sure if this post should be here or under the Relationships forum, but here goes: I have a system that records the payments I make to vendors based on their work on projects. When I create a new payment, it has line items for multiple project line items that a vendor might have worked on. Here are some key tables and relationship fields (note: foreign keys begin with "F_"): Payment (F_vendorID) PaymentLine (F_projectID) Project (isActive.boolean) ProjectLine (F_vendorID) Vendor Here are some key ERD points: Payment has one Vendor Payment has many PaymentLine PaymentLine has one ProjectLine Project has many ProjectLine ProjectLine has…

Hi Folks, We have a database of vendors who work all around the world. My users wish to see what time it is in the vendor's location without having to do the math in their heads. I have a value list of time zones that are already in use (prior developer), but doesn't have the +1, +5, +/-GMT in the list. Also, the concern with doing a calc of Get (CurrentTime) + TimeZone is that it won't take into account daylight savings. Are there any plugins or pre-made value lists that could help remedy this? Thanks!

I have a database in FMP9A which stores records for individuals and a related table which stores incidents. In the table for individuals, I have a GUID field which holds 20 repetitions to store the unique identifiers assigned to each individual. A portal is used to create related records in the incident table. Incidents are logged by GUID. Since one individual can be associated with multiple GUIDs, I currently have a value list created from the GUID field, but this list contains all the GUIDs for each individual in the database and gets cumbersome to navigate. I don't need to see all the other GUIDs that aren't associated with the individual when logging an incident…

Howdy all, I created a value list from my table of Product Types. One of the Types was used in the past but now we use different classifications to describe products of that nature. I need to leave the record of the old type in the table because I don't want to change history. However, when my user is entering data I don't want to give them the option of the old type. Basically, I have a table of 12 records and I want the value list to show only 11 of them. I'm thinking some sort of Relational Value list but I'm not sure how to pull that off since the criteria for exclusion does not exist in another table. Anyone have an idea?

I am working on a POS solution. I have a table for products, brands and of course sales, amongst other tables. The product table is a list of generic items for retail (shoes, shirts, jewelry, etc.). When setting up a brand, I have a checkbox field that lists all of the products based on a value list of all products, so the store owner can select which products they carry for each brand. During the making of a sale and after entering a brand, only the checked items for that brand show up in a product drop-down list via a brand-product relationship I set up for this purpose. So far so good. Here is the problem. If a brand is set to say have "shoes" selected, and t…

Hi, I hope this question makes sense! For each record of a certain table I have 2 value lists. ValueList2 is populated based on what I've selected in ValueList1. Normally I've been creating a new record manually, selecting a value in ValueList1 and then selecting the 1st value in ValueList2, then duplicating the record and selecting the 2nd value in ValueList2 etc etc If ValueList2 eg has 10 values, is it possible for me to create a new record manually, like I've been doing but then duplicate the remaining 9 records using a script? (So that when I look at the 10 records, ValueList1 has been given the same value, but ValueList2 has 10 different ones?)

I'm a new FM user. I have two tables: TblContacts ( ContactID, Contact, DOB, City) and TblRegister (RegisterID,Contact, Date,Obs), my problem is when I add a contact to the TblRegister using a drop-down-list to the Contact and its not registered yet how to jump to the Contacts layout and add all the informatiom about the specific Contact that hasn't been registered? ,like the event in the MSAccess ˜'fNotInList'.