Value Lists

I have a table called Items. This stores information regarding different items, with fields (eg: ItemID, Name, Description, etc.) and a field called AvailableColours. I have a table called Colours (with the single field called Colour) , in order to make a value list from the values in this field. I have it this way as it will be easier to add a new colour to this table rather than a custom value list. I have a table called Orders with fields ( OrderID, Date, etc.) and another table called OrderLineItems with fields LineItemID, OrderID, ItemID, Qty, and also Colour. The OrderLineItems table fills each order through a portal by adding items, etc. This works fine. …

Hi All I'm nearing completing my database and I had a couple of queries, though I'm not sure which sub-section is best - anyway, here goes! We're selling cars and every car when sold needs to have a PDI (pre-delivery inspection). There's a table for cars and a table for PDI information. Cars have a unique vehicle ID which links the two tables and I have also given the PDIs a unique ID. We have made the layout so that our mechanics can use an iPad to fill out the form. MY ISSUE is that they naturally want to use the "vehicle ID" drop-down I have to do a PDI on another car, but of course they're just changing that one ID and linking their info to a …

Hello, I'm adding in a Purchase Order module to my existing music department database and need some guidance. Our department has 15 accounts from which purchases are made. The account numbers on these accounts are static except for 2 digits that change based upon the fiscal year (from July 1 to June 30). I would like to have a way when creating a PO to select from a drop-down list that shows accounts only for the current fiscal year. I will need to keep a record of the POs and their year-specific accounts from past years. I can create a calc field that calculates the correct account number at any time of year for each account, but I don't know where best to…

I have a field 1 and what I would like to do is set field 2's value list based on the data in field 1. Is that possible? Thanks. Dom

I have a Person table. Associated with that Person table is an Instrument. The data for instruments are held in a separate Instrument table. There are two fields in the Instrument table: Instrument ID and Instrument Name. Of course, the Person::Instrument field is related to the Instrument::Instrument ID field. When displaying layouts of the Person table, I associate an instrument value list with the values from Instrument::Instrument Name, so that the appropriate instrument name shows up in the Person layouts, and not the number from Instrument::Instrument ID. Basic, right? The problem is when I export to Excel. When I export records from the Person table, I ge…

I have 2 edit boxes in my layout. I want the value to be the same as another edit box in the layout. I can not figure out how to make this happen. Seems as though you have to relate it to something in the table to generate the value. Any assistance would be appreciated.

Hi, all: I recognize the wisdom of having a separate table for value lists, but should that one table hold all of the non-custom value list fields, or should each value list field have its own table? For example, say you have three different value list fields: fruit type, countries and company names; they're completely unrelated to each other. If you were to put all three in the same table every record would have at least two empty fields (since each record would have one of its three fields filled with data.) Is that a "don't care" issue, or is it better to have a table dedicated to each one so there aren't any empty records at all to contend with? ...or am I i…

For a database for articles, Each article has multiple tags. I have a basic setup with a portal showing records from the join table between Articles and Tags. I am trying to create a value list for tags that updates itself showing only unselected tags for an article. ARTICLES::cSelectedTags is a calculation=List(ARTICLE_TAGS::TagID_fk)&¶ Then ARTICLES::cSelectedTags is connected to a duplicate TO of TAGS::TagID using a not equal relationship operator. A value list is built using this relationship, would exclude the tags selected in the portal ? Attached images show the relationship graph and setup for value lists. For some reason the value list does n…

Forgive me if there is another post referencing this. I tried searching for it but didn't find anything. I have a form that contains a few pop-up menus. Ideally the user tabs into the field, in this case a "state" field presses 'i' and "ID" is populated. If the user presses 'i' again the field value would change to "IL" for Illinois. A drop down menu sort of does this but from a user experience, they are really cluegy. I'm hoping someone can point me in the right direction. Thanks, FM Newbie

Hi, all: I'm probably making this far more complicated than it needs to be but hey, that's my trademark. I have a text field in my solution, States_Provinces where it looks to an external VL table for their full names and two-letter identifiers. To make the user experience easier/better, what I want to happen is this: 1) Tab or click into the States_Provinces field and be presented with the states/province's full names via a drop-down menu. 2) They can either: (a) Type the first few letters of a state's name to bring up the full name, (b ) Click the state's name from the list, or (c ) enter the two-letter identifier. 3) A calculation or custom function …

Hi guys. Newbie here â�� and I do mean newbie. Humanities major newbie. Iâ��m working on a theater alumni database for a high school. Don't ask why. Iâ��ve got about 2500 contacts. Each record includes a list of the productions that contact was in, the date of the production, and the contact's function in the production (actor, crew member, etc). It's the table to the right of the screenshot here: I'd like to create a button that will show all contacts who were in the same production (similar to the ones that already exist at the bottom of that screenshot, for name and graduation date). To throw a wrench into it: The similarity criteria can't just be the …

