Value Lists

Hello All! I'm totally new to FMPro. Having a bundle of fun and very pleased with myself until I tried to define a value list with images in a folder on my hard drive. I'm trying to get a container field to offer a choice of 5 jpeg images. I have tried every variation under the sun with that file path and get "...snytax/can't find file..." error message every time! Arrggghh! Thanks for your assistance! Lisa

Hello, apologies if this has already been answered but I have searched and not found the answer. I know that there is a problem with the Pop-up lists being slow in version 7 - they were much quicker in my older version - in my older version if you typed in the first letter of the search it moved straight away to the names beginning with that letter but in this version I have to wait until the list comes up then type and wait. Is there a workaround or way of improving this? Thanks a lot Grace

I've got a conference database, with 4 tables: Contacts Events ContactEventsJoin Activities There is a many-many relationship between Contacts and Events with ID fields through ContactEventsJoin and there is a one to many relationship between Events and activities (Many activities at 1 event). Each activity has a cost so in the Activities Table, there's a Name Field and a cost Field for each record (and an Event ID field providing the relationship to Events). In the ContactsEventsJoin Table, there is a field for activities. I've made it a checkbox set using a list of the related values in the Activities table so that I can check off what activities…

I have a couple places where user needs to select a name/place from a very long list. I have put the list in a portal which filters via relationship with whatever they key into a global field outside the portal. Works pretty well, but you have to exit the field in order to see the filtered results in the portal. Showed it to the user and he says "can you make it narrow down the list while I type?" Lots of Windows dialogs in Windows apps do this so... it's expected. So is there a way to do this? Is there some kind of looping script that might respond to each key stroke in the filter field? I already have a plugin that can trigger a script upon exiting the f…

I know this type of question has come up before but I am still very new to this and I can't seem to figure out how to make it work. I am designing an Order Entry Database for my Fabrication Job Shop. I have Two Fields in the Order Entry Table. Field One is "Sales Type" which includes Fabrication, Rolling, Stress Relieve, Burn Outs, and Miscellaneous which appears as a pop up menu from a Custom Value List. Once you choose the Sales Type, I would like the Second Field to disply detailed information for each sales type. So if "Fabrication" was selected from the first field, only fabrication descriptions would come up. It seems I need some sort of self-j…

(Version 5/6): I have created a Relationship between two of our files. I sorted the Relationship - and tested it with a Portal. Works great, newest records first - Descending Order. When I use the Relationship to create a Value List, the results are NOT sorted. Comes out in creation order - oldest records first. No obvious way to sort in the Value Lists. Anyway to ensure the Value List (using a Relationship) is Sorted?

I've searched / read all the previous posts I could find on this, but still can't get it together somehow. Here's what I want to do: I have Table A, Youths. I have Table B, Hours Worked. There is a simple relationship "Youth Hours" between Youths <--> Hours Worked, based on the YouthID (unique ID.) In a layout based on Youths, I have a portal that displays "Youth Hours". For each Hours Worked entry in that portal, I want to be able to drag down and select a Category (Onsite, off-site, home) and then, in the next drop down menu, have the appropriate sub-category show up. (Mapped out below for clarity) If: Category = Onsite SubCategory choic…

Hi, I'm fairly new to FM and am using FMP7. I'm creating and Invoice database which has a list of Invoice Items. Each Item has a pop-up list to first select the product type we are trying to place in the invoice. I then want the product name field to have a pop-up list containing product of the selected category. Now the trick is that each product category is a different table. How do I get the pop-up list to look into a different table to create a value list, based on the input of the 'category' field. This seems fairly straightforward, but the FM tools arent' allowing me to do this in an obvious way. Help is appreciated, thanks …

I have a database for tracking invoices. There are invoices, puchase orders and payment tables and once the invoice has been registered the invoice number shows up in a value list within the purchase order table. Once an invoice is paid it is marked as such in the payment table by selecting the invoice number and a radio button. What I would like is for the invoice value list in the purchase order table and payment table to only show the invoices which are still to be paid. Can anyone help? Thanks

Hello all, please forgive me, as i have done my 'searching' and seem to have found 30 people with the same question as me, and about 30 different answers. all of which seem to confuse me. sorry i'm a newbie. i have a value list for medications. listing off 30 meds. and i need to make script to submit a report showing all of the 'medications' in the value list 'medications' along with how many times each of them occurs throughout the records. **Please keep in mind, these values show up in a portal** as i'm sure that has to do with the problem. ie. Accupril 18 Actos 4 Altace 0 Clarinex 6 etc. I would also like to eventually selec…

