Value Lists

Hello, Here I am once again fighting my particular war with conditional value lists. I have several car fleets. Composed by cars that can have one or many owners. Where I'm stuck is when on a day plan, I select the fleet I'm going to work on, and once selected (everything seems ok till now) I want to choose (via conditional value list) any owner of that fleet. I can't accomplish this last step. As always I try to explain my idea as good as I can in english, but I don't get it all the time (sure comment is going to quarrel, hehe, it's a joke). I attach a sample file to cover the gaps of my explanation, hehe. Thanks in advance for the help. …

Hello Sorry for the question... certainly asked numerous times. I am spending two days trying to understand the concept but didn't catch the idea to implement it. My database is a medical invoices one. I have one table for patients administration (one of the fields is a calculation field with his/her age in years depending of the birthdate), one for invoices, another one for invoice lines, and another one for medical examinations provided by our office (including the Minimum patient age and the Maximum patient age for each exam). The medical exams list is provided by a pop up menu for each invoice lines. After selecting the appropriate exams, t…

Hi everybody, I have the following situation: I have a product table. This table is related to a supplier table and each product can have many suppliers. Now I would like to crate an order based on a supplier. when chosing the dropdown list the products to be shown should only be the products related to this supplier. So I have an order table which relates to to the product table by means of line table (the order might have more than one product) In the the order form I have a portal with the line table. The line table has a pop-up menu with a value list showing the products form the products table. Now I would like to be able to include the value…

I know this is "out there", but I must be muffing the search criteria so my apologies for this being covered elsewhere. I have two related files (by StudentID number), Application and Student Database. I've set up a global field in Student Database where a user clicks on its Menu-style value list to show the names of students in Application; what I want to do is show the names of students (from Application) who don't have an existing record in Student Database. That way, it'll reduce the thousands of records/names our clerks have to plow through to find only the ones that don't have a record in Student Database; after the name is selected, a script trigger will fire …

I'm working on a timesheet solution where the user selects the "Role" that they're performing from a preset list of values, and then I want to populate a list of possible values for their "Task" based on their role. Role table includes a field called Billing Category (with 5 possible options). Task table also includes a field called Billing Category. My relationship for the value list is Role::Billing Category = Task::Billing Category. Two of my Role::Billing Category options will share the same values in Task. The remaining 3 have unique lists. I tried to use a checkbox for Task::Billing Category, to indicate that one task can have 2 billing cate…

I believe some of the functionality of creating value lists in Filemaker is broken when you want to display values from a second field for a relational database when using Value list subsets created by a case statement. Let me explain. I have a relational database that contains a list of Stakeholders in a table. Some of these Stakeholders are considered to be suppliers (consultants, contractors, etc..). I have a field called “isSupplier” – and is set to either “Yes” or “No”. I can easily create a list of just supplier names using this case statement for a calculated field called “SupplierList” Case ( IsSupplier = "Yes" ; Name) However, when creating li…

I have a major table that I'm trying to integrate into a drop down menu option - get values from field but I need some help with this... The table has 3 fields, Year, Make and Model (Aircraft), so the values look like 1990 Cessna 180, 1990 Cessna 190, 1997 cessna 150, etc etc I'm trying to create a drop down wherein the user first selects the year (menu items calculated from the year field) then once a year is selected, only those makes from that year are shown, then model, only those models from that make is shown. Any suggestions greatly appreciated, thanks!

Hello, This is likely a very easy remedy to this but it escapes me at this time. I have a value list configured as a radio button selection- has two choices - either "no issues" (default value) or "issues". What I'm looking to setup is a script that would open up a popover if the user selects the "issues" radio button. Any quick thoughts? Jack

I have a Value List with names of our "partners" (each name on separate line). I have a database with a "name" field. I'm just trying to setup a script to run and check if the "name" matches a names on the "partners" value list. But, no matter what I try, it never comes back as "true." Any advise? Does this look correct below? Each time, the result is "0" not "1." FilterValues(ValueListItems(Get(FileName);"Partners");Data Recovery Log Excel export Converted::Name) Thank you for your help! Brian

FM 12. I’m using a value list to insert an id from the first field and to display a related name from the second field. I want to use a drop down list to display the name only. I thought I read somewhere you can place the name field over the id field to do this but I can’t get it to work. Any suggestions? By the way, is there any simple way to refer to a value list that uses two fields?

Hi Guys I am new to filemaker and I am hoping someone out there can help me. I work for a small printing company and I am trying to create a stock ordering system. I have a created a database with the following tables Supplier, Stock, Orders ann line items. What I am trying to achieve is to link specific stock items to the specific supplier and then to create an order for a selected supplier to order only sock that is required from the supplier. I have attached the database I am currently working with. ( No management username ) My problem at the moment is linking the stock to the supplier. Hope this all mak…

Hi Guys anybody know how to sort a numeric value list that is propagated via field values? By default its lists as 1,11,12,13 etc. I would like it list as 1,2,3, etc. Many thanks for any advise

Hi! Sorry a bit new to this still, but I have one table which contains several variables: DateOfConsult and ConsultType (InPatient or OutPatient). I have a layout for data entry in Form View and second layout in a List View. In the List View, I wanted to create a dropdown menu showing the DateOfConsult and the list will show all the people who consulted for that day. For the value list I have two objectives: 1. To show only the dates with OutPatient Consults. 2. To sort value list with the dates in descending order. Hope someone can help! Thank you!

Hello everyone, Really excited with everything I have learned recently about FM. But I think I hit a brick wall. I'm building a database for a private book library, and I got to the Author field, which turned out to be slightly more complex than I expected. Most books only have one Author, but there are quite a few with two or more Authors. And some of those are collaborators, not necessarily Authors, but I still want to mention them and their roles. Really complicated (or at least I think it is). So, I understand that the best way is to have a single Table for Authors, where I will enter everyone, either they are main Authors, Co-Authors, Illustrators, etc…

I am new so please be patient. I am trying to figure out how populate a filed based on a conditional value. I may not be stating this correctly so I will explain. I have created two databases one called "committees" and one called "committee membership". The committee table has the unique id filed "committeeid", "body", and "committee" fields. the committee membership table has the same plus fields for "memberid" and "position". I have created a conditional value list whereby I can choose the body and it will allow a drop down for the committee based on the body. Is it possible to then populated the "committeeid" based on this information? the idea is if I hav…

I have a value list that includes the "Personnel::UID" of all managers in my personnel table. (Determined through a self-related table where "Personnel::Manager" = "PersonnelSelf_Managers::UID". I included a screenshot of the relationship.) I want to compare a single value ("Personnel::UID") against the contents of that value list to take action (show or hide some data on the layout) based on whether the person in question is a manager or not. Can this be accomplished with a calculation using ValueListItems? I am having a hard time figuring it out. Is there a simpler way to do it? I am trying to minimize the creation of lots of random fields that could be h…

I am using a value list with a person's affiliation. They consist of offices, commissions and committees held. I know where to go to edit the list. When I print a report it prints phantom values. There are a couple that I originally created but do not see them in the list nor are they assigned to anyone. When I print the report it shows the value with no one tied to it. How can I find this phantom data in order to delete it. Many thanks. On further review - I think my difficulty can be in one of my three tables that are tied together. When I try to see what is in the Affiliations table I can only see one of the affiliations per person. It keeps the …

Has anyone come up with a way to nicely add a couple of static options to a value list generated from a field? For example, assuming I have a field that I'm using to create a value list. I want the exact same value list, but with "All", "Mine", and a separator to appear at the top. I figured out a way to create a value list that includes "All" and "Mine" in addition to the names in the field the values are drawn from, but the words appear in their alphabetical order, not at the top. My fallback solution is to have radio buttons for "All", "Mine" and "Values" with the value list only showing up if the user selects the "Values" radio button, but this wouldn't be a…

Aloha Everyone, First off I'm ESL and my gramma is not up to par with an English major. Second, I'm a photographer and not a programmer. That said, I am determine not to let that stop me from learning FM enough to program me a simple but functional DB. I'm familiar enough to understand and get around FM and it's back end but have not spent enough time to know it intimately like one who spend everyday in FM. In other words, I know basic of FM parts and functions and attributes but have not had the opportunity to learn how to connect everything together to make one simple idea to work. Lastly, I'd greatly appreciate you all for taking the time to help me with my…

Hi guys! I need to make a drop down list depending on a value selected, here is what I have: Basically I have a database for assets. I need to store the location of where the asset is, depending on the city it may have different factories, so the asset is in one of those factories. So for example, the city of Miami has 3 factories, when I register a new asset I must pick the city and then the factory in where it's gonna be. How would I do this with some drop down list? thanks for the help

I am trying to import my price sheet (excel file) daily, and sometimes I don't want it to update my fields "Regular", "Pair", "Package", but update everything else in that record if I have my "Override" checkbox checked. If I don't have the "Override" checkbox checked, then I want it to update all fields in that record.

I would like help designing a drop down value list which filters the list based on what is already type in the input field. See example - admin 1234 - When they click on the field the drop down menu appears and would be filtered by the first letter of what they typed in so the user can correctly match up with the exact name - the field data comes in from a web form and I do not want to change the web form - just the value list - thanks ValueLists.fmp12

Hi What i want is that when i create a new record my check box field get auto selected the correct option. How would i script that what ever i try doesn`t seem to get it working. Please can someone help me out with this. Thanks

Hello, I have a problem with making a filtered value list work. I want to have a drop-down list in one of my portals showing only certain records from a related table, but I can't make it work. I have (for the purposes of this problem) 3 tables: "Quotations::" "Line Items::" and "Products::". "Line Items::" is the child in both relationships. The table "Products::" contains all of our stock, not all of which is for sale, so I would like to have a check-box field that allows me to include the item or not in the value list of sellable items. From what I read on the forums here, the way to do this is to create a second occurrence of "Products::" and relate it …

Hello, I am trying to create a daily sales call log, for that I have used Portal for which I am using "company" table in which I have "contact 1" to "contact 12" separate fields for each record (company) Now, on the portal, I was able to fetch contact names dynamically based on chosen company using conditional value list relationship and creating new text field with auto-enter calculation of List(contact1,....,contact12), but how can I fetch contact number for selected contact name for that company? I created a new field to auto-enter calculation of contact numbers like the same way but it seems like I am going in wrong direction It would be great if anyone…

Hi please can someone help me solve my issue I created a manufacturing solution that to every product one can select its ingredients from a pop up menu in a portal. the portal then take you to the related ingredient page where it has additional info about the ingredient my issue is when i created it there were only a few products so wasn`t such an issue scrolling down the list to select the relevant ingredients, but as the solution expanded and more products were added the ingredients list became very large and one has to scroll through several 100 of ingredients to select the one he is looking for. i would like to break up my pop up menu , ie one…

I want to be able to add something to my filemaker system. I've got about 5 items that are currently in a drop box. Right now we select the item in the drop box and then manually type into a comment box about 20 other items that we need. I would like filemaker to help me. When I choose the item in the drop box I would like it to keep asking for the information I need that corrolated to the first drop box. What is the best way to go about this.

Hi Everybody I wish you all a very prosperous 2016 and may all your wishes come true. I have been using some of my holiday time to update my FM solutions, so far I have managed most of what I wanted to do and learned a couple of tricks on the way. Now I have found a roadblock, using different value lists on the same field. I have many value lists based on relationships and they work fine, but in this case the situation is: a) It is a checkbook solution, if there is a relationship it displays certain values (List of debtors/creditors in one field, invoice numbers with balances > 0 in the next and Invoice value on the next). b ) However payments …

