Value Lists

I guess I should have been clearer in my last posting. I have a field named "OCC Title" this contains the job position titles. "OCC Title" is a drop-down list, with values from a record that I imported from excel. I have another field named "OCC Code", this is the field for Occupational Codes. Then I have these fields called "States", "Average Salary", "Entry Salary", and "Maximum Salary". What I wish to happen is this: 1) I wish to see the "OCC Codes" automatically filled every time a value within the drop-down field "OCC Title" is selected. 2) I wish to see the fields "Average Salary", "Entry Salary", and "Maximum Salary" auto…

I am really confused over a certain aspect of Value Lists!! I have a field that contains a value list of customer company names and a field that contains a value list of supplier company names. I want to be able to perform a search for all companies whether supplier or customer so I wanted to combine both lists so when a user did a search a drop down list would appear showing all companies. This looks simple enough as in the 'Specify Fields for Value List' window you can 'Use values from first field' and 'Also display values from second field', yet when I select the second field option only the values from the first field are shown! Even the description at the top of the …

I am trying to develop a value list to populate a drop down menu that would incorporate a list of layouts or field names in the current file. The purpose is to map data out of a table that was generated from a raw import. First I would like to have the user select which layout shows the imported data, and then map a few of the key fields in that layout to the permanent data structure of the solution. Then the import will be processed by some scripts. So I need one dropdown (value list) where the user makes an initial layout selection, and a second value list that populates dropdowns using the value selected for the target layout in the first dropdown. I th…

Hey, I put a drop-down value list on my layout, showing only the values of the second field. (The first field with its ugly the serial number I want to hide.) Unfortunately, in the actual field where the chosen value is I have the first value only, the description only shows up in the list. Does anybody know how to make the second value appear in the field? Furthermore: Is there a good way to have a drop-down list and avoid at the same time that the user can enter own values? Thanks, : Mike

I am trying to check a checkbox in a value list for a found set, but can't find an automated way to do it. Anyone able to help me? or do you need more information? thanks

Hi All, I'm wondering if someone can help me out here because i just cannot work out how you would go about doing this... let me explian. I have 3 tables in a database: companies, addresses, contacts. So one company can have many contacts and addresses. What i am trying to do is i have created a drop down box on my contact where i can select what address ID that contact is at... and what i want to be able to do is display the rest of the address details for that address ID but i just cannot work it out. Any advice is welcome. Thanks in advance, ieuuk

I am creating a simple invoicing system in which the contact_fk is a drop-down menu of a value list created from the related contact table. In the contact table I have radio buttons that say "Yes" or "No" regarding if the contact is a customer or not. I have also included two calculations, the first being If ( CustList = "Yes"; ContactSerNum_pk; "" ) and the second being If ( CustList = "Yes"; Customer; ""). These are the two fields I want to use for my value list in the invoicing system. Here is my problem. What I WANT is a value list with the contactSerNum_pk as the first field and the Customer as the second field, sorted by Customer. For some reason FileMaker…

I am working on an Enrollment Database and I want to ensure that a student is not assigned a class that is not for his/her grade. To avoid entry errors I have a check box field in the Classes Table (06. 07. 08. 09. 10. 11. 12) of the database which the administrator checks when setting up the database. In the Students Table of the database there is a field with the student's grade e.g. 09 In the classes + students join table I would like a calculation field that reads the students grade and compares it to the check box field and returns either "OK" if the student is in the correct grade for the class and "Wrong Grade" if the student is in grade 9 but the class …

I have a value list that should get all records from 3 tables. I could do it with 2 if I have a value list lookup and choose first and second field. But what if I need a third? How can I list a field from 3 different fields and show it in one value list? I tried to create a calculation field and added: add_materials::add_name & eo_materials::eo_name & oil_materials:il_name that should list all 3 tabels name fields in one calculation. The problem is that it wont work because it cannot index the field. So how can I list all 3 tables name fields in one value list? Thanks

Hi Really stuggling with this, please help! I have 3 tables BASE SECTOR SELECTION Within BASE I have fields Code Sector (selectecd from a value list based on all records in SECTOR) Within SECTOR I have fields Sector List (calculated field - lists data from several other fields) Within SELECTION I have fields Code Sector Selection1 Relationships... SELECTION is related to BASE by the code field on both sides This relationship provides the sector field in SELECTION SELECTION is then related to the SECTOR table SELECTION:sector = SECTOR:sector Hope that makes sense so far !! Now what I want to do is with …

I have a couple of things I am trying to do - I have a feeling they are quite simple but it's foxing me!! The first is: I have sequential job numbering set on one of the fields, I would like this to begin with the year as the first 2 digits, so 08001, 08002 etc. How do I set this so when we get to 09 it automatically starts from 09001 again? The second is: I have allocated time fields which add up in a total box, it does update but only when I click into the total box and out of it again which is a bit annoying - how can I fix this? Thanks in advance if you can point me in the right direction...