Hello, I'm a pretty new user and I'm sorry if this question is asked all of the time, but I couldn't find the exact thing when I searched. In simple terms, I have two fields on a layout with pop-up value lists. The second field's value list should be populated based on the first field's value. So if the user chooses "Dinner" in the Meal field, the Menu field should come up with "Chicken" and "Beef" as choices. Since the Meal field isn't conditional, it's just a static value list. The Menu field's value list is sourced from another field that contains a calculation formula based on the value of Meal. Question 1: The problem is that when a record is creat…

I have a field that is generated with values from a custom pop up list. When you click into this empty field, the pop-up list drops down so you can make a selection. After you make your selection, the pop up list continues to drop down. (again & again & again) Is there a way to automatically tab to the next field after a value has been clicked on (selected) from the value list? Thanks for your help. Jarvis

I'd like to create a value list for a popup that displays values from the combination of two related tables, not just one. Any ideas on how to go about this? Matt

I have a field with Field Format set to "Pop-Up Menu" and a Value List Selected. In Browse mode I want a particular item from the Value list to be displayed as the "default" value. I've tried several approaches, but the only one that seems to work is using a script with "Set Field" and setting the value. Is there a "better" or more general way to select which Value List item is the default that the list will display? (Pop-up Menu or List, doesn't make a difference.) TIA.

I am very new to database creation so I appologize if my newbieness gets in the way. I am creating a database for my own record keeping purposes as a Montessori teacher. I want to have a few sets of checklists on a table of the presentation I am about to give. The first would have the names of students who have not been given the presentation at all, the second and third are a list of those that have had it and may receive it again. Like this: If class is- Bobby, Suzie, Janie, Richy, Harry List 1- Suzie, Harry List 2- Bobby, Richie, Harry List 3- Bobby, Richie, Harry I have value lists for List 2 and List 3 which comes from a table of the …

I've got a membership database, and I keep track of what years someone was a member with a checkbox. I would like to see the last year everyone in the database was a member. Is there a way to pull the last selection from the list that has been checked off? Thanks, Jeff

If you have a VL consisting of an ID and a calculated names field, only 1 value will appear in the drop down if there are two ore more identical names in the database. Is there an elegant way of workaround to show all these valid values? I use to trim all values used in the calc-field for good reasons so blanks don't work in this case. Maybe include a 3rd field into the calculated field...what I actually want to avoid. Another thing to consider is there are hundreds of records without any name (like the main address of companies without a personal contact) I don't want to show up in the drop down if there's a workaround to really show up all entries...

I'm building an inventory database for our lab, specifically regarding the storage of cell culture samples in liquid nitrogen. I've got some familiarity with database design and normality, and was wondering if I could put the functionality of Filemaker to work for me. There are two containers for these samples. They contain varying numbers of racks, and these racks contain a fixed number of boxes, and these boxes have different layouts (all depending on the container, essentially). Here's a basic overview; Container 1 Has 6 racks Each rack has 12 boxes Each box has a "pie" shape, which looks like this: XX XX XXXX XXX…

Hi, I'm a new Filemaker Pro user, having moved over from Microsoft Access on a PC. I have a database with a number of tables, two of which are 'Companies' and 'Individuals'. The Individuals table has a 'Company' field that is related to the ref field in the Companies table. When adding/editting Individuals, I want to be able to select the name of the company from a dropdown list and have the Company field automatically populated with the ref from the selected record. This is the bread and butter of relational databases, but I can't find out how to do it in Filemaker. I can use a value list with a second field, but it is the numeric reference that is …

i have 2 tables with a common field related in table 1 i have several values in table 2 i have a field with a value list that take the values from table 1, when i update the field on table 1, is not refreshing the value in table 2 that is selected, i have to reopen the list and reselect the value what can i do to update the selected value, both fields are text thanks

Hi I have a field a with a long value list which is defined to contain only specific values. But the field contains some imported data which includes entries that are not on the list and are therefore not valid and need to be replaced. I would therefore like to do a search to find all non-valid entries so that I can edit them to conform with my list. Does anyone have any suggestions? Please forgive me if this is a silly question, I'm not an expert at all in this. Many thanks eelandsaphire

I am trying to generate a value list from a vendor table. This table has both active and prospective vendors contained in it. I would like to generate a value list of only the active vendors. Is there a way to accomplish this. Thank you, this forum has been very helpful as I am learning filemaker.

I am attaching a file that has 3 tables. All I want to happen is on the Popup layout, when you select a supplier from the popup list, have only the contact names that pertain to that supplier come up in the contact name popup. I have done all I know an have read countless posts but am still unable to figure it out. Please hook a brother up! Phil PopupTest.zip

Is there a way to change the order of a value list when defining from a field? Let's take for example; Table "Blah" NAMES JIMMY BOBBY RAUL ANDY a value list defined by NAMES from Table "BLAH" will come up in the pop up list like ANDY BOBBY JIMMY RAUL .. is there a way to enforce the order listed in the field as the order that the values come up in the list? Or is the alphanumeric sorting undoable in filemaker? Thanks, Joel

