Value Lists

I have a value list which is the id of customers and it shows second value of their company name. This all works fine and I sometimes put the value list on a layout as reference showing the name only as pop-up except I turn off entry. This works well in that a relationship is not needed to the parent table from companies. My problem is this I have a table of SALES and in it is the company id and a sales rep id but nothing else in the sales table names it identifiably unique except the date. So I want to display in its second description for the value list, the company name and sales rep name and date. However, all that is IN the Sales table are the company id …

Hi Folks, I'm working at my class assessment database and want to get a filtered value list working. I have a portal that shows all assessments and registers for a class. It's based on a ClassAssessJoin table. The records in the Assess table can either be Grade or Register. I'd like to create a value list that only shows the Grades. I think I should do this by creating a relationship between the Grade/Register field and a preset global Grade/Register field, but can't get it to work. Ideally, later on, I'd also like to filter the list by what year the class is as well, but I'm happy to take one step at a time!! I can't find any relevant posts that are at a…

Hi all, Â Any FM12 file I open up (tried 2 so far) in FM13 results in Pop-up menus only showing the ID, and not the second field. See attached screen grabs. Â I've checked all the settings... "show values only from second field" is definitely checked. Â Anyone else noticed this?

Hello everyone. I'm coming back to FM after few years I haven't used it so I'm a bit rusty. I have the 3 tables below: System Department Owner Department and Owner have a relation on the name so I have a conditional value list that allows me to filter the possible owners of a system based on the selected department. Now a system can be used in more departments so the System table I have updated the DepartmentName field to accept multiple repetitions (3) and I have updated the layout accordingly to show repetition 1 through 3. Unfortunately now the conditional value list doesn't work. I would like to display in the list all the owners related to the selecte…

Hi, Hopefully I've posted this question in the right place! I'm developing a maintenance database (spares) and have came across an issue regarding data input of items. When a user creates a new record (adding new product) there could be different wording of products entered. For example 'lamp or bulb','box or crate' etc. What I want is to prevent duplicate naming of items. I'm thinking possibly some kind of buffer table that would compare say a unique manufacturers id and/or supplier and validate the item name on entry?, meaning if the manufacturer and ID was the same then there would only be a single possible value to enter. Not sure the best way to go…

I am happy with being able to create a dynamic list from relationships. What I trying to solve a away to be able to search through (or filter) a Value List of SerialNumbers from a user input of text. Both the search input of text and the calculated value list (calculated SerialNumber field) have a variable number of characters. A user would therefore enter a text string into a field (which can be a related global storage field), then I need the value list to filter based on that string. I can get this working from a exact match (ab=ab etc), but need to know if there is a way of creating a value list based on an index of SerialNumbers? To simply this to explain an…

Hey everyone I am a newbie feeling my way around Filemaker Pro 13. I got a database I am working on and I need some help with something. What I want to be able to do is have a number of check boxes with labels next to them and whenever I put a check in the box it will add digit one to another field on the same layout adding up as each time it's checked. So for example, having students who come and attend a class I want to track how many times they came to class by clicking that checkmark. Having it add the number of times I checked the box, totaling the days. Hope I've explained it clearly enough. Thank for your help!

When clicking on a popup menu in MacOS version, you can type a letter on the keyboard and the list will jump alphabetically to that part of the list; however, this doesn't seem to be working on a Windows workstation. Is this a missing feature, or am I missing a particular configuration?

I compiled a runtime solution with Pro 12 for a mac user and all the fields that have a value list (radio buttons or checkbox set) are not modifiable. However text fields can be edited. On my mac, every things checks ok. Any idea?

Hello, I was wondering if anyone knows if its possible to have a list view that fills a column, but when it gets to the end of the window in that column, instead of a scroll bar it populates a second, third, or forth column. If it fills all four columns it would go onto a new page. You would be able to filter the results by last name by clicking a letter at the top. I made a mock up describing what I was hoping for. Thank you for you help!

Hi all, I'm new here and new to FileMaker Pro and I need a bit of help. I'm creating a call management system and I have three table that I need to interact with each other. The first is the main table called Job_Details which includes a field called Client that is a list based on the table Clients. The third table is Job_Updates which is basically the updates against the job in the Job_Details table. In the Job_Updates table there is a field called Amount which is the rate to be charged for each client. What I am trying to achieve is that when I select the Client from the drop down list in Job_Details it automatically adds the rate into the Amount field on the Jo…

I need to create a value list for a drop down to be able to choose the Graduation Year for students. I'd like the list to include: this year, this year +1, this year + 2, and so forth. I don't want to do fixed values since list will advance each year. Thank you

Hey guys, I have a database that has a address book in it. In the table I have 2 fields one for customer and one for vender. If they are a customer I have the customer field set to Yes and the same for if they are a vender. Is there a way to have a list that only shows the customers or venders. Not all.

Hi, I've been looking on the forum for this, but i didnt find something that matched my 'problem' I am working on a booking/reservation database for a small hotel. I want to prevent rooms to be double booked. So what I am trying to figure out is how to create a conditional valuelist based on the information in other records. Let's say I have a field called: "date booking" with the data "23-07-2014" and a field called: "room name" with is filled in using the conditional valuelist (bullets) and has data "room 1" Now if there's a second ot third booking on the same date 23-07-2014 the valuelist should exclude the rooms already used: so room 1 or any other room is not …