Novice here. Designing a simple database containing info about horse owners (one owner may have several horses), and their horses. I want to be able to set a field in the 'Horse Details' table, that contains the owners surname, from the 'Owner Details' table, where I can select an already existing owner surname from a drop down list. ie adding a new or additional horse against a current owner. This is to be performed on the iPad. Just not sure how to set up the field correctly in the 'Horse Details' table (and any considerations I may need to make in setting up the related field in the 'Owner' table. Any advice appreciated.

Dear All, I have a "nested Value List" solution (value of a field set by ValueList A filters values in ValueList B ) that has worked through a number of versions of FMP upto and including FMP 11. It now fails in FMP12. It's based on using the Include only related values starting from but then leaving the field set to <unknown>. Which was a trick somebody passed onto me years ago. Basically it worked along the lines of : if the valuelist is the product of a relationship, filter by that relationship, reverting to include all values, obviously returns all values. ARe you aware of any changes to this area in FMP12? thanks in advance Giles

I'm looking into upgrading our FMP11 developed solution to FMP12. For us, key functionality exists around the ValueList feature to DISPLAY one value (e.g. a description) while RETURNING another value (e.g. a UID), into the selected field. I would be interested if you have been able to replicate this feature from the ExecuteSQL() function (I can successfully return a single ValueList item ... having trouble with the above) many thanks in advance Giles

Hi, I would like to know how to create Popup menu while moving cursor on any object(To which object i m going to give that onmourseover action) in the layout and from this popup menu i should select one item that should do some actions(Script triggering while select the item from that popup menu). I am using Filemaker pro advanced 12 with windows xp and Mac. Kindly Share your views. Thanks in advance.

I'm building a contact list and want to have a field that shows ONLY selected values from a list but allows me to select more than one value. I imagine there's a simple solution but I'm just not getting it. I want something akin to the list of tags on a blog post shown at the bottom of each record. Eventually I want to be able to look up all the tags for a given value in another field. For example, look up all the tags associated with records from one organization (another defined list) If this helps, it's for fundraising. I want the tags to correspond to what various funders give to (education, arts, etc.) so I can search which foundations give operating …

I am implementing a inventory system, and am a little stuck with one of my value lists. I have the following relationships set: I have it set so the user can enters Prime Contract numbers. Next they can select a Prime Contract number and then enter a Subcontract number. And finally they can select the Prime Contract number, be shown a list of related Subcontracts and finally enter Task Orders. This all works fine. For my Inventory Items database I have it working where the user can select a Prime Contract for the item. Then they can select a Subcontract based on the Prime Contract. So far this all works. What I would like is based on the Subcontra…

I have a simple conditional value list(which works fine) that lists some dynamic classifications. However if none of the classifications listed are appropriate I would like the user to be able to select "None". Is there a way to add a static value to this dynamic list?

Dear All, Here is the task I wish to accomplish. I wish to generate Estimates, Invoices, Pay and Loss Statements for Events. Depending on the type of Client for the Event, the set of items that are to populate the Line Items for these documents are different. To illustrate, Client Type B will have a certain set of items (Venue, Food, Labour, and Other) that are different from Client Type A (different in the selection of items as well as pricings); that are different from Client Type C.... and so on. I aniticipate 4 types of clients. In addition to this, I wish to break down the "value lists" into: "Venue Rental", "Food", "Labour", and "Other"…

Hello, I've set up a script to sort records in a Health and Safety Database, but two of my fields are in number format, while the rest are text. My Serial Number fields is sorting like 1, 11, 12, 2. I want it to sort numerically like 1, 2, 11, 12. How do I fix this? Thank you! Richard H&S Database Test.fmp12 2.zip

using fmpro11/mac I've set up a yes/no number field for active/inactive clients. I use a booleanvaluelist of "1" and "0". I use radio buttons and want the values to show as "Yes" and "No", but they only show 1 and 0. the values will reflect the yes and no in other box formats, (edit, drop down, popup) but not checkbox or radio buttons. why not. ps every time i come back to this forum, it's reorganized and more difficult to find where to post anything. "Schema and business logic" you're kidding, right ... guess not. I put this here because it involves a value list but it's about the info box behavior. sigh.

There is a table with three columns: ID, CODE, TYPE. ID – number (serial number), CODE – text (unique name), TYPE– text: ("Type A" or "Type B") The aim is to create a value list based on the records from the table, where TYPE is “Type A” only. How to do it?

Hello, I'm a novice user of Filemaker 10 and am having an issue with a drop down box population. Here's what I'm trying to do: I have two databases: Database 1 contains a listing of new students and their information - this database contains fields for information related to their "mentor" Database 2 contains all of the information related to the 27 mentors. I am trying to set it up so when I click on the "Mentor Last Name" field in Database 1 - a dropdown box will appear with all of the mentor last names from Database 2 In addition...I would like the remaining fields related to the the mentor (ie. first name, major, etc) to automatically populate …

Articles to tags in a database has a many to many relationship. I am using a portal to add tags to an article. How do I create a dropdown list that dynamically removes tag entries already added by the user. Say if the taglist contains "Applescript, bash, ruby, Filemaker" and if the user selects "Filemaker" for Article1 and when trying to add a new tag to Article1 the value list shows only "Applescript, bash, ruby" and so on.. Logic was that if I could connect a return separated list of userSelectedTags from the parent table to a return separated list of all TagNames in the child table using a not equal to relationship, I could use the relationship to show all the Tag…

I have a table is used as a value list. I want the value list to display the list in the order in which I entered the data in the table... so a sort by the primary key would work. Is it possible to sort a value list is the list is based on a field? Is so, how?

Hi, In Filemaker advanced 11, can open related table with drop-down, but in Vr.12 unable this process. I mean, I have a categories table and related to this table some product, when in Invoice form I click on categories i can saw only related product to this special category. In fm 12, I design database but when I click ,nothing happen. Please help me, Thank you

Recently upgraded from version 11 FMP to v12 - all went well apart from the fact that all value lists based upon a relationship have stopped functioning. Standard value lists are fine. This happens across the whole system and I am baffled by this. If I add a portal to the layout showing the related records they appear just fine, however I can no long get them to appear from a drop down menu. An example is that I have a job table, a company is associated via a CompanyID, there is another table of contacts that are linked companyID to companyID in the contacts table and in the job table there is a relationship from the companyID(jobs) to companyID in the contacts table…

I'm trying to do, what seems like, a very simple task. I have a task management database in which, among other things, assigns individuals to various project tasks. I have a table called 'Personnel' which has fields such as first and last names, and status. Status takes its values from a value list called 'personnel_status' which has two choices: Active, Inactive (inactive means they are no longer an employee). On my Task layout, I have a drop down field (the foreign key from the Personnel table) which takes its values from a value list called 'assignment' in which the list is populated by the the primary key of the personnel table (a 2nd field--the employees full nam…

I hope my cryptic title hasn't confused everyone?! Background: I have a value list called Unit. This has 3 values in it which correspond to the units of clients facilities (for example store room, front office etc). We select the unit for a client orders staff from us, so we know where they're going to be working. Obviously certain areas require different skills. They're pretty generic and these are fine for most clients. Some clients don't even need them. We've come into a bit of a snag lately with a client have multiple locations. My idea was to use this Unit list as a way to stipulate what the location the shift is for. My idea was to create another tabl…

Hi everybody, I've followed a few tutorial on how to make a conditional value list and I made it happened once but for some reasons, I'm not getting why I can't get the second one to work. I have a few tables ready: Main_Category table Sub_Category table Customer Table, Order Table Order_line Table Basically, A client can either be from a choice of 2 categories (A or . When I create an Order, I want a pop up for the product that will only display the sub_category according to A or B. In other terms, let's say the 2 categories are N. America and S America and sub categories are Canada, and USA for category N. America and Argentina, Bolivia,…

Any help greatly appreciated. I am working on a booking solution and I have a value list containing custom values that are publication dates in the FM required format of mm/dd/yyyyy. I want the user to be able to choose specific dates, one date per field, I have pop up menu fields named date1, date2, etc, but don't want them to have to scroll through 52 entries (some publications are weekly) each time they have to choose a date. Is there a way of selecting for a range within the list? For example can I have the popup list show only the dates between August 1 and December 1st? I have 2 fields with drop down calendars, date_start and date_finish, where the user wou…

First off - I'm a complete novice at this, so go easy on me please I've imported a file that was originally in MS Access and a few of the fields need to have multiple values in them. The field concerned - advert type - could be (for example), Platinum, Gold, Silver, Bronze, and these values have been put into a separate table so it can act as a lookup table. Sometimes I need to select more than just one type. I finally found the Inspector and the control style is pop up menu and the "values from" refer to the correct table. However, when I go back to browse mode and then try and select more than one option (have tried every key going with a click), it won't sele…

I'm brand new to FM and this form. I'm working on a database for tracking patient symptoms. I've followed the official FM tutorial, and no joy. I keep getting the "no values defined" message when I try to use the conditional pop-up menu. I've downloaded a couple of examples of working FM files, and yes, they work, but I can't seem to replicate the magic of what they're doing. I'm looking for an explanation of what I'm missing, rather than just a fix of my file, as I need to generate several levels of complex conditional menus. An example of part of my DB with conditional lists is attached. I would appreciate any advice & education that anyone out there …

(I wasn't sure if this topic should be posted in the Scripts forum or here, so I apologize if I got it wrong. [How come when there's a 50/50 chance at something I get it wrong 90% of the time?]) Is there a script command to clear a Custom value list from a field? I couldn't find one. In use, when I create updated master files, I don't want to include Custom value list entries after making a clone of the previous version's file. However, I want to leave Indexing on for the for field(s) (for the end user) but just want the stored/indexed choices cleared out before they're given a copy of the updated file. As always, TIA for your help!