How do I easily count items in a value list? I have been using an IF statement field like: if "item" 1,0. Then I use a summary field to sum the counted items. This makes 2 fields per counted item, which really uses up space. There must be an easier way to do this.

I have a database with more then 600 fields. For the users I have made some preselected exports they can select from (nodialogs, straight into a excel-file). But I want them also the have the possibility to choose from a selected list of fields. I have made a custom valuelist with the fields they can select. I have found the method (patterncount, etc.) to see which fields the users want, but then? If I make tmpfields and fill them with set field I have to do that for each record. Is there another way to solve this problem? Thanks Bea

Hi, I have some global fields as a pop-up menu (showing a value list), placed on the header part. For some reason, the values cannot be changed while in the list view (form view works). Is there any way around this? Jari V.

The database works fine until I try and access the pop up list (5000 entries) and type in the first letter of the last name to get to the place in the list I want. Then I get the spinning colored ball of death. I can scroll through this list manually but as it is a big list I want to get to i.e. Smith, James and so I press in "S". I am using OS 10.4.1. and FileMaker Pro 7.0.3 to access a database across a VPN (using OS 10.4.1 built in VPN software) the databases are hosted on a Macintosh G4 with FileMaker Server 7.0.3.

I've attached a value list to a global field on a data entry screen. A click in the field displays the value list. A click on the value enters the value into the field, BUT the pop-up list re displays. It keeps doing this until I click somewhere other than the list. Is this normal behavior? I would like the list to close after a selection is made. Thanks.

Hello all, I am making my first database and I was wondering if it was possible to create a pop-up hierarchy when searching for itmes. For example i have a bunch of images i need keywods for. Is there a way i can have a first list that is say [airplanes, vehicles, boats]. And when i select vechicles to search, the other list would appear as [cars, trucks, minivans]. It seems like a pretty logical way to search for things. Is it possible? Thanks in advance.

I would like for telephone service representatives to be easily able to enter the make and model of certain equipment a customer has when on a call (to check for compatibility). I am working with an existing database where make and model tables have a numerical filemaker-created unique serial number index and ALSO a common alphanumeric name for the product make and model (I am talking about telephones here, so there are many makes and many models). How can I set up a value list field popup for make, and then a conditional value list popup for model, where 1) the filemaker-created unique serial number field remains key as the entered value in a record showing a parti…

I have just moved a large application from FM5 to FM7 and am encountering a lot of differences. The latest relates to the behaviour of popup menus. The popup menu in question is based on a value list which references the Client file - so what you see is an alphabetical list of client names. In FM5 you could get to the right part of the list by typing in the first few letters - "Jo" for John etc. This isnt there in my version of FM7 - any way of getting this functionality back ?

I have a series of value lists offering a conditional list structure (e.g. Category 1, Category 2, Category 3, Category 4) The first value list (Category 1) uses values from a field in another file and the others use related values from other files. When I open my file as a host it works fine, but opened as a shared user (using another password) on another PC another value list has attached itself to the first field. (Value List for Category 3 now attached to Field: Category 1). Can anyone advise?

I have a field which users can either input a NEW value which is then added to the list or select from values previously added to the list. How do I delete or change these values??? Thanks

Hello, suppose you have a value list of say payments. you specify all the ways you can pay for something. The value list contains "master charge, visa, american express, check and cash", the field on the layout is formatted as a check box Set. The user checks off one or more check boxes. How do you know which ones have been checked. for example, maybe you have a button with a script and you want to say "YOu checked this and that and that".. is there a function to do this in FM7? Also, suppose you want to set one of those check boxes via script, how do you do that? thanks for any help in advance, sincerely, J__

This is probably an easy one for you advanced developers: I've got a database of boats (I work for a boat brokerage in Alaska, remember me?) Boat ID's are set by auto serial numbers. Over the course of the last 3 years, many of the records/boats (IDs) have been either deleted or exported to archives. We want to keep the IDs to 3 digits, and we want the existing boats to keep their IDs. (Sometimes we re-list the same boat and pull it out of archives.) So, out of 98 active boats and 250 archived, I've got 650 ID numbers to dispense. The available IDs are specific (i.e. 108, 109, 113, 119....994, 997). I have entered them into a custom value list and turned off…

Hi everyone, I am confused. I have an emp table and a time sheet table. I have a pop up list in the time sheet table to show all the SS#'s in the emp table. The relationship between the two is that SS#. What I want to do is create a pop up list that only shows the active employees from the emp table.(field name status) I have created a self joined relationship in the emp table with a global field that is a constant "active" called gActive. the relationship is gActive to status. I Then created a pop up list with "Use values from field". Using Emp:SSnumber and clicked "Include only related values starting from" Self Active. This works great if the record already e…