I have a employee table that has a termination date field. I want to create a value list that only shows the employees with a blank termination date. Any help will be appreciated.

Ok I know this has been asked before but I need some extra help I think. My Setup Broker_Table: Broker_Co Questionnaire_Complete (Check Box) Etc... Policies_Table: Broker_Co Etc.. Relationship: Policies::Broker_Co = Broker::Broker_Co There is a pull down menu on the policies page which has a value list that get info from the broker table. What I need it to do is only draw broker names who have a completed box checked... How can I do a conditional value list that only shows completed checked brokers. Thank you, Joseph

So, I've got a Shipping Company dropdown, it holds information like UPS, FedEx and DHL. I then have a Shipping Method dropdown, that is filtered based on the Shipping Company selection. My problem is this. When I select a shipping company, and then try to select a shipping method, the shipping method list is either empty or filled with the filtered items from my previous selection. It only updates itself when I click off to the side of the fields so nothing has the focus, and then I bring the focus back to the shipping method field. How do I make it so that the shipping method dropdown is updated automatically so I don't have to click off to the side to update …

This is probably very simple, and I'm probably over explaining it here, but I'm drawing a blank. My DB is for copyshop job tickets. I have a radio button set with 6 options for users to select the type of paper they want (plain letter, cardstock letter, plain legal, etc). The copyshop charges a rate for each paper type, but some of the rates are the same for different types - ie colored letter paper is the same rate as plain letter and the same rate as plain legal (.006 cents per sheet). The DB needs to record the paper type and assign the rate in a separate field for the same record. What I'd like to do is have a set of radio buttons to select paper type,…

Hello. I'm relatively new to FM, and am in the midst of redesigning a database for a school. It was set up based on names, and I am trying to get it set up around ID Keys instead. One problem that I am having is that, from a data entry point of view, people want to see names. Take, for example, our student agents. Some of our students are referred by agents, and we want to keep track of which student was referred by which agent. Students and Agents are both separate tables. I linked them by creating an Agent ID FKey in the Student table. I then set up the field to be entered by selecting from a drop down value list. The list came from Agent:Agent ID PKey …

Hi All, I'm creating a recipe database (don't groan!). In the Ingredients table I have fields for Ingredients, Measure type, Quantity etc. In the Recipe table I have RecipeName, Method etc. I bring these together on a Recipe layout, where for each recipe there is a portal for ingredients with their corresponding quantities and other fields. Some ingredients are used (and so entered) more than once in a recipe, but I don't think this is a problem. I've used a value list based on the Ingredients field to enter the ingredients into the portal, and it all LOOKS good. If I do a find on the portal the find works OK, finding only recipes that include the ingredient reques…

Thanks to the help from the forum, I was able to write a script that can automatically check values for multiple records in a checkbox set. See: http://www.fmforums.com/forum/showtopic.php?tid/199116 Now I'd like to know if it's possible to do the same for unchecking values. Anyone?

I'd really appreciate any help with the following problem. I have a field that contains a value list, shown as a checkbox set. Different records have different checkboxes checked. In a certain layout, I'd like to check one of the boxes for a certain found set of records. I now have this script: Go to Record [First] Loop Insert Calculated Result [select; fieldname ; value] Go to Record [Next; Exit after last] End Loop This works, but it replaces the current checked boxes, because I use "[select;...]". But if I don't use that, I doesn't work. I get an error message telling me that my field doesn't except the new value. What am I doing wrong? …

I am having a wonderful time right now with a relational value list that works, kind of... I have a company table, a location table and an order table. Both the Order table and the location table are related to the Company table by the "ContacID" field. When I create a new order, the ship location field will display a drop down value list of all related values from the location table, based on ContactID. Well, it works beautifully for all companies that were imported into the database when we went live. What I just found it, however, is that for all companies that are being created in the database now, the value list will only show the FIRST related locatio…

I have a table with a calculated field whose value depends on various conditions. I use that field for a value list elsewhere. I would like to 'snapshot'or 'save' that value list to fix the contents so that it can be applied later, even though the values in the original table, and hence the original value list, may have changed. Hope that makes sense. Any way to do that?

I frequently use a value list for data entry. That is, I insert data from one table into another via a value list. I set the first field of the value list to be the record ID and set the second field to be the client name. I then set choose the “include all values” radio button and place a check in “Show values only from the second field”. However, the value list only displays the second field if the field is displayed as a pop-up menu. If it is set as a drop-down list, the first field displays. Is this a bug? Or must I always use a pop-up menu to display the second field?

I would like to limit the number of character that a user can enter. I understand setting up the field with the Maximum set to the desired number, but the user can enter as many characters as he wants. The user doesn't know he's gone over the, let's say, 80 character limit until he tries to go to the next field. At which time, the error message shows up. Is there a way to have filemaker stop allowing any characters to be typed in to the field when past the limited number of characters?