I have a table with over 300 records containing the data of individual regions. Each region belongs to one of only ten provinces. I want to select a record for work by using a drop down list, but it makes sense for this to be a conditional list using the filter of the province to show only those regions in that particular province. I have created a conditional value list by following the instructions in the filemaker manual, but this gives me a separate table and creates a whole load of new records, which I don't want or need. Can anyone please help? I attach a simplified version of what I am trying to achieve - simply selecting a region's record by province …

Hey everyone I'm in the process of updating a database solution so all main layouts have a "quick jump" feature. The quick jump is a pop-up menu that has all major layouts listed so the user can quickly jump to and from certain layouts. As I have never implemented such a feature, I have currently created a script that sets a variable based on the selection, and then created IF statements to take the user to the correct layout (or perform the correct script if necessary). Set Variable [$quick_jump ; value:quick jump] IF [$quick_jump = "Main Menu"] Go To Layout "Main Menu" (or Perform Script) The script is very basic at this moment in time as I have only …

Hi, I am trying to create a value list based on related values. I am using 2 concatenated text fields in the same table for either side of the realtionship. On the left, I have GetAsText(Date) & "_" & GetAsText(ID)& "_1". On the right, I have GetAsText(Date) & "_" & GetAsText(ID)& "_" & FirstRecord where FirstRecord always equals 1 if it has a value. I can see the records listed in a portal on the layout when on any record with the correct Date and ID, but they only show up in the value list when I am on one of the records that has a value of 1 in FirstRecord. I have used these types of relationships for value lists thousands of times in FM6 …