Hi, I have a large list of supplies. I am trying to create a simplified menu that branches out by catagory type, then specific items . I have seen this somewhere. I know on websites... Can this be done in FMP?? Thanks for any help you can offer.

I have a checkbox that displays values from a related table. How do I sort those values within that checkbox? Thanks.

I'm still working in Filemaker 6.0. I would like a pop-up list to activate a script after the entry has been made. I have created a script that will activate the pop-up list. However, the script doesn't wait for the entry before finishing. I hope there is an easy answer. I can't seem to find it by searching the forum. A pop-up menu will not work in this situation. I'm running Windows XP. Thanks for any help.

I would like to find the largest number/value in a long list of fields such as the latest date in field "date". This value is then to be used as a criteria in a find request. I know I can sort and then go to the last record but there must be something more elegant out there. Any suggestions?

Is it possible to sort a dynamic value list (from a relationship) on a field that doesn't appear in the pop-up? I know that you can place a 2nd field in the vl and sort on that, but I don't like to have a number showing in the pop-up that is totally irrelevant and confusing to the user. Even more challanging: I want to place a separation bar into a dynamic vl. The bar is easy to get by inserting a simple "-" into the depending field, but they always ends up in the top of the pop-up. Does anyone have any ideas about this, or is it just impossible? Greatful for all answeres!

Hi, my problem is I have 3 diffent fields and only show in one pop-up list! like below: Field 1 (APL) Field 2 (APD) Field 3 (APP) and Pop-up list show APL in one field! APD APP Thank!

Hello, I was wondering if someone can help me with this. Basically i have two drop down menu list. One is call Locations and the other is call Program Names. What I want to do is if someone choose the Location Austin from the first drop down menu, i want to only to diplays in the second drop down menu all the Program Name that contain the words Austin. i think, it can be done through Conditional Value list but i am not sure how start. Thanks Victor

How does one display selected (more than one) values from a value list with more than two values in the list. I have a school PTA database (one table) with all student names and their parents. To join the PTA, I created a value list listing - student ; parent1; parent2 with check boxes next to each. Sometimes all 3 joined; sometimes 2 or just one. In trying to display actual names from the choices I created a field for each to display each selection which works fine except when 2 check boxes appear in the record and nothing is displayed Case(PTSA_Membership="Student1";Student) I realise Case only outputs one result. Stephen

Hi I am new to filemaker and am stuck. Is it possible to have a field like "wine_producer" and once it has a value entered (a record has been saved) , on the next entry the field becomes a popup list and the user can pick from the existing entry for selecting the wine producer? Thanks Regards Zaxatron

Hi- I just can't seem to find a work around for this one... Here's the scenerio: (running in Find mode) I have a field called "field_search". This is a pulldown field, where the user decides which field they'd like to search. Search criteria is entered into a field called "search_criteria". What I need to happen is depending on what field is chosen in "field_search", the appropriate value list will appear in the "search_criteria" field. What I have tried: (all running in find mode) Enter data into "field_search". Click on "search_criteria" field, which executes a script that populates a global field called "pulldown" with 'set field' with data from …

Can't Figure this one out. I WILL SEND SOMEONE MONEY THROUGH PAYPAL IF THEY CAN SOLVE THIS ONE! I have a deadline to finish this for a client. I have a value list for types of vinyl. [color:"purple"](3341, 4512, 664859, ect.) I Need a calculation to charge different type of labor costs depending on what types of vinyl are selected. [color:"purple"](1.50, 2.50, 3.75, ect) PROBLEM: The value list will be changed, so i cant very well write the calculation like, [color:"brown"] if ( vinyltype = "3341" , 1.50 , 2.50 ) i cant use that because some day the vinyl type [color:"purple"]"3341" might be deleted and replaced by the client with [colo…

Hi, I am looking at using Filemaker to create a database and am trying to find out if it is possible to use a Trackbar or Slide bar to set a field value (determined by preset entries). Is there a 3rd party product available that anyone knows of? Thanks, Steve.

I have a pop up list of contact names whose values come from a field in a related file. I want the names to appear in the list as first name last name and be sorted by last name. Instead they are automatically sorted by first name. Any suggestions as to how I can get the list to be sorted by last name? I really don't want them displayed as last name, first name.

I have field with multiple selections, one of which is "active". I set the find to find "active". I want the value list to only show the "active" members in the found set. Instead it shows all. What am I missing?