Hi, I have a need where the list of values in radio button format has text values that exceed approximately half the width of the screen. (I know you may see that as a little silly, but it's part of a questionnaire and the text needs to be what it is.) I want to resize the box so that the lines with the long values wrap around to the next line, but cannot see how it's done - if it's at all possible. Does anybody know how/if it can be done please? Cheers, Greg

See attached images. Its only happening when the value list is in a checkbox.Â

I have created a virtual list and I would like the variable fields to have a fixed length so that they align to give a table appearance. Is there a way I can do this? Is there a way to implement tab stops to effect this appearance?

Have a passenger list and next to their name it has 'adult', 'child' or 'infant' in a drop down list. At the bottom I wish to summarise the booking schedule so the person reading the report can see how many times 'adult' was selected for example. The following is in a portal: Age Bracket, First Name, Last Name, etc etc (Adult, Child, Infant), (First Name), (Last Name) etc etc At the bottom of the screen I wish to have: Adults: x Children: x Infants: x Thank you in advance. I love using this forum to learn!

I have a field "Status" = If(EndingDate < Get(CurrentDate); "Expired"; "Current") Then I have a relationship which is set to match "Status = kCurrent" where kCurrent is a calc field "Current". This works great, except... As the date changes, the value of Status doesn't change, since it's an indexed, stored calc field. If I change Status to an unstored field, then the calculation updates in real time. However, the relationship breaks, since you can't have relationships that terminate on an un-indexed field. Is there any clever way to have a value list which works the way I want it to? I suppose I could change the field to a Lookup, and then run a …

OK, my last question turned out to have an idiotically simple solution, so I'm hoping this one does too. I have a Funds table, listing the various pots of money which can be used to purchase a given item. Each fund has a fund_name. There is also a fund_active field indicating whether the fund is still open for use, with values YES/NO. I have a Purchases table. When a record is created for a new purchase, one of the fields is "Fund" indicating the fund used to purchase the item. This field is a drop down value list, which is set to "Use values from field Funds::fund_name". Currently, this drop down shows ALL the fund names in the Funds table, and the list is g…

I have a database that tracks jobs.. Under each job I select which employee worked on that job using a Value list of my Personnel table. The personnel table has 200 names.. but only 50 still work for me. the Table has a Current employee field with values "0" for former employee and "1" for current employee. I want to only be able to select from employee in that table that has a value of "1" What is the best way to do this? The Jobs table is linked with my Employee table Via "Employee ID#" After reading some of the post on this site I have decided maybe the best way to do with is to create Calculation field in the table to Calculate and Full Name only if the Current Em…

Dear FileMaker professionals. I have a question regarding selection one field from a table depending on another field. I have a layout like this: |Room # |v| |Name |v| |BUTTON| It is the entrance form. So i entering a room# and name. All data goes to my table. So in my table i have two fileds: 1)Room number 2)Name of person i would like to use the same layout for choosing person linked to a room number. If i choose Room number 2, in the next field (with drop down menu) i can choose persons who live in this room#2. And next to the second field i have a button that opens a layout with person's details. Do i need to write a script? If …

Greets all:  Brain hernia of the month: What I'm trying to do is create a value list from chosen names in a portal so I can use it in a calculation later for a text field and I'm stuck. (Please refer to the attached.)  I have a table connection between RESUME and CONTACT; of concern in the CONTACT table are the fields, Name and ShowInResume. The portal (in RESUME)  has the filter enabled so it only shows the names within it that have the checkbox in ShowInResume ticked (with an "x"). So far, so good.  What I want to do is place another checkbox to the left of each name so the user can choose which name(s) he or she wants to use as a reference in a résumé. S…

Hi I have a table with standard comments in icelandic and english, named standard comments. I use the field comments::standard comments in icelandic as a checkbox set in a form in a sample table. When the user checks one or more values the field sample comments in icelandic updates. If I uncheck value the sample comments in icelandic updates. I also have a field which is comments in english and is a looked up value based on a relationship between comments::standard comments in icelandic and sample::standard comments in icelandic. When I check one or more values in sample::standard comments the field sample::comments updates but when I check one sample in sampl…

Hi all, Not sure if this is the right place to ask, but here goes… I have a field, control style = Edit box, with Auto-complete using existing values checked. Is there a way to reverse the order the Auto-complete suggestions show up? It shows a–z, I'd like it to show z-a. Thanks.

I have been trying to find an answer to my problem for ages and have had some really good help on the Filemaker.com forum, but I am hoping i might find a different answer here, that is more in tune with what i want to achieve! I need to create a database that generates and stores information about tv commercials that i make. The most crucial thing i need to do is generate new "clock numbers" for each ad. This is a unique 15 digit code in the format ABC/DEFG123/020 - ABC = ad agency code, DEFG = product identifier, 123 = serial number between 001-999, 020 = the ads duration in seconds. I have figured out how to generate a new code for each new record, and its been …

Ok I thought this was simple and I might be making it harder then what it seems , I have searched the web and the forums and I guess I just don't get it So I have a value list driven by a related table I want to search against that value list and if the field matches anything in the value list I want it to give me a 1 if no match don't do anything I've tried the filter values , value lists etc functions but to no avail its always a 1 no matter if it matches or not So Field = LAt Value list = LAT_List I thought is would be as simple as If LAt = (Any Value inside the list LAT_List) Then show 1 If LAT (Does not equal Any Value inside the list LAT_List…

I currently use the Layoutname function to create a list of layouts that I have in a file used for spreadsheets only. This list works great as it allows the user to click on the layout name from the list that they would like to view and the script merely takes them there. Now that the list has grown to a large list, I would really like to be able to filter this list down by one mechanism or another. I have tried limiting the list by the Table that it is associated with but have had no luck. Does anyone have any idea's with this thanks in advance...Chad

I have a field in one table which I would like to auto complete with values from a field in another table. I can see that using a drop-down list will work, but I'd prefer not to ever actually have the drop-down list show. I'm thinking I could use a script trigger so that whenever the user enters that field, a mouse click is performed in that field to make the drop-down go away. Is that possible? I don't see any script step that seems to fit the bill. Thanks, Michael

I have a conditional value list as on my attached picture, which is very simple and shows a company and their products. I pick a company and the next field shows the products for that company. This works well. Companies table holds the company name and the products, order table displays the company name and lets you select the product.(Item). I need to display another company and product on the same layout so i have Company Product Company 2 Product 2 The all must work of the same companies table so i can display 2 separate companies and products on the same layout. Hope this is clear enough. Any ideas?

Hello,  This is my first post in FM Forum and just started using Filemaker days ago.  I would like to register some selected products from the market to recommend that for clients. This way I created 2 (3) tables, Table 1 - Register Manufacturers Table 2 - Register Products Table 3 - Help table for categories according to the tutorial http://help.filemaker.com/app/answers/detail/a_id/5833/~/creating-conditional-value-lists  In table 1 I would like to register product as attached drawing shows, I woud like to achive with some checkbox all together. (This will be about 50 checkboxes) In table 2 I want to register the products via sub categories - kind of f…

Hi, I am trying to sort out our company Database. We have a field called Company_name which is a drop down from a value list with all the company names in it. I have a field underneath called Products. what i need to be able to do is select a company name and the product field only shows the products for that particular company in a drop down list. any ideas?

Hello I have an address list in which I need to choose town and village. Every town has different village names. how to choose correct list after choosing the town? thanks

Hey Guys, I've using a checkbox set to assign people to an event, but the checkbox set is displaying Full Names and actually storing contactIDs. What calculation would I need to display these full names separated by commas ? I'm currently using Substitute ( id_contact ; ¶ ; ", " ) which gives me "C004, C007, C0991 etc..." what I'd really like is to be able to instead have "Name1, Name2, Name3..." I'm sure it's just a case of using a slightly more complicated calculation but I can't work it out James

I'm using Fm13 Advanced. My solution has a form view of products. The form view has three additional fields that I use to flag products as I scroll through them. Each of these flags is a Yes/No, and each has an accompanying field that is used to indicate the customer number/order number. I cannot figure out, though, how to create a list that would be automatically updated each time I flagged a record- and have the list on the form view. For example, perhaps I flag Product A, then Product C, then Product F. I'd like a list that shows what's been flagged. I've tried various portal combinations, but that's not productive. I've been able to make it work using a new wi…

Hi, i have a survey database used to collect client personal data including post codes in UK (United Kingdom). It appears that almost 50% of the time people are getting these postcodes wrong and return invalid data, so they need to be validated somehow. British Royal Mail issues a data file with over 26 000 000 existing postcodes in UK and i need to validate the postcode field against these 26 000 000 existing records, each time it is populated. My first thought is to create a table in a separate file with 26 000 000 (more or less) postcode records and make a value list that would contain the records from that table and that field. Than i would make the postcode fi…

Hi All, Hoping somebody can help please. When setting a field to 'Unique Value', how do I stop it telling me that the value already exists if i'm in a different related record from a different table. I.e. Silly example sorry - Say I have two tables 'Months' & 'Dates' I select January from 'Months' table and go to related table Dates and enter in field with value set as 'Unique' 1, 2, 3, 4 and so on. I then select February from 'Months' table and go to related table Dates again and enter in field 1. Straightaway it stops me and says value exists, yet I want it to exist as as it's a different related record/month. I don't want to set it to have the us…

Hello everyone, I created a database in which the user selects an option from a radio for various indicators. I'm trying to get a count of the following: Â total HE for indicator 1.1 for high schools total EFF for indicator 1.1 for high schools total NI for indicator 1.1 for high schools total U for indicator 1.1 for high schools (continues for all the indicators) Â Same as above for Middle, Elementary... Â Then I want to get a total count (Elem+Middle+High) for all HE, EFF, NI, UÂ Â What I've done is create a flag field where (ex:) HE_Indicator1.1_Flag = If(Indicator1.1 = "HE"; 1; "") Â I've then created separate tables for counts (HS_Count, MS_Count…

Hi, I have a portal showing various records. 1 to 10 say portal row number fieldA fieldb I need do have a drop down value list which only shows 1 value and that should be from the portal row above. Ie 1. fieldAContent FieldBContent 2. fieldA FieldB when i click in fieldA in portal row 2 I need this to show what is in fieldA from portal row1 can this be done if so how? I tried various thing using the relationship model but obviously I can't use calc fields to form relationships. Or at least I think I can't I guess I could use a script that goes to the previous row and grabs the field etc etc.. this may be the way?! …

Hi Being quite new to Filemaker and trying on a pretty limited time to make me a support database , now I have a couple questions. We have a number of products in which the article is described as follows CL25-11, CL25-12 , CL25-21, CL25-22, CL35-11, CL35-12 and more. When creating the post you state exactly as above since the last 2 digits are important in a future support case.. Now I want to create a spareparts list based only on the first 4 letters in the field, like this CL25 , CL35 etc . With a conditional value list and check-boxes I want to select the spareparts for CL25 , CL35 etc, a spare part can sometimes fit several products. its working but now it ad…

This is driving me completely crazy. This must be so simple. I have a filtered value list in my hosted database that does not work until I go to the related layout and come back. I tried to replicate the behavior by creating the following simple database that is a simplified version of my hosted db. Job1Only field is a global calculated field that is equal to 1. Job id number 1 is "Manager" I have a value list that I put on the Holding layout that is used to select a manager from the list of managers of the company related to the holding. So it's a pretty simple filtered value list. Everything works perfectly on my local simplified test…

Hi there, I'm trying to summarise and count unique values in a field and would appreciate any help to make it a swifter process. I just can't seem to get my head around it. My list looks like this ... Large Carton Large Carton Medium Carton Medium Carton Medium Carton Medium Carton Medium Carton Medium Carton Small Carton Small Carton And I want it to look like this ... 2 Large Carton 6 Medium Carton 2 Small Carton Any suggestions would be massively appreciated. Thanks J

Totally new to FM. Using FM12 Advanced. I'm trying to create three drop down lists based on 1. Equipment Type, 2. Equipment Model and 3. Document Name. I would like the Document name list to be dependent on the Model Chosen, The model would be dependent on the type chosen. The overall goal for this part of the project would be as follows: (again, I'm new and may not know how to best implement the logic) This part of the project would be to create documents with merged data by using layouts. So each document (contract) would have a separate layout. The layout would be triggered by the selected document name from the third list mentioned above. I've read arou…