I have an Employee table occurrence (TO) which has a related Manager TO through a field called ManagerID. I have created field called StatusID in the Manager table. This StatusID field is related to a table called Status. On the Employee layout (with the Employee table as its source), I have created a dropdown for the ManagerID field which works fine and refreshes the ManagerName edit box which is located right beside it. I have also created a dropdown for the StatusID field and I want to display the StatusDescription edit box right beside it. The StatusID field works fine but the StatusDescription field does not refresh when a StatusID is chosen from the dropdown.…

is it possible to have an input field within a custom dialog box to include a drop down value list ? thanks ben

I an order system where I have a relation calculated value list based upon that a researcher has a head of department and depending what projects (cost centre) that head of the department carry the researcher can choose (only from that head of departments and no other heads projects) a project (cost centre) to debit the purchase. The value list doesn't work unless it's "been triggered" by adding a new project... After a new project has been added the new project AND the already existing projects spring to live... I realize there is some relation error and mostly wonder if anyone has experienced anything similar? Cheers!

Hi all, using FMPro6, I would like to change a defined value list field to a plain text field. I figured out how to delete the defined value list, but an empty dropdown menu is still there. Sorry, I am pretty new to FM still. Thanks all, Heeter

I can't seem to figure out how to calculate if a value in one field is one of the values in a checkbox list. When I use Case (field1 = List ( field2 );"something happens"), "something happens" only when just one checkbox is checked. But I want this to be true when the same value is checked, no matter if there are others checked as well. Does this make sense? I hope someone can help me out... VAB

Is there any easy way to do this that I'm just not aware of? I have a value list ("All Departments") populated by values in the field "Department" stored within the table "Users". In the "Hardware" table (which has a relationship to "Users") there's a text field "DeptFilter" that's global, set to display as a checkbox set using "All Departments". When the user clicks a "Find" button they're presented with a simple layout showing the "DeptFilter" field as an assortment of checkboxes. In theory, they select one or more checkboxes and click OK which then triggers the script to show only those hardware records tied to the selected department. Selecting a S…

I am having problems with a checkbox set. I have a list of procedures identified by item numbers and descriptors. These are two fields of a table. There are also corresponding unit values for each procedures. Multiple procedures can be used for one patient - they are selected by a checkbox value list. I am trying to write an invoice using this data. By using a "merge field" I can get a list of the item numbers, but only the first of the corresponding "descriptions" and "unit values" appear. Am I going about this completely the wrong way, or can you suggest any solutions. Ultimately I need to multiply the unit value for each selected item by a …

Hello, I have a popup menu value list that displays only the second field (oil_supply). The first one is just a serial number (000203). I also have a different field that calculates ( Filter ( Proper (oil_supply) ; "ABCDEFGHIJKLMNOPQRSTUVXYWZ" )) and only displays the first 3 letters from that field. The problem is it will calculate the first value field (Serial Numbers) instead of the second (oil_supply). Is there a calculation that uses the second value field instead of the default first one? Thanks

Is there a way to make it so that if the radio box = "Lingerie" then it will automatically change the layout to "Layout2". If the radio box = "Toys" it will change the layout to "layout1".

When using the type ahead feature I'd like the drop down menu to not display at all or if it must display to be blank until the user begins typing in the data entry field. My users find the scroll list of many hundreds of records confusing when nothing has been entered. Is this possible? Kind regards,

Hi all, Apologies if this is not the right place to post this question. I have a FM file where I have imported a JPG image into a container. I would like to double click the image and have the source image open externally in "Preview" (The mac default image viewing software) Could anyone suggest how this would be done? Thanks! =)

This has probably been answered before, however... I have a database that I am developing. In one table (called Books) I have a handful of fields which includes 'Book Title' (text) and 'Level' (numerical value). In another table, I have a value list that uses values from Book Title (First Field) and Level (Second Field). What I need to happen is: When a user selects a Book Title from the value list, it then displays the Book Title, plus it also displays the Level in a separate field. How do I make this happen? Regards, Michael.

I'm 99% done with this database (hooray!), having figured out just about all of my woes and worries. Now, after sitting in front of my screen for nearly eight hours getting everything ready, I've run into a snag that my sleep deprived mind can't connect. Here's the relevant part of my relationship graph: On the PAYMENTS table, when a new payment is received the user first selects the exhibitor from which the payment was received. This is established through the relationship between the PAYMENTS and EXHIBITORS 2 tables. I have a value list that's created from all of the exhibitor names in the EXHIBITORS 2 table and it works nicely. I run into my proble…