all, we recently upgraded to 7 and ran into a strange problem and I hoping the group could help. We have an Invoice file that has two sets of repeating fields. One for Labor Codes and one for equipment. The user enters the first field in the labor line and a pop up of the code # and Description field show up. When one is selected the labor code gets put into field A, the description goes in field B, and the unit cost goes into Field C. This works for the 1st row of the repeating field but not the remainder. When you enter the second or subsiquent rows you see the Code # and Description. Once selected the Code # gets pasted into Field A but nothing get…

Is there any creative way to have FM pull up a particular value list (i.e., "Type List For Class ______") based on the value of another field (i.e., "Class")? I don't want to involve button-driven-scripts or to require users to manually change layouts. BACKGROUND: I have a database where I have a field that is filled with a number of "Classes", and a number of "Types" -- the types basically being sub-categories of each Class. Type and Class are seperate fields. There are so many types that allowing users to choose from a value list of all the types entered thus far is becoming extremely cumbersome! So what I want is to only show value list based o…

I've just converted a FM4 file to FM7 for testing and some minor modifications before we do a company-wide upgrade. I'm finding that one of my pop-up lists no longer allows a keyboard shortcut to go to a certain part of the list... i.e., in the pop-up list of about 800 client projects, in FM4 users could type a single letter (or 2 or 3 letters if you're fast enough) and go to that part of the list. In the FM7 converted file, this is no longer working. I have another pop-up list (of employee ids) with only about 40 values, and I can still "go to" in that list with a keystroke, but it's not working in my big list. I'm wondering if there's a property or setting tha…

I use a value list with some 6000 values that show all names of the people in a certain database. Actually there's the record's ID and a second field that calculates the full name. Both fields are indexed, the value list is sorted by the calculated name-field. By clicking into the field that holds the list and type-ahead it takes a while to get the right alphabetic character highlighted. I know, the list is quite long and so on but it was much faster in FM6 than it is now in FM7 (7.0v3). Any next time you use the same field it works much faster. Another strange reaction of the type-ahead is that sometimes first the very last value of the list gets highlighted and by typ…

Hi Everyone- Here's my situation. I am creating a searchable catalog for a customer. To make a long story short, I need to have a value list be dynamic in "Find Mode" so if "company name" has been chosen as a search option, it will come off the value list so they cannot add another search criteria with the same field. To throw another wrench into the problem, I need to only have this happen if the user chooses the "and" option. I have found similar postings for this, but they do not work in find mode as far as I can tell. I just can't seem to wrap my mind around this one! I am running in OS X Jaguar and Developer 6. Thank you all in advance! -Ren…

Hi all, I'm creating a timesheet database that I can use to track the hours for employees of my consulting business. I've enclosed a copy of my database to illustrate what I'm trying to accomplish. An employee can select which project they're working on (from a pull-down menu) and then enter their hours for that project. The problem is that as we do more and more projects, that "Projects" pull-down menu is going to grow very large and an employee will have to spend 10-15 seconds scrolling through hundreds of projects in order to select the correct project and enter the hours for their work session. Not only will this be inconvenient for them, it will no doubt lead to er…

I have been tracking donations in a set of repeating fields (date, amount of payment, type of campaign, etc) for the type of campaign i have set up a value list. individuals can donate to more than one campaign so have a lot of folks who have a number of different items in the repeating fields. how do i perform a find request on only one type of campaign without having the other types show up in the found set? ultimately, i want to be able to do caluculations or summaries on how much money has come in from each different campaign in the value list but when i do a find on people who donated to one of the campaigns it also displays any other campaign they do…

good day! i'm on the steering committee for a new non-profit group in the pacific northwest, and trying to teach myself FM for our membership database. i've used it before for really basic stuff like mailing lists, but this may be out of my league. i learned some simple script/query writing years ago, but don't really remember much. for our trade directory, each member has four listings, each listing belonging to one or more of 16 categories in a value list(some listings will belong to several categories). i need to create a columnar table for each different category with all the corresponding listings and the contact info for the member. these tables wil…

On a file I have used for years, when I am in Browse mode, only one newly created (and not the most recent) field will show me the pop-up value list. This is a file with 12 pop-up value lists. This occurs in all layouts. Any ideas anyone?

HI, I have one text field that has one word in it. (this is a global field) I have another field which has a value list in it set up as checkboxes. I have a third field that holds the result of the comparison. Each record will have at least one box checked, but may have more or even all of them checked. For each record i need to compare the text field to the value list field. If the word is checked in the value list field, i need a third field to be marked with something (yes or 1...). If the word is not checked in the value list field then i want the third field to be empty (or produce a 0). I hope i have explained this properly. I have tried vari…

Hello Experts, I'm stumped. Working in FMP7 on Mac OS X. Bear with me... SHORT VERSION: I would like to create a value list showing only related records, but the underlying relationship needs to be based on a calculation field which references related fields, and so is not indexed. An unindexed field (correct me if I'm wrong) cannot be used as a match field for a relationship. Is there a workaround to create this value list so that it shows only field values from a subset of records in a table? DETAILS: In my business, I sell hours of work to my clients. I have contractors who perform the work and bill me by the hour. Each pairing of client and co…