Hi I am not sure if this forum is the best to post this query. I have what I think is a very basic question. I have a dialog box with a pop up menu. The user selects a value I then have a calculation which goes something like: " If choice 1 or choice 2 or choice 3 then do this OR if choice 4 or choice 5 then do another. I have done this in the context of a case function. This seems inelegant. Is there a neater way to determine which calculation to perform based on the user choice without all the "or's" Joseph

I'm new to Filemaker in general and am creating a database for organizing footage into categories . Basically, I need a drop down field in which you select one category then it brings you to another category and so on, yet I have no idea the correct way to go about this. Which is the most efficient to make this work? Example: Animals -birds -dogs -lab -pitpull Transportation -cars -trains -planes -Air force one -military Also, after I create this table is there a way in which I can use it within another table? Thanks a ton!

Hello Forum, In my file I have a table for letters and a table of persons. Each letter has one recipient and is related to one project. I read, that this anchor buoy thing is all the rage. So I followed that, as best I could. I use a value list in in a pop up menu to have the user select the recipient. The first field is the kf_ID of that person. The Second field (only this one is displayed) is the Name. That is very smooth, since it is automatically sorted alphabetically. As for the project I couldn't quite figure out things yet. I set up a field that calculates a string which is used as a second field (number & ": " & "project_name"). In…

Hello, What im trying to do is straightforward, but i cant seem to figure out how to go about doing it. Referring to the images, i am trying to add a class to a user. A very simple method of choosing from a dropdown, click add class and presto its linked to the user. I would also like to make sure that the class is not added twice. However i have no idea how i can just fill up that dropbox without it being a part of the table, just referencing from another table (Classes.class Name). After which when its linked, the linkage would be registered in the "Classes Joined" table.. linking the user id to the class id. I got a minor idea to use a calculation fie…

Hi, I need a Black or White choice, only one can be selected. They are in the same Layout but not in the same field. Black is in the left side of the Layout and White is in the right side. I tried using Radio Button but could not figure out how to separate the two choices from the same field. In Check box I don't know how to make only one of the two fields be selected. Cheers.

If I export data that includes a Checkbox or Radio Button, where one or more values have been selected for that field, I get a very strange separator character between each value. It won't even paste here, but it looks like an arrow pointing upwards. I've never seen a character like it and it's not recognised by any program I've tried importing to. Can we change the separator character used on export ?

Hello, I'm trying to create a conditional value list. I've read through what I can find on this topic... and there's a lot. Still not able to equate a solution to my example. Can someone advise please advise how to proceed? _EMPLOYEES ID_EMP.pk Name Status (active or inactive) _PROJECTS ID_PRO.pk ID_EMP.fk Team Leader My link between the two tables is _EMPLOYEES::ID_EMP.pk to _PROJECT::ID_EMP.fk To simplify this example I have just two records in the employees table: Name Ben Status Active Name Sally Status Inactive The Team Leader value list field in the _PROJECTS table should only produce those reco…

the below image the junk checkbox is ticked and in the field text chicken is beside milk instead below the milk i need enter command here tried triggermodifiers but didnt understand it plz help plz tell any better alternative for below script triggers or scripting final list Copy.zip

Hi Everyone, This is my first post here I need your help.. I have attached the sample file that I am working on. What I am trying to achieve is to have two related lists which when an item is selected from the first list the second one is updated accordingly. I have made two portals in layout "models" which I will be using mainly. Actually it is functioning now but with slight glitches : 1- when I select an item from the first list my hilte gets lost 2- since the record is changed every time when I make a selection the first list is scrolled back to top. Thank you for your suggestions, Koray Birand models_test.fp7.zip

I have a table of Companies, operating in differing Regions (defined in a Regions table), stored in a repeating Regions field for each company. For my Items table (located in a different file) would like to store Companies in a repeating field in a similar matter, and be able to set Regions for each item via a value list based on the Regions defined in each Company. If: Company A have Regions 1, 2, 3 Company B have Regions 2, 4 and I select Company A for the first repetition of the Items Company field and B for the second repetition, I would like the value list for the items Region first repetition to show 1, 2, 3, and the second repetition to show 2,4.…

Hello! My name is Jon, I started learning FileMaker about 8 months ago when I got hired for an ophthalmology specific EMR company. I was trained under FM11 Pro Advanced, but am still very new to database development in general. I've been working on a specialized appointment scheduler module for our program, but have found that my initial approach was unsatisfactory on a network. My Calendar layout was 8 portals of related calculation fields, where each line was a record corresponding to a time (ie, 8:00am, 8:10am.) There were over 1,000,000 of these "time" records stored in this table. When booking appointments Filemaker would perform finds on these records fo…

I have a value list based on two fields: A record ID field, and a "display name" field based on a concatenated First-Last name. This appears in a pop-up menu which filters the portal below it to display the related contact information for the contact selected in the pop-up menu. Everything works correctly for data entry on a new customer record. My problem is that the pup-up menu on each existing record currently shows the Record ID number for the contact, and not the display name. The portal below does not show any information. To update this, I have to manually select the pop-up menu and re-select my choice for the primary contact. Is there any way to autom…