I have added an additional TO to sum the withdrawals in a set of financial records by year, Withdrawal YTD column. I would like to show the yearly Withdrawal YTD sum in the last record of the year only and be blank in all of the other months in the given year, it may be Dec 31 or may not. All of the records would still be there, only some the values in the Withdrawal YTD column would be blanked. In this example only these values would show in the Withdrawal YTD column. Dec 31, 2008 $8,000 Dec 31, 2009 $9,000 Dec 31, 2010 blank Dec 31, 2011 $10,000 Dec 31, 2012 $11,000 Jul 31, 2013 $12,000 Before data below.

We recently upgraded from FMS 11 to FMS 14 and we noticed different behavior in our drop down lists. say we have a value list of the numbers 1 to 100 and we have a drop down list that uses that value list. If you have Auto Complete OFF you have this behavior: click in the field - scroll down and choose 50 - click out of the field - click back in the field and the drop down list will already have 50 selected and you can easily click on 51 as it is next in the list. If you have Auto Complete ON you have this behavior: click in the field - scroll down and choose 50(or type ahead) - click out of the field - click back in the field and the drop down…

I have a table named "city" I have many records and record more everyday. I have done value list with checkbox set. I can find with multiple checkbox. I did it in my project. I can select one by one in find mode but I can't select all by one button. I need just select all in find mode one button. Checkbox.zip