I have a file for staff which has input for first name, last name, 5 checkboxes (each a different field and value "1"), and 5 fields based on whether the checkboxes are checked or not. For instance, if the person belongs to the custom department, the related checkbox is checked and the persons first name is copied into the "custom department people" field. This is done by Define Database/Field=Calculation. I can then create a value lists in separate files based on the fields in my staff file. So if someone belongs to the custom department, that checkbox is checked and their name will be copied into the "custom department people" field and listed in the value list in …

Hello, hopefully someone can point me in the right direction with this one, I have two value list of times, start time and end time and I have another field that's a calculation field based off of my two time value list when I subtract end time from start time I get and whole number for instance 1, 2, 3 and I would like a more accurate calculation for instance START TIME 4:00 AM END TIME : 5:15 PM RESULT : 13.15 HOURS USED IS THIS POSSIBLE?

I'm trying to find a way to color text in a pull down list. Does anyone know if this is possible? Or is there another workaroud for this? i.e. a way to type in a specific work like "Active" and it turns green based upon a calc in another field. Any suggestions are welcome. Thanks!

i am trying to create a value list that lists the values from the field that I require plus an "ALL" value. I thought I had it worked out, but find that when I add a new value in the table it does not update my caculated list. I have a table Zones which contains zone ID (unique) airline to which the zone belongs (which can occur many times)and a list of city codes that apply to this zone. When viewing the records through a portal I want to be able to show zones listed per airline plus the ALL to show all zones regardless of airline What I am trying to do is to creae a value list that lists all iairline codes in the table plus the "ALL" value... and that i…

I have 6 categories Artist,Client,Contact,Customer,Payor and Writer(s) in People table. In a Catalog table and a License table I need to pull up each People table category seperately. One pullup with Artist, One pullup with Client, etc. Have category field in people table. Have a Category table using categoryID for relationship to People Table. User clicks button that enters "Artist" value in category field then enters namefirst then namelast. What would be the most efficient way to do this and how? Thanks to all the people who support such a great site!

I have created a series of 4 conditional value lists based on music categories showing entries from 2 fields(e.g Code No & Category - sorted by Category). In the first value list, where each Code No is prefixed with a letter A, I can type the letter P (e.g. P for Piano/Keyboard/Organ) and I get the expected result. In the second value list, where each Code No is prefixed with a letter B, I can type the letter P (e.g. P for Piano) I get the same expected result. However, in the third value list, where each Code No is prefixed with a letter C, I type the letter P again (to try and get "Piano Duets") but the entry offered is the last entry in the value lis…

Haven't figured how to record the date in a date field when someone clicked the checkbox "on:"

I am making a Database for staff people, so we can entered our working hours. Each record content the following: Name of the Staff - Custom VL of the current staff Date - Auto entry today Date Department - Custom VL of the different department Task - Custom VL of different task Start - Time you did start working End - Time you did End working Total That's it. Here the question : I would like the Pop-up list to showed different "task" depending on the "departement" you did select. How can I acheive that ? thx guy

How can I make a value to perform a desired script when selected from a list?

I have a table called Diagnosis; it has fields for Diagnosis Code and Diagnosis Description. I'd like to use a check box to populate my Patient record (Patient Table.) My reason for a check box is twofold: 1) It lets the doctor "study" all the available codes without need to scroll down a pop up list. 2) It will allow the doctor to easily choose multiple codes. Since there are a lot of Diagnosis Codes

I'm building a database in which I'll have to calculate a Revised Trauma Score, that takes ranges of values into one code. For example: values, for a variable called Glasgow, of 15, 14 and 13 must return a "4". Values 12, 11, 10 and 9, must return "3", an so forth. In SPSS I would use the "recode", but as a newbie in FM I'm quite lost... Can anyone help in with that? Thank you!!!

I am creating a research database using medical records. You should probably also know that I am extremely new to FileMaker Pro, so I'm not quite sure what I'm doing. I have a very long value list of medications in alphabetical order that takes a long time to scroll through. Is there any way to just type the first letter of the drug and have it jump to that section of the list? Thank you! Newby

I have 12 check boxes one for each month I need a way to get a count on the number of boxes that have been checked.