I have a script that copies data from a text field that is setup as a checkbox. The checkbox pulls values from another table. However, when the script copies the data from the field is not only copies the checked data but any data that is currently in the field and previous data. For example: X Choice 1 X Choice 2 O Choice 3 The script will copy not just the 2 items checked but all 3. It then also copies any choices that may no longer be in the database. Running FMP 11 Advanced Any help is appreciated. Thanks

Have just noticed my Dropdown's dont work anymore. It seems that Valuelists defind from fields only work if you define a relationship with "Include only related values starting from". The "Include all Values" doesnt work on my old Database files. If I create a new Database and do the same ("Inlcude all Values") and it works fine. Also, FM12 is very sluggish!!! At least 20-30% slower! Havent tested any new feautures yet but I like the fact you can have larger scroll bars on portals now! Yipee! Have you guys noticed any slow donws using the new corner radius tool?

I am able to find a number of examples on how to create conditional values list... but none with same type of relationships I need in my solution. I have a total of five tables and two TO in my database. _PROGRAMS (parent table to all) Events.PROGRAMS (TO of _PROGRAMS creating the relationship to generate the EventsONLYPrograms vl) Services.PROGRAMS (TO of _PROGRAMS creating the relationship to generate the ServicesONLYPrograms vl ) _PROGRAMS_2_EVENTS (a join table) _EVENTS (child table and layout where I need the EventsONLYPrograms value list to display) _PROGRAMS_2_SERVICES (a join table) _SERVICES (child table and layout where I need…

I want to sort a list using a custom order based on a value list. The field in question is a calculation field. For some reason i cant get the field to sort in either the custom order or in alphabetical order. Has it got something to do with the fact that the field is a calculation field? Please help. Very stuck. Not sure where to from here.

REMOVED

Maybe someone can help me I just cant seem to get it right, I set up a database of volunteers witch I can assign a task using a portal and a dwindling value list, I got that part to work. But then I found out that the dwindling part only works on one record so I changed a couple of things, 1. I set up a self join relationship to keep a list of all volunteer keys used in the join table across all records. 2. I changed the calculation use that self join relationship. The one thing I cant seem to get working at least fully is when I select a volunteer in the portal in record one in it displays a list of all of the volunteers (so far so good) after I ass…

say for example I have a value list comprising of A,B,C,D,E Supposing I always choose the value A and rarely choose one of the other values, is there a way that the field starts of with A in the field and if you wish to change it to one of the other values you can click on the field and it will present you with a value list A,B,C,D,E? thanks for any assistance. Metso

I started a fairly small database a few months ago. When I entered data in the person's name field a pop up list appeared in the next field " address field". The problem is that the list has expanded and it is very difficult and time consuming to scroll down and select the proper address. Is there an easier way to do this ?

Hi, I am sure the answer is going to be one of those face palm moments, they usually are for me.... I have a simple file that I have attached. The file contains the following tables "Items", "Vendors", "Departments" and "Item Types" As you can see in the file I have related vendors --< Items >--Departments ---< Item Types . I made value lists for my departments, vendors, and item types based on the field data in those tables for my item entry screen. The department and vendor value lists work as I intended, however, I am having a slight problem with my item type value list.... I made it so that only the related item types will show based on the relation…

I have a value list of vendors based on a field. I have one particular vendor that I want to always be at the top and the rest sorted in alphabetical order. Is there a way to do this?

Hello Everyone, I am new to Filemaker. Its been more than 24hrs now I have been trying to get this but no luck. Please help me to achieve this. I have two table product(id,productname,rate) and invoice(id,name,date,total). I have layout for product, its working fine. In the invoice layout including the fields from invoice table i want there to be also option to chose products from product table, in a tabular manner(similar to the product list on invoice layout on starter solution invoice), when clicked on productname i want a dropdown list to appear with the products from product table and in next column after product there will be a text box to fill in…

I really like the ability of popups to restrict user input to a provided list. However, I find I am forced to use a drop-down if I want to use a script to update the drop-down/popup contents. Question: Is there a way to use a script to write directly to a field based on a popup? (What is happening is that I can add / delete records from the table that the popup is based on and although the popup reflects the change, a calculated field that shows the 'order number' of the contents in the popup DOES NOT get updated unless I use a Drop-Down.) For example, if the user selects the 2nd item in the drop-down, the calculation shows 2. I can get this to work in the drop…

I have a form which uses a drop down list to store an ID and an edit box overlay to show the related value chosen. (still baffled that FM hasn't just made that a native option) The problem I am noticing is that the Edit box only refreshes when one clicks on a blank area on the form. I have drop down lists in other forms that refresh their edit boxes as soon as a value is selected. The difference being that the ones that refresh immediately, the drop down list field is from the table the form is based on, but if the drop down list field is based on a related table it doesn't refresh immediately. How do I get it to refresh without changing the forms base table…

In the above Setup layout, on the left column is a hard coded list of membership 'types' (Yearly, Honorary...etc) . These Memberhship 'types' are accessed in the main program via a dropdown listing. Each member has a membership 'type'. The dropdown choice is used to calculate what the membership dues are for that membership 'type'. This works well. However, I would like to replace the 'hard coded' dropdown list of Membership 'types' (Yearly, Honorary...etc) with global fields or $$variables. The purpose is to allow the user to define the membership 'type' (In he setup layout above) by, for example, replacing '50 Year' with '40 Year'. Then (and this …

I'm looking for an elegant solution that would do the following: I have a table with Title First name and Last name as 3 separate fields. I want to create a value list which would display the Last Name, First Name and when selected would enter the Title First Name Last name in the field in that order. So for example the list should look like: Smith Peter Smithers Andy Select Smith Peter and get Dr. Peter Smith Select Smithers Andy and get Prof. Andy Smithers Any help would be appreciated.

Hi there! I am still learning FileMaker and I had a bit of a challenge. How do I replicate in a value list the same behaviour as I have been able to do in the attached portal? I am not sure that I am able to fully understand the correct value list concepts to be able to replicate what I am after - can someone give some advice? Basically it is a multi choice quiz, with multiple correct answers - down the bottom you click a button to verify the answers, and then it will check to see if they are correct. Is there a way to do this in a value list? Multichoice Quiz.fp7.zip

I'm using a value list from one table to manually enter the foreign key in another table. Using first field and show data from second field etc. The value list currently has 1685 entries which obviously is the number of records in the table that it derives from. This number of records could grow significantly over time. Therefore is there a maximum number of entries that a value list can take? If so, what are the alternatives?

I am working in Filemaker 11 Pro Advanced on Mac OS X. I have my invoicing setup so that what is to be invoiced is first selected by product type from a drop down and then the individual product from a second drop down list called product. My problem is that my database has grown to where I have quite few products in my product list that I order but do not sell because they are used to make the products I sell. I want to be able to flag my products on the product page as either sellable items or not and have just the ones that are flagged show up in the invoice product drop down value list. Hope this makes sense. I have attached a sample file I just made of what…

My script is using a Go To Field[ ] with select/perform set to open a field for the user to make a selection from the associated value list. The field highlights properly, awaiting an entry ... but the value list isn't displayed for them. Is there a technique to automatically open the list? I know a pop-up will automatically open ... but a popup is not appropriate for this particular field (with 200 choices) and layout. I need the scroll bar for the user. Thanks for any help.

Hello All, could someone take a look at the attched file and do the following: - enter any number into member field in STEP 1 and click next or go directly to layout "STEP2" - click one of the pull down menus and select a hotel - then click the SELECT button below so the total field on the right sets to the desired amount You can now see the cursor blinking in the field and it doesn't leave the field unless you click somewhere into an empty space on the page. I've tried a lot of things but so far wasn't able to get this to work. How do I get the field to set itself just as if you'd click one of the other select buttons on the left that do not have a pul…

hi guys, Please go easy with the noob! Im creating a database which formulates recipes. I have created drop down lists for selecting the ingredients from and a value list containing ingredients, what I would like to happen is have a user select an ingredient and then have my database automatically show the cost per gramm of including it in the recipe for example, when sodium bicarbonate is the ingredient selectedfrom the dropdown, I want the database to automatically then display the cost in a field next to it. Any ideas as to how I can link the value list in such a way? any and all help would be greatly appreciated. thank you in advance, Chr…

Hello, I'm new to Filemaker, so forgive me if my terminology is a bit inaccurate. I'm using FMP 11. I'm creating an invoicing database and having some issues with populating the client list dropdown. I used the "Invoices" starter solution as a base. That's the background, on to the question. The client list is populated from the customer database and the list is constructed using the first and last name fields or the company name if no individual is identified. I believe the string looked like this: First Name & " " & Last Name. I wanted to display last names first, so I changed that string to: Last Name & ", " & First Name …

I am using FM Pro 11 Advanced for Mac, and I am looking for help simplifying my use of value lists for a project. I have a fairly complex set of 20 related data tables, each table with 100 fields, and approximately 20 fields in each table use value lists (400 value lists total). The field names are unique throughout the 20 tables--i.e., there are 2000 field names. The value lists contain highly variable text codes that are used in X12 Electronic Date Interchange (EDI) formats--e.g., X012, CH, 8, 837. Because the codes themselves are non-intuitive, I need to be able to see short code descriptions next to the codes when using the value lists; that constraint require…

Hi, I am using Drop down for one of valuelist. when i want to change a value, the drop-down menu do not work, meaning it does not show any data. it happens some time and sometime works fine. Is there any way to fix this problem? Thanks in Advance .Waiting for reply Thanks, Genelia

Hi there, I would like some assistance with the drop down list I have created. Basically what I want to be able to do is (as an example) is to have the user select a choice from the drop down list, and then this record is then stored and updated in their file. Then return to the layout with that updated choice. This would also - upon the user coming back into the file - restore their preferences / settings that have been stored for them. Yet when I am doing this - it is changing it for all records. I have tried to be explicit by making it change based on searching for the record afterwards so that it only updates that 1 record. Am I miss…

Hello again, I am sure this is possible, but I just can not get the following to work!!!! I have a contact database, and sales database. Both contain the usual fields that you would expect, but I want to use two fields - "Company Name" and "Company Contact Name" (both of which appear in each database) - as lookup fields. Both fields are drop down lists in the sales module. So, in the sales module, I want to select the "company name" from the first drop down list. Once selected, I want the second drop down list to have only the names associated with that company in the contacts database appear in the list. Each company in the contact database is a r…

I have a field with a drop-down value list. As soon as an item is selected from the list, the cursor moves to the next field. I need the cursor to remain in the field. For example, a value might be "Proceeding for the Appointment of a Guardian for ". I need the user to be able to select the value from the drop-down and then complete the sentence by typing a name. Is there a way to accomplish this? Thanks, Kevin

Hi all. I've been using the following script succesfully until suddenly it doesnt work as it either doesn't render the first or the last record or additionally records in between. Here the script which some very nice people suggested previously: # # Replace colon with carriage return for ease of splitting data from label # Labels are now always odd numbers and their values are even. Go to Record/Request/Page [ First ] Loop Set Variable [ $values; Value:Substitute ( Students::lettertext ; ":" ; ¶ ) ] Set Variable [ $count; Value:ValueCount ( $values ) ] Loop # Set fields counting backwards. Exit loop when done. ExitLoopIf[$count =Get(FoundCount)+1]…

Hey Guys, I am a completely new user to Filemaker so please be patient with me. Everything I have done on the attached file is through self-learning. I have tried to merge Inventory management with invoicing and basic accounts for my small business. I have succeeded so far however stuck at a small point Basically for one design no. i may have multiple suppliers and multiple cartons no.s When I create the invoice successfuly selecting the design no. lot no. (Supplier name) & carton and input my desired pcs/yards, instead of deducting stock from the selected carton no. Filemaker decides to subtract it from the first carton no. only. I have attac…

I'd like to have conditional formatting enabled when the value of a field is not a value of a value list. I've looked into this briefly, but am posting here in case anyone has done this. Thanks.

When I setup via relationship a valuelist of a date field I logically obtain a (text) list of dates. But I need to use it to control a relationship with a date field and the stuff only works when text valuelist and date field are equally formatted. I use the european date format, sorry V.list 6/1/2012 7/1/2012 8/1/2012 13/1/2012 can not be relationated to the date field 06/01/2012 or can not be found in the vList via PatternCount. Well, it does work when the date is from october / nov / dec on 10th to 31th But useless, of course. The issue is solved with relationship multipredicate but I have to set up (it is a week control scr…

I can't seem to find a way to darken the Checkboxes and the "X" in them. In my middle age the "X" seem far to faint. I would appreciate any help.... Thank you

Hi All, How can I or one of my users deselect a radio button set without using the shift/click action? I intend to publish a list of two hotel categories via custom web publishing. Each category will have a radio button and if hotel category 1 gets selected then category 2 gets deselected. I have this option for 8 nights at 16 different hotels; now if a customer clicks through the hotel categories, makes his selections and then decides that he doesn't want to book the hotel on a certain day, it will still show his earlier initial selection. Thus the need for a deselect of single radio buttons or refresh of all the selections made. Thank you guys! Andy

I'm trying to create a list of years based on a date field in one of my tables. I am putting a dashboard together that allows the user to select the starting year from a drop down list. Each user will possibly have a different range of dates in their copy so i would like to have a drop down list of years based on the dates in a field in their copy. I hope that makes some sense and someone can point me in the right direction? Thanks

Good day dear FM friends, I have hot stuck on something much trivial - something I though would be a breeze to set up, but apparently not. Please help, dear friends! I thought I could easily find a function similar to GetValue but the other way around. With a valuelist based on cities::id to show cities::name I would need to do something like: getValueListItem("cities value list"; "Paris") to return cities::id. I understand I can use position to find the position in the list, but how about the corresponding id?

I'm having a bit of trouble on a value list in a way I have never encountered before. As you can see in the popup, the value list shows two fields. The first field is a number field, the second is text. I would like the user to be able to select the item by typing the account number. However, a strange behavior is happening. When I start to type the number, the value list disappears and then only the numbers typed so far show in the field. Now, If I change the value list to sort by the second field, the description, it allows the selection of the value list by typing the account number. I have never seen this behavior before. Sorry about the small images b…

I want to contextually assign different value lists to a field. For example: if field Select_VL is "VLB" then field VL displays value list B Its trivial to display the contents of the selected value list using the function: ValueListItems ( fileName ; valueList ) For example: Set Value List Related Example.fp7.zip However, the field contents do not behave like a value list. It is not possible to select a particular item from the value list, have it auto complete, etc. For example: if field Select_VL is "VLB" then field VL displays: Garlic Red …

hello mates first of all i wish a very good year 2012! i am trying to figure out how i can solve following problem: in a table persons i've got (among other fields) person number, initials (possibly but not definitely calculated with the name) and full name. i have a value list which is auto created. i have a popup with this list, which shows initial as first (it's the key) and full name as second. i need the sort to be done on the person number. any chance to do that? cheers

Hi All, Is there a way to Auto-Enter a field on Creation of a new Record based on Value List. I have a value List of the months, Ans I ant each record to auto-enter January followed by February etc. until December, and then start again at January, I know I can show only the name of the month by formatting the auto-enter date entry, but this field needs to have only the name of the month as it is related to another table through this name. Thanks a million, Maria

I want a drop down list to show me all my Vendors from my Company Table. Background: In my company table I have a field called (Name) to list the name of companies and then one with check boxes (Choices_Client_Vendor) to identify if the name is a vendor or a client. Sometimes they can be both so this is why the check box. To create the drop down list I created a new field called CompanyVendor in my Company Table based on the following Case: Case ( Choices_Client_Vendor = "Vendor" ; Name; Choices_Client_Vendor = "Client" & "Vendor" ; Name ; "" ) My value list shows me all my records that only list "Vendor" in the (Choices_Client_Vendor) field but…

Hello, I have created a simple new database "SURVEY.fmp" with 4 layouts that contain a survey for my customers. One of the layouts contains 7 questions, each one can be selected by radio buttons for the category "good", "average" or "poor". Customers are supposed to go online, enter their reservation number and via buttons/scripts at the end of each page click through the survey until they reach the end and submit their survey. While the radio buttons behave correctly on my PC they don't do the same thing in the IWP. On the host computer I can select/deselect the radio buttons throughout all three categories "good", "average" and "poor". I can select a button an…

I'm using FMP10, and our database is published online. I'm the only one who has access to add entries to our value lists. The value list is created by entries into the field, as opposed to creating a list manually. With 169 entries into the value list, 12 are duplicates. They are exact duplicates, i.e., if you do a search on duplicate version #1, I get 625 matches, and a search on duplicate version #2 also finds 625 matches. I have no idea how these are being created. I know I didn't do it, and since no one else has access, I don't see how anyone else could be causing this. So, that is problem number one, how these duplicates are being created, and how can I…

Hi all, Hope yo had a great weekend! I've got a report card writing Database and been trying to get a value list working all weekend, but just can't seem to do it. I've got a table with the fields (and a few examples below) as follows; COMMENTS table -------------------------- ENGLISH CATEGORY He is smart Positive Comments He is hard-working Positive Comments etc... He is lazy Negative Comments He needs to focus Negative comments etc... His reading ability is good Reading comments His Reading is improving Reading comments etc.. ...and so on I've got another t…

Dear All, Just registered here for my first day with FM ! I have seen other posts related to the topic but never really solve my target which is like a set of Drop Down Menu "Russian Dolls" like. I have modelled my database with several tables : Country : CountryID CountryName SubRegion : CountryID SubRegionID SubregionName SubRegion1 : SubRegionID subregion1ID Subregion1Name SubRegion2 : SubRegion1ID subregion2ID Subregion2Name I have created separate tables to avoid data redundance for obvious reason. Relations created based on shared fields (CountryID between table Country and SubRegion, SubRegion ID between SubRegion and SubRegion1, e…

Hello once again, After some time away from this forum, I've chosen to revisit & streamline my current travel agency related FM solution even further to make data entry more efficient. I've encountered a small problem while not critical but is annoying/time consuming; for this I need your wisdom. Situation as follows: From my drop down value list of contact names (containing hundreds of them), via a portal, I assign 3 participants to an airline booking... let's call them x, y, z. To do so, via a portal, I scroll thru the dropdown value list to find participant x. I then repeat same process to find participant y & z. Tedious to say the least. …

FMForum Members, my apologys in advanced for possible spelling mistakes but my written english is not that good but here goes..... I have a number of functions in a value list. This value list is used as popup when a new volunteer is created. When i create a Task i use the function value list to filter the volunteer list to set one or more volunteers on that task Now my problem: I woult like to see that when i choose a volunteer for a task that that name dissapeers from the list, a so called dwindling value list I konw that its possible i hav seen a number of examples but i cants figgure out how to make it work in my setup. attached …

I have three tables. TabA, TabB, TabC I set relationship : TabA >--- TabB >--- TabC I created a portal based on TabA_self. I want to display a some field from all tables. I have no problems with the TabA and TabB. I do not know how to display field "ParameterC" from the table TabC. Copy database in the attachment. joins.zip Please explain to me, how to do it.

I have a checkbox field called 'Age' that contains the following possibilities of target age group for which my games are intended for; 2 - 4 5 - 6 7 - 9 10 -15 Some games can be played by both toddlers & older children, so I have ticked two, three or all of the checkboxes. When clients search the games database, They view the game description and under age they see a field called 'Age inclusive' which is a formula grabbing the left word &"-"& the right word of the 'Age' field, which works nicely when I have ticked one box or ticked several in order from lowest to highest. HOWEVER, if I tick '7 - 9' and then '2 - 4', the calculation result…

First, I'm using FileMaker because it's a lot more user friendly than access and I'm not a DB guy. so I may be thinking about this all wrong. I'm making a software inventory db for my department. it will have all the standard pertinent Software Fields in one Table, and then where we have installed the software, and the "where it's installed" is where I'm having problems. I want to have a drop down menu from a "building" table (I did this part) then have a second drop down menu with "Room Numbers" and then have a check box list of the "client" Lastly, I'm going to need multiple copies (I'm thinking 4 will do it) because the same software entry will be in…

So I made a drop down menu for a field, when you click the value it tabs to the next field automatically. I changed the behavior but it doesnt do anything. How do I make it stay on the field once I make a selection?

I defined a value list, called "client names" from a text field that is indexed and chose, includes all values. On a layout that displays the same field, from which the value list is defined, as a related field (no portal) I defined the field to display as a drop down list using values from "client names". This field can only be entered in find mode by the way. I wanted to use the "auto-complete using value list" but the inspector will not allow me to check off this option and the option is not dimmed. I don't understand why. From what I have read using the Help tool this should be possible. Have I missed something? Any help will be greatly appreciated. …