I just got our server and I thought this was supported to work and it does not. I do not know if it is me or the server. Privilege set for PARTS is " Division = Users::Division I thought security removed things which were not allowed. But the value list still shows parts where the division does not match these rights. Do I mis understand ?

Well probably not but it did not do what I expected so I would like to mention it. I have a script which counts the values in a value list and acts accordingly. It is based on 'all values in field'. It recently broke saying there were less values than there were and all I had done was change the sort order of the value list. Please see attached. First button was my original. We did not use this value list for data-entry, only to get the count of all products for my script. Alternate code is not required. But then another situation wanted only the alternate codes to display for selection in another layout and I thought, perfect, I already have just the thing. …

Is it possible to create a value list that consists of the contents of five different fields? I have one table that is called WORKERS. The table consists of five global text fields: Worker 1 Worker 2 Worker 3 Worker 4 Worker 5 I would like to format this value list as a checkbox. When a worker has been certified as being trained to perform a certain task their name would checked in the checkbox list as people we could draw upon to do that task. Is there anyway to make this happen?

Attached is my current setup, structurally correct thanks to Comment. I have reviewed many posts and I cannot find one similar to this need. I have two fields where, if I select one field, I want the other to filter down to only the associated values whereas if I select the other one, I want the first to filter down. Maybe I am approaching this improperly. When we create a Transaction, the person may only know the Unit. I would like only People associated to appear. But sometimes they will only know the person and then I want the Unit to filter down. Should I perform a find instead of trying conditional value list which might not be possible this way? Ideas …