hi, i am fairly new to filemaker and am wondering if there is a way to select an item on a value drop down list and have that automatically go to a different layout? example: I have a drop down value list in a contact list database made up of: Client, Freelancer, Employee... and so on. i want to be able to select client in that drop down list and then have that automatically navigate to the client layout in the contact database or if i select freelancer to have it go to the freelancer layout in the contact database. Is there anyway to do this without selecting additional buttons?

Dear filemaker oricles, I am not an expert by all means, i am just doing a simple data base for my training center. I have setup two fields, 'course type' and 'course fee'. The course type field is a dropdown list of all our courses. I want the 'course fee' field to auto-fill itself depending on the course thatis selected from the drop-down list. The problem i am having is, i can't figure out how to assign prices to each entry in the value list. Any help would be fantastic

Hi there, I would appreciate some help on this, how can I change the style of a field by clicking in a check box? for example: check box | text field [x] | [color:red]text here changes style (color, or strikeout)

using a drop-down menu list is a simple way to provide a limited set of possible field entries BUT, just use copy & paste to enter any field contend you want (or better: dont want) in the drop-down menu field Any ideas how to block copy & paste for drop down menu fields? thanks norbert

Hey everyone, I am working on a database for a metal recycling company. I have 2 Tables. A customer table and a service order table. They both act as different modules (customer module and invoice module). I have relationships set between the two so that when I start a new service order from a customer it automatically sets name, phone number, and address to its appropriate value. On the customer module, I set up a metal pricing list so that the owner can set the price per pound paid for each metal type (ie Customer ABC TOWING has thier prices set to: brass is 10 cents per pound, copper is 13 cents per pound, steel is 18 cents per pound, etc). On the invoi…

hello, The "Scenario" I have a table for my CRM System which keeps ALL adresses regardless of the type (supplier, customer, subcontractor,....) called "Address" There is a field "isSupplier" in that table which either says "Yes" or "No" whether the entrie is a supplier or not. Now there's a Table for my Products called "Products"... For each product I want to be able to choose my main supplier from the "Address" table described above and have it associated. to accomplish this the Products table has a "SupplierAddress_ID" numeric field which can contain the AddressId of a supplier. I want to create a ValueList which should show all Entries fr…

Hi, I have one field that displays a second value lookup as popup menu. I do want to have the same result in a second field. So once I chose the popup and it displays the second value the other field should display the same value. In my set up now the second field just displays the value list of the first value (record serial). How by calculation of the second field can I display the second value?

Hi, I am reasonably new to Filemaker but have extensive Access knowledge, so not a complete beginner. The Goal: 2 populate 2 fields from a value list The Source: A Supplier table with 2 fields i am interested in SUPPLIER and ADDRESS The Destination: A form with 2 fields SUPPLIER and ADDRESS I have a value list created from the supplier table with just SUPPLIER and this populates the SUPPLIER field on the form OK. Then i would like the ADDRESS field on the form to be completed using the appropriate address for the SUPPLIER already chosen. The Question: Can this be done? Thanks

Hi, I am relatively new to Filemaker. I am trying to use the TimeCards template to do timecards for my company's staff. When we choose the week and have the staff enter their hours, everything seems to work fine, but when we switch to a new week, to enter hours for the next week, the hours just stay there. Is there a way to keep the staffs hours from multiple weeks in one database? Or is filemaker (or maybe just this template specifically) just not geared toward this sort of thing? I think I understand why it doesn't work, the repeating fields don't seem to have any relationship with the date selected, but is there any way to fix this to make it a functioning…

Hey, I wonder if there is a solution to this problem: I have a table1 that contains a field called Keywords1, and a table2, that contains a field called Keywords2. (In the Keywords fields the user can enter any word that he thinks is important to help him categorizing the record.) Now, ideally, when entering words the user can choose from a value list that uses values or words of both fields. Well, I tried value lists, calc fields, text fields / auto enter, and so on, but I couldn’t find a solution. Even though the tables are related (table1:table2 is 1:n) I am not successful. Any ideas? Thanks a lot, Mike

I could not find anything that actually answered how to copy data from one table to another in the same database. Do you simply import and while browsing, select the same database? I have not used Filemaker in a few years, so I am a little rusty. I am basically trying to find a work around for the lack of conditional value lists in IWP. I have a huge list of inventory items, most of which are used rarely. For my main users, I have conditional lists based on a category that works just great. Now for the web users I am stuck. The list is crazy and long. I would like to actually duplicate a small number of items into seperate tables for each category. I was th…

The example, a serialized products table that includes a number of fields describing the product. In other DBs I would create individual tables for the descriptive fields related with an ID, or put them all in one related table linked with an ID and a type. Filemaker appears to prefer using value lists for many things I might normally use tables. Is this one of them? The end goal is to populate drop-down lists in a products portal with auto completion and the ability to use the tab key to commit the selection to the field. The reason I'm having trouble doing things my more traditional way is because of this statement from the help file regarding auto-comp…