Somehow I believe this will be a "no-brainer" for an experienced FMP person: I have a file of medical staff in my application - it has fields like Staff Member Name. Staff members also have a Type field - which can be P for Practitioner (ie. Doctor,) R for Registered Nurse, T for Technician and A for Administrative. I'd like to use the Staff List as a drop down list to get Practitioner Name on the Patient record. Right now all staff members show in my drop down - but I only want the "P" records to show on the list. What's the best way to achieve this? Much thanks in advance, Mark PS - I'm using FMP 7 Developer

I have a client that has an older db that uses repeating fields. For phase 1 of the project, I am not quite ready to remove them. He sells to retail and wholesale clients and I'd like to relate his inventory file which contains a retail and wholesale price to his invoicing system. But I can't figure out how to displace the right price based on where his customer is a retail or wholesale customer. Any thoughts on approach. Remember, his invoices are now using repeating fields and not portals with a separate invoice line item db.

I have a related file that builds a value list fields 'attendance_code' = A-Absent AM... 'debit' = .5 I use the field 'attendance_code' (alpha) for selection purposes but need the related field 'debit' (numeric)to be used in calculating a number of fields using the 'attendance_code VL'. Perhaps this should be in Calculations but I think I am just stuck getting 'attendance_code' = 'debit' thanks!

hi there... been a while, here is what i am having truble with. i have a field that is a value list (builders names). i have another field that is called "sites" i have 3 different value lists called different "builders names" in each one has about 3 to 5 different "site names". is there a way to have the value list for "sites" change as the name in "builders name" changes? any help would be great.

I have two related tables, PO_Job and Job. I want to produce, in a portal, a list of all jobs that do not have a relationship to PO_Job. So, I created a value list, Assigned Jobs, of all the Job keys from PO_Job. In another table, Preferences, I have a global field, AssignedJobKeys, that is a calculation: ValueListItems ( Get ( FileName ) ; "Assigned Jobs" ). From Preferences I create a relationship to Jobs: AssignedJobKeys (not equal) JobKey. I then have a layout based on Preferences with a portal displaying the jobs. After creating the calculation, the field is filled in correctly, but as I create entries in the PO_Job table, the calculation in …

I have a portal with a field filled in by pop up list. eg. can choose entry a, entry b, entry c etc. Is there a way to choose entry a then add next to it entry b, then add entry c so that the field ends up as "entry a entry b entry c". I tried to place that data on the layout and cut and paste but it won't allow. Any suggestions?

I'm sure this has probably been asked somewhere in the recent past, but.. Is there a quick way to make a pop up list field LOOK as if it has a pop up list? I mean all FM does is add a silly drop shadow for a menu, but for a list it does nothing. I've seen an example file with 'drop down boxes' that look like those on a web page. I don't know how they did it, though. Any ideas?

Simple task but I'm not sure how to make it all happen. First is a table of items, contains fields such as item number, item description, item cost. Second is a table of orders, an order entry form if you will. On the order entry page I generate a pop-up menu value list of the item numbers from the first table. The idea here is to click on the popup menu, pick an item by number, then fill in a few other fields to complete the entry for this order. My question is this ... how do I fill in the other fields on the order page? The pop-up list just fills in the one field, how do I pull the rest of the item data over to the order page based on choosing the item n…

I am developing a database designed to contain examination questions. A growing issue is the need to accommodate several tiers of questions, 3 tiers, along with related answers/scoring keys. The organisation requires that all are visible on the one page (otherwise I would make another layout linking back to this using scripts), the 'Question Bank' encompases the group of records, however the 'Question' is the core table for this layout. 1. Question Bank (2) 2. Questions (2.1...) Question Answers Marks 3. Subquestions (2.1.1....) Subquestion Answers Marks As such I was hoping to use a portal within a portal to relate subanswers t…

After I have the script perform a Find, I need to sort all the found records in an order that varies 4 different ways. Each record is in a specific category (1-4) and has it's own rating (1-5). Depending on the category number, I need it to sort records by rating, but in different orders. Example: Category 1 = Sort 1, 2, 3, 4, 5; Category 4 = Sort 5, 3, 1, 2, 4. I've tried creating a value list from a field in which I enter the order I want (to use as custom sort order), but the value list just puts the numbers from the field in numerical order. Is there any way to do this? And if not in FMP6, could I do it in 7?

Been searching posts to accomplish switching layouts by PopupMenu...Am I asking alot to be able to have a one-click selection, how could this not be a feature of FMP?...So does someone have an example (to download) of a function, script, script parameter whatever so that I (a person trying to understand FMP) can understand. For clarity: Need a PopUpMenu that has the names of the layouts that the person clicks once and they are instantly brought to that layout. This is a great forum thanks to all that take the time!

