Value Lists

I've been cruising and perusing the forums for a couple of days now trying to find out how to create a conditional value list in v4. Looks like what I want to do would be a breeze in v7, but alas, that's not in the budget. Can anyone point me in the right direction? ~Courtney

OK, I have two tables "Staff" and "Computers". I have a value list based on the "Last Name" field of the "Staff" table. On the Computers layout, I want to assign the computer to a staff member by pulling down the "value list of the last name". And when I select the last name, I want the rest of the information from the staff record to fill in as well. So, I create a new record in the computers table. Right now, I have a portal (showing only one record, as the computer can only be assisgned to one person) showing the staff. The Last Name record in the staff portal is a pull down list (with the Last name value list), but will only pull down if there is already a …

I have a VL of several initial of workers in the office. Let's say they are: AA, BB, CC, DD, EE, etc.etc. I'm wondering if there is a way to make the field be in a color pertaining to the person's choice of initials. Example: if the users chooses AA for the initials, then the box with the initial would be light blue. If BB initials where chosen, then light green. And so on. Is this something easily done or do I have to go back to the drawing board. Thanks, Kris Kauker

I have 2 fields: a Vendor ID and a related Boolean defining whether that vendor is active or not. I would like to build a value list with only the active vendors. Any ideas? It sounds easy! lol Thanks!

Is there a limit to how many lines/characters can be placed in a custom value list?

I currently have three tables. Applicants Search Committee Members Search Committee Member Assignments Search Committee Member Assignments is a join table between the other two. I currently have a portal on each Applicant record in which you can assign search committee members. The portal uses a dropdown menu using a value list of the available search committee members that can be assigned. I'd like to make it though so that you can assign search committee members via checkboxes based on that value list. Could someone tell me how to do this ? Note, I need to leave the relationship in tact, because I use information from the Search…

I tried to post this earlier today, but since I don't see it up, I'm assuming it didn't work. Apologies if this is a duplicate. I'm trying to find a way to add up all unique entries in my field "authors," and since its value list is drawn from the field, eliminating duplicates, I wondered if there is a way to just calculate the total number of items on that value list. How would I do that? Or is there a better way? Thanks for any advice, Athena

I am trying to create reports based on a value list in a bank register. I have a value list with a number of categories listed such as Electrical, Rent, Deposits, ect. I would like to create fields for the above categories (Electrical, Rent, Deposits) that would give me totals for each category. Is this possible? The report would look something like this: Electrical - Electrical total (field) Rent - Rent total (field) Deposits - Deposits total (field) Thanks in advance

So i have some tables Table_1, Table_2, Table_3 Table_1 contains ABOS (A Bunch of Stuff) and speicfically a dropdown to choose a Category based on the categories in Table_2 (that was easy enough to do), what I need to know how to do (in dummy terms) is make Table_1 display only relevant options from the choices in Table_3 right now, I am doing the Dropdown by relating Table_2->Category_ID to Table_1->Category_ID and then using a valuelist from Table_2->Category_Name What I need (trying for explicivity here) is to now display checkboxes from Table_3->Choices Table_3 contains the fields Choice_ID, Choice and Category_ID Presently my…