hey everyone! this question is not really off topic material but i dont know where else to put it. Its a simple one though, I have a drop down window that displays values. Can i re arrange them as i add new ones or will it screw up my data?

Hi, I am new to FileMaker, and have been playing around with it for a few hours now. I'm looking to replicate the functionality shown in iTunes smart playlists, in which the user pulls down a behavior from a drop-down list, but can add more. Basically I would like to have an inventory of car enthusiasts. For each person, I would like to let them add multiple cars in their collection. I want to include them by brand, which will be accessed by a drop-down list. But I want to user to be able to add multiple vehicles. So maybe Joe Average has only one vehicle, but Jay Leno has dozens. Is there a way that I can make it so that I can have an indefinite…

It seems that you cannot create a value list, from the values in a global field. This seems silly. Is it true?

I need to now if i can make values in a value list apear and disapear upon conditionals??? How could i do that easyly ?

I created a new database which contains a total of three fields. Two of these fields contain a drop down menu, while the third is a date field. When either of the two drop down menus have changed a new date should appear within the date field. The first drop down menu contains the shipping time, while the second is the method of shipping, UPS, Fedex etc. Could someone please point me in the right direction as to how to get this to work? Whatever help you can offer would be greatly appreciated. Thanks in advance.

Hi all, I've been able to keep a field generated list in the order i want by using hints on this post, the thing is that when using the list in another table via a link, (or even in the same table) the text doesn't auto complete, actually the feature turns off. basically i'm set this way: "JobTitle" field "index"field(to setup the order)number from 01 to XX "Calculatedindex" field(using Remplace2 ( 10^index - 1 ; "9" ; " " ) (sorry french application version here) The list is generated using JobTitle & CalculatedIndex, sorted by 2nd field. Any idea? Regards Dom

I have a value list that holds product spec via a checkbox set which is working fine. I would now like to use this data in a layout I have created for printing purposes. I would like to add a (different colour) bullet point next to each value in the list. Is there a way to do this? I'm not sure that this can be done but I am asking anyway just in case! thanks

I am using a a dropdown list to show the surname field from a table containing thousands of names and addresses. The value list specifies the surname as the first field and also displays a second field which is first name. For some reason if there are people with the same surname, then only one instance of this name is shown in the drop list despite there being different firstnames!!! I cannot understand why if they are different records, that Filemaker excledes them? Any help appreciated that would enable me to show all records in these drop lists!!

I know this topic has been covered numerous times, but none of the solutions seem to apply or even work with my problem... I have a data base for employee information. Here are the tables (simplified for view) Emp_Table: emp name (*source for value list) status Timecard: emp name Value List: status ("active" "inactive") (custom values) emp name (* from emp name field of emp_table) In the Emp_table I specify info like, name and status (active or not) In the timecard table I have a field for the emp name which is a value list from the emp names in the emp_table. In the employee table I have a value list to select the st…

Hi. I cannot see any native tools to do it, but was wondering if anybody was able to make FmPro do the following task: I have a need for a drop-down box that displays entries that not only start with-, but also ONLY have the typed characters in it. For example. A list with 100 names of various spelling. As you type the letter A, only entries in that field that contain A (not just start with A) appear, then T is pressed, and the list narrows to only items in the list where AT can be found somewhere in the field contents, thus narrowing the search smaller and smaller until it beeps when none are found - the beep is optional. lol Is there such a function - eve…

I have a field named Groups that is populated from a checkbox with a value list. I need to change some of the group names in the value list, but I also need the records already in the database to change to the new names also. How should I do this?

I am changing a custom values list to be a table managed list. The custom values list looks like so: Alert Fun -- Sad Depressed -- Silent -- Scared Mean I need to be able to keep the grouped values together and use the separators. I have found that I can use a space in the separator records to get around the duplicate values issue. My problem is that I am left with an additional "sort" value in the value list when trying to keep my grouping of values correct. Any thoughts about how to elegantly recreate this custom values list in a table managed solution? TIA, Aaron

It seems to me there must be a way to alter the size of a button without having to drag it with a mouse. In the world of Pages, there would be an "Inspector" where I could define its length and width. How to do that with Filemaker 9 Pro? Thanks.

