Value Lists

For the solution I'm working on, there are fields that need to have codes in them that I want to have the user chose by value list, but the codes themselves are not very descriptive. for example, lets say I have a field that can take the codes A, B, or C I want a pop up menu that will be something like A - foo B - bar C - goo and then have ONLY the letter go in the field So far, I've been using two fields. One for the value list with the description, and another for the actual code that is a calculation field that sets the appropraite code based on the value selected in the other field is there a more elegant way of doing this?

hello - i have a file that is in the form of a SSN,Scholarship_code each line contains 1 ssn and 1 scholarship code.. if a student has 2 scholarships he has 2 lines.. each w/ different code (D,E,M,I etc etc) 555-55-5555,A 555-55-5555,C 666-66-6666,A 777-77-7777,M how can i get the checkbox field to populate with multiple checks?? there are 18 different scholarships avail. and i created a single checkbox field with the 18 different possible values.. if i import the file, and match columns, i only get the first 555-55-5555,A checkbox.. what do i need to do to have it check through each line and thus check multiple boxes?? than…

I have two db's. project.db and earner.db Project db is the main editing screen where you enter the project, you then select the fee earner from the relationship to earner.db who worked on that project. The issue is this. I need it to be a checkbox type list so you could select 1, or 2 or more people from earner.db. However, I need the values from earner.db to 1) update for new records but 2) remain as-is for old projects - rather like a lookup.