I have two databases Attendance and Class List. There is a relationship connecting them based on [color:"blue"] Student Name . A drop down menu in the Attendance database defines if the student is "tardy" and a check box defines if the tardy was "excused" (0=not excused, 1=excused). The Class List database uses the following "If" statement to count the number of tardys and subtract 1 if the tardy is excused: If(Attendance::Excused=1, Sum(Attendance::#Tardy1)-1,Sum(Attendance::#Tardy1)) This formula works for the first occurance of a student but if there is a second tardy it doesn't subtract. When I check off the box, the sum stays at 1... Thoughts? …

Hi.I am a newbie so please bear with me. Using FMP 7 I want to create a billing layout for CABLE REPAIRS. Each record contains fields relating to the company, cable type, employee/technician, hrs billed, rate, etc... It also includes an area that calculates the charges incurred when replacing commonly used connectors and materials on these items. I have 4 groups of fields. Each group has a "Qty" field next to a "Connectors" field. Each field in these groups is a separate occurrence. The "connectors" fields are named "A" "B" "C" and "D". I want each these to utilize a drop down value list to select one of the connector types. (Probably 20 types) The user can choose to …

I've created a value list from a calculated field using the following formula which produces the string showing the JobNumAssignConc at the front. How can I make it sort alphabetically, like other value lists do? Case ( StatusDue != "99 Closed" ; JobNumAssignConc & " " & ClientName & " " & JobTitle) Help please from anyone in the know!

I have a database with two fields. Field One = ANIMAL Field Two = FAVORITE FOOD Both fields are populated via value lists which draw their values from the respective fields. The second field, FAVORITE FOOD is constrained to using only related values from the first field. IF: ANIMAL = Bird > FAVORITE FOOD = Birdseed IF: ANIMAL = Dog > FAVORITE FOOD = Kibbel This is pretty simple so far. When you select the animal name, a list of possible food presents itself for you to select from. What I would like is to have the value for FAVORITE FOOD automatically selected as a default choice (Not as an option to pick from) so that when you c…

Hi, Do you know of any way (or workaround) where I can produce a ValueList from a calculation field which is set to "do not store calculation results". I'd appreciate any thoughs Thanks Giles

I am working on a task list manager for my cabinetshop. I have three fields: PART NAME and TASKS and COMPLETION STATUS. PART NAME is populated from a pop up value list. This value list contains the custom values: Door ---- Drawer -----Faceframe TASKS are also generated with a pop up value list but this value list contains only related values. If you pick Doors your available TASKS only contain Door activities. If you pick Drawers, all subsequent tasks choices are germane to Drawers. COMPLETION STATUS is a simple radio button: Finished -----Not Finished What I have so far is a simple conditional value list. I would like to com…

Hello all, edit: seems i did not explain clearly, thats why nobody looks at my post. i know how to make a value list based on another field, the question i have is how to make a valuelist minimum 3 level (possibly unlimited) levels deep? im stumbling to find out how to make Valuelists displaying only Values i selected in a prior Valuelist. It seems i have a mistake in my Relationships, but i cant fins out where. The first one Valuelist is easy and displays as it shoud. All Field Contents from the type table. The second one works as well, but the third one wont function. It picks up Beer, even though i selected Dark Spirits. Can anyone help me fix this file i pos…

Hi guys, I having some problem in sorting with filemaker. I playing around with People Management and using the features List View, where I can sort by First Name, Last Name etc, which I will use, but I also want to sort by Nick Name, Email Address and Phone Number. I copied sort by last name in the scriptmaker and also in Define Database section. I only changed the field I want to sort by as the other seems to be that way. however it wont move, I feel its because it's [email protected] can someone tell me how to fix this? I want to sort by the first letter then second etc like any program that sorts. Thanks in Advance.

When I select a customer from a value list I set it up so the customer's ID is shown in addition to a second, more meaningful, field. Is this the only way to do it, as the numbers in the drop down list make everything look untidy? What I really need is a way of just showing the meaningful names, but still allowing the ID field to be called upon. Is this possible?

I have a list of customers based on their company name. However, I now need to display the company's contact name along with the company title in the value list. To do this I created a calculation field, based on the various details, and set that as the field to populate the list. Instead of getting a more detailed listing, I get some company names in the list and the rest blank. What am I doing wrong?

Hi, please help me with this: (dev 7) i have 1 file with products, like ford - focus ford - contour gmc - suburban gmc - silverado in other file or table (invoice) i want appear only i want, i have 2 popup list, manufacturer and model; if i choice ford manufacturer in my second popup list i want just the two models i have in ford for example. I has this in 6 version, but now i am really confuse. I am thankful.

I have this database which I want to use in several languages. A different language = a different layout, but this doesn't change the values of value lists of course. So I have this example database (attached to the post) where when I select in -> table Main field Language the value -> Dutch the -> table Main field Country shows only the values of -> table Translations field Dutch which have -> table Translations field Active Status showing as -> Active I'm sure it is easy and right under my nose, but can't figure it out on my own.

I have a value list that is based on a calculation field. My problem is I cannot get the calculation result showing on the value list instantly. Instead, the user has to click on outside of the filed to complete the record in order to get the calculation result appeared on the list. I noticed the reason of causing this delay is that the value list turns the calculation field with index on even I've set it off in the beginning. Can anyone get me some tips to resolve this problem? Example: FY is a calculation field; V_FY is a value list based on FY The problem is V_FY doesn't show any the value until the user completed the record.

I am not sure I am in the right place to ask this question. If not please direct me to the right place. Situation: I have a field formatted to access a value list via a pop-up menu. The value list has several hundred entries sorted alphabetically. I have also opted for the "other" and "edit" options and they appear at the end of the value list. Since the list is so long, it takes a bit of time to access a value list item located at the lower end (or anywhere below the A's) of the value list as FMP scrolls from top to bottom. Question: Is there any way to utilize dynamic data entry with a field of this sort? By dynamic data entry I mean by typing in the le…

I am working on a time tracking and billing system for my company in FM7. Can anyone help with this: Projects are contained in a Projects table. Projects can have Status=Open or Status=Closed. Each project is broken down into components contained in a Components table. Each component can have one or more staff members working on it. I have a Staff table for staff. Components, Projects, and Staff are linked in a linking table which I call BillingUnits (eg: Project ABC, Component XYZ, Staff LMN). Here's the problem: When someone enters their time into an Hours table they need to choose a "BillingUnit" ID to allocate their time to. I want to create a Value List t…

I have a calendar solution with a value list containing 3 choices. The choices represent 3 differnt layouts in file B. When I select a date and goto the related record in file B, I'm using an external script from file B to goto one layout. I need it to go to the appropriate layout depending of the choice of the value list. How can I script this?

I have as an example a Car database with two fields one is called "Manufacturer" eg Ford, Porsche, etc and the second field is called "Model". When I Have a drop down menu highlighting "Porsche" I want the second field to automaticlly let me select the model as being "Boxster" or Carrera", etc. If you have a demo file I can look at that would be great. Anyone help me - thanks

Hi, I'm a newbie here, it's my first (and stupid I guess ) post... I have a list with names, the user must check the checkboxe(s) near these names. What's the simplyer way to grey out the non-selected names and checkboxes after the user leaves this field ? Thanks for your help

I am looking for a way to generate a value list based on the selection of a value from another list. Here's an example: Table::VEHICLE INVOICES Field::Vehicle_Type (Records=Focus; Escape; Ranger, etc) Field::Vehicle_Model (Records=ZX3 S; FWD XLT; Tremor, etc) Table::QUOTES Field::Select_Vehicle_Type Field::Select_Vehicle_Model When a user in a QUOTES layout selects a Vehicle Type (eg. Focus) from a value list linked to the VEHICLE INVOICES table, I need the Value List for Select_Vehicle_Model to populate itself from the Vehicle_Model field in the VEHICLE INVOICES table (eg. ZX3 S). Have I provided enough information for someone…

I still can't get my head around this. Could someone "cookbook" this for me? I get confused going to Define DB, Relationships, Value list, Field behavior, etc. I want to script/calculate which values of a ClassID (table of classes) will show in a drop down. Sometimes it will be only for a specific grade, sometimes All, sometimes, not yet assigned classes. [i've read most of the posts, here, but when I try it, nothing happens - I must be omitting some step] Thank you

hi, I'd like to find out if it is possible to automatically select the next value in a value list through a looping script, in a similar way to the go to record (first/next - exit at last) options. I'd like to use this for my room bookings database. I have relationships set up to show if a particular room is unavailable at a certain date/time period and I would like a script to loop through the list of rooms, and copy the names of rooms that are available into a global. Thanks, PJ

Post deleted by quillpro

Hi Guys, I'm pretty new to FM and I know this subject has been discussed many times in this forum but I still can't find a clear example for FM6. All I want to be able to do is make a selection in List1 and the options in List2 change depending on what was selected. I can't find examples anywhere and i'm going crazy! ta in advance, Steve K.

Hey all: I want to allow a user to select a month, day and year from popup-menus to create a search date for a find. I want to display the month name as the selection choice, but want to pass the month number as the actual data entered into a global field for my calculation. I know how to display a second value in the list, but that

FMP 7, Mac OS X: I am trying to create a value list that is made from field "source" in table "a", which is then sorted according to field "sort order" also in table "a". I have created a self-join relationship "SELF_CONSTANT" from a global field "gCONSTANT" in table "A" that relates to "CONSTANT" field in table "A" and ensure that gCONSTANT has the same value as CONSTANT in all the records. The relationship has BOTH "Sort records" checkboxes checked and "sort order" field selected as to how to sort. Then the value list is created from he field "SELF_CONSTANT::source". Most curious is that a resulting popup menu using this value list has the values from "source" f…

I think I'm stuck in FM 6 thinking. I have a FM7 DB that has 2 tables. L2 Main and L2 Bureau Raw. L2 main contains client personal data, and L2 Bureau Raw contains accounts listed on a clinets Experian Equifax and Transunion credit reports. I want a value list that shows a clients Experian accounts only. Created a relationship called EX General Accounts with a match with L2 Main to L2 Bureau raw. Social Security & " " & EX is what is in both match fields for this relationship. I made a value listed with data from L2 Bureau Raw, and to include only related values starting from EX General Accounts. The value list shows all accounts listed in L2 Bureau …

OK Dont even know if this is possible but here goes. I have got a variety of fields that are from a value list. I am wanting to have a second field which can determine the range that these value lists go for, for the chosen set of records. The value list is this ES1 Early ES1 Mid ES1 Late S1 Early S1 Mid etc etc..... you get the idea(there are 16 of those altogether) I need a field that will say that these records go from ES1 Mid to S1 Late (or whatever) this will then go to a relational database to put in an appropriate picture for a report card. Hope I've made sense and any help would be greatly appreciated. Many thanx in adva…

I need to provide a value list for a list of Codes which also displays a description of those codes next to it. However, once chosen that field will only contain the code itself and not the description. HanDBase offers a simple way of doing this called "DB Popup". Basically it is just a "link" (I don't know if this is a true relationship) to a different table containing a field for the codes and a field for the description. Once you choose which value you want, you can tell it which field to display from that table. This is so incredibly useful and easy to do in HanDBase, but I don't see clearly how this can be done in FileMaker. Any solutions? Thanks.

I have a value list generated via a relationship to another FM DB and it's contents are controlled by the values in a repeating field. The problem is that I can only get it to work for the first repetition of the repeating field. Is there a work around?

Is it possible to make a value list from a field to show in descending order? This is to show the last serial number generated instead of the first at the beggining not at the far long end of a value list. Help appreciated. Mauricio Platform: G5 / Version: OSX FileMaker Version: FM6 Platform: / Version: FileMaker Version: Platform: / Version: FileMaker Version:

HI all, Is there a better way to do this?? I have a supllier field that links to table of suppliers on an ID number. In the pop-up I would like to display only the NAME of the company. It would be possible if i had control over the width of the columns in the pop-up (column1: width of 0; would hide the key field & column2: with of 2 inches would give me room for the company name to display). Right now what i have is a calculated display field on top of my SupplierID pop-up so that when the desired ID is selected the display field is automatically populated with the company name. thanks Dan

Please could someone help me? I am trying to design my first database and have two files. One called Suppliers and one called Stock. I have been trying to create fields which will show specific stock details (order number, stock description etc.) if a certain company name is selected. I have created a Value list for the stock details but how can I separate the information into the individual Suppliers ? Many thanks Lesley

On my data entry screen I have 6 checkboxes. On my report form, I want to print out only the name of what items were checked off. My problem is the report form field lists the items checked ina column, and I need it to print out in a row in order to save space. Just dragging & shaping the field to one long row does not work, it only shows the first choice and the rest are out of sight below it, all space to the right of that first chice is blank.

I am a schoolteacher at a school that has close to 1000 students. For our school

Hi All, In FM7 i can't get my pop-up list to "jump" to the proper supplier when i start to type the first letter in the supplier name. (in fm5.5, when i type "s" the list jumps to the 1st supplier starting with that letter). Is there something different in FM7?? What am i not doing?? Tahnks --Dan

Still learning and I have another question:) Is this possible or is there an easier way? I have an Inventory file with a record for each item offered by a manufacturer. I have a script that generates a PO record in a PO file comprising a random set of items by one of the manufacturers (in 16 possible fields: Product ID 1-16 in the PO file) and a creation date. For example, in one PO record any one item could be ProductID1 and in another record it could be ProductID8.... How can I create a value list (in any given record in Inventory) of the creation dates in the PO file where that given record occurs so that all the data associated by a particular Product…

Hi Can someone clue me in as to alphabetizing a list in FM. The list is seperated by returns and may contain multiple words per line. This would be the contents of an example field: Fred Abby & Joe 2Happy ToCare Ancient Aztec Ruins are amazing Lettuce Pray

I have 2 pop-up menus with that are non-enterable in browse mode. Is there a sciprting function I can use to turn these to enterable after the user clicks a button. Basically want to be able to set Field Behavior:Allow user to enter:in browse mode = true. Is this possible? Thanks, -G

what is the code to create a popup menu based on a value list in custom web publishing (XSL)? I have tried (unsuccessfully) with (Field in db called 'Department' with valuelist called 'Department') <input type="hidden" name="Department.op" value="eq"/> <select size="1"> <xsl:attribute name="name">Department</xsl:attribute> <option value=""> - Select One - </option> <xsl:variable name="department" select="$layout/fml:FMPXMLLAYOUT/fml:LAYOUT/fml:FIELD[@NAME='Department']/fml:STYLE/@VALUELIST"/> <xsl:for-each select="$layout/fml:FMPXMLLAYOUT/fml:VALUELISTS/fml:VALUELIST…

Hi, I've created a "Fullname" value list from a calculation field that contains info from 3 other fields. I should have around about 1000 names in the value list, but actually have 6. Any ideas what I'm doing wrong? cheers,

When defining a value list from fields from another file I can either make a VL in File A from the fields in FIle A then define the VL in File B using the already defined VL in File A, or in File B define the VL as directly from the fields in File A. Other than the fact that the second procedure requires a relationship, is there any advantage to either method? Thanks.

Hi Everyone, Been reading through the forum and can't seem to find just what I need to answer this question...so here goes. Some quick background -- I'm a music editor by trade, and part of my job is typing up notes for the composer to use when he is working on a show. The "spotting notes" that I generate are our bible for that show: I have length, start times, cue names and numbers. Each cue has a value assigned to it (read: value list) which denotes it as a certain type of cue, for instance a main title theme or an end credit. I created a value list with those values listed in it, in the form of a pulldown menu for each cue/record. There are six differen…

Hello, I am new in this... I have 100 records and 2 popup i would like to create a new layout with the results of the combination of these two pop-up. How do I do that? I am very new in FM. Thanks

I've been seaching the forums but I can't seem to find the answer to this. I have a value list which contains vendor numbers and vendor names sorted by the second field, vendor name. The user tabs to the vendor number field and gets the pop-up list. In version 6 if the user typed an 'M' the list would scroll to the vendor names that started with 'M' now in version 7 the list scrolls only scrolls if you type in a vendor number. I hope I explained that well enough. I don't know if this is a bug or if FM did this intentionally. I hope someone can help me out with this because it's a real problem for me. Thanks!

Ok, I'm whipped. Many of the threads here seem to be about filtering, but I'm not getting it.... A Workshops record contains WorkshopName and ActiveFlag. ActiveFlag is a Number field containing 0 if the workshop is inactive, 1 if active. I want a value list that contains the WorkshopNames for active records. The ActiveWorkshops value list is defined to be "Use values from field...", "Only related values: WorkshopsByActiveFlag", using values from :Workshop_ID and ::WorkshopName. The WorkshopsByActiveFlag relationshop is from Workshops to Workshops, a self relationship matching ActiveFlag to ::c_Constant. c_Constant is a stored, indexed calculatio…

Hello there Forum!!! A text field in Contacts. I need a popup menu which will display, depending upon the Staff viewing it. This popup will need to be user-specific and only contain THEIR possible choices. And they need to be able to add and change this popup freely but it would need to be restricted to 15 possibilities. A portal would not work in this scenario (no space). I'm considering many things and would appreciate knowing how you all would approach this situation. I have a Preference file, a Staff file and a Contacts file. I currently don't have a Value List file. Is this a good candidate? Or would you store this VL within the staff record itself? Ide…

I have a script step which sorts by a custom order, involving three fields. The first of those three fields is set to sort using a custom order based on a value list, which is as follows: Red Yellow NI Green Note In the sorted results, items appear in this order (there are no entries for NI at this time): Green Note Red Yellow This is in the wrong order. I tried selecting "Sort Records..." from the Records menu, and removing the other two fields (to sort just on this field), but the results are the same. I suspect this is a bug, but the same, unchanged setup was working perfectly before. The only changes I have made were to …

Here

I need help. I have a list of Jobs with corresponding Job Titles. I want to use this field as a value list, HOWEVER I only want displayed as part of pop-up list Titles for Jobs that are not 'completed'. Completed jobs are flagged as such. Removing these from value list will limit pop-up list to around 30 items, as opposed to several hundred if value list contains ALL jobs. Can I use the "Include only related values starting from" box to accomplish this. I'm new to FM so please be specific. Thanks.

Hi all, this is my first post. I have done a lot of reading and ordered several books. I appreciate your help in helping me get started on redesigning my website www.robnokes.com, currently the site is run on W2K with a SQL db driving it. I have a pop-up value list of six items (about, contact, credits, news, references, movies) and I would like to select the one item from the pop up list and then have a script find the appropriate records (based on the selected value from the pop up list) and display them. To date I have not been able to create a button that has an underlying pop up list. Please advise. BTW I am writing this on FMP7 and also have Dev7 and…

I have a field with 8 repeating text values called "Tour" (types of kayaking trips). I want to establish a script or calculation in the "Fee" field (city port fee) that queries the "Tour" field and returns a value in the "Fee" field based on whether the type of kayak trip listed/repeated in the "Tour" field uses a motor boat or not. If yes motor boat, then fee; if no motor boat, then no fee. What seems to be failing is the repeating nature of the "Tour" field - niether script nor calculation recognizes the repeated values as a field. Any advice to my friends ou there?

I'm having a frustrating time here, something that my head tells me should be quite easy to sort out... In main layer (Members) I have a drop down list, that contains membership types (Beginner, Junior, Adult, Junior Honorary, Adult Honorary, Expired) I would like to be able to display in another layer "Junior" only records. I would also like a layer, that contained the details of a combination of types, as a "Junior" member can also be a "Honorary" member. Thank you for any help. (If I have posted in the wrong section, please shout, and I'll quietly move elsewhere)

Hi, Suppose you have say a list of purchases in a table called [purchases] I have a field in there for customerName and customerPhone and so on. I'd like to go to a contacts screen - which has a contacts table. Pick a contact from the table - say in find mode and then set that values from contacts in the [purchase] tables contact fields. If you use a value list with a drop down, then this is easy. the thing is my contacts list may be so big (say 100 or more) that the drop down would be cumbersome to manage. Also Im not relating the producs with contacts because I only want to copy the information - not have a link to it. Is there a way to do this with va…

Hi I am having problems with this: I want to have a warning message pop up if a particular item has been selected in a fields pull down menu. I can do this with a script but it then needs to be triggered by clicking something else. Does anyone know any other way I can acheive this.

I have a whole database of information, some of the fields are selected either by checkboxes or popup menu, the question that i am asking is that when you edit the popup menus or checkboxes, the already created information selected from those boxes remain the same and does not change to what you have edited it to, therefore leaving two types of the same fields but with different name, is there a way to change the current fields to whatever I have modified them to? My current solution would be to create a .NET program to interact with the database and change them, but I want to know is there a way to do it in FileMaker. The version of FileMaker that I am using i…

This is the problem..... I have a features table which user can modify the names of the check boxes, on the other page that it updates correctly it composes of a products page which you can select the features it has using checkboxes again. When I modify the names of the checkboxes in features, the names of the checkboxs on the products page changes, but if it is already checked, it will be unchecked, how could I get around this problem, by making the checked boxes update but without it being unckecked. Please help me Ken

I need a popup menu with times. I want them displayed every half hour from 7am to 10pm. I could create custom VL of course, but I want the result to be a real time field (will be triggered to notify User via plugin). Is there a calculation I can use? Or, if I need to enter them all manually, how can I be sure it will be appropriate for a time field. I just have never worked with time fields before. LaRetta

I have a Database set up as a quotation database. One field (called "status") is a member of a Value List that has values for "Current Sale", "Sale Lost" and "Sale Complete" and are displayed as radio buttons. The other field is called "Invoice Number". Now some users when clicking on the "Sale Complete" button are forgetting to enter an "Invoice Number". Is it possible to force a user to enter an number into the "Invoice Number" field but only when they click on the "Sale Complete " Radio Button and not on the "Current" or "Sale Lost" button. I know you can click on "not empty" for valadition for a field but can you do this or something similar for one radio button wi…

When you sort ascending on a field, blanks go to the top of the list. You can get around this by sorting on a value list. Non-value list members, including blanks, sort to the bottom. In FM6, this also held true for sorting portals. But in FM7, whether you sort on a relationship, or sort the portal directly, blanks go to the top of the portal. Anyone else been bitten by this? It bites. My workaround is to use a calculated field Case( SortField, SortField, 999 ) /* I hate this */

Currently there is a drop down list with each month range in it. EX: 1/1...2/1 2/1...3/1 And so on. This is used for searching for patients whose baby due date is in that month. HOWEVER, the year stays as the current year when the search is done. What I'm looking at is taking the 1/1...2/1 and adding the appropriate year to it and putting that in the EDD field and doing the search on that. So if it is October and 1/1...2/1 is selected in the drop down list, the date in the EDD box is 1/1/2005...2/1/2005. Any suggestions will be appreciated. Basically I'm not sure how to get the data selected, I think after that I can dynamically creat…

We are using a popup list field that has more than 1600 part numbers in it. We are having a problem using this kind of field on Windows in a type ahead mode. That is we want to be able to type in the numbers rather than select them from the menu. On Macintosh this fields works just fine, in two ways. First is that after tabbing into the field, you can type and the list selection type ahead will begin selecting the correct item. Unfortunately, with such a long list and six digit numbers, one seldom finishes typing the entire number. The second way is by pressing the "Enter" key (not the "Return" key). This changes the field from a pop up list to regular type in…

I have a global variable set for the months of the year with values of JAN, FEB, etc. I'm displaying them as checkboxes and want to make a button that can select/deselect all months. Any ideas?

OK I am having trouble setting up a value list as follows: It is for a list of computer components (A long varied list) I would like the user to be able to select the type (monitor, printer, scanner etc.) then the next box will show all matching manufactures of that product (HP, Panasonic etc.) then finally they get a final box that contains all the models that match both type and manufacturer. Thanks

Hi ! Let me start by saying I'm totally new to FM and have only "watched" a couple of tutorials. I have no experience in db of any sort. Anything to get started, right? I have now made my first database and have gone to an extent where I have many tables with many fields and many, many inconsistencies... How would I make a value list display only certain records from a table. I mean, i.e. I have a table named AGENDA, where I stored CUSTOMERS, SUPPLIERS and EMPLOYEES, then I have the field EMPLOYEES in the table INVOICES where I would like to show only the employees and not the customers and suppliers, so I created a Value List from the field AGENDA ID so a pop-u…

I've got a value list on a layout based on related file that has a record ID field and a text description field. I want to store the record ID after the value list choice is made but only want to show the text description in the value list and after the selection is made. I can get this to work fine showing both the record ID and the text description but haven't been able to find a simple way to hide the record ID and still use it's value. Any help to a frustrated Access programmer trying to learn Filemaker would be most appreciated. Hunter Desportes

In the Access world I come from, a pop-up (or drop-down) list will often show a list of text values to the user, but actually store a list of hidden numeric values. The "hidden" values are "serial numbers" that have no meaning to the user, but are necessary for completing a relationship. I don't see a way to do this in FileMaker. Am I missing something? Am I "going about it all wrong"? thanks

I

I have created a db using many layouts (70 or so). At one time, when you clicked the Layout menu pop-up button, the layout choices would appear in several columns, right to left. The 2nd column would contine with the layout options where the first one stopped at the bottom of the screen. It no longer does this and you have to scroll down to see them all - a pain in the butt...anyone know how to fix this? I am wondering if this was a earlier version of FM(4?) and now 6 does not let you do it?

I work with normalized data, so when i use Popups, i have a problem and i need help. How is the best tech to make popups selections when the data lists is normalized? I put the field with the ID code on the layout and the related field over it and chenge the behavior, but when i select it, the FM show me the popup correctly (i don

I'm new to FileMaker, so this may be basic, but I couldn't find any good documentation on it. I have an application that tracks hours of operations for airports. Some may only be open certain months, days and hours, so within each month I have the days of the week that it's open and the hours during that day. This makes for a lot of fields and could be tedious data entry to update, so I'm trying to speed things up by giving the user checkboxes on global variables so they can check off, for instance: All Months, Mon-Fri, 9-5 and then click an "Apply" button which will perform a script to go into the database fields and, in this case, apply the time of 9-5 to the M…

I am having a problem getting checkboxes to work. I have a value list ready to go, I pick checkboxes as an option, but no checkboxes come out. Only the list is showed but no box to click.

Hi guys... I'm stuck...again! I have two files - an invoice file and a file containing a list of all possible services. In the service item file I have flagged some of the services as "hot" items and want to display these items as a value list in the Invoice file. I created a value list in the service item file that displays the "hot" items correctly (based on a relationship), but it won't display in the Invoice file... I'm sure I'm being dim, but I can't figure out what I'm doing wrong. Please help... Thanks Dave

I created a value list based on the records in a particular relationship. I created a script step that populates a field in the core table with the items in this value list. This field was used as a filter for a second relationship. This script was working fine until recently. I created a few other relationships that are based on the same parent table as the relationship that creates the value list. Now, the script refuses to "Set Field". Any suggestions?

Hi, I currently have a database with a value list in it. This list gets a client_ID added to it via a relationship with another database. Every time a Client_ID with a type of "PW" gets added to the related DB, the value list in the file I am working on gets that Client_ID added to it. This part works fine. Now, what I would like to happen is have a record created in the database with the value list for each client_ID, with the value auto entered into the CID field. Currently there are 43 client_ID's in the list, so I would need 43 records. However if a 44th gets added via the previously mentioned relationship, it should automatically add a 44th record with …

I have a (fairly simple) report that wants to sort alphabetically instead of by the custom sort based on value list I've specified. What are the likely/possible causes of this? Specifics: I'm doing a membership list for an organization with 3 levels of membership: voting, minors, inactive (V, M, I). The list uses a subsummary report that lists the members by category with a count of each category. Subsummary part: fields: status (this is the V, M, I list) & count Body: fields: name, mbrship date, status (V, M, I), serial# The script that runs this first calls a subscript to find and sort the appropriate names (this subscript sorts first by mbrship sta…

Here is my scenario I have 2 files one containing names of subjects and the other of diffferent tasks the subjects perform. Every time a subject is entered a set of tasks that the subject performed is assigned to them. Because there are a large number of tasks I want to be able to display just various categories of tasks. This I was able to accomplish using techniques for dynamic value lists described in this forum. Each task record in the task file also has a field for category. Then in the subject file the user makes a choice of category to display. Through a relationship I can then show just task names where the categories match. The problem is I also want a choi…

I have a core table called "Clients". It has related a table called "Fleets" and another table called "Jurisdictions". There is another table that is related to "Fleets" called "Units". "Units" has a table called "trips". Each "Fleet" is authorized to travel in a certain group of "Jurisdictions" (states). Each "Unit" (truck) that belongs to a "Fleet" and travels in a "Jurisdiction" has to keep a "trip" record. I use my database to record these "trip" records. Upon entering the "state" field of a new trip record, a value list appears that is based on the "jurisdictions" that are related to the client. This helps avoid user error by inadvertantly ent…

Hi Everybody! Here's today's issue. I have for one of my customers a database with three tables in it. One table is for all of my contacts, and I have three types of contacts, Customers, Vendors, and Employees. When a contact is created one of those three options (Customers, Vendors, and Employees) is selected from a value list to assign a Contact Type to each Contact. I use that Type in a calculation field along with an auto-entered serial value to assign a Unique ID to each Contact. (the calculation is "Contact Type Code & Contact ID"). For instance my first contact in the lsit is an Employee whose Uinque ID is E1, next record is a vendor (V2), and s…

I have not posted here before but I did not see this topic anywhere else. So, please pardon the question if it has been brought up before. I am creating a file with multiple tables. The primary key for many of the tables is a field containing the employee's id number. There is a a table which will reference the employee id from another table containg employee benefit information. I have created a field in the second table which has a pop-up list referencing a value list in the parent table. The pop-up list works correctly and retrieves all of the employee ids from the parent table. If I add a second field to the value list, such as last name, the pop-up list performs…

The great thing about value lists is that it automaticly removes multiple instances from the value list. But, now i have a need to keep multiple instances in my value list. Even more, i also want the list to be sorted alphanuerical (not ASCII). Suppose the relation that is used delivers the following records to the valuelist: aaa bbb ccc ddd eee aaa ddd Normaly the valuelist would be aaa bbb ccc ddd eee but now i want to be the value list aaa ddd aaa bbb ccc ddd eee Does anyone know how to achieve this in FMP 5.5 Thanks a lot Jitse Schaafsma

I want to enter multiple selections from a pop-up list, but find it will only allow single entries into the field. A pop-up menu is no good as it is not friendly to use, and dangerous when browsing, as it is easy to lose previously inserted data.Same goes for check boxes. The pop-up also needs to allow user entry into the field. The ordinary old pop-up list would be ideal if it could be made to accept multiple entries. Any ideas? Rex

I've developed some survey questions. Each question has four answers: NA, Not Important,Important and Very Important. All four are a value list which are marked with a radio button. When I do a find and check NA I get what appears to be a true number. I think Not Important is accurate. But when I ask for, click in the box Very Important I get all of the Importants as well. Any idea why just clicking in any one of the boxes does not get me the individual answer?

I have a set of three radio buttons I am working with. I would like the database to switch to a different layout when one of the three buttons is selected. Each button needs to go to a different layout. Is this possible? How can I make the magic happen?

I have a field that when accessed displays a pop-up list linked to a field in another db. But when clicked it displays the value list across the screen with some long records truncated...the file contains about 130 records Am I able to format the pop-up window...add spaces to the records...I know i can if I type the information using Custom Values in Edit Value List...but I don't know how to if I use Values from a field... Or should I try another solution? Help please

Hi: I have some legacy databases that I am working with and I am trying toa dd some functionality for my office staff. I have a Customer database with all contact info for my customers. I have a Vendors database with all my contact info for my vendors. I also have a Documents database that is related to both of the other databases. I frequently make documents to my customers, and I frequently make documents to Vendors. I use the Documents database to make documents to my customers and my vendors ( which sometimes refers to info from my customer file). However, I have just come upon a request for a new Document which could be directed to either customers or vend…

Is there a way to get more than 2 fields in a value list. For example: I have a popup list linked to a value list. That value list is looking up 2 values from another table. When I click on the popup I only see those 2 values. Is there a way to add a third or fourth? Thanks for your time

HI all, boss wants to set the values on several of our value lists so they change automatically. example: Customer Status field contains 'Active' 'Inactive' 'dead'. He wants to enter a number smewhere (rules) and it be something like this thinking If Customer Invoices = 0 (they never ordered) or haven't ordered within ____ years, call them dead. Between 5 years and 2 years, inactive; and if they have ordered within two years call them active. I have calcs now that do it (unstored) but the determining time-length is set. How would you allow boss to enter these numbers? Would I write onto layout (use text tool) the questions and place fields where he …

Reproducibly reliable, at least on Panther (10.3) and FM7.0v2: any letter-keystroke in my radio button related-value-list field causes FM to crash (unexpected quit). Background: I'm experimenting with the best kind of quick-select from a related list. I had been using pop-ups because of their easy arrow-or-type navigation, compared to portal rows with buttons, but pop-ups always max out at a dozen items or something like that before scrolling, and you can't see the list until you tab into the field. So, I liked radio button fields because they can show values in my choice of fonts, displaying as many values as exist if the field is made "tall" enough. It was nice: ta…

Is anyone knows if it's possible to create unsorted value list? I need to create a value list consisting of all time values from another file, but the times are formatted in the text fields. I don't want the times be sorted as text.

Hi all I have a value list which people can choose a certain criteria (Criteria 1). I want another value list (Criteria 2) to appear next to it in another field based on what they have originally chosen. Essentially I want value list 2 to be determined by what has been chosen in value list 1. Hope that makes sense

Hi Guys I've published a database on a website and on a 'custom seach page' I have a checkbox field with about 20 different value list options but am having huge probelms changing the search from an 'AND' search to an 'OR' search. If for example my value list ranges from A through M, I want the user to be able to search for records containing *any* of A, F or K not necessarily all of them. All I can seem to do is when selecting value list options A, F and K it will only return a record containing ALL options and not just one or more of them. HELP PLEASE!!!!!