I have a field that uses checkboxes with custom values. I want to sort by these custom values. (I have club members select 2 forms of community service -- I want to then list everyone who signed on for each of the 5 forms. The problem is, the standard sort by custom value will only allow the club member's name to appear in the first of the custom values checked off. Their name will not appear under second option they have checked. I want the names to appear twice in the sort, but the sort will not repeat. How do I generate a list of names by these checkbox custom values?

Hi, I'm pretty new to FM, so I hope this is the right forum. I have 3 tables in my database: Jobs, Companies, and PIC (Person in charge). Each Job is performed by one Company. Each Company has several PIC's. Therefore, I have related Jobs and Companies through the "Company Name". Companies and PICs are related through the "Company ID#". The user looking at the Jobs database can select a Company for the Job by pulling down a drop-down list with a value list based on the "Company Name" field. The appropriate information fields about the company then display as static fields in a portal. However, I want the user to also be able to select one of the the PICs from th…

I had a value list based on a list of suppliers I entered directly/manually into a special field for the purpose. I changed this to base the value list on the actual suppliers I have created records for. So, add a new supplier, and then the value list will automatically change to include that. But something is awry - the value list is fine except that there are 3 suppliers who appear twice in it. I checked, and there is definitely only one record for each of these suppliers. I experimented with deleting one of the suppliers, and their name still appears twice! So how does this work - it has some kind of memory for what was listed? How do I change this? Its like…

Hi, I have a table which is used to create recipes. In the creation of the recipe I need to select each ingredient from the Products table. Each ingredient then needs the amount put in. I can get the field to properly list the ingredients, but how do I set-up the table so I can add as many ingredients as possible? The number of fields for ingredients will be different with each recipe. Also, how do I link the amount field to the ingredient field when amount is an edit box and ingredients is a value list? I need to do it this way because I will also be creating a Meal Planner table which will select recipes for each meal on a specific date. I will als…

Hello and thanks in advance for your help I did a layout and I need include the number of record, the number of found record and the total record. As in status area. Should appears so the form: 1 of 5 when we do a "find" thank you. jjf

Hi, I am new at the FMFORUMS and I find it fantastic. I am trying to find a way to create submenus, meaning that i will have a pop-up menu and inside of it some kind of a submenu so if i will choose an option from the submenu automatically that will select the root of the submenu. I hope i am clear enough. I would appreciate any help . Paul

Hi: I have created a simple file to demonstrate what I am trying to achieve. Basically I am trying to filter a value list to present the user with available position codes for a specific date. I have used Ray Cologon's ZapValues custom function to filter the available codes and then used the field "ListAvaiablePositionCodes" for the value list. The problem I am having is that when I create a record and select a date the drop-down menu sometimes displays "". If I click the "ListAvaiablePositionCodes" field the drop-down menu is updated. I realise that there may be an easier way to do this, if so can someone let me know. DynamicValueListFiltered.fp7.z…

Hello, I represent a company called Sutherland Design Agency and I am creating my first database with file maker. My CEO wants me to set up a drop-down menu on our time cards that lists all the open projects. I created another table that has project name and a radio button set with status: open, closed. I want to be able to filter the project name field in a value list so that if a project is closed it doesn't show up in the drop-down menu on our time cards. My boss says this is definitely possible, but i'm not sure how to do it. I'm a total beginner. Any help would be appreciated. Thank you, Logan

I think the answer to this is likely simple. In the real world I'm taking soil samples and counting the numbers of individuals of species in each sample. In FMP 9 I've got Samples, Sample-Species, and Species tables. On a Samples table layout I have a Sample-Species table portal on it in which for each record I have a dropdown menu for Genus and a dropdown menu for Species. When I select the Genus, I want the Species list to be filtered by Genus. Genus and Species are two fields in the same Species table. I've tried a variety of relationship graph arrangements but I can't seem to do this simple logical thing. Thanks for your help.

I would like to know how can i change filemaker menu like in Busines productivity control.

Are there any techniques to bold the text of only the selected items in a set of check boxes? I've done some searching but have come up empty.

Got a copy of Fmp 9 - the best kept secret in the world. I've tried Access from MS which is a nightmare and very hard to learn. I've set up my first database to track vehicles at work and it badly needs tweaking. I have a pop down list of 7 vehicles on my form. Each time I fill out the monthly mileages I'd like to assign some unique info to each vehicle - such as registration, service dates etc. I am having trouble visualising how to do this task - should I create separate value lists for each vehicle or a new table Hope this is no too confusing Cheers

I'm setting up a Price Summary database using Many-to-Many relationships. Basically, I have a long description of a machine that is being sold and I have simply entered the data in a large field that ultimately, through a relationship of a product id, leads to a printable layout. My problem is the return paragraphs/enters are recognized as a new value in the value list and not all the information is present in the printable format. How do I prevent this or get around it?

I've come across some responses to this, but nothing that has really helped yet, so I apologize if you've seen this before. I have a field that has a value list (a, b, c, d, e), and want to perform an auto calculation in a 2nd field that displays text based on the results of the first field. For example, if someone checks a, c, and d, the results in field 2 would be: You checked a You checked c You checked d I can't seem to figure out how to do this. Simple if/thens or case functions will only return one of the results. I'd prefer not to write a script, but am fine doing so, if necessary. Any ideas or references would be greatly appreciated!…

When users are creating a new record, they must pick from an exsisting company list of about 3,000. First tried using a custom value list, but of course ran into the size limit error. Then created one based on field, but it is very slow in creating the list for the users. Is there a way to filter by each character that is entered? For example, when first clicked on the field nothing would happen. Entry of the first character "T" would display all value enties that begin with the letter "T". then "Ti"...and so forth. If thats not do-able, there has to be a beter way of providing a predifined list of choices for record enrty.

I work for a graphic design firm and will be using the database to help keep track of design projects and tasks. Question: Is is possible to create a value list for a specific record? Explanation: I have created a relational database that contains a project table and a tasks table. Each project consists of parts or phases specific to that project. For example, one website project may consist of a home page and a clients page, while another website project may consist of totally different pages and page names. when I create a new task record and assign it to a specific project, I want the "Project Parts" field containing the drop down values to show …

First I apologize for my lack of experience with FM. I am trying to filter on a value list that is created from information from another table. In short... User enters the Transaction Table via the web browser. First option is to click the _kf_booth which references Booth Table. My current issue is the booths change products every year. So I created in the Booth Table in addition to Booth# and Product, I now also track Season(which is the year) and Location. I don't have any idea on how that value list the user clicks on via the Web in the Transaction Table can be filtered by Season/Year and Location so it would only show a List of the applicable Booth#'s…

Greetings. Let me begin by pointing out my Filemaker abilities are limited, but unfortunately so is the time alloted to me to actually learn it. But, I am almost done with what I am doing, I just need to know how to do one more thing. My client is a nonprofit org, and they want to keep track of their Volunteers' hours by month for each volunteer. What I was thinking of doing is on each individual volunteer lay out, I will have a field for January, one for February, etc for all 12 months that will allow them to input the time. I was wanting to have a popup menu dropdown above that to allow them to select the year, 2006, 2007, etc that will change the month fie…

Hi FM forum, Looking for some advice on formatting a dropdown calendar. I've enclosed a screen shot of the page, and what I'd like is to have the dropdown list just be the month/year names. It then would show up in the global date field, formatted to just show the month/year. Is this possible? It works if I put the mon/day/year format in the list, but how about just the names? Thanks in advance, John

Hi all, This seems to me like it should be fairly simple, but I just can't see the right way to do it. (Or maybe it can't be done?) For purposes of running some reports on employee activities, I have a field (EmpCode) formatted as checkboxes for each employee. The user checks each employee whose data they would like to include in their report. I would like to add an additional field (EmpTeam) formatted as checkboxes for so that if I checked "team 1" then all employees that are part of team 1 would be then checked in the EmpCode field mentioned above. This is just a shortcut for users to help them autofill the options for their reports rather than needing to…