Hello I'm not sure if this is the right group to be posting to, so apologies if it isn't. I have a file called Estimate and I want to be able to display a pop-up menu of all the estimate dates for the active street address line. Can anyone tell me if this is possible and if so where do I begin? I suppose a value list would be required but I'm not sure if I need to do a find on the street address line first to get all the estimate dates and then I don't know how to get them into a value list. Any help would be most appreciated. Many thanks eSBee

Hi to all friends do you know how many caracters can be placed in a value of a value list ? It seems that there is a limitation, but I don't know !

...couldn't find a posting for my kind of problem, so forgive me if one exist - or better tell me where I can find it I try to narrow down new entries in a portal by what was entered before into the last row of another portal. In fact, I got a text database that shows different portals to other files (like contacts or projects). When I match a text to a contact (as step 1) then just the projects related to this specific contact should show up in a VL when I match the text to a project (as step 2). This works well, but the problem is, if a contact has no related project (coming from a bridge file) of course no VL exists. So what I try to find is something like a …

I've been digging around here and the posts on conditional value lists have been helpful. i.e. helpful value list post However, I think this one is a hair different... Here's what we originally started with: A single table containing a value list of 25 CUSTOM values, cap warning calculation fields for each entry in the value list and supporting summary fields for the calculations. Field 1, "Sessions", displayed the values of the pop up list and the other calculation fields would display "CLOSED" once a value had been selected from the pop up list in ten separate records. Therefore, if we selected value A02 in the pop up list in ten records, the cap …

I went back to the drawing board and fixed my previous problem but I have one hurdle left. I have now successfully set up popcal1.0 to trigger from my field "closed" and it enters the date correctly. However does anyone know why popcal comes up on the screen every time I call for a new record? Can this be disabled? Thanks to Munchie for the help on calling the calendar in windows.

Hi, I am currently creating an image database. I have a value list of about 40 projects that an image has been used in, and another value list of corresponding project codes. Some images have been used in more than one project so I have the lists displayed as checkbox sets. I would like to be able to set it up so that when the user checks boxes in the project list, the corresponding project code boxes also to become checked, and vice versa. Is this possible? I can get it to work if only a single box is checked (using the auto-enter calculated value option and setting up a case statement), but doesn't work if i check more than one box. Can anyone help? Hope this all m…

Heres my situation: I have constructed a table that lists some of the layouts im using. (easy enough) A value list has been created that contains the names of these layouts (also easy enough) My problem is how do i determine if the current layout is a member of that value list? Cheers for your suggestions.

Hello, I've recently converted my db's to 7.0v3, and notice that my drop down menus have an incredible lag. With version 5, I was able to just fly through my data entry and FM was able to keep up. Now, I have to stop, pause, wait for the menu to "open" (drop down) make the selection, wait to make sure that it is actually selected in the field, and then carry on. A real waste of time... Anyone else have this problem? Is there a quick-fix? Thanks. Travis.

is there a way to print only the checked checkboxes in a list? thank U for helping me

Hi, I would like to know if it is posible to deconstruct a range of dates, just the opposite problem we have dealt before v7. In essence. I get from related Value list the following dates 14/7/2003 17/7/2003 18/7/2003 21/7/2003 22/7/2003 23/7/2003 24/7/2003 28/7/2003 29/7/2003 30/7/2003 Bu I need 14/7/2003, 14/7/2003, 17/7/2003, 18/7/2003, 21/7/2003, 24/7/2003, 28/7/2003, 30/7/2003, ranges in pairs in order to be sent for charting. I know how to make it with a go to related records & loop passing through the records sending data to a global an gettng the result. But for speed (

Sorry, I posted this to filemaker general earlier today. Is there a way to have your words wrap in a value list? Instead of being in one long straight line? Thanks for any help, Doug

Surely there must be a way to change the appearance of a pop-up menu (or pop-up list for that matter) but I can't see a way to do this. I have searched through the help file & here with no luck. Any help appreciated.

I am using Filemaker 7 and I need to create a conditional value list and honestly would like to scream because I can't get it to work. I have 2 tables Entry and Products. In the products table I have the fields part number and workcenter. I need to display in the Entry table a product value list based on the workcenter field. Example: Operator is in Entry table she chooses Workcenter(WC) 64 I need only the part numbers for WC 64 to display. I have created a self join relationship with the Products table with WC being the match field (products2). Where do I go from here??? I have chosen the part number field from the Products2 starting with Products and chose onl…

I am in the process of designing a medications list database for my office, one where we can record a patient's list of medications they are taking during their check in process. One key to this design will be ease of use. I know that I could use an inventory-like setup, whereby I would have a table labeled med_chart (similar to a purchase order set up). Utlizing a med_join file portal on the med_chart table, it would pull information from a continually updated medications table of products used. I have presented this, and although it works, the nurses find it very cumbersome. Instead of a portal where they use individual entries to generate their chart of m…