Value Lists

Dear friends, You all please help me in Working with Radio buttons. Whenever I use radio buttons, multiple selections are possible just by pressing the Shift+click. So I don't want the Multiple Selections should be possible using Shift key. So, you all are requested to help me as soon as possible. For example, whenever I use radio buttons in case of Gender using Male & Female, I am able to select both of the options. But I don't want this. I need only one selection after pressing the Shift key also.

To whom it may concern: I'm brand new to this community. (Just joined this morning.) And, this is my first post. Also (to make it challenging) I am relatively new to FileMaker. I've worked with MS Access for 10+ years. So, I have created a table that lists Inspectors (people). I have a field in that table called "Active". The allowable values for that field are "Y" or "N". I am currently using this table as the source of values for a Value List. And, I am using this value list to populate a drop-down field in another form. All of this (that I've described above) works just fine right now. What I'd like to do is this: Some how train the v…

hi, I have a field that during data entry I would like to autocomplete based on a value list. The value list is a list with multiple words. It is the "Chief complaint", in a medical history. So the typical entry might be "patient here for f/u of cataracts", or "px here for f/u of cancer". I would like it to autocomplete when typing ANY word. For instance, if I start typing "ca.." only values with words containing those would appear in the drop down (or pop up), even if "ca" appears in the second or third word. right now, you have to type the whole phrase "px here for..." and there is a bunch of entries that start like that. any ideas? thanks in adva…

Hello, I gonna need help again for the following. I turned it around several times, but cannot find a correct result. I have two files, one helicopter database, and one registration database linked by a helicopter ID. I would like to regroup all registrations having the same helicopter ID in one single repeating field in the database helicopter. the field storing registration is a text field, the helicopter ID is a calculation (concatenate of three other text fields) Any help will be very much appreciated, for both the teaching and the solution. regards

This is a throw back from converting a system from Access, it's quite a large database and although I'm keen to stick with relations using numeric IDs between most tables, but I feel it will confuse some users if some of these IDs are displayed on screen for many smaller / linked tables. Hiding in Access is trivial using a combo box, as is dynamically changing the combobox rowsource at any given time, but not in FileMaker, not that I can see. In fairness, you can hide IDs value list pop-up menus but not pop-up lists, as some of the lists will contain many items, lists, not menus are required. Currently I've added what I think is very overly complex and clumsy sy…

If my grammar in the title is anything like my calc syntax I'm in BIG trouble. Please refer to the attachment. The plan is to let users, using FMP 9.x, enter then select their search criteria for use in a report; the Custom VL List for all three text fields (named Sort_Choice1, Sort_Choice2, and Sort_Choice3) contains the same labels as what you see on-screen: Date Range, School, Grade, Period, Teacher, Student, and Attendance Code. What I want to do is prevent users from selecting a choice more than once. For example, if s/he picks Date Range for the primary sort and High School for the secondary sort, I don't want the goof to pick Date Range or High School ag…

I'm having real trouble getting my head around this in FileMaker, yet I can mock it up in 5 minutes in Access with SQL queries, and changing the row source of a combo box First table BOOKING = BookingID, BookingDate, BookingTitle, CustomerID, CategoryGroup Second table CATEGORY = CategoryID, CatDescription, CatInfo, CategoryGroup Third intermediate table (Portal) BOOKINGCATEGORY = BookingID, CategoryID (with relations to show the description and info in the portal row) [bOOKINGCATEGORY is related to BOOKING via BookingID and CATEGORY via CategoryID] I need a value list dropdown in the Portal for the CategoryID which only shows the Category records w…

I'm a Filemaker novice, but have done quite a lot with MySQL, so the concepts aren't new, just the ways to do them I have a filemaker table of categories it has two simple fields. ID and catagory. example: ID Category 1 Red 2 Blue 3 Green In another table, I want to assign one ore more categories to a product through a value list populated by the category table. When the user see the options to check them, I want it to show the category names but I want it to save it as the ID value(s) Or at minimum be able to export the field as a list of the category ID values rather than a list of the categor…

Hi all, I am relatively new to filemaker, and would really appreciate some help! In searching the net, I came across a topic here which replicates the functionality I want, but I have no idea how come it works for them and when I try, not for me. (located here: http://fmforums.com/forum/topic/74977-value-list-auto-complete-with-calculation-field/) I'm trying to have a field "Company Name" where I choose a value from a drop down list, and then right underneath it, the "Office Name" will automatically update. They are situated in two tables (Company and Office, respectively) and are related by an ID. I don't know what I'm doing wrong, any hel…

My staff work to appointments and I am creating a database for these appointments. I have created a value list which contains the names of the staff members who are working during the hours of any given appointment but I would really like to be able to create a value list which narrows it down to those who are actually available - that is to say, those who are working and not already occupied in another appointment. I think I can get this result by writing a script, but is there a more straightforward way by creating a new relationship? I've been struggling with this for months on end and would be eternally grateful for any input! Thank you in advance,Michael …

something has happened to my "solution" and I dont know what it is: every drop down list and menu now requires me to hit the return key before the highlighted value is placed in the field. I dont know what I changed but all I used to have to do was scroll to the value I wanted and click on it. Help!?

Filemaker Pro 10 Advanced. We're having a problem with portal autosort I have a repeating field list on the left and a matching portal on the right that pulls corresponding data from a related table. The user types a word on the left and the related word appears in the right-hand column (the portal). So far, so good. The correct data appears. But... the portal is sorting it (I don't have any sort values set in portal preferences). This is NOT what we want. We want the portal values on the right to line up with the corresponding values on the left, exactly as they are entered, not for the list to reshuffle itself. There's no way to pre…

I'd like to create some drop-down lists where a user can specify their favorites to appear in their favorite order at the top of the list, and then all of the system-provided values would follow that (sorted in alphabetical order). I created a calculated field that takes a repetition text field from the user preference table, and I concatenate it with a value list that has all of my system-provided values (just a lookup on a table). However, FM8 seems to be sorting the resulting multi-value text string that I'm returning before it pops-up in a dropdown list. So my entire purpose is undermined. Any ideas on how to "turn off" this auto-sort that is taking place? O…

Hello friends I have a database that has a field <<Photographers>>. I also have a table where I enter the Photographer's info such as NAME, PHONE AND LOCATION The <<Photographer>> field is a drop down menu based on Photographer's table <<Name>>, I would like to show the list based on their location. how do I do that? here is a sample Dave Saint John Mac Toronto Rick London Steve Paris Shelly Paris Ben

I have a value list that pulls values from a table's field. I want to show all the values (as normal) - except for one of the values. The table I am drawing the values from has one record called "Root". I do not want "Root" to show up in the drop down list. How can this be done? (I have a record called "Root" in this table as it is used to control a hierarchy within that table.) Any help appreciated, thanks.

Hi, I have one table with plenty of contacts in it. In a second table I have record let's call it "person" where one of contact is assigned to task. Because of versatility I'm not using contact's names but ID of person instead. By using of popup list I can see names again. Some of the contacts became inactive by the time and I don't want them see in the popup list anymore. So I made filtered list of contacts based on attribute "active". What I don't know yet is how to fix the fact that all tasks where was used now inactive person show only ID because isn't present in popup list. I hope I expressed my problem clearly. Thank you.

I want to display a value list that is sorted by year, then name, of the records. The list should pull it's data for both fields from a table, one field being a PK, the other being the name. Most solutions I've seen are quite restrictive as they require the use of one of the two fields for the purpose of sorting, but I need both fields. The only trick I can think of is numbering the PK relative to where an item should appear in the value list, but I see this as more of a kludge than anything any would like to avoid it.

I'm sure that this has been covered but I have looked through the forum and haven't had any luck finding this exact situation explained so bare with me. I have three tables: * COUNTRIES * STATES * DISTRICTS The COUNTRIES tables has an auto serial # as well as a Country field The STATES tables has a auto serial # as well as a drop down list field for COUNTRIES and a State field The DISTRICTS table has a auto serial # as well as a drop down box for Country and a drop down box that sorts the STATES data based on COUNTRY chosen and then has a District field. I am good on the COUNTRY to STATE relationship for the conditional value list but can't see…

Phrase For best selection See a store near you Phrase Export For best selection See a store near you Phrase Export French Visitez nos magazins pour la gemme Displayed as "Drop Down List" Values from " Undercopy drop down Value List Using Values from "Phrase" When i use it, I select the Phrase- and the Phrase Export Displays in the drop down menu for selection. I have the "Phrase Export French in the Table, but I cannot make it display on the page properly for french. I wanted to link these together so that when the English was changed the french would be automatically changed as well. Any help you could provide wouuld be …

Hello, I am creating a solution that keeps track of expenses and calculates the expenses for each month. I am having problems displaying the name of the selected choice from a value list on a portal. In the solution there are three tables, Expenses, ExpenseCalculation(Main Layout), and ExpenseLine. I have created a field that uses a value list that collects data from the tables expenses. This data is then stored as a record in ExpenseLine which is reflected on a portal in ExpenseCalculation Layout. I have been able to catch the value of each expense, but not the name of the expense to pass onto the portal. Any clues? Alberto

Anyone know how to create a filtered value list that excludes values that have already been selected? Here's the context... A Meeting TOG includes Attendees and People, as shown in screenshot. The Meeting layout has a portal to the Attendees, and the portal contains a popup of People. I'd like the popup to show all the People records, except those that are already in the portal. I've tried several filters, but I'm stumped. Thanks, =L= _____ Leo Di Croce

(I'm sure this topic has been covered but I just can't find it in the forum with the phrasing I've been using.) I'm trying to follow the Good Practice example of having a separate table store Value List choices but I'm stumped how to set up the TO so multiple tables share the same list, i.e., Table1, Table2, and Table3 each have their own City text field but I want them all to share the same list to draw city choices (from the table, ValueList.) Mind you these are discrete fields, not a portal set-up. TIA for your help! Ciao, Rich

Can't figure out what is happening. I have a value list with values A, B, and C. The field definition in the table says this field is always validated and the values must come from the value list. The entry field on the screen says it come from a drop down list based on the same value list. When the user clicks in that field, the three choices appear as they should. If the user initially clicks on B, the field is filled in with A. If the user initially clicks on C, the field is filled in with B. In either case if the user returns to the field and again select B the field is correctly filled in with B. The strange behavior is only happening on the initia…

From a table called"floor" I need to be able to have a drop down value list that shows the remaining spots available to claim. The other table called "spots" has a fixed number of records that are numbered 1 through 36. As the spots are selected from "floor" I have two calculation fields, one changes a yes to no once the spot is claimed. The other replaces the spot number with a "". I tried several relationship combinations with no success. If I use one of the fields for the drop down that are a calculation I get a warning that the function won't work because the field uses a related, or other non-indexed field. I tried several thing but I am stuck. I am gr…

I have very successfully converted my Filemaker 5.5 marina management solution from .fp5 to .fp7 files using Filemaker 10 Advanced and Windows XP SP3. A lot of work, but well worth the effort considering all the new available features and benefits. Couple of things I don't understand about FP10 that I would hope someone could clarify for me. When using the field "Drop Down List" feature, the screen presentation becomes distorted. Also, when switching from the normal screen view to add the "Status Toolbar", the screen presentation is distorted. To view screen shots of this problem, see the attachments: Drop Down Screen 1.bmp Drop Down Screen 2.bmp MP …

Hi, not sure if this is possible but would greatly appreciate any ideas... My records have a TIME field. I want to be able to sort on this field, BUT, want to have a START time which the user can select. This would determine where the Sort would begin from. For exmaple, with the following 5 times: 03:00, 06:00, 09:00, 22:00, 23:00 a standard sort gives: 03:00, 06:00, 09:00, 22:00, 23:00 but if the users decided that the Day Starts at 08:00, then the sort would return: 09:00, 22:00, 23:00, 03:00, 06:00 so it is kind of rolling sort. Any ideas how I can go about this?

Apologies up front for the newb question, but I am having difficulty following the Filemaker Help on this particular topic and I would appreciate some help My dilema is I need to create a field that behaves and reacts to whatever is in another field using drop down value lists. field 'TYPE' is a drop down list containing a value list 'Furniture, Household, Lighting'. Dependent on the value I chose in 'TYPE',I want it to activate a selected value list in my second field 'SUB TYPE'. So if I select ' furniture ' from my drop down list in 'TYPE', the 'SUB TYPE' field will display a selected value list connected to 'furniture' alone. eg chair, sofa, table. If I cho…

I am having a bit of a conceptual block on this and I can't sort it out. Some guidance would be appreciated. I've got a patient database. Each patient has a past medical history consisting of several diagnoses. The past medical history diagnoses, ideally in a portal linked to a standardized diagnoses table, should be selected using a dropdown menu using a value list from the standardized diagnoses table. One should also be able to add a free text diagnosis to the past medical history that will be added to the value list for future use. The standardized diagnoses table should contain only unique values so that standardized diagnoses are not repeated. Of course many pa…

I have a relationship set up between tables 1 and 2, whereby a value list is populated by records from table 2. All the value list items are in a Text format such as: ST-***-###. the astrixes are always 3 letters, and the Hash's are always numbers. I am trying to populate the value list with ONLY items that start with say: ST-VUL-###, but have been unable to do this. The list needs to only list those records that have those 7 characters(including hyphens) and not ALL the records. How can this be achieved?

sorry :-D:-D i need help about how to modify multiple record at same time , after a search, assigning them two values from a checkbox list. These checkboxes are the result after adding a field in database, filling with a value list and choosing checkboxes option in data panel. thank you

Hi Here I am with another question. I really am glad this forum exist and there are nice people there to answer my questions. Thank you. My question is: A field can have a dropdown with a valuelist and the user can choose a value and it will return this value in the field. In my case the user (if clicks on the arrow) needs to open a pop-up with more information on it and if a record is selected, it needs to bring back not only the field from where it's selected, but also 3 more. See screenshots. If projectnr is selected it needs also bring back the regel, the activiteit and the type. Sabrina Horst

I'm trying to contextually assign different value lists to the same (global) field for search purposes. Using the calculation "ValueListItems" I can assign different value lists to the same field. The problem I'm having is that I want the global search field to display as a drop down list with auto-complete. But the only way I see to make this field as a drop down with auto-complete is in layout mode. When this is done a value list must also be assigned, which prevents using a script to contextually assign a different value list to that field. Is there a calculation or scripting method that can make the global search field as a drop down field with auto-complete? …

Hi all, been a short time lurker but first post : This is probably an easy one but it is where I am at now If I have a field with a specific and unique name (for every record) is it possible to create a drop down select list of that field to be used as a go to record selector? So if I select the drop down and select NameC it will go to NameC's record? Thinking about it from a fresh start how you you recommend I do that? Thanks GW

I need to aggregate the information in several fields and use it in a value list. But if the field with the value list is a calculation field, it is not possible to set it to "auto-complete." For example: 3 fields: last_name, first_name, complete_name If the complete_name field is a calculation field (calculation = first_name & last name) then a value list of complete_name cannot be set to auto-complete. Is this something I'm doing or is this generally true with value lists, that they cannot be set to auto-complete if they are a calculation field? If the value list field is not a calculation field and is populated with data by a script performing the exact s…

I have two variables I have assigned through a script. Each variables contains all the primary key values of a specific table. I want to step through the first list and see if it contains any values that are contained in the second list and, if so, apply a condition to it. The obvious choice for this would be the PatternCount command but unfortunately this will not work for numbers. How would I do this?

Hello to everyone, My question is if it is possible to format the text in the custom value list. For example to have the "10" in red, the "5" in green. Thank u.

I have a value list that uses "custom values" (hard coded values, not values from another table) that I use to track the source of something. The source could be from multiple places, so I am using a "checkbox set" so multiple sources can be selected. For example, the source list is: Source1 Source2 Source3 When I select 2 values, the data is stored as: Source1Source2 Is there any way I can select the delimiter? I need it stored: Source1::Source2 I don't even HAVE to have it stored this way, it could be done when I export it to a coma delimited file.....the software I am importing this data to requires it to be ::: delimited. I a…

G'day I'm new to this and can not for the life of me find out what I'm doing wrong. I have made a database the main dispatch form has a portal in it and I'm stuck on a few of the fields. What I want to do it multiply Quantity by the perunit1 price and put the result into perunit3 field for cash customers but I want the perunit3 field to remain blank if I don't enter a price into perunit1. Don't laugh to hard but this is what I've tried so far. If(IsEmpty(PerUnit1);"";"PerUnit3=Quantity*PerUnit1") This always gives me $31 no mater what I put in the perunit1 field. This one always gives me a total of $1 If (PerUnit1 ="";"";"Quantity * PerUnit1")…

Hi all Just started yesterday with filemaker pro 11 advanced. I need to produce some sort of hour registration, but i have some questions which haven't been answered by searching via google or reading manuals. Hope you can help me. 1. Is it possible to install some default theme? I mean that every input-field I generate for multiple tables within one database shows default in a custom theme. And not having to adjust every edit-field by hand. 2. Is it possible to adjust the table view layout-wise? Like position on screen , colors etc. 3. I've created a checkbox (field is type number) and on layout the control style is checkbox se, values from Bool…

In my data base I use quite a few drop down lists to save time in typing. There are several places where I have to go back in and hit enter to create proper paragraph separations. My question is can I put a carriage return in the line of text that will allow for the appropriate spaces in my text box?

Hey, I have a drop-down list with auto-complete from value list enabled. Go to next object using TAB and RETURN are enabled. If I'm in the field and type the letter A to start my auto-complete I see the dropdown... I press the down arrow to move my selection from Apple to Apricot and then press tab. It works. But now if I shift-tab back into that field, I see a list of all my values again, but if I try and use the arrow keys to change the selection only pressing RETURN actually changes the field value - tab simply moves to the next field and doesn't update the field (like it would on a webpage for example)... this behavior will mess up my users. Any …

I have 2 tables and 1 join table. Employees Join Table Vehicle I have it set up so an entry in either Employees or Vehicle creates a new record in the join table so if you're in either table, the relationship will show up on either side. So I have a portal on Employees and Vehicles from the Join Table. In the Portals are the fields from the join table. These fields are drop down value lists. From fleet it looks at Employee name and from Employee it looks at Vehicle Description. When choosing one or the other makes shows up on each table. Everything works fine. What I'm trying to do is exclude in the value list the vehicles or employees that have a…

I have a problem that I do not understand how to solve. I created a solution for a therapy practice. One field is for a description of the service for the purpose of billing insurance. I set the validation for the field to value list "psychological services" that uses "custom values". Initially I entered standard values, but allow the user to edit the list. The problem is that when I update the solution I have to find out if the user edited the "psychological services" value list and enter it into the new blank database I give to the end user. The solution contains many value lists and this is time consuming. Any thoughts or suggestions to importing…

Hello, Over the last couple of years, I've built a job management database for our company, but I only "work" with the program a couple times of year, so I'm a little slow. I have a value list from DB1 that I use as a pop-up list when creating new jobs in DB2. I was hoping to limit the value/pop-up list options to contacts who work for the same contractor (Customer Name) that I've already entered in DB2. I know almost anything is possible with FileMaker and searching your threads has always helped me in the past! Thanks, Tara

I have updated a data base I created, but my old records do not show the current information needed to take advantage of my implemented Value list. To make the value list work I needed to combine some fields and changed the combinations along the way while I was refining what I wanted (this combined field is what is not updating in the old records). All new records are fine but the old ones have this one field still showing the old original gathered information. Is there a way I can update the old information so all records are using the needed current information for my value list? Thanks in advance,

I have a recipe dbase, using o.a. the tables: - "recipes" and the table: - "search recipes". Both tables are related by the field "recipe name" (recipe name = recipe name) In the layout of "search recipes" I have the entry field "recipe name". Any entry entered in this field should generate results in the portal (from the table "recipes") So I want the entry "tomato" to deliver the results: tomato soup spicy tomato pie tomato soup 2 Or when I enter: "tomato soup" it should result in displaying: tomato soup tomato soup 2 I just cannot figure out how to do such a thing with FMPro 9.

I am very new to FileMaker so please be kind. I have a field which has a drop down list of values. The values are from a field in another table. I am aware that I can have the list display additional values from a second field along side the first. i.e. an item number and description. My goal is to display both values in the same field when one is picked. Unfortunately the second value disappears when a selection is made. I am willing to have a second field look up the data based on the selection, but I am not sure how to do that. My other problem is that I need to adding multiple items to the same record. Without creating a ton of potentially unuse…

I have a value list pointing to a join table which I've created a many to many relationship for. In my master layout I have a portal with Pop-up menu for the selection of records and the associated value list. Everything is working correctly, except that my user wants the list that pops up to have a custom order. How can I make the pop-up list use a custom order as opposed to automatically being alphabetical? Thanks in advance!!!

I currently have a field that the users use to select their respective names when entering records. The drop down list has names and a respective district, for example: Sarah - DAL. This is for Sarah the coordinator and DAL for Dallas. There are several names in the drop down. A request by the users was to have this coordinator field auto populate when they open the file. My guess is this should be fairly simple. I am guessing that if I add security and have the users login to the database I will have the identity of the user portion solved. How do I easily take that idea and use my existing drop down list to auto populate the coordinator field? I am thinking t…

I have a value list currently displayed in a portal with related records. The value list uses values from the field that's pointing to it, but there are several items in the list that don't have any data associated with them. For example, if I want to find the name of a company in this field, say ABC Company, I select ABC Company from the drop down list, but it returns the message 'No records match this set of find requests'. So if there are no records matching, how is it even showing up in the list if it's set to only use values from that field? I'm trying to delete these values from my drop down list since they're not being used but it won't allow me; there's no way…

I have a portal and each row is highlighted with different colours depending on a script that is triggered by various coloured buttons. This works well by having transparent text fields laid behind the data fields on the portal. However, when you enter data, all the fields in the portal turn white, or whatever colour I format the body of the layout. Is there a way of fields not going back this far in an arrangement stack so that they can retain the colour of the text file behind them during data entry? Thanks Frommy

I have a field that is a Check box attached to a value list. The value list are "Amenities" and each amenity returns a number in another field. If Amenity A is selected, then the result number associated with that Amenity should be 124. I a very close having the numbers show up correctly however some of the amenities result in two numbers. For example: Amenity "24 Hour Front Desk Attendant" (Number "6") and Amenity "24 Hour Front Desk Attendant (On Call) (Number "179"). When I check "24 Hour Front Desk Attendant", the result number shows the correct number as "6" however, when if I check "24 Hour Front Desk Attendant (On Call), the result number shows both, numbe…

Dynamic Value Lists & Multiple Data Entries...... I’ve constructed a dynamic value list, which functions thus. There are (3) main categories defined. Under each main category are several subcategories, for example Main Category: Nissan, Subcategory: 200SX, 280SX, Pathfinder, Altima, Maxima, etc. Main Category: Toyota, Subcategory: Land Cruiser, Tacoma, Highlander, etc This Dynamic Value List currently only allows entry to one set (pair) of entry fields. I need the dynamic value list to provide data entry for a maximum of five paired, separate entries in the same layout. Any ideas or suggestions will be sincerely appreciated. …

Is their a way to "auto complete" text in a field based on a relationship data similar to how a auto complete works in value list? Jay

I've only been using FileMaker for a few days. They handed me a huge FileMaker 10 manual and i got through about chapter 4, before they handed me over this database to work on. A large part of my trouble stems from the fact that I'm not sure how the database is supposed to be or work. The guy who was working on it before me I think made some changes he thought they wanted, but didn't finish those changes, so gave me a non-working database in a halfway finished state. If it were an already working database, at least I could see what buttons were doing and such, right now I have buttons that do nothing, and I'm not sure if they are supposed to have a script attache…

I have two DB's related via P & F key Id fields. Within the Budget DB I have a pull down field defined to use the Payee::Payee field data to populate the field in the pull down within the Budget DB. This appears to function fine except whenever I add a new record with in the Budget DB selecting one of the data values from the related Payee DB it also adds a new record to the Payee DB? I am attempting to use the data values from the Payee DB and be able to add new records in the Budget DB either using an existing Payee::Payee data value or adding a new one from within the Budget DB.. I am not sure what I am doing wrong with this? Please Advis…

Hi Everyone, Apologies if this has been covered before, I searched first, but couldn't find the information I needed. I am running FileMaker Server 11 (I had to upgrade to 11, so that the new FileMaker ODBC Driver for PC would work with my solution) and my clients are mainly 8.5 and 9 Mac. I have pulldown menus in my solution which are a selection of products. There are 700-odd items in this menu, and the sales people are accustomed to typing a few letters in order to skip down to the product they are looking for. As near as I can tell, this behaviour has been removed in FMP 10 and 11. This is kind of a big problem for me, as we cannot live without th…

Hi, I have: two tables, A the data file containing the records & B the options file. On Table B 1. drop down list-Companies 2. 2nd drop down with the items. The second list depends on the company chosen from first list. This works fine. I need to then have the cost of the particular item chosen automatically appear in the field for "Cost". Does anyone know how to describe how to do this? M

In my student database I am using looked up values - but sometimes the looked up value changes - if a student moves to a new address. my question is if I change the looked up value all the records change their data - how can I keep the old data on the old records and only put new data ( new looked up value) on newly created records ie since the date the student moved. should I be using looked up vaLue at all?? thank you for your help

Hi. I have a database that works very well but I need to add a Quotes capability to the system. The problem is that I don't want the Quotes "page" to affect the inventory OnHand number. The OnHand field runs without a problem but I don't know how to render the QtySold inactive (That makes up, in part, the OnHand field) when a quote "page" is created using the same info as per an invoice. (Quoting capability is needed as doing a quote is a big deal to my customer and retyping the info to convert a quote into an invoice is simply not viable. Any help on this would be terrific. TIA Bob Moran

I have a data entry layout with a field showing a custom value list as checkboxes. I have a find layout with the value list as a popup menu. Performing a find using the popup menu works OK for some, but not all items in the custom value list. Anyone got any ideas?

I think this is a value list question but I cant seem to make it work. My main table is called "customer" My second table is called "phonenumbers" In the customer layout, I list the phone numbers in a portal. Each customer has 1 to 6 phone numbers. I want to load those phone numbers in 1 variable (separated by a CR) in a script. The variable is called $AllNumbers. Can someone help me with the syntax?

Hi, I’d like to have some value lists that are based on a previously selected value. ie. Car Manufacturer (Select Audi from value List) Model (A6 Avant) This is selected from a list of models unique to Audi. Engine Size (3.0tdi) Again this is based on the fact that the previous selections have narrowed the engine options down to those only available on an Audi A6. Does anyone know how to achieve this type of value list in filemaker. I tried to do it on found sets but no luck so far.

Hello all First of all hello to all, new here and new to Filemaker (as you will understand lol) I would like to ask for an idea on how to make something to work and if its possible.. it might be a bit complicated (or atleast to me it is) Ok, here's my problem.. I have 3 tabs, on first tab i want to display a text field RANK1 (will get to this). On second tab i have a checkbox (Box1) of 5 values (Val1, Val2, Val3, Val4, Val5) and on 3th tab i have a portal in which i will write some things. What i want to do is, based on how many lines i have on portal to autocheck Val5. Also some of the Val's will be hand checked.. When all 5 Val's are checked i want to s…

I am trying to alert our staff when a project change they are working on has been marked to show what budgets will be affected but still has $0 for the budget amount. I'm going to need to use this alert in other calculations so I can't use conditional formatting alone. A user (any user) will create a record and check values in a field called disciplines_affected. disciplines_affected has a checkbox value list with six values(all values have to remain - the values selected also denote sets of sheets in the drawing package) ARCH SPEC STRUCT MECH ELEC PLUMB ARCH & SPEC affect the Architectural Budget STRUCT affects the Structural Budget M…

Please Please Help! I have 2 tables, Ingredients and products. The product layout has fields for line items,1. formulas1, formulas2, etc.-which is a drop down menu to select the ingredients from related to the field manufacturer. Works fine. 2. manufacturer list drop down menu related to the formulas list from the table ingredients. Also works fine. 3. I need to capture the cost per gram in the related table Ingredients for the field cost per gram in products table. The value would depend on the formula selected in each line item. I don't know if I need to use GetNthRecord, create some kind of If formula? The value list with related tables doesn't seem to work.…

Hello, I need to add some sort of mail functionality to a filemaker view, where I can freely enter a message. I seem to requite an "Edit Box" for this, but that is always coupled with a database field. Is there a way to add some sort of input box without a database coupling? Thanks in advance, kind regards, Maarten

New to fm, I have table of manufacturers with,manufacturer A, B, C, D, etc. Other tables for each manufacturer with items specific to each manufacturer. Let's say at least 2 manufacturers named A & B for simplicity. Each item has two names, English & Chinese, thus 2 fields. I need to create a layout with field manufacturer drop down menu where selection of A will bring up only items from manufacturer A in next field items with both the English and Chinese. If B is selected than only items from B should display in field items. Please help with detailed info for a newbie. The only thing I know how to do is create the drop down menu.

field item =case( company name="appple"; ipod; company name="microsoft"os:) when i entered into browse mode its working fine when i click on apple item is changing to ipod but when i change it to microsoft item is still ipod o not changing to os, i have to delete record or add new record why or what happening not understanding the problem plz help me

I have a drop down list that uses a value list that uses values from first field "Employees::id" and second field "Employees::name" Showing values only from second field. I would like to be able to add an additional selection to this drop down for "-All-". Can anyone tell me how I can do this?

i made a 2 value list (a,b,c)/(apple,ball,cat) ---- i made 2 tables with field name (short) in one table and feild (long) in other table , when i am in table 1 and if i select item (a) from table1 it should automatically change the corresponding valuelist item to (apple) in table2 is it possible can any one help me please , does the two tables should be related plz someone help in simple method

Hi, I have reviewed hundreds of posts and tried numerous things and still can't get this to work. I could use some help in finding a simple solution. I'm developing a property database (real estate) that has at least two areas where I will need a 3-level conditional value list. One is for selecting the zoning district, based on the city, which is based in turn on the county. When I enter a property record, I want to be able to select the county from a drop down, then go to a city drop down that will show the cities within the selected county, then a third that will show the zoning districts in that city. The other is the same concept, for property …

Hi, I need to pass multiple values from a dropdown list (text, 20 repetitions) on ESTIMATE layout to another dropdown list (text, 20 repetitions) on BOOKING layout. On ESTIMATE layout I compile list of equipements (with relative prices) a customer requested then create PDF file from it and send it to the customer via email. Once the estimate was accepted by him/her I reopen the ESTIMATE layout, click on button created by me which opens BOOKING layout, creates a new record and pastes values from REQUESTED EQUIPEMENTS dropdown list to an editbox field. This works well but... What I really want/need is the values to be pasted into a dropdown list (text, 20…

I recently upgraded from 8.5 to version 11. I like most of the improvements, but I have found that the drop-down list functions differently then before. Before, the drop-down "window" would resize to fit the displayed field. Now, the "window" only displays a portion of the data, followed by "..." Is this the new way the drop-down list functions, and if so does anyone know of a way to increase the displayed number of characters. Thanks, Bill

Hello, I am in a small freight business, and working to automate dispatching, reducing steps and paper. I have a list of Companies in one table (hundreds of them) - fields are all the normal stuff, name, address, city, state, zip, email, phone, fax, etc. These companies can be either a) shipper, receiver c) billing party. on one shipment they could be a shipper on another shipment they could be the receiver. I have another table called Shipments, which has fields for shipper (address, phone, fax, etc.), receiver (ph, fx, addr), billing party (ph, fx, addr). My goal is to only have 3 pull down lists to provide quick selection of the shipper, re…

I created a value list for "Employee Full Names". The list is taken from the Employee table and from the field name_full. In a layout for a table called "notes" I have a field called name_full and am made it a drop down field from value list "Employee Full Names". For some reason it only shows 1 name. What am I missing?

I've just come across a problem not previously encountered. I've just started using FMP11A 11.0v2 and, only for the first record in the database, a couple of value lists do not appear. They appear for all other records. If I duplicate the first record they work OK on the duplicate. If I delete the first record the problem transfers to the new first record. If I make a small change to another field on the layout, the value lists work until the file is closed. Opening the file in FMP8.5A doesn't display the problem. The file is hosted on FMS10 and I've opened it with a full access account. I'm also having problems with these VLs not appearing in PHP CWP. An…

I have several fields in my table that all should be selected from a master list of options. In some cases the fields should only have one selection from that list, in some it might need more than one selection. So I've set up a second table which is the master list. I know that I can set a filed to have to select from that list, but what about when I need more than one value? How do I have a field select multiple items from that list? Once that's done, when I want to present the information, how do I output the multiple selection items in a comma-delimited text string? Thank you.

I am trying to create a script that takes a value list, loops through each item in the value list, gets the value of the item, and then performs a find for that item. I am having difficulty find the functionality or a custom function that will accomplish this for me. Basically, what I want the script to do is get the total amount of items in a list (done this, this is easy), go to the first item, get the value of the first item, loop through and get the value for each remaining item, and then exit upon reaching the last item. I found one CF on Brian Dunnings website that seems to be what I want but I can't get it to work; it just returns a 0 value no matter wh…

I'd be lost without this forum, if for no other reason that I got honest to goodness outstanding answers. I have 3 tables... Customers Customer's Products Products I've created a layout for Customer's with a portal for the Customer's Products that lists all the products that that customer has purchased from us. I now want to have a separate layout where they can either add new products or edit an existing one. Typically, new products will get added through invoicing, but sometimes, a customer will call and say they have a product that we don't have a record of. This happens when they purchased from a reseller and they didn't send in their registr…

Hi folks, I want to set up a value list, so that when I select items on the list, it appends to other items in the field, instead of that item being exclusive for that field. e.g. value list contains (VERY simple example here); Red Blue Hat, Shoes, From this list, I want to be able to sequentially select certain items that build on each other, such that my field might, after the selections, read something like; "Red Shoes, Blue Hat," I've seen this functionality in an ipad program (Handbase) and hoped I could replicate it here. Chris

I'm currently trying to create a value list that shows only active products. I would want it to work where when I click the checkbox that makes the product inactive in its detail record, a value list created based upon products would show only active products. Thanks

I have a table with 12 subjects. The user can go to a layout where they can select, through check boxes, any number of these subjects to create a found set of records. At any time they choose, I would like the users to be able to go to a layout, where using a dropdown list, they can select one of the subjects in the found set only, and go directly to the first record that contains that subject name. I don't want them to see all 12 subjects - only the ones that they originally selected. I also want to keep the found set that contains the selected subjects. I know that value lists will always show all the subjects available, not just the ones in the found set in a circumsta…

I have a table, territories, which has 40 entries. The user can select 1,2,3, or even all all 40. Once selected I need the entries to be in all in a field separated by a comma. I am not sure how to address this. thanks, Jim

Hi everyone, Please bear with me if I am missing something obvious, but I can't work out how to display the final - rightmost - characters of the items in a value list for which I can only provide a narrow field on my layout. It needs to be a pop-up menu, which will display the full 60 character contents of each item on the value list when the user is making or changing a selection, but which will only display the * last * 20 characters of the selected item when the menu has popped down again. I should be most grateful for any help with this. Peter

Hi, I'm wondering if it could be possible to create a value list in relation with another one. I mean, for instance, I have my first value list, which is the specie, and I have the second one, that is the breed. If I choose "bovine" in the first one, I would like to have only bovine's breed in the second value list, instead of having ALL of the possible breed of bovine, horse, pig, etc. Is this possible?

Hello, I would like your opinion on this "thing" I call a "malfunction" and not a normal behavior. What do you think ? Thanks Agnès MenuTest.fp7.zip

Hi, I have encountered a strange problem with FM 11 on Windows (any version). While on OSX when I open a pop-up and start typing it moves the selection to the position of the letter I have typed. Same action does nothing on Windows, which is a problem, since I have fields with 50+ values in the pop-up and scrolling to the needed one is not an option. Any ideas? Thanks!

Hi all I am a novice at FM so apologies if this is blindingly obvious. I have created a drop down field and the values to go in them. I want to be able to do a find(s) and each time apply a particular tag in the drop down list to all of the records in the found set for retrieval later. I'd be grateful if anyone could point me to how I might do this? Thanks in advance

Hi, Using Server 11 v2, client 11 v2 ...client in city A Server in city B ...vpn connection ipsec...window environment. Everything works fine with all my layouts except for the layout that has a dropdown list to choose a customer to create a ticket. When I click on the dropdown arrow to choose from the list there is a time period lag and then several customers on the list appear to load ready for selection...if I scroll down the list then it will go blank and there is a time delay and then more load ...this process continues until all the the customers are loaded from A to Z ...Once all the customers in the dropdown list appear to be loaded then I can scroll up and …

Is somehow possible to bind multiple dropdowns to drop-down simultaneously? Or 1 dropdown with repetitive fields? My goal is make simple layout with just a few rows of dropdowns which consist of 3 fields. row1: |Dropdown1|Dropdown2|Dropdown3| : rowN: |Dropdown6|Dropdown7|Dropdown8| And if user tries edit any of dropdown in one row the others DP will rollout too.

Hi, apologies in advance, I am at the bottom of the learning curve. I thought that I'd done reasonably well but then encountered a bit of an obstacle. Any pointers appreciated! I have created a database from a starter solution (contact management) for a small series of events that I am developing. I need to create something like a value list with a range of tags (for want of a better phrase) that I can apply to individuals in my database. I might need to apply one tag to one person and five to another. What is best practice to be able to do this? I realise that when indexed it is likely that I will only be able to search on one tag at one time. Than…

Hi.. b4 i wander in the wrong direction.. thought i ask something I can't find answer to/// TIA I am currently using current time and time to timestamp our messages/// Now we have a client account in another Time Zone.. Thought I add a Account field acc_timezone It be + or - number from our current timezone, that the operator is working at taking a message. Trying to figure how to timestamp Client message with their own timezone? If not isEmpty(acc_timezone) [color:blue]How might I calculate +/- from current date/ time? else */ default use system time to mark message Endif

Not sure if there's an easy solution to this, maybe I'm being dumb again! In Browse mode, users select from a drop down list which stores the ContactID number of related contacts. A lookup field displays the select Contact's full name. In Find mode when the user searches for a contact by using that value list, the Lookup isn't performed as in Browse mode, so the user thinks that they haven't selected a contact to search for...any elegant solutions to this one please?

We are trying to create a dynamic Value List that filters the results in real time as the user enters data into the destination field. We are also trying to format the value list in a unique way in which all sub-categories are indented just below the main category. We would also like the Value List to display a separate column containing an additional value. I have created a quick screencast that shows the QuickBooks functionality that we are trying to achieve in FileMaker 11. Is this possible? If not, is there a plug-in for FileMaker that would allow us to do this? Thanks. View ScreenCast Movie

I am trying to create a value list that will return the placement that the record currently occupies in the current found set. On the surface this sounds very easy; just use get(RecordNumber). The problem that I am running into is that the records I am trying to count are first created in an unrelated table, and then imported into the table that the value list is part of. The reason for this is that the record represents a list of choices presented to the user to choose from a master list of examples, and then once the user has selected from this list, is then imported into the related table where I want the value list to count. My solution to this problem was to …

Hi All, I have created a solution which includes new tables to store records and along with tables of records imported from Access databases. At least one of the imported databases is not formatted in such a way that I am easily able to perform lookups based upon related match fields. I have included a sample file to illustrate my predicament. Layout "Range1" illustrates the imported database while "Range2" illustrates what I consider to be a more conventional layout. The problem is I have approximately 30,000 records in the imported database that would have to be copied several times and split up to contain one term and rate per record if I am unable to perform look…

This is one of those things that might be staring me right in the face but I can't figure out nor can I find any threads here discussing it. By default radio and checkbox selections always show the button/checkbox to the left of the value it represents. Is there a way to align them to the right? I am mimicking some vendor supplied form in a layout and they are right aligned. I can think of a couple ways to hack it but I thought I would see if there's a 'correct' way to do it.

Hi all My relationships are shown in the graph attached. When I created a new tax in the ArtworkTax table, my drop-down list that is using a value list determind by field was not updating. I was using value from field (TaxID), using also second field (TaxName) and showing only values from second field (TaxName). I hadn't left any TaxName fields blank. I swapped the value list to only use the 1st field (TaxID), now the drop-down list shows all records in ArtworkTax table. I changed the value list to show also second field; all records now show in the drop-down list. If I switch back to show only second field, only 1 record is shown even though I have three …

Okay here goes- We have a field displayed as a checkbox set, the data it displays is the lists of services the customers offers, the description also includes the price. They want to be able to click a checkbox or multiple checkboxes per line item & the description & dollar amount appear on that line. I have a script that takes the items that are checked and puts it together on one line by simply using the substitute function, that substitutes the paragraph mark with a comma. Now I just want it to grab the numbers at the end of the description and put it in the amount field. Example of my list: Shampoo 15.00 Blow dry 10.00 Manicure 15.00 In th…