Hi all. I'm looking for some guidance on this problem. When a user creates a job in this database, I'd like the operations that person chooses (in a portal) to disappear from the value list once assigned to that job. Currently, the database is set up with the operations and jobs with their own tables, and are joined by a table called operation estimates, which takes both primary keys from the other tables. I've scourged the internet and forum sites, but can't seem to find much information on this type of list. I'm sure it has to do with conditional value lists and table occurrences, and just recently I've wrapped my head around that, but any help woul…

On my layout, I am using a checkbox format so that a field can accept multiple entries from the value list. My problem is this, I want the input to be a checkbox so that users can check the boxes that apply, but I would like the printing of the field to be in a horizontal list format. I set the checkbox to not print and placed a field underneath that prints as an edit box. Unfortunately, it prints as a vertical list, not horizontal as I would prefer and need so it all fits on the form. I poured over the FM help and couldn't find a solution. Any ideas?

Simple question - I hope - I'm creating a simple pull down list with 3 values for students - plus, equals,minus and want to use the characters ie +,=,- but the minus sign will not display. I have tried putting inverted commas and single hyphenation marks but they also show and I only want a - sign. I'm sure there's a simple solution out there!

I have a field formatted so that it picks values from a value list. The system is built on FMPA9 on MacOS X 10.5.2 International with Greek enabled. All is well except... When I format the field to be a pop-up menu (as opposed to, say, a drop-down list), and then I click on it to expand the menu so I can pick a value from it, all values in the list show in the wrong font, gibberish-like. If I go ahead and actually do select a value, then the pop-up menu goes away and the selected value sure enough shows up in its proper greek capable font. But this behavior renders the Pop-up menu option pretty much useless to me. I have to only use Drop-down list, instead. …

Hi, Is there a way i can navigate records via a value list? Some may say that such a technique would become unweildly as databases generally grow to contain thousands of records, but let me explain my situation... I have a Suppliers table with 20 or so records and would like to do a layout where i can choose the supplier via a drop down list and then have the individual suppliers products appear in list form in a portal below. Obviously i already have a separate products table with a foreign key for the Supplier ID. I could use the find functionality of Filemaker to select the Supplier, but it just seems to me to be a rather laborious way of doing what shou…