I have been creating a sports card database. I think I've got all the bugs out of the main database and the feeder tables. Now I'm on to working on getting the finial reports/tables from an idea to a working filemaker table. So, this is what I have in mind. I want a table that at the top, I have Manufacture, Brand, Year, Card #, and Sport. This table would pull from the other tables to get info. Those areas are easy to configure, but I want to be able to see what cards I'm missing in a set and what I have for complete sets. As you see from the screenshot, it has check boxes by each card number. I was thinking of mirroring this, but I am having a hard time on thinking of h…

We have a table of Suppliers. We also have a table of Tasks. When defining a Task, the user chooses a Supplier from a value list that is filtered by Territory. i.e. the Task will have a Territory defined and only the Suppliers operating in that Territory are selectable. However there are some Suppliers that work across ALL territories. I would like to have a way that these Suppliers are included in the value list for ANY territory, so if the Task has the Territory defined as (say) Sydney, the value list will show the Suppliers relevant to Sydney AND Suppliers that cover all territories. Ideas?

Not sure if this is a bug or a feature. Has anyone else noticed this? When editing a Value List, specifically, entering carriage returns, then copying the whole list to a text editor BEFORE saving changes to the VL, a text editor reveals a high-ascii character in place of the newly-entered carriage return(s). Only after saving the Value list, does this char "convert" to a carriage return. Curious feature.