On win OS, is there a keyboard shortcut shortcut to open a Drop down list that includes an arrow? (FM12)

Dear All, I am designing a database for my workshop. The system lets users generate LPO Master (Table) with LPO Lines (Table linked to LPOs). An LPO Master can have many LPO Lines. LPO Lines have quantity values of spares ordered (LPOQtyOrdered). After an LPO Master is made, goods ordered, goods received, a Goods Received Note (GRN is made). This is stores in a GRN Master (Table) with Bin Card Lines (Table linked to GRN Master for Stock in, Table linked to Req for Stock Out). You can order 10 bolts, receive 9 bolts today and 1 bolt tomorrow. So you can make 2 GRN Masters for 1 LPO Master. You can order 10 bolts @ 1 USD and receive 9 bolts …

I have a list of Dogs - each dog has one vet; but each vet could be attached to many different dogs. So I have a join table between the two so that: Dog - dog vet - VetClinic. In the dogs layout for entering I have a portal that should allow the person to pull down a list of vet clinics to choose which one their dog goes to. The choosing of a vet clinic (dog id links to dog idfk in join and vet clinic id links to vet clinic idfk in join) isn't a problem, all the vet clinics are there, but I can't figure out how to make the phone number and address for that vet clinic ONLY show up in the next fields in the portal; I can only get it to display all the phone numbers/ad…