Good evening, I'm having difficulty getting my head around the correct way to create a conditional value list that only shows related values once a certain field has been filled. The Tables are as follows (i have omitted some fields so as to not complicate the example) SUPPLIERS pk_supplierID supplierName PRODUCTS pk_productID fk_supplierID productName price INVOICES pk_invoiceID fk_supplierID dateReceived INVOICE LINES pk_lineID fk_productID quantity When entering an invoice into the system, the first thing a user does is select the supplier of the invoice. This is done by a simple value list that references the …

Context, I'm working on a system that has lots of People (table tPeople) and items (table tDocket), I relate the two using a third table (table mDocketsPeople). Question/best practice request: What's the best way to help users select people to associate with a matter (or vice-versa). Assume both lists will over time have on the order of several hundred items. What I've tried (talking from the perspective of a layout in tDockets having a portal into mDocketsPeople): Pop-up menu: Works, but doesn't allow typing and easily gets out of hand past say ~50 items Drop-down list: Displays the person_id instead of the nice human understandable value name. This i…

I have a People table with a Roles field with "staff", "faculty" and "students" in it using checkboxes. I can create value lists off of this table filtered by role. No problem. But I also have the field Status denoting Active Faculty. When a constrain the relationship by two fields, it breaks. Is it possible to do a value list filtered by both fields? Should I just write a script to do a find, then copy the table, and base the value list on that table? Thanks! -Jeff

I have a database that is used to monitor maintenance callouts to various buildings, these records are classified as either 'open', 'pending' or 'closed' from a drop down field menu. When the field is changed to 'closed' how can I prevent all the rest of the data in the record from being modified? Many Thanks, Dominic

Hi All - I recently did some fooling around with value lists based on some responses to a different topic that I posted here. As a result of the fooling around, I stumbled across something that I thought was interesting so I thought I would post it here. I don't know if maybe it's already been discussed, so forgive me if I am reiterating a past topic. Here goes... So, the general rule of thumb is that you can use calculation fields in value lists only if they are indexed. I found a that you can actually use an unindexed calculation field in a value list if you also show a second field and you sort by that second field. The important thing is…

Please bear with me because I only have a very basic knowledge of FileMaker. I have a database that contains a list of software and their respective serials and users. I want to be able to select a user from a drop down list and be able to view (and print) a list of that user's software and serials. I've been struggling with this for awhile and I'd appreciate any help.

Hi all - It's been awhile since I have posted. I ran into a little something that I can't seem to come up with a solution for. Hoping you can help..... What I want to do is create a list of items in a single field on a single record and use the contents of that single field as a value list. The problem I have is that when you use that field in the value list definition and then assign that value list to a field as a drop down list, FileMaker sorts the values alphabetically. I actually want the value list to appear exactly as it appears in the field. For example, the field might contain: Red Green Blue Yellow I want the drop down list …

I have a drop down list for "part numbers" in upper case & "description" in title case in an inventory database containig over 17,000 records. Can I format the drop down lists to show in caps lock or title case? Some people who have entered data have entered them in all different case formats so the drop down list looks very messy.

I wonder how to add a auto enter calculation to show the first value in the fields value list? So when I create a record it fills the field with the value list first entry. Thanks

Hello I'm a newbie and I have a problem... I want to do what I though was a VERY simple thing, but I'm blowed if I can find the answer anywhere. I want to be able to have a specific value list show in Field B depending on the selection made from another value list in Field A. Eventually, I may do this to 3 levels, but for now, 2 levels is all I need to know. I thought I'd link to a PDF file showing my problem in more detail as I find diagrams always make more sense to people than me trying to explain! Auto-selecting Specific Value List in Field B Depending on Choice in Field A Many thanks in advance... Jo PS: A word of warning, I am a …

Is it possible to create Header's and Sub-headers within a value list, while using the checkbox feature? I don't want the Headers to have a checkbox next to them either.

Hi All, I am creating a database for a yearly tradeshow that houses all company and sales information. I have created a separate pricing database. Currently the database pulls the pricing from the other via a sales ID. This works great but there are approximately 106 items to sell. When next years show comes into play I am assuming I have to add another 106 records to my pricing database with the new prices. The sales ID is a drop down list to choose the item, if I add another 106 records, the drop down list is going to start getting ridiculously long. Is there a way to pull only those records that pertain to the specific year I am currently working with? The pricing da…

Hi, I have done a popup list using Fenton method ( Here ), but it doesn't look very professional. When the window pops all the layouts under resize. Is there a way, to let all the layout to there original window size and only the popup to showup in exact fit? Nick

How can I use the conditional format to change the background of a field through a value list? I have 2 fields, field 1 is the conditional field and a second field that has a value list attached. (None, Red, Blue, Green...). So the idea is change the value list and field 1 gets a different color. Thanks