i have a file with 3 fields id, name and category (can be A of :. now i need a value list (to use in another file) with all the names with category set to "A" pieter

This is probably something simple, but I cant fix it. On my Mac (OS9.2 FM5.5), the value list items seem to be positioned high in their spot on the list. It cuts off the top part of the letters. Not really a big deal, but I would like to fix it. I have tried to adjust the Line Spacing in the paragraph section of Text Format, but it doesnt seem to affect it. I might post a screenshot of it later if I get back to my Mac today. Thanks, Ken

Hello once again, I have 2 db's set up. the structures are as follows Db 1 Name Total Db2 Name Sign off limit. I want to create a pop uplist in db1 for name that lists all the names in Db2 providing the total amount in db1 is less than or equal to the sign off amount in db2. Is this possible guys. Thanks for all your previous replies, the FileMaker community really rocks!!!

Hi everyone, I've been racking my brains over this one, so hopefully some kind soul can help. My database contains many columns of mixed data. E.G. Date, Number, Percentage etc. I duplicated it in order to create a relationship. (It was all previously done on excel spreadsheet). My question is this..... Is there a way to do a search with the option of Equals Date, Does Not Equal Date, Is greater than date etc as in an auto-filter search as in excel. If so could someone explain it as I am lost. Incidentally, I would like to be able to have three or so different filters going at once. E.G. greater than or equal to 1/1/2003 AND g…

I have a field with a value list and check boxes to select multiple values from this list. if I export the file with this field to a tab delimited text file, I get all the selection within that field seperated with a "space". Is it possible to get a "comma' and a "space" there. that would make things a lot more understandable. i hope this is clear... thx

Hi all, is there a possibility to have a value list with the date of tomorrow, today and yesterday displayed? At the moment I am using a value list with text (tomorrow, today, yesterday) as a pop-up and dependent on the selection I insert the date via a formula in another field. But I would rather like to have the actual date displayed in the pop-up. tnx for your help

I have 2 fields - (Fa) and (Fb) (Fa) has a pop up menu containing 3 choices (C1, C2, C3) Each choice needs to cause one of 3 ValueLists to appear in (Fb) pop up style. So.... C1 should yield Value List 1, C2 yields Value List 2 and C3 yields Value List 3. I have been building the calculation a little at a time and right now it's working like this: Case (Fa = "Choice 1" , "ValueList 1" , Fa = "Choice 2", "Value List 2" , Fa = "Choice 3" , "Value List 3") Of course right now, the actual words (Choice 1, Choice 2 and Choice 3) appear (Fb). What I cannot figure out, is how to get the actual value list to pop up in (Fb). Incidenty, the 3 Value Lists a…

How do I increase the vertical spacing for a set of radio buttons. I'm trying to get 3 radio buttons evenly spaced inside of a box that I have drawn in my layout. I was able to align them vertically, but they appear one right under the other and I have not been able to modify their spacing. Thanks!

What i'm trying to do here (if its possible), is to create a hierarchical value-list (selecting the 1st-level releated to 2nd-level etc.) that when a you select the top level value-list, then the 2nd-level which is related to the selection made in the 1st-level value-list, should appear on the current layout. The rest of the value-lists not matching should be hidden from the layout. Is this possible to do? Thanks

Hello, I'm scracthing my head trying to figure out how to create a value list within a portal that will display values based on a second value list within the same portal. Any ideas? Thanks for your help, Peter [color:"black"]

Hello, I was wondering how to do multiple selection from pop-pop menu. This is the script i have right now, it work fine but i want to do multiple selection while holding the shift key. This is the Script, i have which fine: Set Error Capture [On] Allow User Abort [On] Enter Find Mode [] Set Field ["Locations","Locations_list"] Set Field ["Status","Status_list"] Set Field ["Class","Class_list""] Set Field [Year","Year_list] Peform Find [] If ["Status(CurrentError) = 401"] Show Message ["There were no records matching the criteria you selected"] Find All Else Go to Layout ["Summ…

I have a value list that pulls related values from another database based on IDCustomer. If I want to display the same value in every list, regardless of IDCustomer, how can I do it? Sort of creating a general value that all customers can choose. Example: Customer 1 Related Value List: Red Blue Green (this value would be in every customer's list) Customer 2 Related Value List: Orange Yellow Green ((this value would be in every customer's list) Thanks for the help!

Hello, I was wondering if someone can help me. Basically, i am trying to do a find using a drop down menus. i have 4 separate drown down menu where the user will chose from. I am trying to figure out what what values have being selected from the 4 different menus.Than i want the user to click on Find button and they will go to layout call summary which will only show the records that containt the values selected from the drop down menus. i have included fm file to give you idea. The one i am refering to is the one in the yellow box area in the fm file. I dont know where to start, i am newbie. i just now the basic of FM. Thanks, SolarPunk multi-find.zi…

Is it possible to make the value list in a second pop-up list dependent on the value chosen in a first pop-up list? For example, the first pop-up list offers a list of chapters, the second offers a list of subsections. If the user selects chapter 1, the second value list is populated with a list of subsections for chapter 1. If the user selects chapter 2 from the first list, the second value list is populated with a list of subsections from chapter 2. Thanks Scott

Is it possible to add a down arrow to the pop-up list field so that it looks like other pop-up lists rather than an empty field? Thanks Scott

Is it possible to attached two separate value list to a single field. Example when field "product" = Pipe then value list pipe would appear in the Thickness field when field "product" = Plate then value list plate would appear in the thickness field I know this can be done with custom values but this would not be feasible because the values would total in the hundreds and the values are already in two separate database. thanks lionel

Hi All, I have a database that needs to lookup values via calculations from one of three other databases. The dilemma is in dictating which relationship to use to lookup the required values. I use a value list to show which other database the required data is in but am not sure how to set the calculation to use the right relationship depending on the value selected from the value list. Does anyone have some ideas for me? Thanks in advance JB

There is a way to select a value from a value list and activate a script from the selection. My problem is that currently this is not working for me. I have done this before but for some reason my value list is not working correctly. The [text field] "payment_type" is linked to the [valuelist] "payment_type" and I have specified the field to perform my script. In the [valuelist] "payment_type" is a listing of values: CASH, DEBIT, VISA, MASTERCARD, DISCOVER and OTHER. I have two other fields that are involved in this script. [number_field] "payment" and [number_field] "credit_card" Below is how I have my script written. Go to Field "payment_type" if ["payment_ty…

Dear everybody, I am new with filemaker and I want to solve my problem. I want to make a popup list in a field in a master file. This list includes some fieldnames from another related file. I cannot make a link between its items and related fields from another file. I want to make it appear the content of the related field from another file when I click on each item of the value list. For example, my master file is Main menu file including these fields: Activated sludge, Trickling filter, RBC ... In activated sludge field, I make a popup list (custom list) with fieldnames from another related file (Activated sludge file) such as process description, design parameters…

I have a payment database that has 2 fields 1-(Value List)Payment Type 2-(Number Field)Payment The value list and the Number Field repeats 8 times so that you can choose the payment type and payment 8 different times. For example if a customer purchases an item and chooses to pay a partial payment with Visa for $15 and comes back again with Master Card paying $25 and comes back again with Visa paying 25 and back again with Master Card for 50. You now have 4 payments: 2- Visa, 2- Mastercard total payments is 115; but Visa's total was 40 and Master Card's total was 75. Is There a way to group the Visa and Master Card purchases together and come back with a t…

Dear everybody, Here is another file. It's related file. Thanks Snow Activated Sludge.zip

Dear everybody, Here are my attached files so that I can make my question clear. They are zip files. Hope to get your help soon. Thanks Snow Activated Sludge.zip

I hope this hasn't been answered 100 times, but I haven't been able to find a relevant post. I have 2 simple related files: Ticket Holders and Tickets. Ticket Holders has personal information about people who bought tickets to an event. Tickets has information about the tickets: seat numbers, etc. I'm trying to use a value list in Ticket Holders to assign tickets to people. I have a repeating field setup to hold the ticket id's and have assigned a value list to the field. However, I can't figure out how to have a ticket removed from the list once it's assigned to a person. I've tried a huge number of things: calculations, script, tips and tricks from d…

Can someone help? I have a simple checkbox value list of personnel... Selected are those in attendance... I would like to show a total of attendees on the working record... Can this be done? [color:"#666666"]

Is it possible to have a value list not attached to a field. Example: value list with only two selection Pipe Plate would make a selection of either one and have another value list popup but would not like to have "Pipe or Plate" enter into the field but the information in the second value list. Pipe or Plate is just to decide what value list to use I hope this makes sense Lionel

I already seen a scripted method but I'm quite sure there is a clac for this. I want a field to hold the values not choosen from a value list. Say a field with checkbox with A, B,C,D,E Field t_choice = A C E Field t_nonchoosen = B D Am I dreaming ?

I have a value list where the users should only choose data from the value list. If the user enters data by typing this should not be permitted. How can I prevent user from entering data other than the option in the value list ?

does anyone know if it is possible to use a value list on an input field in a custom dialog under FMP6? Cheers Hal.

I have a db that has morethan 600 records and it has a field=name. I made a form called list that will list all the names in ascending alphabetical order from a~z. My question is? how can I make a clickable alphabets in the Form:List like A~F, G~L, M~R, S~X and Y~Z. When a user click this link it list only the names with beginning character of A~F (as example) and the rest of the alphabeth category. I'd appreciate if somebody can help on how I can write the script on this matter. TY

Hi, I've got a submissions database where I use a value list to sort items, (e.g. out, resend, accepted, rejected, revise). In order to keep track of the records, I use colors to distinguish the values in the list. I'm manually setting the colors for each different value in the list. I'd like to know if there's a way to automatically set the color when I choose any item in the list. I am a total novice when it comes FM scripting, and my first attempts were a total failure, so if possible I need an explanation that will walk me through from the beginning. Thanks so much Charles Carroll

Problem: Create a "sub" list that changes when the user selects a value from the first list Scenario: 1. Created Value list of 5 Coaches (each has "X" players). 2. Created a calc to assign a number for each coach. (This seems to work as the number changes with each coach) ex: --> PatternCount(Left(ValueListItems(Status(CurrentFileName), "Coaches") & "

I own a multi-media business and I am working on streamlining the bid process. I am trying to create a database that will allow my clients will choose the (project) options that they want (via radio buttons). There about a dozen sections that they will choose from, with three (radio button) options for each section. (basically low $, med, and high) When they click "submit" they will be taken to a "totals" layout that will show all of the sections but only the final options that were chosen by the client with the proper dollar amounts. I need to be able to easily modify the dollar amounts and info for each item as part of my bid research. Can anyone point me …

Is it possible . . . (famous words on this board) I have a pop up field that has two selections. Both of the selections are managers and what I would like to do is when manager 1 is selected an email script that I have built is activated. The other option I have "toy-ed" with is making the field a calculation and if the field = manager1 then basically run my email script. I am not having much success with either one. any ideas

Hello all- I have a STAFF file and a STUDY file. A member of the staff can be a coordinator on many studies and vice versa, so it is many-many, which leads to my COORDINATOR file. Coordinator has a STAFFID and a STUDYID. I want a value list which shows the FullName (calc field in STAFF) of only those STAFF who are COORDINATORS (have a related record in COORDINATOR) as well. I have tried just about every combination of things, but the only way I have been able to get it to work is to have a text field in STAFF that designates whether or not the person is a coordinator. That's no good. Please help. Thanks- Courtney

Hi, I am a newbie on FMPro, and I have a question: I have a field TURSPEED with contains values 0 to 5. These values have specific meanings 0 - none, 1 - Very Slow, 2 - Slow, 3 - Medium, 4 - Fast, 5 - Very Fast. I wonder how I can represent the Text Speed in a form layout where instead of numerical values, the actual text is shown (eg. Fast). Of couse, it would be easier to hardcode the speed in text into the field rather than numbers, but then I would lose sorting/index ability on the numberical field. My current thoughts of approaching this is: a. use another table/file/DB to represent the relationship of TURSPEED numbers to the text.…

Hi, I have a ValueList which I'm using for data entry on a form. The ValueList originates from a field in another file. I want the user to be able to use "other" to enter a new value, but then I want to automatically update the file where the valuelist pulls its values. In other words, the next time the ValueList is shown, I want the new value to show up. Is there any way to do this? Thanks in advance!! David

hello, I have a pop-up list with a value list The first value of that list should be entered automaticly (because 90% of the time that is the needed value). but the field is always blanco to start with could save me a lot of time thx

I have a value list that is a list of 25 or so award categories. The last has some values - such as: book award, book award finalist, pulitzer award, pulitzer award finalist I want to be able to do a Find on this value list. If I do a Find and check the checkbox with the category Book Award - the find does a find for any of the values that have the word Book or the word Award in them. So it finds all the book awards and the book award finalists, not just the sing value Book Award. I tried creating a new filed that is a Text field - that does look at the value lists and pulls any of the awards over into it with a space between each word. but - still here - i…

Trying to figure out how to change between 4 Value lists with a Pop-up Menu. What I want is actually quite simple but I'm breaking my brain on finding out how. I would like to be able to change the Value List of, let say field "Checkinbox" displaying the Value List with Checkboxes. There are 4 different Value Lists. The idea is to use a Pop-up Menu field called "Changer" to select which Value List should be shown. After trying with a Portal I noticed this won't work because I want each Value List to be on the same location. Using overlapping fields in a portal only makes all the fields in the Portal appear or disappear, so this didn't do it, having t…

OK, probably a pretty easy situation for most of you, but I am at wits end! I have file A that contains products and file B that contains various documents that might be attached to these products (rebates, specs, reviews, etc). I want it simple to attatch records from B to A, the easy solution appeared to be populating a value list from B for use in A. This works well! Documents can be added (up to five per product) and all goes well on that end. I think, however, that there must be a better way that would be more elegant and robust. For example, if I change the name of a document in B, it does not propogate through A (I could do a script that would ste…

Hi, I just found this forum & already love it! Here's my first question (I'm sure I'll be posting a lot more!) I have a housing database and a few of the fields have value lists that contain the room numbers for different areas. (For example, NewDorm may list room numbers 1 through 100 and OldDorm would list room numbers 1 throgh 50) The value lists are set up to ensure that each record has a unique item. I'd like to know if there is an easy way to run a report in a layout that will show me all of the rooms still available for each area, or not chosen on each list. Has anyone done something similar to this request before? Thanks in advance for your help!

I'm stumped as to how to implement a recent record list. I have created a global field that gets updated every time a navigation button is clicked / first in last out stack buffered by a pattern-count check to prevent duplicates. The global field cant be indexed so a valuelist doesn't work ? how can I build a pulldown list for quick access of the last 10 records accessed ? [email protected]

Hi all, what have people used as user friendly methods to enter times? The best I can think of is actually having 2 number fields: n_hour and n_minute and then a t_AmPm text field, but then I have to create a calc to join them into a real time. That is about the only way I can think of to still be able to use a managable pop up list, but was looking for other suggestions. Thanks!

If I have a database like such: Company.........Category a....................1 b....................1 c....................2 d....................2 I need a way to get a pop-up list, in another database, containing the Company name only for those items in category 2. P.S. using FMP 4

I have a field (EDIT METHOD) with a value list. When I enter or change a value in EDIT METHOD, I want todays date to auto-enter in the field, EDIT METHOD DATE. Your help is always a lifesaver! Maxwell Morlay

Hi, Does anybody know how I can specify a default value (which is displayed by default before the user access the field) for a field using a value list? Thank you!

Hi everyone! Well, I've searched for this on Forum and can't find an answer. It must be so simple that no one's every asked; however, I need an answer because I have forms to mail out. I have a pre-printed form (HCFA) which has two check boxes for M & F. I have an existing Value List displayed as checkboxes for M & F but I can't get them to line up with the form. Is there any way I can 'ungroup' them so I can move them further apart to match my form? The only other thing I can think of is to create two calcs to display them but before I do that, I just wanted to see if I have a better option. Any suggestions? LaRetta

Hi everyone! Sometimes a User may accidently choose a value from a pop-up menu but then change their minds. They want the value to instead remain blank. I tried adding a line to the value list with only one space so they can de-select a previously chosen value; however, this doesn't work. I tested report summaries and the space is treated as blank as far as grouping records but fields with the space sort AFTER blanks. I suppose I could add a button next to the pop-up to clear the field but I wanted to check first and find out how you all handle this situation. Or should I just use pop-up lists and educate my Users on how to click again to enter the field? …

In order to support the re-use of a value list on layouts of several different tables (let's call them A.fp5 and B.fp5), I've created a single table (let's call it List.fp5) containing those values. A.fp5 and B.fp5 obtain the values via a pop-up list, set up by defining pop-up asoption "Use values from field, specify table...List.fp5." So far, so good. The undersireable behavior is that when a value is chosen from the pop-up on A.fp5, a new (and thus duplicate and useless) record is create in List.fp5. What's up with that? How do I prevent it? Thanks for your help, folks. -- Pat

I have a psuedo-stupid question. I'm using value lists for certain fields to reduce data entry errors. For instance, I have a value list containing counties, like "Lycoming" and "Clinton". My question is, when a user selects one of those choices, could I have it actually stored as a number? We have to do reports for the states that use codes for the counties, like clinton is 18, lycoming is 41. Thanks!

Hello, I'm new to FileMaker and what I want to know (and that's really the only thing I wanna know!!), is how to retreive the value of form-field or url-parameter? TIA, Xander

What's the go? Is it just me.. (quite possibly) I have a value list based on a relationship. I also want the user to have the option of adding additional values. I dislike Pop-up Menu I think it's ugly - especially when that list can grow, I like using Pop-up List with its scroll bar. So can someone tell me why only pop-up menu will allow you to add 'other'. Pop up list gives you no added features. I could understand (maybe) check box, radio buttons not being able to add due to display reasons. But why can't menu and list pop-ups have the same feature?: grrrrr

This is similar to another question on this post but not exactly the same and that question wasn't answered fully anyway so here goes. I want to have a pop up list were it accesses a value list. if i select automotive it gives me a second value list where i can choose car, truck, motorbike etc. if i choose car, it gives me another list that says ford, holden, fiat etc. if i select ford, it gives me another list that says falcon, fairlane, fairmont, mustang etc. The new value list is based on the choice i make in each value list along the way. Can it be done, is it easy or very tricky and does it say how in the instruction manual (i can't find it) I saw some…

I'm creating a database centered around rock climbing. One of the conventions of rock climbing is a rating system that goes like this (depending on which system you use, try not to argue the merits of the actual rating system if you're a R.C., lol): 6 7 8 9 10a 10b 10c 10d 11a 11b 11c 11d 12a... and so on 'til 16d When I do a sort, it doesn't sort correctly because of the mixed number/text values of the rating sysetm. Sooo... to sort correctly, do I need to do a custom sort based on a value list (which I'm completely unfamiliar with) or do I break apart the ratings into the seperate components (sort numbers seperately, then the lette…

Hello, I have a value list of items with checkboxes. I want a script to cycle through that value list and operate individually on each item that is checked. What is the best way to do this? Thank you. Evan Cooney

I have 3 databases - Contacts, Appointments, and Photos. Each Contact can have multiple Appointments, and for each Appointment, there can be multiple Photos. In the Contacts database, there is a portal that shows all of the appointments that have been scheduled for each contact. When you click on a portal row, and enter an appointment date, a new appointment record is created in the appointments database. A contact serial number is automatically populated in the appointment record that associates it with the contact. There is a fcontact name field in the appointment database that is a lookup based on the contact serial number. Now, in the Photos database, each ph…

Is it possible to have a field display 1 of 3(or more) value lists depending on the value list choice in another field? I have a field named "Company" which is a pop up list of Car Companies for example. Ford Chevy Dodge I have also defined 3 value lists of the models of each companies cars. For example: Dodge Value list would include Intrepid, Ram, Caravan, Durango, etc. I want the corrisponding value list to show up in a field named "Model" depending on which car company I choose from the Company pop up list field. Does this make sence? I have searched this forum and found lots of solutions but didn't find one that seemed to fit my situation…

Scenario as follows - In FM file, select an item category from popup list. A sub set of items appears in 2nd popup box (eg select Soda in list 1 - sublist of sodas appears in list 2 eg Coke, Pepsi, 7up etc) Now the next step is to have 4 fields - Supplier, Contact, OfficeTel, MobileTel - so that when you select (eg) Coke - the suppliers details appear in their correct fields. Can someone guide me through this PS ... many thanks to Jason ... thus far. cheers

How to get this work? I want a conditional valuelist that is based on the input in a repeating field and takes data from a related file. Sure it works, except for that the valuelist does not update it's condition when moving to next repetition! Simply I have two repeating fields, one with artists and one with tracks. Related files is Artists and Tracks, master file is Albums. I've taken the Artists into a valuelists. Now when I pick one artist into the Artist field I want the Tracks valuelist to be conditionally based upon the Artist, so only tracks by that artist is shown. But, as I said the valuelist is only based on the first repetition, how to get it w…

Is it possible to use a script to add a value to a value list? I do not want to have a separate database file for the values, and it is multiuser so I can't use a global field for the values (because it will change).

I am trying to confirm that a customer# and order# entered in one database match for the same customer# in another database (created only for this verification) containing customer# and order#. My relationship and calculation work fine as long as the order# entered is the first one found in file 2 for that customer#, but if that customer# has multiple records with more order#s my validation calculation fails with all but the first. I need to continue to check for all order#s for that customer#. I then tried copying all order#s for a customer into a single record with a repeating field for order# and used extend in the calculation but still could verify only the fir…

Is there a way to create a value list of either all field names in the database or all fieldnames on a certain layout? I have tried using the FieldNames function [i defined a calculated field as FieldNames( "BargSurveys" , "" ) where BargSurveys is the name of my database], but this gives me no result. And even if that worked, I would still just get a list of all the field names in that field, but it wouldn't allow me to create a value list. any ideas?

Dear All, I would like to know if there is a trick to make a value list as sorting as decreasing order. In the book, it says it is automatiquely sorted as increasing order. Thanks

I want to create a value list using a repeating field. The field is a date and is repeated twice (begin date/end date). I want to make a value list that concats the begin date and end date (i.e. 01/01/2002 - 01/15/2002) and then use the result as the choices in a popup list. Any way to do this? I want to keep the begin date/end date bound to each other, hence the repeating field. Thanks The Mad Jammer And then...there was nothing

One database, one field called Project Name, 6 records: 2 of the records have the Project Name of ABC 1 records has the Project Name of EFG 3 records have the Project Name of HIJ I created a value list that looks at the Project Name field, so the value list contains: ABC EFG HIJ Is it possible to take the contents of the value list, and place them in a repeating field so that the first repetition contains ABC, the second repetition contains EFG, and the third contains HIJ? I want to create a calc that looks at the first repetition and tries to match it with the contents of of the Project Name field.

Using FMPro 5.1 here on a network, A patient database has over 21,000 records and close to 40 templates that I've set up. The administrative's assistant's computer (using Win98), has a list field that makes her scroll down one long vertical list of names whereas on the other computer (using Win95), when I click on that field, the whole list shows up in columns across the whole screen making it much faster to select an item vs scrolling down. Can the Win95 display be duplicated on the other machine?

I have a field that you select the value you want in it via a pop-up box that have the values based off that field. I'd like to sort the available selections in reverse format (high to low). How can i do this?

How do I get my popup list to display different fonts? Specifically I need the last item to be displayed in a different font than the rest of the list. The data is custom and entered at creation but I'm flexible!

I'm trying to create a sorted listed based on a custom sort order. I can get everything to work, except that i'm mixing times (in the format or mm:ss) and text. How can i specify where to put the times in my sort list (they'll be in numerical order). Everythign is in text format. Happy t-day -j

I have 3 databases: Staff, Items, and Transactions. The Staff file contains information about staff members (obviously) such as Staff Name, and a serial number that is used for relationships. The Items database contains information about things that can be assigned to staff members, such as a mailslot, a nametag, and a phone number. Each record in the Items database contains a serial number, the item name, and item type. The Transactions database is used to link the one-to-manys between the Staff and Items database. I created the usual relationships between the files so I am able to go to a staff record and assign items to the person using drop down menus. The o…

I'm having troubles with a related value list with calculations. I used a self-join and a related value list to create a pop-up menu that lists all the names for that particular ID number (the ID is not unique). Works fine if the value list references a text field. However, if the value list references a calculation, then the results get screwy. Sometimes, they show up. Sometimes, they don't. Even odder is that it seems if you start with certain letters, there isn't a problem. For instance, anything starting with "t" seems to work. See the attached file as an example. Note the difference between the two value lists that should be the same. Before you say th…

I've set up a database of inventory, and I'm trying to find the top 200 selling items. I can sort by "items sold year to date", as an example, but I want to limit the list to only 200 records total. I don't know how to do this without going manually to record # 201 and then performing a find of all records smaller than "X" qty sold YTD, and deleting those records, and then printing out my report. Any suggestions qould be appreciated. Longtime Nutshell User, New Filemaker user

Help! I am a complete FM novice and have managed to pick up the basics very quickly. But i am making a quiz using FM and am stuck. All the questions are multiple choice with three choices which i have used radio buttons for, each question is on a new layout linked to the next with a button and script. what i want to know is how can i give the correct answer from each question a value of one and the incorrect answers a value of 0 and then have a total at the end of how many they got right!!

I currently have a contacts database that uses value lists to designate the category the contact is a member of. So it looks like this: At the top of my contacts database, I have a row of checkboxes that is one value list for categories such as Personal, General, Press, Client, etc etc. Under each of those values there are sub type value lists (i.e. print and web under press). This layout is starting to seem a little sloppy and I'm wondering if anyone has a better suggestion for categorizing contacts. One contact must be able to fall under several categories.

At first I want to excuse for my bad english. I have one file with list of jobs, I would like to find all jobs for a certain customer and make invoices for them. I wold like to select multiple jobs from that list (using checkboxes) and include them in invoice, and mark those jobs somehow so when I do another search those jobs don't come up because they are already invoiced. Thanks in advance.

I am creating a field that requires morse code input, but i can't seem to find the right characters to use. I'm quite new to pc's (been on the macs too long) and i am looking for a good sized bullet point and a thick dash. I don't want to use special font sets in case my end users don't have these. Does anyone know of keyboard commands that will allow me to input these? Or is there a way to enter graphic files in values lists? Many thanks in advance, Andy

I'm a bit unclear (when aren't I ) on the differences and similarities between Value Lists and Multi-Key fields and their corresponding application. They appear to be (or CAN be) the same thing. FM help isn

Can anyone point me to information on the basic can/can't do stuff for value lists? I've been trying for some time to use them in my project.Some work, some don't. Missing index is my usual problem. Many thanks in advance! -jim lee

I have three files, well actually more than that, but these three are the pertinent ones. Parts - Data on everything I buy, build, or sell Inventories - The different inventories that parts can be found, built or shipped from. Part Location links - Links Parts to inventories. Basically part ID, Inventory ID & Qauntity in stock. (Among other location specific things) I'm sitting in inventory #1 looking at a portal of all my parts (part links) I'd like each part to have a popup menu. Fine, this is no problem. I would like this popup menu to show me the possible places in -this- inventory where I stashed this particular part. IE "Box on top shelf". I …

I have two value list questions: First, a formatting problem that I'm beginning to suspect can't be solved: My value lists, in pop-up lists, are displaying without enough space between each line, and the top bit of the text is getting cut off in each line, making it difficult to read. I've tried to play with the paragraph formating of the field, but nothing has any effect on the display of the list. Is this just a bug? (I'm using FM 6.0v3, Mac OS X 10.2.1) Second, I would love to copy the entire index of a field, so that I can use that to create a value list in another file (one that won't, eventually, be related in any way). How can I access that index? Ma…

Dear gurus, Is there a way to accomplish this: I would like to have a popu list on one of fields with a text values which consists of values typed in before. As a field format I chose Popup List and value list is a list which takes values from same fields. Ok yhats fine. But there is my problem ... Is there a way to have values on that list depending on another field value? If this is not clear lets assume I have DVD rental with collection of 3 DVDs (to simplify) with DVDId: 1, 2, 3. There is another file keeping track of their rentals. Is it possible to have 3 separate lists for DVD # 1, 2 and 3? This is just example - not database that Im working on right now but…

A value list that shows values from two fields that enters value from the first field on desktop enters concatenated string consisting of both values in FileMaker Mobile. Example: -On desktop field_one=product_code filed_two+product_label Using value list that shows content of those two field correctly enters only product code in a field that uses this list. However, on Filemaker Mobile, a text string of field_one & field_two is entered.

I have a text field called buildings in a file called buildings that contains four records. The value of buildings for the four records is: Primary Intermediate Junior High High School When I make a value list based on the contents of this field, I do not like the fact that when I go to use this value list in another file in a popup menu, the items are in alphabetical order. In the file buildings I created a numeric field called BuildingOrder and typed in numbers for each of the six records based on the order I wanted to display them. I then went back to the value list and stipulated I wanted to see this second field and sort by it. Now when I use this val…

I'm using FM 5.5 on Win 98SE. Does anybody know why popup lists don't close after a user has selected an item? It can't be anything on the layout, because I created a new one with only 1 field. The list remained on the screen after I selected an option. Its not a windows bug, since I've never had this happen with any other software. Any clues?

Hello, I've taken the plunge and started learning FileMaker last Friday. It was a bit weird at first compared to Access, and there are a few things that it doesn't do that I wish it would (like conditional formatting and event triggers), but I'm getting the hang of it. But I've also found there are some things it does much, much better than Access. Like most things in life, there are tradeoffs. But one thing is vexing me, and I'm hoping someone can help me out. I'm having trouble getting values to update in a field. Here's what I've got. I'm keeping track of people and their family relationships. I have a field for the first name called FIRST and one …

I have a solution that requires what I call a shrinking value list. I am instituting IP based printing at my school district. All the printers in a particular subnet have the same IP address except the last entry in dotted decimal format. In other words, printers in subnet 80 would all have one of the following IP addresses: 10.121.80.220 through 10.121.80.254 This is a total of 35 different IP addresses. I want these to appear in a drop down menu based on a value list. Lets say the first printer I assign the IP address of 220. When I get to another printer I want the drop down menu of printer IPs to not show 220 since it is already assigned. If 18 IP addre…

Hi, I am trying to summarize selected items from a value list that uses check boxes. I need to summarize on the selected items in a field that shows the data left to right separated by comma's and not paragraph returns. See example below. From a list of countries that the following countries are selected: China, Canada, Australia. Field currently shows it as the following: China Canada Australia What I'm looking for is: China, Canada, Australia The reason for this I can add it to a form that shows all of the relating countries in a single field. Any info on this will be greatly apprecieated! Thanks, Anthony

I would like to know if there is a way when i click on a field with value list ..it appears fast ...since I use host but it is still slow. Does anyone have the same problem? Thanks

I need help in creating a user defined value list summary at the end of a report. I am a film composer and am creating a database that tracks pieces of music I write for a given film. Each record in the database is a cue or singular piece of music. Within the data base there is a user defined value list that allows me to enter different categories for each of the pieces of music (i.e. suspense, action, love, etc). The value list changes for each film. The report I am creating shows all the records in the database (all the pieces of music I need to write for the film). At the end of the report I would like to summarize how many of the pieces fall into each of…

Dear All, I would like to know if there is a function member of a list ...let's say a list (1,2,3) ....member of vale list is 1 or 2 or 3 ...is there a function to get these values out one at a time? Thanks

I am using a value list from another file with the ID as the first field and the name as the second field. I want the ID to appear because when chosen, the ID fills in a series of other fields in the file. However, if I try to sort by the second field, the value list gets all weird, it sorts some alpha but leaves the ID in front of some. If it sorts by the second field, no ID populates the field either. How do I keep the ID as the first field so that it can populate but sort by the second field? I tried a filtered relationship but that doesn't seem to work because my fields are not indexable. I also tried a couple calculations. Any help would be awesome here!

Hi there, I was just wondering how to do this best. I have a pop up menu that uses a value list based on a field from another file. When the values come up they are in alphabetical order. How do I get them to come up in an order defined by myself. I tried numbers in front of the items but it just came out as 1 - First Item 10 - Tenth Item 2 - Second Item And so on... Any help would be greatly appreciated. Regards, Mark Bowen [email protected] http://www.kingfishergraphics.com/phpBB/

Dear All, I have a value list A (1,2) in the field B(attach a value list A)...if someone type 3 in filed...or any number not in the list..it will pops-up the mesage ... I don't want to use field validation ...since it is too confused ...can we use a script or any way to deal with it? Since i don't want people to modified values in the list Thanks

I am attempting to design all of my db's utilizing Pop-Ups across the top. The method I am reviewing is Cobalt Sky's Layout Menu. It appears to consist of one LayoutName text field, two globals and a calculation. I am hoping to have this universal throughout my dbs in many respects (i.e., one Pop-Up for Main db items, one for Reports, etc. I am wondering about the possibility of establishing a db, entering each Main Menu Item in the text field and each Sub-Menu item in a text field (which should also allow for expansion in the future) and joining this to all db's. Before I waste my time attempting this, are there potential drawbacks to this approach, even if I succee…

I've searched everywhere and I just don't understand this. This is what I want to accomplish: I have a main DB that tracks jobs. I have one field for project manager (project manager) I have one field (due date) I have one field that is a value list (open, in progress, done, hold) I have other fields for job number, project lead, project description, etc. I would like to have a Value List that shows: Job number / Description based on the job being 'overdue' I would then like to further this list so I can select it to change based on the 'project manager'. Any thoughts? Thanks, Rifleman

I have a db, ItemDescription, and a db Checkoutlist, which points to a portal in ItemCheckout. People can check out numerous items from this portal, using the value list ItemDescription::ItemName. I have created a script for each record (ItemName is unique) that creates a field with the appropriate number of items for checkout in the form of n+1 on each line. e.g. If there were 5 Hyperstudio cd's available for checkout, the generated list within the Hyperstudio record (in the ItemDescription file, where it is created) would look like: 1 2 3 4 5 What I want to be able to do back in ItemCheckout is to click on ItemName, choose an item from the pop-up list, su…

After many an hour of trying to figure this one out I have hit a wall. I was wondering if anyone could give me a pointer. Here is what does work: 1) Database called Contacts. Two fields, One called "ID" and one called "Name." 2) Database called Jobs. Has a field also called "ID." Uses a relationship back to Contacts based on the two fields ID : ID. Uses a pop-up with a value list that shows the "Name" from the contact database. Here is what I am trying to get added into the equation: 3) A third database called Files. Contacts has a portal that links to this third database. The relationship is based off of ID : ID. The third related database also has a fiel…