I am trying to make a list that is select-able and the values are base on another field. I have tried the following but for some reason the values are all or none. If(at_client_sn=814; List(at_department; "ALBANY MEDICAL CLINIC"; "ALBANY SURGICAL ASSOC"; "ALBANY SURGICAL CENTER"; "ELM ST. PROFESSIONAL"; "EYECARE ASSOC"; "GEARY ST. CLINIC"; "INTERCOMMUNITY HEALTH"; "LEBANON COMM. HOSPITAL"; "LEBANON IMAGING DEPT."; "LEBANON SURGICAL ASSOC."; "MAIN ST. CLINIC"; "N. LINCOLN MEDICAL PLAZA"; "PHYSICIANS REF. NETWORK"; "REBOUND PHYSICAL THERAPY"; "SAMARITAN ADMITTING"; "SAMARITAN ENDOCRINOLOGY"; "SAMARITAN HEMATOLOGY"; "SAMARITAN INTERNAL"; "SAMARITAN NEURO SURGERY"; "SAMARIT…

Hey there, I'm sure others have come across this issue and I've even done some extensive research prior to asking for help. I have an employee database set up and I'm attempting to set up a scheduling module. I'm no stranger to conditional value lists, but this has me stumped. In my parent table I have my employee details (including job types and classifications). In my child table I have all the necessary scheduling info. I currently have a conditional value list that allows me to pick employees based on job type and classification. Since employees can be booked on various jobs at different sites, I need to add a date filter to keep folks already booked that day…

I am new to Filemaker and developing a document manager in FM13. I have spent a lot of time trying to search this forum and others to find a solution but, probably due to my ignorance, I have not found (or just missed) anything that has been able to move me towards a viable working solution. I have a master list of keywords that I am using with the intent of simplifying navigation instead of using a bunch of cascading portals or drop downs. This approach seems to be the base of my issue. From the image, the portal on the left side is the keyword master list based on the demo by 1-More-Thing, which is populated using executeSQL. Initially, I tried to setup value lists to …

This should be easier, but I am having a small issue on how to limit records in Drop Down. Currently, I can not get File Maker from showing all my records within the Drop Down. Even when File Maker has a limited found set. See attached fmp12 file Help. Here are my records: If I click on my Pending script it creates a found set of just pending: But if you click on my DropDown you get all the records. I just want the pending records. How can I limit the Drop Down to represent only those records that I have in my found set? Thanks in advance, Chuck Help.fmp12

I am new to FMP so this maybe a pretty elementary question for some of you. What I want to do is have a dropdown list that is defined by certain options that I have pre-defined. In my example these would be Serial key, Credentials, keygen, or patch. If serial key is selected i want a text entry field to appear below or next to this dropdown list. if credentials is selected, I want to have a username and password text enter field to appear. If keygen or patch is selected i want to have a hyperlink entry field show up.

I have been requested to produce a report consisting of Employee Names, each with the single task assigned to them. I have a large DB table ALL_TASKS where each record is a unique TASK_NUMBER, and each record has an employee assigned to it (EMPLOYEE_NM) from a value list (unique values from the field EMPLOYEE_NM). There's also a lot of other summary data assigned to tasks, like time to complete, etc. (Tasks are added sequentially all the time throughout our work day). So far I created a new empty table for my report, REPORT_SUMMARY, where each record will be an employee name, with TASK_NUMBER and some other summarized time info alongside it. (TASK_DURATION) I want to c…

I’m on Windows 7 w/ FMP Pro 13. My issue: the text in my checkbox fields is randomly being truncated whenever I print (directly to a printer or to PDF). See attached image; highlights are areas where text is cut off. There does not appear to be a pattern. I had temporarily solved the problem when I turned all checkbox text from Arial to Tahoma, but the problem came back (even though all checkbox text is still Tahoma). Thoughts?

If one sets up a field to validate as 'member of value list' AND If that value list is custom and it includes a dash separator THEN ... typing a dash in the field will PASS validation. It seems that FileMaker gave a single hyphen a special role as separator but forgot to handle it from validation context. Please see attached file. Clear the drop-down on text1 and type a dash in it. I envision some User wanting to select 3.75 (the line between two values) and can't so they type dash in the field. It's the only character outside of legitimate values that is accepted. I went back and checked version 11 and same behavior so this has been here for a long time. Part of…

I have a need for a value list that updates when I update the master list of values in another related table but does not globally update all records where the list is used. For example, I have "customer" table with radio buttons of various subscription rates that are populated by a value list in another table of "subscription rates". What I'm trying to do is when I update the table of subscription rates it will NOT affect individual customer table records and update them. It only affects new customer records created and rates from when the "subscription rates" table is updated. So every previous record before the subscription rates table is updated to new rates will re…

Hello, This is the situation I have a problem with: Two tables - contacts and projects, linked by a joined table to display linked contacts/projects via portals. Many of my contacts can be present in a project, and a contact can be present in a row of projects. I got it working via manual entry of the project IDs and contact IDs. Basically this is fine, but I expect to have a large number of contacts in the database, so that it will be quite inconvenient to enter only the IDs. I made a dropdown menu with a value list, which is better, but still not ideal as I can't use the Filemaker "auto-completion on entry" field function, because I have to display the ID and the …

Hi everyone, I just started using Filemaker 14 and I have an issue I just can't figure out. I have 3 product levels that are based on each other using conditional value lists. The final amount of products is about 200 so they are divided into 3 categories and about 15 subcategories. There is also a field for the failure key. This is also a conditional value list based on the product. I now want to make it possible to have the failure key depend on the subcategory in some cases and on the product in other cases, so basically the failure key has to depend on two different fields that are both conditional value lists themselves. I have tried figuring it out …

I cannot find the right article related to this so if i use the wrong terminology I apologise. i have a list of circuit breakers with fields for their model number, type. Amp, max test value. in a test sheet form I want to select the breaker "model number" from a value list, then the popup list in "type" to be populated from the related fields in the "model number". Then the "amp" popup field from the summary of both "model number" and "type" to eventually automaticly display the "max test result" associated with all these factors. I am experiencing trouble finding references to this type of thing but I may be searching in the wrong place. Even if I could get pointed …

I have a database in which data could be in one of two places. This tracks games between two Magic players, and Games::FirstDeckName holds the name of the deck that pays first, with Games::SecondDeckName holding the other deck. I have a layout that presents the user with a means of selecting any deck that has played any number of games greater than 0 (Matchups::Friend), then selecting from a list of only those decks that participated in those games (Matchups::Foe). It then shows their records against one another and summaries of the games, with the summaries acting as links back to the related games. That works great. However, the second menu uses a value list constructe…

I'm confused as to how to make the filemaker "type ahead" feature work. I need for the field in my table to lookup values from my value list but by typing it out instead of being a drop down menu. and then if the name is not found, It needs to be able to go create a new record in the other table. I am familliar enough with having to do the last part, but the first part is simply not working. Also, is this "type ahead/auto complete" feature work in Webdirect? We have a chart of Job codes, and a chart of clients. I know how to format most of these things but using this particular feature doesn't seem to work... (should i type 1502 --- it doesn't give any data when the…

Hi - I hope someone can point me in the right direction. I am trying to create a simple database (to help me understand a principle) before using the concept in a more complex solution I am trying to design I have three tables People--<Employment>--Occupation In other words I want to record a person's job history. I have set up Employment as a join table, with allow creation of records in this table checked. I have made a portal to record the employment history and this seems to work; populating an employment field in the portal via the Occupation foreign key using a value list based on the Occupation Name from the Occupation table. This also seems to work. Wh…

I remember doing this in the past but just plain forgot the method. I have a "text" on a layout which asks for one of two checkboxes to be selected (i.e. Answer= ☐Yes ☐No). As it is now, both checkboxes can be shown as "checked" (or "not empty). I want it to be set up so that if "yes" is checked and then later "no" is checked, the checkmark in "yes" will disappear. In other words, only one of the two boxes can be checked. Additionally, could there be a third box (i.e. Answer= ☐Yes☐No ☐N/A) which would work the same way with only one being able to show a checkmark.

Hi, Not sure, I looked for a title that specifically said "Custom Menus" and I thought there was was one. Anyway, I have client that we've set up a "Custom Menu Set" please see attached pics and they want to format fields. Baring giving them administrative access, how can I provide this. Every attempt I know of to turn on the "Formatting Bar" has proven to be uneventful. I can show the "Formatting Bar" but it is grayed out ... Why?? The only way we get the formatting bar available is if we log in with "Full Access". And that is not going to happen "EVER". So how do you do it. Where's the secrete decoder ring? Thank you. Tom

HI, I don't know if I've done something wrong, but the attached is a copy of the relationship for staff table. The global field is set on login to Active and that status of the teacher is set to either active or Leaver. When I then create a value list on the Staff table, it is also showing the leavers which I dont' want to happen. Any help is greatly appreciated. TIA.

Hi - I suspect there is a straightforward way to do this but I can't find it!! I am creating a solution to store then analyze some of my surgical workload. I have a table called "Operations" and this is related to another table called "Occupations" via a join table called "OccupationAtOperation". What I would like to do is have a field in the Operations table that is populated via a pop-up menu that is looked up from the relevant field in the Occupation table. I can create such a menu using a value-list, but I can't figure out how to add to the list without going to the Occupation table itself. Is such a thing possible? Can I enter the Occupation field in the Operati…

Hi! I am very new to Filemaker Pro 13. I am creating an employee database that records all trainings they have taken. My layout is all set up EXCEPT I can not figure out how to create a summery/list of trainings that are only applicable to a specific employee. I have about 100 different trainings and if a particular employee has taken the training I have an "x" on my very large excel spreadsheet. How do I create a formula that will generate a list of all trainings that have an "x" in my excel spreadsheet that correspond with each employee? I do not want to have to list every training ever on each record and have to scroll through and find the ones that have a check next t…

So, in my database I have already been able to Create a Crew list, for a project. However, Each Call for a project can have varying or even the same crew members. How do I set it so that i can create a Check list for crew from the pool of crew already assigned for a show? The crewxstaff contains all the crew, staff availability contains/tracks if a person is available, Crew code are their initials and each part (crew), call, Show have their own id. I don't want to have to use finds for this purpose. I also want to be able to assign each call the crew from a field that contains crew codes separated by space. Also, I want to be able to if a crew member is not found, the …

I am a new developer and have a small problem I can't figure out and hope someone can help. I created a text field that uses a pop-up value list for its values and want it to use one of the choices from the value list as a default response. Any help would be appreciated.

I seems to have done this before - but I cannot get this to work again, and I cannot seem to find the exact answer. (2) tables - Assets, Students I have fields Assets::Item a simple text field, and Assets::PermissionOnly - A number field. On a particular layout, PermissionOnly is a checkbox set, attached to a value list with custom values of 1 and 0. I am trying to create a conditional value list so that Students::PermissionList displays checkboxes of items with a value of 1 from Assets::PermissionOnly. Which can then be checked, when permission for a particular item is granted. To make the first attempt, I decided to wait on the checkbox set and use a portal to view…

I want to have a list of all records (their names and id number) in the found set on the side of the layout and be able to select records and see related information while still being able to see all the rest of the records in the list. Thanks for the time!

Hi all, Attached is a sample file that contains the problem I am trying to solve. In short, I would like a value list to display in FIND MODE all of the WORDS that have been used in creating WORD ASSOCIATIONS. The table is WORD ASSOCIATION: a WORD can be associated with another WORD. For example: CAR is associated with VEHICLE (a synonymous association). I have the "creation" of a WORD ASSOCIATION functioning. I also have drop down value lists in "find" mode for each of the two WORD fields functioning: they show only the values that exist within their respective fields. However, a User should be able to (in "find" mode) select from a single drop-down list that displays …

Hello there, on a list layout, I am showing the main fields from this tickets/service orders database, if the user wants more info he can just click on the "more info" and go to the layout that shows the full record, but sometimes the user wants to see just one extra field, lets say total due or date closed etc, is it possible to make a value list that lists the name of all the fields not showing (I can simple make the value list names), then based on that selection, show that specific field on the list? I was thinking to have all the "possible" fields stacked, and set to hide unless their name is on a global field, and then with a on object validate script the value lis…

Hello, I have a Employee_Table that holds records of employees including their Employee_Code. I have a Employee_Codes value list being generated from the Employee_Code field. Employees are users of the system and log into the system with a limited privileges set to view and edit their own record, no other records. I have a Meetings_Table related to the Employee_Table in which employees record meetings. One of the fields to be filled in is a Meetings record that uses the Employee_Code value list - from which I want the user to be able to select from any current employee's Employee_Code. The problem is, that they only see their own Employee_Code in the value list. Th…

Hi, I've got the attached script which takes the users account name and and then based on the relationshihps returns their staffID, DeptID and then a list of staff members in that dept. This code brings back all employees in that staff table related to that department, irrespective of whether they are Active or Leaver. How do I amend this script / relationship to return only Active members of staff? TIA

Hi guys, I have a strange problem with a value list in one of my databases. I added a value list and set it to display a list from a field of employees. It worked for a while but after closing the database and re-opening it, the drop-down value list no longer works. I then checked in File>Manage>Value Lists and my new value list has no name anymore and I cannot delete it or edit it, it is just completely bugged out! I thought I would try again and re-create the value list and set it as the drop-down, but exactly the same thing happened, it has no name and is undeletable/uneditable! Now I have two bugged out value lists stuck in my database and I am unable to remov…

I started building a very straightforward project with 3 entities/tables: Clients, Projects and Invoices. Clients have a 1-to-many relation to Projects Projects have a 1-to-many relation to Invoices I started entering some dummy data in the 3 tables. I populate the Products table through a pop-up menu, that selects client names (e.g. K A, K B, K C etc.)Â from a dynamically generated value list (showing the name field of the Clients table. So far, so good, it all works. But to my surprise, the pop-up menu additionally starts showing index fields from the serial index of the Clients table (IDp_Client). I really can not see how entries from the index field (e.g. KLA00…

Here's an odd one.... I'm building a value list of data which comes from a static field in a relationship. That builds just fine and changes as I nav the parent record set. And example of the list might be: iDRAC (00:00:00:00:00:02) Server On-board 1 (00:00:00:00:00:00) Server On-board 2 (00:00:00:00:00:01) That's a combination of NIC ports and MAC addresses on a server. I can confirm the list is correct by using the Data Viewer to monitor: ValueListItems ( Get ( FileName ) ; "Server Ports and MACs" ) I want to be able to select from this list in a field but when I apply that list to a checkbox field the options display as: iDrac Server On-bo…

Greetings, all: (With three topics posted in under two weeks, you know how my month is going. :S ) I apologize if this topic has been covered elsewhere in this forum--I looked but just couldn't find an answer. I have a text field with a value list of school grade levels (K, 1, 2, 3 ... 11, 12) that's in a checkbox form on a layout; teachers often tick more than one grade in that value list per record. Fine. However, parsing this field set-up is a pain when it comes to producing summary reports (though there is a "Magic Key" way of doing it--see http://filemakerhacks.com/2011/07/31/magic-key-and-check-box-reporting/) . Magic Key looks interesting but from what'…

I'm at my wit's end trying to manage this value list. I'm writing out the way I have it set up, not because it's working (it's not), but in hopes that a real-world explanation of what I'm trying to do will foster discussion. The goal is for a list of events to display only events that are in the future. The records being referenced must continue to encompass the past events, but in the place where we're seeing them, we only want to see events that occur today or in the future (because there's no sense letting people register for events that are over). The base value list is already set up as field contents: Use values from: rel_events::UID Also display value…

Not sure where to ask this one, so here it is. This one is for fun - tracking lottery numbers. I've got a file that I've entered every lottery draw in the state since it started (the list is downloadable online and I was able to import it to FMP). Here's the problem. (And it's not a huge deal but since I can't figure it out, it has become a challenge). The list shows the balls for each draw in the order they were drawn, not numerical order. In other words out of 53 balls, let's say tonight they were drawn as follows: 7, 53, 24, 16, 10, 40. My file has 6 ball fields labeled One, Two, Three, Four, Five and Six - I spelled them out since numbers get messy in …

I have a layout with a drop down list. The value list it uses is just a simple custom value list with two values.  It shows a "o" in front of the value. I copy/pasted the exact same field on the layout and on the new one it appears normal/doesnt have the anomaly. (it looks like its a o or 0 in a small font, or possibly the degree sign - cant exactly tell which character it is.)  See pic to see the two fields side by side - I have absolutely no clue what is going on here. The simple fix for appearance would be just to delete the original value and use the copy/pasted field - but I'm worried that there may be something other than just an appearance thing going on.…

Hi, I am a newbie to FM. I have a question that I can't figure it out and decide to ask in forum. Hope that someone would expain the following. I create a new FM file using start solution called "Personal Records". When I clicked the search icon (magnifying glass icon) in the "Personal Details" layout, FM jumped to a list layout called "Personal". I understand how to create this part. Now I notice the records in "Personal" list layout are clickable and when I click any record, FM goes back to "Personal Details" form layout. I don't understand how to do this. I look at the layout trigger but I see no connection. When I edit "Personal" list layout in layou…

I feel like I should know how to do this, but when I think about it, the only ways I know how to do it will not allow another part of what I want. What I'm after is to make something like a rolodex. The way I know how to do it, you end up with a list of found records, with a script for the alphabetical "filter," when you want that. The thing is that the only way I know to do this, you end up with a small body part, like in the Contacts starter solution. But I also want to have my virtual list sidebar alongside, because that's how I'm handling my navigation between layouts. Obviously, the way I know how to make the rolodex is in conflict with the size of bod…

I don't want to waste time and irritate someone. I'm having trouble figuring out if there's a certain forum where a question about the Virtual List Sidebar might be posted. I'm new here, and wondering if this "General" group is a place to ask for such help, or if I should be going to a specific section of the Forums. Thanks. -- Rick Horowitz Filemaker N00b (but with experience on other areas of programming)

Hi All, Am I going crazy or is there no way to sort data displayed on a popup menu? I have a popup menu that takes its data from a value list. The value list looks at a table in my FM solution and uses the ID field, also displays from the name field and has "show only values from second field" checked. This gives me a great list. However, my client has asked for custom ordering - we have a new field in the table called "display order", my clients will go in and give each record in the table a numeric value and then want the popup list ordered by that rather than the default ordering. Is this possible?! Many thanks

Hi, I've got two table Staff and stafftype (which are linked via a relationship on StaffType) with which I've created a value list so that a staff memebr can be chosen on a layout through a drop down box. My stafftype table tell me whether the member of staff is a teacher, TA or support staff. Currently my value list is displaying all staff in the staff table. How do I make it conditional so that it will only show Teachers or TA's? I will end up creating a number of lists to show each type seperately due to how they need to be used in the layouts. Thanks Ann

Hi. I'm making a database for employees and as there are family members within the business, I want to break-up the names as follows... 1 - Prefix: [Mr Mrs Miss Ms] 2 - First_Name 3 - Second_Name 4 - Last_Name Then use a calculation field to bring them all together as so - [Prefix & " " & First_Name & " " & Second_Name & " " & Last_Name] Then when making new records for say something like 'Disciplinary Events'... wish to be able to choose an employee from a drop-down list. Obviously I do not want to use a values list for the drop-down made-up from either the First_Name or even the Last_name, as there are family employees within t…

I have an employee table, where the employee has a status of "Active" or "Inactive". I'm trying to create a Value List of Active Employees that I can use anywhere within the database, in multiple tables. I though I could create a table "TableA" with a Calc Field "Static Active" = "Active" then create a relationship between TableA->Static Active with Employe Status. Then create a value list based on TableA. but that did not work. I end up with a blank dropdown box. In the same database, I have multiple tables that are going to need this value list. I originally created multiple instances of the Employee table and linked to each table. but that's multiple rela…

I'm looking to create a popup that determines the choices in another popup. Example: At kbb.com, looking for car makes and models, if you choose Ford in the first popup, popup 2, to the right of popup 1, lists all Ford models. If you change popup 1 to Toyota, popup 2 becomes all Toyota models. Can anyone here please explain this process? Thank you in advance.

If i have a checkbox field. How can i make a script that goes through the checkbox selections and creates a new record for each selection i choose. Example Checkbox field... A B C If I check A and C I want to have a script that goes to a new table and creates a new record for each selection New Table Record A Record C Thanks again for the help!

Hi All, I have a table called "Claims", there is a related table called "nameLink" and table related to that called "name". So there is one claim to many namelinks (claim.claimId to namelink.claimId). Then nameLink.nameId to name.nameId. So the situation is that I have many names to one claim. Currently I have a layout that has claim as my primary table. I have a portal on that layout that brings in all related nameLink rows. The portal has one popup menu, which has data displayed from namelink.nameid, and its values from names table (storing the id, but displaying the name.name field). This works great, I get a popup showing all the names in the name…

I have a field "Completed" for a table "Task." The idea is that it's set to 0 initially, and a user can check off a box to indicate that the record has been completed. I set up the field as a number, with auto-enter data of 0. I set up a value list "yes, no" with a single value, 1. On the layout, for the field, I created a checkbox, and sized it to hide the value of 1, so you only see the box. Before the box is checked, the value stored in the field is indeed 0. However, when the box is checked, the value stored in the field is shown as: 0 1 That is, 0 on one line, and 1 on another (I have another layout that displays the actual value, for testing pur…

Hello everyone, I would like to know if there is a function that obtains the values selected in the group check boxes so they can be counted and represented in a chart.

I set up a portal in a layout for table A with respect to related records in table B. The first screen shot shows the portal -- there is currently one related record, 1041.343US4.   I created a value list that is used in the portal. Thus, in the second screen shot, if I click in the box, you can see all the different values. This is working as intended.   Now, the problem I'm having is that the value list is not showing up for a new related record created in Table B using the portal from layout for Table A. See the third screen shot. If I click in the box, the value list doesn't show up.   However, if I were to enter anything, and pres…

Image 1 Image2 Image3 WorkerList field is a calculated field for which the calculation is : List(Worker::Name) All occurrences are sorted by the created time stamp (descending) as in the example in Image3 I would like the workerlist field to list in the order of workevents so in the example above (Mary,Eric,Ann,Luke) The only way I got it to work like that was by adding another sort for the Worker occurrence as illustrated below the bct field is a calculated field that gets WorkEvent::ct Image4 It works but it's sorting on a calculated field and it's certainly not ideal. Is there an easier way other than using SQL ?

Sorry, I´m absolute new to FileMaker. I'm trying to create a checklist like those found in collectible trading cards. Each record in my database has a collection of trading cards. Each collection has a different number of cards. So, when I enter the size of a collection, let´s say 127, I need Filemaker pro to create a checklist with 127 numbered checkboxes on the fly. I need the checkbox list to be functional, that is, when I click an a checkbox, it performs a simple inventory calculation. Is that possible? I hope it is! I speak Spanish, sorry, if I didn´t explain myself correctly let me know and I will try again. Thanks! Enrique

I'm still waiting patiently for actual Tick boxes! 29 years and counting!!! Come on FM14 you can do it baby!!!

I've got a situation with value lists that I'm trying to find a "simple" solution for. I have a table of records...300,000+ records. I have two fields of interest, Code1 and Code2. Code1 is a general filter and Code 2 is a more specific filter that has values that ONLY occur for Code1. Code 2 is a child of Code1 Example: If Code1 = A then Code2 will only be Red, Blue, Green OR If Code1 = B then Code 2 will only be Alpha, Beta, Gamma. This is inherent in the records. I need to search for specific Code2 values but I need the value list to be filtered by a Code1 selection, otherwise my Code2 value list from field values is TOO long and non-nonsensical. I'…

I am creating a pop-up menu list from a calculation within a table. For some reason the value being displayed is always showing twice. Would someone experienced this problem before ? Pop-up menu (double).tiff

Hello, I have created a database with a bunch of patients. Each patient has a unique hospital number put on their charts. This number is usually assigned to them once they are registered in hospital. In some cases we like to keep track of people who donate bone marrow to another patient and they want to remain anonymous. In this case, we would put a "dummy" number in the hospital number field. I would like to make a value list of a bunch of dummy numbers that would come up in a dropdown for patients with this case. This is very easy as I can make a value list but my problem is that I want the dummy numbers to be eliminated from the value list once used, that way …

Hi, I am new to the forums so firstly thank you for the fast amount of information on this forum and apologies as I know this topic has been covered to death. However, I am struggling to make heads of tales of it. I also apologies for my wording in this post as Im sure I will not use the correct terms to explain myself. Please bear with me. I started to create a database and teach myself by watching tutorials and reading forums. I have made some blunders along the way and I am probably going to have to abandon or heavily modify what I have already got going. In lieu of this I have just made a new database to help myself clearly understand how relationships wo…

To better control the database table navigation I've chosen to hide the toolbar. I've been able to recreate most of FileMaker Pro navigation functions. However, there are places where I would appreciate to get help. I've attached a filemaker sample of why I've done so far. If I want to go to record number 5, I type 5 in the edit box. However, I always have to double-click in the edit box to highlight, clear the number and enter the desired record number. Is there a way for not having to double click. I.e As I am entering the a number the action occur. Also, when entering "Firstname" in search, there are 6 records which are found. A little round green image app…

Sorry this relates to FM 11 Pro, I couldn't find a place to post about FM11. I've had this issue for ages and want to resolve it as it's a right pain. I have a DB with various drop down menus, when connected to a second monitor but displaying on the laptop screen some of the drop downs work, some open the actual list on the second screen and some just open the drop down arrow and never open a list. These have all been created in the same way on the same version. Their performance is always the same i.e if it opens it always opens and if it opens on the second screen it is always on the second screen. As soon as I pull the secant monitor the menus return to normal…

Hi I have a problem with sorting. I need this to properly create food labels. A certain product (e.g. chicken sandwich) contains several ingredients (Chicken, Butter, Tomato, Wheat, etc.). These ingredients have to appear on the food label in descending order based on their weight. Amongst others, I have a table called "Recipe" with the fields "Product Name", "Ingredient", "Amount in g". Here, I add all the ingredients of a certain product together with the corresponding amount (in grams) of each ingredient. There is also another field in this table called "Ingredient_Label_List_S", which is a statistics field that sorts all the ingredients of a product (e.g. …

By default (inactive) my checkbox are grey. When clicking on a checkbox the block is filled in green with a black coloured X demonstrating a selection has been made. I would like to replace the X by something else. For example, having the block in grey for inactive and everything in green (no black) X would be just perfect. I have been using the inspector with many combination and have not been successful. Could someone guide me in where to look to fix this issue I am having? Thanks! Daniel Checkbox - selection.tiff

I have a database for my cabinet shop that has two fields: ACCOUNT & TASK. ACCOUNT is populated with a drop-down value list. TASK is a value list that only uses related values from ACCOUNT For example: ACCOUNT: Doors yields possible tasks of: TASK: Cut lumber, sand lumber, glue lumber ACCOUNT: Drawers yields possible tasks of: TASK: Install hardware, Install drawer Face, Drill handle hole. Is there a way to make TASK an editable field, i.e., when I click into task be presented with related values but also be able to add a value on ad hoc basis?

It's my understanding that the List function (across a relationship) should return a list of unique values. In other words, no duplicates. Apparently this is not the case. Instead I'm using Brian Dunning's UniqueValues CF to achieve this end. What's up with that?

I need a push in the right direction. I have a value list from a related table. All is well; however, most of the value lists contain numerous choices, but some of the value lists contain only one choice. Is there a way to automatically populate the field when there is but one choice in the value list? Thanks, Kevin

I am working on a Class project , which suppose to show the Class, the Classdetails and the Teacher incharge.. Thus, I have 3 tables, Class, ClassDetails and Teachers. The parent Table is the Class, while ClassDetails and Teacher are child tables.. Both ClassDetails and Teacher are related to the Class via the class id. (Classid to Classidfk of ClassDetails) and (classid to Classidfk of Teacher) my layout is based on Class table, with portal based on ClassDetail table.. Now, I want to use a value list from the field in Teacher table, so as to display the Teacher who is incharge of the class.. I have done all I could think of, the value list shows, but if…

So I'm hoping it's not actually so complicated, but here goes: I have a value list called "Active Employees" that uses only related values from a field. This works perfectly. I'd like to create a new value list that includes all of the active employees as well as two other random values. These two separate values are not employee names and therefore I don't want them to show up in other places where I use the Active Employee value list. The goal here is to effectively combine two value lists. I'd be most grateful if someone can provide me with a workaround whereby I might incorporate these two additional values? Thank you in advance,

Using FileMaker Pro 13 I have a view in a SQL Server 2008 server that provides customer id (unique identifier), first name, last name, and full name. I have two tables in my Filemaker Pro database. One represents the external SQL view and the other is a local "customer sign in" table made up up customer id, customer first name and customer last name - and a relation to the table representing the view. I have a layout where the "Enter Name:" entry is a dropdownlist with autocomplete using a valuelist that pulls the fullname from the view. The autocomplete is working well. What I'd like to do is add "First Name" and "Last Name" fields to the layout and have them…

Hi. I need the following. Say I have separate classes, like 9th grade, 10th grade, etc. In each class you have those students in a class. For each student you have the subjects they are taking. Something like that. If I want to click on the class drop down first (say I pick 9th grade) and the next drop down list should be the students in that class (not all the students). I click on a student and the next drop down has that students courses. I click on that and get that course to pop up on the screen. Something like this for giving new courses to a student in a particular grade as well. Click on grade, click on student in the grade and THEN click on all courses out of a …