I'm sure I'm missing something obvious, but I cannot find the answer to this. I'm not a programmer, but I had a very little experience with python, and I used to use list variables. How do I use them on FileMaker Pro? I would really love to set a list and be able to retrieve the last value, the first, the third, etc. I remember in python it was as easy as ListName[numberofitem], and I could even use ListName[-numberoftheitembackwards] Am I missing something obvious? Isn't it possible to define a list variable in filemaker pro?

I'm looking to find out if it is possible to filter a value list based on the users privilege set, or perhaps something similar such as an administrator using checkboxes to define what values are available. I would use the Pop-Up menu with a script trigger to perform the "command"... For example, I could have a value list that acts like the File menu: New Record Delete Record Print Report Flag Record for Review A user that is within the privilege set "Manager" could have all the preceding values available, and maybe an additional "Clear Flag" value, but a user within the privilege set "User" would only include the values "Print Report" and "Flag Record for…

One of the features that are in FMP13 is a new option for a summary field that will gather the records into a list ( List Of ). Though it isn't exactly a calculation or function that we were looking for, it is great that we finally get something that has been needed for a while. I haven't tried benchmarking it against copy all though.

Hello, I am wondering if it is possible via calculation to compare a single field with all options in a value list? I am using this as a portal filter. I have several portals on a layout, all from the same table that use different value lists for selection. I only want to display the active records in each portal from their respective value list that was used. I am trying to use this function, but it doesnt work. Each Portal Record will be visible when: Scope::FieldName = ValueListItems ( Get ( FileName); "ValueListName") Is there a different way I can compare this field to all the entries under the value list and see if it matches any of them? Th…

This demonstrates the List Of Summary Field and how to preserve vertical position so that your script can perform its task if you need to include the NULL values. By default the List Of Summary field does not preserve the NULL values. The key is to create a field that concatenates the desired field with some other data such as & "|" & Get (RecordNumber) ListOf.fmp12.zip

hi all i have a value table with 2500 records that one of the fields has a value list. in the value list there is 5 variables on off the called "unicode" i what to delete it. but if i delta from the list is is still saved in the record. how can i do a loop that will delete it from the records? thans dani

I'm trying to get a value list formatted like the following: CALL Initial Inquiry Leadership Call EMAIL Initial Introduction Rep Check-in MEETING Client Sales Meeting Weekly Meeting NOTE Company Background I have attached an example file showing what I've done so far and where I was heading. The issue with my approach (thinking I could use a sorted relationship) is that a value list has a sort associated with it. I've left my example as is though so you can see what I was after. Here's a little more explanation: The header rows are hard coded and won't be changed by users. I added those records to the table and then used a…

What are the concepts to begin understanding to not ever let a field be empty or not one of you possible values you want? For instance: Cat or Dog for the purpose of what you are doing are all you need to receive as data You also never want it to be “”, NULL, FALSE, 0, or Empty (so something like 1 could do) I have started understanding about Auto Enter but this is more of a Validation Issue correct? Does it need to be a Value List or can a calculation do the trick? I guess scripting could be this type of sentinel as well?

Hi, I have a file table that has many Forms. Each form has it's own layout. How can I provide a field my users can click into, list the layout names that I need ( only the Form Layouts ), and have the user select whichever form layout they wanted based on the drop down list. Value List doesn't work to the best of my understanding. And the other alternative is to create a new table just for layout names. Then have a script step check the user selection to the actual layout names ... If ["PatterCount ( LayoutName ( Get ( FileName ) ) ; g_UserSelectableField ) = 0 Message .. Else Continue with script End If Is there an easier way ?? …

If you have a return separated list how could you wrap each line like this? Cat Elephant Woodpecker Dog Mongoose To this <wrap>Cat</wrap> <wrap>Elephant</wrap> <wrap>Woodpecker</wrap> <wrap>Dog</wrap> <wrap>Mongoose</wrap>

Hello, I've read through posts regarding what seem like similar situations, but I am afraid I just can't wrap my brain around the examples. I need to track errors for employees. I need to make the database as easy as possible for the managers to use, otherwise they won't use it. The first field would be the manager selecting their own initials from a simple value list. The 2nd & 3rd fields would allow them to select the initials of the offender, OR, the offenders name. If they picked JMS in field 2, then John M. Smith would get automatically filled out in field 3, and if they picked John M. Smith from field 3, JMS would be filled out in field 2. I …

Hi all, I hope you can help. I have a drop down field in a portal with a value list attached, the value list is a number of different written functions, for example "Set Priority", "Set Normal" , "Delete"... there is a script trigger set to 'OnObjectModify'. The idea is rather than have many different buttons in the portal for these different functions I want the user to select a function from a drop down, and based on their choice, the script trigger carries out the requested task. But everytime I request a task from the dropdown, it always goes to the first record in the portal, despite the 'Go to Related Record, Match Current Record only' setting being turn…

Hi all I'm a little stumped here and after trying numerous methods I figured I would ask for help. I have an Asset table which contains records imported from an external source. There are three key fields in this table: Product ID (SKU), Asset ID, and Department. I have a second table called Product IDs. This table includes: Product ID (SKU) and Product Description. The two tables are joined by the SKU. Each asset department has a separate layout on which their respective records can be modified. Each layout has a search feature that will constrain the found results depending on their department. For example, one of my departments is called Lenses, und…

I am new to FileMaker and I am loving every moment of it. It is so powerful. I have took some training (online) and have been reading on best practices and other related topics. My solutions for my business are coming along, but I am stuck on some areas. I have constructed a database that will collect information for my business. This information will have Topic and Subtopics. It was suggested to me that I try a setup like this. INFORMATION------<TOPICLIST>-------INFORMATION_Topic INFORMATION::pk_information = TOPICLIST::fk_infoparent INFORMATION_Topic = TOPICLIST::fk_infochild INFORMATION and INFORMATION_Topic are both Tabel Occurrences with the same data…

Hi, I need the value list number, not the "Value" base on "A" number. So, lets say I have a value list relationship of ID's ... 345 567 678 786 799 801 Value 799 is number "5" in the list. I can get the value 799 if I manually enter "5", but I have a field where I've built a relationship that puts the ID of 799 into an ID fields base on the customer selection of drop down menus. Based on this ID field ( 799 ) I would like to extract "5" from the ID value list relationship above. And the following functions below don't seem to give me that option of extracting the "5" ( it would appear ). ValueListItems ( Get ( FileName ) ; "Inventory I…

I have a check box that displays two values from a value list. I want to make it impossible for the user to select both check boxes, and required to select one. I don't know if this will cause a problem later, but in another table, I will be reusing the same value list as the source for a check box and will need the option to select both in that record. So the properties that restrict the user to select only one check box in the first table can't interfere with the ability to use that same value list on another table and be able to select both. Should I make another table with just one field and two records instead of the value list and use a validation calcul…

Hi Folks, I’m new to Filemaker and cannot figure how to get past a particular point using conditional value lists. I understand the conditional value list and have it working. It’s a two table file. One table has all the values and fields where we have Breakfast, Lunch, Dinner in a Menu table. A second table called Order has all the food choices related to the Menu table. Here is where I need help. What I want to be able to do is when I click on my final related selection—say Lunch...Hot Dog—is have a couple of windows (fields, portals?) be available to enter narrative data into to fully describe the second object chosen—the Hot Dog. One window entry could descri…

Hi  I'm trying to solve a problem regarding excluding certain records from showing in a drop down list. I have a list of volunteer drivers that are available for hire and show in a drop down list, however there are times when a particular driver won't be available due to holidays, sickness, etc. What I'm trying to do is display just those drivers that are available in the driver drop down list.  I have a table that contains all the driver details including both the driver name field as the drop down and a field called status which points to a value list containing the list of availabilities. I have googled this and been on the forums to read up on value lists …

I'm pulling my hair out over this one. I know I've seen the answer to this one somewhere, but no amount of googling seems to be helping me find it again. I've created a value list that uses values from a "Drivers" table. The first field value is the DriverID, and the second is Full_Name. When I select to sort values using the Second Field, the value list shows only the first record from the Drivers table.

Hi, I have a value list which gets its data "from Field" "Allow editing of value list" is greyed out. Is there any way I can remove some of the values in this list? Thanks Ian

Hi All..! I'm new here as I just started in FileMaker (transiting over from MS Access) so I'm not familiar with everything. I'd like to ask about possible solutions to a problem I am having with value lists. Here goes ... Table 1 -- "look_Category" Field 1 -- <pkID> (Serial Num.) Field 2 -- <Category> (A list of financial categories: "Firm," "Product," etc.) Table 2 -- "look_Product" Field 1 -- <pkID> (Serial Num.) Field 2 -- <fkCategoryID> (Relationship with pkID in Table 1) Field 3 -- <Product> (A variable list of financial products: "All Cap Growth," "Fo…

Hey everyone. I hope this is the right place for my questions. I've recently upgraded from Bento as there's a lot more I wanted to do with my database. Now, knowing what I want to do and being able to do it are two completely different things! So, I have a small (c.1,000 entries) database for my video game collection. It's flat file and contains all my hardware and software. I use forms which only display the relevant information for each item (info for hardware is dramatically different for software) so while I know there will be some data redundancy I don't think it's too big a deal on such a small database. To dip my toe in the water of FM I want to make it so…

I am trying to create a filtered value list based on a property from a related table. The first table is Products. The second table is Customers. I want a value list on the customers layout that shows only the products associated with that customer's SIC Code. There is a field in the customers table that lists their SIC code. For purposes of this solution, there is only one SIC code per customer. I want a value list that will show only the products from the products table that have the same SIC code as the one shown on the customer's layout. I won't bore you with the 200 approaches I have taken - I'm sure I am missing something basic, I have just been looking at the …

i have this portal with 3 records with checkbox box on it and a droplist field for that portal what i want is to show only portal records with checkbox ticked for example if i have 3 records photos, documents and files. If it ticked photos and documents in dropdown list it should be photos and documents only

Hi all, FM 11Adv for widnows here I have a checkbox list such as: Apple, Banana, Orange, Lemon Now, I would like to add another text value to each selected value of the checkbox, in real time. So that when the user select "Orange" in the list, there will be a Custom dialog box that will let her to insert an adjective (i.e. "Good", "Bad, "tasty" or whatever she likes). Finally, I would like to report in a second field the combination of checked value (from the checkbox) and the free adjective I have let the user add, to have: "Orange good", "apple Bad", "lemon tasty" etc... I am trying to play with triggers so that the custom dialog box pops up as far as a val…

Hi, How can I extract the following Values where the "x" is the check box in the value list: Apples x Grapes Oranges Pears x Lettuce x Cucumbers Pork Steak Flowers x Brown Rice I want to auto populate a second field ( below ) with only the check item from the value list ( above ). Grapes Lettuce Cucumbers Brown Rice Thank you. Tom

Hi, i'm creating a presentation of IDC-10 for myself, but can't make it work. I would appreciate all the help. I've this table, which has in the first row the IDC-10 code (CIE10) that matches the diagnosis description in the second row (DX) I've create this presentation, and use list to select data, so when i select in the DX list i will like to automatically put the matched code in the CIE10 field. Thanks IDC10.fmp12.zip

Hi everyone. I’m trying to accomplish a conditional value list and I’ve been working with a few sample files I have (I still don’t get the whole picture of how it works, I always miss something), and I’m stuck (once again, lol). The idea is: Meeting Holdings Companies Executives Is going to take place a meeting where some executives may go. That depends on what Holdings (not single companies) are going to be represented in the meeting. I need to condition the Executive value list to the Holdings they are in. I attach my sample file. Thanks in advance. Conditional VL Join Tables.zip

I have a pop-up menu that displays standard ad sizes for specific publications. "Allow Entry of Other Values" is activated so that users can put in a special size when appropriate. If someone puts in an "Other" value all is fine. However it seems that this disables the value list for that record. i.e. if someone enters an "Other"value and then changes their mind and wants to use one of the standard ad sizes from the value list, it can't be done except by typing the name in the "Other" dialogue box. This is not effective if the user wants to review the available options. Is there a way to ensure that if the "Other" value is deleted, the original pop-up menu is re…

Hi All - Up until FMPro12v3, I used a little trick in order to create a custom sort order in value lists that were derived from field values... I would define two fields in the table in which the field values lived....one for entering a number(Position) and one calculation field(SortBy) that stores a quantity of space characters equal to the number entered in the Position field. So, if the number 5 was entered in the Position field, 5 spaces were in the SortBy field. I would then define my value list to use values from a field, select the actual field that I wanted to display and then select "Also display values from second field" and select the SortBy f…

Hi folks, I'm a filemaker newbie doing my best to develop a personal rental property management database. I have quite a good understanding how conditional pop-up menu menus work after watching several tutorials online. However I'm unable to figure out the task at hand. I'm looking to the following. In the tenants layout I choose an apartment number (via a pop-up menu through the relationship with the apartments table) that the tenant wishes to rent. Once that apartment is considered "rented" I would like that apartment taken off the conditional pop-up menu. Any help/clues would be greatly appreciated. Thanks

Hello Everyone, I was wondering if it is possible to make a field show a different value list based on the outcome of another field. For example, lets say I have a drop down field that contains a value list of "Books, CD's, VHS's, DVD's" and then another field that shows a drop down list that would be unique to each one of the values in the first field? Thanks in advance for any help!

I have a form which has two seperate fields ( Fruit1 & Fruit2) and I would like to create a value list to show both fields...for example: Fruit1 might have values of Apples, Banana, Grape Fruit2 has values of Lemon, Mango I want a value list when the field is selected to show all 5 as a selection: Apples Banana Grape Lemon Mango Any thoughts?

This is a tough one.  I have a Membership application.  I have a popup that works. (not the problem). Part of the data I collect on each Member is if they are "Active" or "Inactive" (Members::ActiveInactive) To that end there is a Members::ActiveInactive field that holds the appropriate "Active" or "Inactive" value.  My tables are :   I have a layout based on Meetings. on the left side of the layout there is a portal based on: MemberMeetingJoin . This holds the members to show at a particular meeting.  On that portal there is a field: KF_Member which is a popup that grabs:              MembersTOC::KP_MemberID and Member…

Hello, I am reading on the forums here and I cannot seem to wrap my head around dynamic value lists in the way my search is set up on my layout for my db. My database consists of multiple tables, only one is significant in my question. My table designated as "main" contains the following relevant fields parental key: pk_main field 1: Last name (text) field 2: first name (text) field 3:Full name (calculation=last+first name) global field: Patient search On my layout I have every letter of the alphabet displayed as a button. When I click it it searches the first letter of the patients' last names and does a find. It works great. I have a global field th…

Hi everyone. New here, just trying to see if what I am trying to do in filemaker is possible, as I am pretty novice with the software. So I have been working on a banking database for a student deposit program for a financial literacy program for schools. The database stores student information such as the school year and the corresponding grade, homeroom, and teacher for that school year. This is all identified by a bank ID # given unique to each student, and I use that as my primary key. We are coming up on the second year of the program, and I need to update these records for the new school year, grade, teacher, and homeroom for these students, as many of the…

OK. I have two files one with GUI and one with the data. Now I want to make value lists but both files seem to be able to create the same value list in their own file using the table occurrence there but also can create a value list from the other file. Is it better to create the value list in the data file since it is closest to the real data? Or is it better to create the value list in file my people will work in, the UI since that is closes to them? When would I use the part that says "use value list from another file" and why would I use it? This is being set up where everything happens in the GUI file. I can find nothing in searching so the question is pr…

I would like to apologize if I am not using the proper naming convention for what I am asking for help with. Until about a year ago, I was a PC woman, who had used Access forever. So, I'm having a little trouble with the same tasks or features having different names. So, please correct me! Here is my problem. My database (I'm the only user and it resides on my MacBook) is for my art supplies. I have my Primary Table, that pretty much holds all the data, related tables, and a few extra tables that I added (Vendor Table for example) for future use. My Primary Table is as follows: tblArtSupplies ArtSupplyID ProductCode ArtSupplyName ManufacturerID Me…

Forgive me if this has already been asked, I looked and could not find anything realitive within the forums and not seraching via google either. I am also very new to FileMaker but have done a very large amount of research and study before starting my project so I do have a farily good understanding of the program. Just to give a better idea: I have a layout for client information and then a checklist(which is on a different table, same table as the portal also on this layout). The idea was you could check off one of the values within the checklist, the value would then autopopulate within the portal: Set up via "Auto-complete using existing Values". Along with th…

I have a value list of the type "Use values from field" and "Use all values". A second field is shown (same table). When I change the record "view" access to "Limited" for the user's privilege set, that user is no longer able to use the value list, even if they have view privileges for all of the records in the table! Popup menus simply display "<no values defined>" Is this normal?

NO NEED to address this query -- I figured it out! Â ------------------ Though I can't seem to find the original thread, I (successfully) learned last year sometime how to create a Value List for a field that offers a filtered subset of a larger Value list depending on a value in a different field. Â The setting is a film archive, and each Record is a media object that with a field that specifies what kind of ELEMENT it is. Â There are several dozen possible values for Element, so to make the drop-down list a manageable length, the available values are filtered down by another Field, TYPE. Â So the user creates a record, specifies TYPE (Audio, Video, Paper, Photo) …

I am trying to populate a fk. The way I am doing it is that I have a value selected from a list via a field in the parent table, and then have the pk corresponding to it in the parent table looked up and auto entered in the fk field of the child table. It worked for one record, got the right pk to populate the fk, but it's not worked since. What am I doing wrong?

My boss asked me to make conditional list fields for a portal, that when I choose a value in a field, I can choose its own options in the other field. For example: There are too many products, with diferent suppliers. What I want is to can choose a supplier in the "supplier" field in a portal row, to then choose in the "product" field all the products that sells the specific supplier. I still don't have acces to the DB to view the tables.

Hi! I have two tables: Client and Contacts. The client table has a Portal that contains a list of Contacts (Emloyees, Contactors, Consultants) What I am attemping to do is one of two things: 1. Create a Value List from the Portal so I can choose one of the Contacts who is the Key Contact for that Client, or 2. Create a Conditional Value List that will list the Contacts related to that Client. For information I have a pop-up menu on my Contacts layout where you choose which client that Contact is related to. I have tried several things, I believe I must be messing upthe relationships. Any ideas?

I need some theoretical and logistical help: My solution is a checkout system which involves penalties when an item is late. The problem is that two parts of the campus (luckily each running their own solution) want to impose penalties differently. My goal was to create a utility table so that I could create one solution that would potentially work for both parts of the campus. My idea: I created one value list that has 12 different penalties (from 1 day to 1 year). I put these on a utility table so that the different solutions could choose which penalties they wanted to implement via checkbox. I then created another value list based on those choices. This…

I have a large database with a multitude of fields where a value list via drop down is associated. However, when we set out to develop this, we didn't know what many of the values in these lists would be comprised of, so we didn't have any strict validation in place. Users were allowed to edit the very basic lists we came up with and we didn't have validation on any of the fields. So now what we have is a ton of fields and records with data that doesn't match the associated value list, meaning there's lots of redundancy (some records will have "Black & Blue" in a field while others will have "Black + Blue" -- and the value list has just "Black & Blue"). We've obvi…

Hi, I attached a sample file. How can I switch valuelists by choosing different animal? Thanks Visit.fmp12.zip

Hi, I have 3 value list from 3 different tables. I also have a field in my layout to use these value list. How can I switch these value lists on this field? Thanks

Hi, I created a dynamic value list to class my contacts. I can add per contact a parent and a child classification (I call this a group) This classification is added in a portal, so I can choose more than one group per contact. The dynamic value list: first parent and than the children due to the choosen parent work fine. But only in browe mode. It won't work in find mode. Does anyone know about this problen or could help me. That woult be great, Thanks in avance, Filip

Hi, This might be a silly question but I've looked high and low and can't seem to figure it out. I have a text field that gets its value from a value list via a drop down box. In Browse mode, when the user chooses a value it automatically tabs to the next field. However, I want it to stay on the field until the user chooses another. I can't figure out how to make it stop moving to the next field on its own. Thanks!