Value Lists

I've found a radio button graphic I would like to use (Buttons & Things site). One is selected, the other isn't. I've tried stacking them, but can't figure out how to use them with an existing value list and how to make the 'selected' graphic display while it's unselected counterpart not. My test is simple - Y, N (auto-enter being no). Is there a way to use these cool buttons? I also found great checkboxes ... same issue ... assigning them to a value list and making them display properly. Can someone point me in the right direction?

I have a message appear on screen which contains about 7 lines of text. When the box opens, however, it only shows half of the text. The user has to drag the box to show all the text. This is a pest for the user. How do I make the box appear showing all the text?

Could someone point me to some info on setting up a city state lookup based on an entered zip code? Are there previous threads dedicated to this topic? I didn't find any initially.

Hi, I have a value list in a checkbox field. I'm trying to create a calculation that says "if value A is checked, put A here, otherwise leave blank". However, because I'm saying "Field="A"", the value will ONLY show up if it is the ONLY one checked. If multiple values are checked, none of them will show up in their respective calculations. How can I rewrite the calculation so it will pull value A regardless of how many boxes are checked? Thanks in advance...again, Leah

I have several value lists where each value is a large amount of text. There is no problem accessing the values on the mac. However, when I open the database on PC, there are some fields which won't give me access at all. Any suggestions? I really would prefer not to have to redefine all the value lists...!

..assigned to that field. The field is formatted to select a value from a value list using a pop-up list. Once a value is selected I want to run a script. I thought this could be done by using pause /resume features but I've forgotten how to do it.

I'm trying to build/use a pretty OSX-like popup menu field. It works okay when its setup as a popup *list*. It doesn't work at all when simply changing it to a popup *menu*. Bug? Okay, the field is set to use a popup list, but its set to *not* allow entry. (If you allow entry, then its graphics, even if transparent, cover the intended graphics when selected.) The intended graphics are setup as a button that calls a script that does Exit Record/Request and then does Go to Field "the field". The result: When you click on the field you invoke the button that performs the script that ends up popping up the specified popup list. But if you simply cha…

I'm trying to use conditional value lists in a Building & Remodeling Job Costing application I'm trying to create and when I move to the field that uses the conditonal value list the pull down menu appears but its blank. I've looked it over and even rewritten the relationships several times now and still can

Know this is probably a basic question but am not sure best way to handle it. My main file references a second file of employees. The match field is employee ID. From the main file, I want my users to be able to change the name attached to a record in the main file by using the related name field on the master file layout...but what needs to be updated is the match field in the main file. I tried using a global field but realized you can't attach a value list to it. If someone could point me in the right direction, I would greatly appreciate it. Thanks in advance.

When you define a value list by using data from a field AND including data from another field, is there anyway to "hide" the text from the first field in a pop up list? The data in the first is the match field (id numbers) and the second field is the employee name, which is what I want to be seen in the pop up list. This is really a follow up question from an earlier post titled 'updating a match field'. Thanks in advance for any wisdom.

Saw this done once. Two fields side by side at the top of what looked like a list view. Select the first fiels and a value list appears. select on of the items. So far simple stuff. Now depending on what was selected, what looked to be a find perfomed and only the items that matched showed up. And even better, select a itme from the second fields value list and the find even tightened...using the values from both fields to perform the find. Now how the heck did they do this? And even more, how did they get fields to be active as pop-ups at the top of a record in what looked to be in list view? LR

Hello all, I am new to this board, and would appreciate some help. I have 15 fields, each with 4 to 20 checkboxes defined by a value list in another file. I need a report to show what boxes were checked (for all fields, not individual) as line items. This way I can reference the price, and then do calculations. How do I get each SELECTED checkbox into a separate line item? TIA Cheers!

Hi, can someone help me. I have a option feld that has radio buttons. The user can only chose one option but i need to confiquare it so that the user can chose more that one item in the radio box. how do i do this? thanx you shanela p.s would anyone reccomend a good book for a intermediate users of filemaker?

i have created 2 fields to lookup up a product id. 1.) product_id that uses a product value list 2.) lookup_field contains a value list of "suppliers", "customers", "supplier_category" ,"customer_desc". if lookup_field is "suppliers" i want the value list for product_id to be supplier_products. if lookup_field is "customers" i want the value list for product_id to be customer_products. if lookup_field is "supplier_category" i want the value list for product_id to be supplier_categories. if lookup_field is "customer_desc" i want the value list for product_id to be customer_descriptions. the reason i need this is so we can use different fields and sort …

Hello peers! I have a popup list attached to a field. The value list is based on values in an indexed field from a related db. I click in the field to bring up the list, but when I select a value, the list will not go away. I have to click in an empty area on the screen in order for it to shink. I have never encountered this before, so am I missing something? Also, a little background on this project: I am making a solution that will be served. It is sort of a RSVP setup where users log in to our company website and there will be a link which will go to a main file. They will RSVP for upcoming meetings and such. I got the files all ready to go, but this is a ne…

OK, after almost 40 hours on this one I am to a point where I dont know what to do. My main database is Jobs.fp5. My related is Contact.fp5. I am trying to get some information out of the contact database and into my jobs database via a value list. But here is the problem... There are 2 seperate pieces of information I need to retrieve. The first is from a simple "last name" field in my contact database. The second needs to be from a calculation of some sort that would look at a portal on the same record and taly up all the "last names" from the portal. So the "last name" field contains "Ross" The portal on the same page contains 3 names: "Lee" "Orton" "S…

Could you help me out with a problem, i'm kinda new to this program, I know the basics though.. Here's my problem I have one field called GROUP: this field has radio buttons ( 4 different ones, "3hours", "6hours", "12 hours", Other) I have another field called AMOUNT DUE I want a value entered in the AMOUNT DUE field depending on what radio button I select in the Group Field... Ex: If I select the "3hr" button in the GROUP field, then I want $50.00 to automatically be entered into the AMOUNT DUE field. Is this possible??

I am having a slight problem with a pop up list. It is taking a couple of seconds to dropdown. I can not see why? As there are only about 120 records in it. When you go into the field it takes about 2 seconds to see the dropdown list. Can anyone tell me why?

I have a value list with items like: rro Rushford Ross Orton Design scc Salt City Candle Company cure CureCrete A field with a pop-up us used to select an item. Is there a way to have it so that when the item is selected only the first word is populated into the field and the rest are ignored? And also a variation, is there a way to do the same but have just the first word ignored and the rest are used? LR

I have FM M2 version 2.0 and conditional value lists are not exportable to the handheld, can conditional value lists be used with FM M2.1?

Hello all, When users create a new record they are asked to assign the record to one or more categories using checkboxes. There is an "Other..." option so they can assign their own categories if necessary. I have a tally sheet set up in a related file that counts the number of times each category was selected. Now the users want to be able to also see a list of the values entered into "Other..." and have a count of each value in that list. Is this possible? I'm stumped. Thanks (yet again!) for your help, Leah

Can I have a valuelist from a global field? FMDev 5.5 reports an error that it cannot be done since the field cannot be indexed... Filemaker breaks out a multiline field as single items for valuelist on regular fields.. I thought that would have been good option - so user's can modify valuelist from the web.

Here is the challenge: I have a project db and teams are assigned to each project. I will assign names to teams through a simple portal, but I would like the project report to summarize with a text calc. So the result is one long string showing only the teams that where build. Also the name of the teams and people are not predefined. i.e. ProjectA BLUE TEAM: John, Sandy, David RED TEAM: Daniel, Sam, Tes, Frank, Betty

In one of my FP5 databases a field with a drop-down menu appears perfectly (single-column list) on all the iMacs here in the office but on the PC the menu pops up as a multi-column list and fills the whole screen. It doesn't allow me to scroll down or across, so I can't get at all the list values or the "Other..." choice. Sorry if my terminology is a bit dodgy sometimes, I work with the Spanish version so don't know exactly what everything is called in English.

I'm using FM5 for the first time on an iBook running OS9.2. I'm creating a new database, very very simple. I have some fields where I want a predetermined choice of text. I created the value lists ok and allocated them to the fields. But when I try to create a record, the lists don't appear as pop-ups or anything else, when I tab through the fields, these fields are just skipped. Probably simple but I don't get it... Thanks, Param

Hello everyone im new to the forum and new to filemaker. I have been using filemaker pro 5.5 now for about a week and i have learned a great deal just reading the filemaker manual and some from the posts here. I spent over 4 hours on here one day and took in as much as i could. You guys do a great job. I have a question about a database i am building. Its somewhat of a simple database. Its a database that simply tracks members of a private club. In the base i have fields for personal information about the member(s) and a few payment option fields. Where i am having problems is in the Amount to date field. I have a field for Amount they pay for there dues per year cal…

I am in need of a simple tutorial for creating Conditional Value Lists. I have found some articles and examples but nothing that clearly explains how to do it. Is anyone out there up to the challenge of creating the ultimate clear and concise explanation? I would just like to have one database. I would like two fields, both of which provide value list choices. I would like the second field to have a list that changes based on the choice in the first field. I realize this is fairly basic, but I just can't get my head around it and would appreciate any help you can offer.

I would like to know how the duplicate can show on value list. For example I have a database A with frield Num( number) Num 1 2 3 1 Base on the data above , I make the value list but the popup can only show 1 2 3 I want to see 1 2 3 1 ...IS there any way to see all value including duplicate in value list? Thanks for your help. I really appreciate .

I'm trying to figure out how to make a browse list of personal names (generated from a valuelist displaying all records used in that field) to search for exact phrases rather than keywords. For example, I want the value displayed, such as Jones, John, to search for that exact phrase - "Jones, John" - rather than the two keywords "Jones" and "John", which has the effect of finding records with "Jones, Tom" and "Smith, John" that are irrelevant. The code I'm using now is: [FMP-valuelist: names, list=names] <a href="FMPro?-db=Databasename.fp3&-lay=basic&-sortfield=sortyear&-sortorder=ascending&-format=searchresults.htm&names=[FMP-valuelisti…

I have a portal that displays data in chronological order, except I need 1am to come after 11pm. I created a corresponding value list, but it doesn't seem to effect the sort order. What can I do to create a custom sort order for time?

Hi I have created a field and called it Delivery. It has 3 options in a value list ( SameDay, 24Hr & 48Hr ). Is there a way of creating a Summary to show How many jobs were delivered on the Same Day or 24Hr or 48Hr. [color:"black"]

Anyone has problem when click a record in value list and next time click again and it position is the same as last one . Me i have problem it does not go to the same position , i have to search from the beginning. I really need your help . I try to run many tests sometime it works ..sometimes not ...that is why I need a little trick. Thanks

Thank you for reading this! Think of Books>Chapters>Verses in The Bible. I have a static popup menu of the Books and a dynamic popup menu of the Chapter numbers based on the chosen book. Easy so far. The hard part is then a third popup menu (dynamic) of Verse numbers based on the two choices of Book AND Chapter. A calculation field result displays text based on these three choices. Is this possible yet? [ March 09, 2002, 08:02 PM: Message edited by: terrencebrown ]

FM4 Mac Self Relationship within a Contacts file Have Portal with linked Value List - select CARS and all garages are listed etc. First time I have done this and it is very fast and really useful. I would like to know how to make it as flexible as possible. In particular, if a Contact does several things, e.g. Plumbing, Electrics and Joinery, how can these be shown on different lists etc? Obviously, I am trying to avoid lots of layouts and additional fields. In addition, are there any other ways this can be improved? As always, thanks in advance for any comments. Keith

I have a survey of 42 questions. Possible responses are Always, Sometimes, Never. I am trying to make a talley sheet that would have a summary of how many respondents chose each of the responses for each question. Example, Always=42, Sometimes=15, Never=5 for each of the 42 questions. Would radio buttons or somethings else be better. What formulas should I use. [email protected]

Is there a way to create a record in a related file conditionally? For example: If two files (File A and File are joined by a primary key ID. In File A... If field_ONE="1" , then create a new record in the related file B and display the contents of FIELD_X and FIELD_Y in File B. Else if FIELD_ ONE contains any other value, do not create a record in the related File B. Thanks in advance...

What's the best way to define a DaysOfTheWeek value list? Because I use simple column sort (click on the heading of the column you want to sort by), I'd like "Sort Ascending" on such fields to sort M-Tu-W-Th-F-Sa-Su. But I want the field values to look pretty "Monday", rather than "1". I've come up with the following approach: Define the field to be a Number field that strictly demands to be a member of the "Days" value list. Define the value list to be "Monday 1", "Tuesday 2", "Wednesday 3", and so on to "Sunday 7". Then when you see the field, it looks good... if you size it just right, you won't even see the number. But even if you do, no big dea…

I want to create a value list that includes values from multiple (six) fields into one list. The "Use values from field" option only allows up to two fields. Any suggestions on the best approach to achieve this? Thanks. Scott

Can anyone out there help me with is query? I need to organise layouts displaying specific data on the amount of work done and the time worked on a particular job. How to display this data is not a problem. All information needs to be indexed to a job number. Say, for instance, Job 1024 Each job can be split into Batches. For instance, batch A is the first half of a job and batch Bis the second half. Jobs are also split into proofing stages. 1st Proofs, 2nd Proofs etc. Data about batch A ,B and C etc and 1st, 2nd and 3rd Proofs etc need to be kept distinct and separate for invoicing purposes. To avoid confusion, each possible combination of batches and sta…

I have two fields First Name, Last Name. I defined a value list called Names and it will use values "Last Name" and "First Name" then I created a popup field that plainly displays the valuelist of those fields nicely, However, after selecting the name you are looking for and moving on the the next field the pop up value list field only displays the "Last Name"? at first I thought the layout of the field was to small to display the "Last Name" and "First Name" so I expanded it but it still only shows the "Last Name" any on how I can make that display both? KKalvin26

Is it posible to change to a new layout when a person select a value in a value list ? I need to hide some field that they dont need to fill in if they dont select just a special field in they value list?

Hi. I've been scouring this forums, and I'm getting that there are issues with value lists and calculated fields. Basically, here's what I need: I need a pull-down menu of customer names (calculated based on various text fields) on an invoice so that the user can select the item, and have it auto-fill in the address. Right now, I have the "left value" in the value list as the ID number, and the "right value" as the calculated name. So, the pull-down menu isn't showing all the records from the customers table. How can I get it to do this? I assume it's related to "indexing"? Alternatively: Is there any way I can just have it build a value l…

First, I have to say this board is a terrific resource; I got a long way on my problem just reading through prior posts. Many thanks to all. But, I got to one issue I couldn't seem to resolve. I'm creating a Value List from related records, using the formula I cobbled together from prior posts here to form a text result that concatenates the related values from the "History Items" database: Substitute( ValueListItems( Status( CurrentFileName), "History Items Value List" ) , "

I was hoping someone could offer me a solution to a problem I've been having with a record keeping database I built for my 6th grade classroom. Our district uses a standards based grading system that Use "O S G N" instead of "A B C" for scores. I created a script attached to a button that allows me to sort based on a custom value list so that O is first, G is next, and so on. The problem I run into is when I try to sort the list after I've added "+" and "-" to those scores. Even when my value list looks like this... O+ O G+ G G- S+ S S- N N- it still does not sort properly. I have tried many different things, read many different books, and…

A cryptic subject but I will try to explain the problem. I have two fields, say "x" and "xcode", where I have a value list connected to "x". When you choose a value in the value list the "xcode" is set to a numeric value for example "1" if you choose the first value. This is performed through the calculation LeftWords(x; 1) Now I want it to work both ways because when I import data from another file to the database it usually only contains the numeric code. Is it possible to do this and how? //Henrik

I am having a problem with my value list. It is conditional and works when entering a new item. My problem is that I have a different form for crating a find request, the same value list will not work on this file. Why not? I can see no reason. Has anyone any experience of this?

I'd like to have the first value in a pop-up list automatically selected when the list is selected by tabbing or have the first selection in the list display automatically when a new record is created. Thank You

Is there a way to have a value list only show the "FOUND SET" and not the entire database? Example: Value list (from fieldA) FieldA: Adam Mike John Andrew Perform Find for "Mike" & "John" Value list: Mike John Catch my drift?

I have a multi-table solution running off of FMS 5.5 (all clients are FMP 5.5 too). Multiple platforms are accessing the server. The solution utilizes dynamic value lists based on relations. Everything works great, _except_ on NT clients. The pop-ups show blanks. You click on it, and a single row of nothingness appears. This only occurs in NT (v4, sp6). 95, 98, XP, Mac Classic, and OS X are all fine. Any ideas, solutions, experience? Many thanks.

All, I have 2 databases - FileA and File B. I have succesfully created a simple conditional value list in File A. I now want this list to be used in File B So far.... I have created an external value list in File B linking it to the conditional value list in File A. I have then assigned this list to a field in File B. BUT this doesnt work. I have checked and re-checked all assignments. No values appear in the value list in File B :-( Am I missing something? Any help would be greatly appreciated Thanks Chris

Is is anyway to show unindexed values (from a related unindexed calc field)? Any work-around way? Thanks

Any ideas on how I can include the plus in A+, B+ etc in my dynamic value list based on the raltionship A+, A, B+, B, C+, C etc?

Hello folks. I've been using FMP for over a year now, and have recently started using FMP 5.5. When I have a field that is definded by a value list, I don't get any pop up menu when i want to enter data! My questions are this: where did it go? Is it something obvious that I'm missing, or does it have to do with the newer version? It's just getting really hard (and tedious!) to enter the EXACT value without being able to select it from a pop-up menu. Thanks. Jackson Hewlett

All, I wonder if anyone can help me with this one! I have 3 databases - Timesheets, Timesheet Data & Projects Timesheet Data is referenced to Timesheets via a Portal that works beautifully! In the Portal I have a field called Project No. I currently have a pull-down value list of all projects numbers contained in the DB called Projects. This works fine! However I would like to refine this value list. I would like to limit this value list to project numbers contained in the Projects DB that are 'live'. This 'live' information is contained in the Projects DB in a field called Status. Any suggestions? Any assitance will be greatly appreciated! C…

I thought I could do this then found I could not! I have various linked files, one is 'Contacts' containing various individuals' details. Main file is 'Meetings' at which records will be created for each meeting with varying numbers of individuals from the 'Contacts' file attending. What I need is to be able to use a pop-up list of 'Contacts' in the 'Meetings' file which will be the basis for a mail-merge function so that I can send invitations to the 'set' of 'Contacts' attending, with these invitations printed out automatically, with all relevant personal address details added. I suspect this involves a portal or lookup of some description but I am not sure exactly how…

I'm making a scheduler in FileMaker Pro 5.5 where you can select a procedure (input list using the field procedure in the procedure database). There's a second field called steps in the database Procedure, in that field you write down the different steps needed for that procedure (every step on a separate line). What I want to archive in the scheduler is the following: The steps needed for the completion of the procedure will be listed in the steps field, the field is formatted as an input list with select boxes. The input list in the field steps must be linked to the procedure, so that the list used are the steps for that specific procedure. In other words: I…

I use a drop down menu that lists the name field from a different database. The problem is that this database has about 20,000 records. The result is that when you try to drop the list down it takes 15-20 seconds (sometimes longer!) to appear. Does anyone have a solution for speeding this up or narrowing the list that is displayed so that I can find the required name faster etc. Thanks Nick

I have a production workorder for an item that has several attributes. Example: a pendant that can be gold, silver, brass, aluminum. The shape can be: flat, curved, semi curved. The attachment can be: pin, ring, clip, none The color lettering can be: green, red, blue. etc... I currently use drop down boxes to select the attributes for each pendant. That means 4 or 5 drop down boxes. I would like to number each attribute and make a single entry to come up with the final set of attributes. For example entering 1,6, 8, 12 would give me gold, curved, ring, red. I know that I can concatenate every possible combination o…

I am updating a solution created by someone else. Here's my problem: I have three related files: Departments Staff Projects Departments and Staff are related such that for each Department there are multiple staff members, and each staff member is associated with more than one department. For each Project, A staff member and a Department need to be selected from a pop-up value list. I would like to use a conditional value list, so that once a Staff member is selected, only that person's associated Departments would appear in the Departments pop-up list. This seems elementary - but since there are three files involved, I haven't managed to make it work. …

I'm working with a database that has pop up lists in it. One of the pop up lists, when not being used (waiting for an entry) shows a title, i.e. Select Sport and then when u click on it all the different sports show up, but 'select sport' does not. How does one title the pop up list so it's not blank without actually putting a text box over it cuz i don't believe that's how it's done in this case. The actual field that is being used is a global field pulling in a value list from a related file. I hope I explained this clearly. Thanx in advance.

Using a Pop-Up-List or a Pop-Up-Menu, is there a way to get them to show the value selected? In other worlds if I have 10 names in a Pop-Up and I click on one of them, I want

Thanks to this forum I can now travel between databases and layouts by selecting a desired location from a value list then clicking on a button to execute a script based on the value selected. I'd like to eliminate the button and be able to initiate the script by merely making the selection from the list - much like can be done in a web page. Any thoughts or suggestions will be appreciated.

I have a file of Companies with one field Company ID. In the Companies file I also have a field for Company Type (with three choices, Vendor, Client or ShipTo- check boxes). I have a value list Pop-up in my Purchase Order database to choose from all the Companies, but I want to show in my list only the Companies where the Company type = Vendor. Can I do it?

I was going to post this as part of the "hierarchal conditional value lists " thread, but then thought it was different enough for its own thread. I have found many posts with similiar questions, but none seem to address this specific problem. here goes: 3 files- invoices products items I am having a hard time concocting a conditional value list schema for entering heirarchical data from products into the items file through a portal in invoices. sticking with a car analogy, lets say we have fields: model make year color I would like to have a value list displaying all models (from product…

Is it possible to use a selection from a value list pop up to jump to another file? It would sure beat having a specific button for each db you need to navigate to. TIA for feedback EasyEdE

I have the following problem with Pop-up menu: 1. Using FileMaker Pro 5.0 and 5.5 2. Operating system is Windows NT4 (Service Packs 4 and 6) 3. In Layout Mode, I have chosen for Field Format for a particular field, under Style for a value list: "Pop-up menu" 4. When in Browse Mode on this field where Pop-up menu used, the list does not appear vertically with the ability to use the up and down arrows to scroll up and down the vertical list 5. Instead the list is presented vertically to the depth of the screen then further columns of the value list are presented horizontally until the value list runs off the right hand side of the screen. The…

A value list that I am creating is a choice between several lengthy phrases being inserted in a formatted letter.. In ten years of using FMPro, I had never run into the fact that there is a 255 character limit for each value. And, since I was exceeding that number, the phases would truncate. I have found two tech bulletins (101491 and 102388) which advise that the workaround is "use a code value in the value list and set it to trigger a lookup into another file that contains the actual data to be entered." My thought was that this meant to use the "use values from field" choice and have the appropriate text over in the chosen field. That doesn't work (or I'…

I am using FM 4.0v1 and have made a value list from another db to display in my main db. The value db has fields that list the type and grade of material. Since is it hard to determine what type of material is being chose by just looking at the grade I have check the box that says show information for other fields. But only the first matches showup in the value list in the main db. Example: Grade Type SA234 Pipe SA516 Plate SA106 Pipe Value list will only show SA234 and SA516 (along with the type) put not SA106 could someone suggest what I am doing wrong?

Hi All, Hopefully, one of you have done something similar to this. I have an online form that is registering students for placement exams at a university. For any date and time, a maximum of 30 students can register. When a given date and time exceeds 30 registered students, that date should be removed from the value list that holds the available dates and times. The thing is that I don't know whether that kind of capability can be facillitated over the web using CDML in combination with Java or JavaScript or if it is even possible at all. Do any of you you happen to know how value lists are stored and can be referenced in s…

Hi, I was wondering from selecting from value list and running a script based on which value is selected. ex. Lets say there is field with value list defined. And by selecting one of those value from that field, can it have perform a script? Thanks in advance!

I have a calculated field in DB A that I am using as a value list in DB B. The DB B field is set up as a pop up field. When I go to the field to select a value the list pops up fine with the appropriate values BUT as soon as I select the value I want I get a dialog box telling me I can't modify the field. I vaguely recall that there is a need to put another field in one of the databases that acts as an "intermediary" or some such thing. TIA for any feedback.

Hi. Does anyone know how to add text to a radio button list that won't have the radio button next to it? I want a label to appear on top of a list of radio buttoned text items, inside the field. NOTE: I discovered that a - will produce a blank line in a radio buttoned list.

Hey everyone, I am brand new to FMP and I have one really important question. I collect alot of names, address, emails, etc. I have people who fall into several groups and want to know the best way to keep them all in one databse even though not everyone is in the same group. some fall in several groups, and some one group. I hope this makes sence? How could i do this and mark which groups they are in wether it be one group or 5 groups? Reba

I am trying to create a database to simplify a selection process to a specific product, which is displayed in a portal I have managed to make it work to two levels based on a relationship, but i need more scope, well at least 4 levels Product Type (5 Choices) Then by Manfacturer (Choices dependent on Product Type Selected) Then by Colours Available (Choices depend on both manufacturer and product type) This should narrow the final selction from the product database from 500 items to approx 6 Any suggestions on how to take this further. Cheers Mark

I don't know if this has been asked a lot or ever. I don't know what I would search for to try and find it. Here is my situation: I have three related tables: People (grandparent), Boats (parent), Results (child). In this database, a Person can own many boats, and a boat can have many results. No problem setting up the tables to have unique ID values (single user system) and relations to make that structure work. Here is the problem: In the Results table, I need to populate an ID field (foreign key) with a value from the Boats table (primary key). Since the user should not have to remember the ID values, I am using a popup, based on a value list that…

Hello, I have created a script for a value list, the script is a simple [clear] script which clears another field when run. The problem I have is I don't know how to apply the script so I can still scroll through the value list with the script attached to it. Thanks for any advice. Chris Brown IT Support United Kingdom.

Hello, could someone please help? I have a database with a value list that is based on a relationship, when I choose data from one value list (1) it automatically looks up data from another database and in the second value list shows all the data that relates to the data in value list(1). The problem is that when I want to change value list(1) to something else the second value list still shows the same data until you click on it and choose the data you want. for example: value list(1) = Company Value list(2) = Product In company I choose McDonalds In Product I choose Chicken burger But then I want to change the company to B…

I have a value list that comes from a field that calculates what months to show based on what year was selected. i.e. for year 2002, show fiscal months July - December "July" & "

I have set up a button (N=1 & Y=2) that a user will check if the "Billing Address" is different than the "Contact Address". Right now the button is in place but isn't linked to any type of functionality. That is where you all can help me. As the default, I would like the "Billing Address" fields to mirror the "Contact Address" and the button to be set to "N" - then based on the user actively selecting the button to "Y", the address fields would clear for the user to enter the new information. Any/all suggestions are welcome. I appreciate your help in advance. Thanks!

Hi, I have created a database in FMP and I have 2 pop up menus one is comany name and the other is the size of paper eg:a1,a2,a3,a4,a5 but the sizes are all different to each company. So the question is, is there a way of selecting a company name and it bringing up all the sizes that relate to that company that I have selected in the comany pop up menu box. (I dont know much about relationships) I have created another database with two menu fields, company and Size and have created the 3 companys (company 1, 2 and 3) and in the other field, sizes 1 - 14. I then created 14 records. matching comapany 1 to sizes 1-6 company 2 to sizes 7-10 and company 3 to sizes 11-14. …

Used to be a power user of FileMaker years ago, but since 3.0 have drifted off into part unknown which leaves me with a problem I cannot now easily solve in 5.0. Have created a pop-up list containg 30 items for ease of entry and to control search element criteria. I now find that two or more of the items in the list are required to show up in the field. How do I get the FM5.0 to do this without adding composite items to the list? Can it be done? Thanks

I think I know this can't be done, but here it is anyway: I have a bunch of valuelists that I store in a preferences file, where I give the user the ability to change the list contents by including the format option Edit... If I have to replace the preferences file because of an upgrade or major bug, there doesn't seem to be a way of transferring these valuelists to the new file. I know I can get them out with a Design function, but how can I put them back into the new file???

I guess this is a bug. But I have the strangest results with a value list in find mode. I have a relationship that is based on: a global field in database A a text field in database B As the value in the global field changes in A, the correct value list is shown (in database A) from the data in B. The value list works fine in find mode on fields that are in the current database but shows me a completely different value list on related fields. Notice that in browse mode Value List works correctly on all fields! Has anybody noticed this yet? What is happening? ----------- Ok, even weir…

To All

There is probably an easy explanation for this, but it is keeping me up at night: I have a calculation field in one DB ("first_name" & "/" "computer_model") that is being used by a value list in another DB as a pop-up menu. It works fine until I update the first DB. The changes are reflected in the pop-up menu, but not in previously created records. I would like all previous records to update with the new information. Any clues as to what I am doing wrong?

Please could someone confirm that the 'Other' option in Value Lists does not work on PCs (as opposed to Macs where it does work) and that this is not just a local problem with my databases.

Ugh, I'm completely stuck on this value list problem. I have a value list which is in a file that acts as the middle of a many-to-many relationship. I want it to show only values which have not previously been chosen for one of the related files. Here's an example: Table 1 : Projects Table 2 : Employees Table 3, many-to-many : Assignments (Choose both a project and an employee match) In Table 3, I want to create a value list which ONLY shows Projects that have not yet been chosen. It's a usability thing - so that the client doesn't have to scroll through a whole bunch of already assigned projects, but will just see those that haven't yet been chosen and ar…

Hi All: I'm sure this one is on the tip of my tongue... I have two fields: "Contact Type" which is located in a db called Contacts, and "Performing Artist" which is located in a db called "Bookings." When I select the "Performing Artist" field from withing the Bookings db, I would like to have a value list featuring the full names of all the Contacts who are of the Contact Type "Artist". the fullname field, by the way, is a concantenation of the 'first name' and 'last name fields' in the Contacts db. is this possible? kindest regards and thanks, john

Hi, I have 3 databases: A, B, and C. In one layout of A, there is a portal to display/edit records of database B, and the field format of one of the fields in the portal is assigned as an pop up value list, and this value list is a long list, contains about 20 items. And the items of this value list are come from database C (there are 20 records in database C) And the rule is that the item in the value list is to be selected ONLY ONE TIME per record. In database B, I can setup a SELF-relationship to detect if there is a duplicated item. But I would like to display the word “selected” side by side of the item in the pop up value list to indicate that the ite…

Is there a way to set a field to look up information from other fields, and yet still allow modification? Specifically I have a donor with names and addresses etc. I have fields for title, first1, last1, title 2, first2, last2. I want the data base to automatically enter Mr. and Mrs. George Smith, unless I know the donor prefers to be listed as The Smith Family, in which case, I'd hand enter that listing.

I would like to create a pop-up value list which is simply about a half dozen years to choose from, starting with next year, but changing each year depending on the date. For example, this year, the user enters the field and they can choose from 2003, 2002, 2001, 2000, 1999, 1998... but next year, the same field would supply six sequential year choices starting with 2004 and ending with 1999. Anyone know how I can do this in a value list? I assume I must select use values from a field, then create a calculation field and use Year(Today) but then what? Year(today) + 1 etc. etc. doesn't seem to work. I don't know how to make a calculation field return multiple values eith…

Hey Guys, I have a simple shopping site running. I have a field in a "shopping cart" db which displays ordered items and is populated by a value list generated by relationship from an "ordered items" db. However when someone adds two items to their cart (instead of adding it once and changing the quantity to 2), it will only display in the value list once, but will appear in the portal twice. I am using this method so I can generate an automated response email with the items they have ordered in it. Thanks in advance. John.

Ok, I have two databases. One database has two main fields I'm working with SERIAL_NO and OWNED_BY. In another database I have two drop down boxes one that displays all the SERIAL_NO's from the one database, and one that displays all the OWNED_BY from the other. What I'm trying to accomplish... When I select an "Owner" from the OWNED_BY box I would rather it show me only the 20-30 serial numbers in the SERIAL_NO box instead of all of them. Meaning, I only see the serial numbers for the given "Owner" instead of every serial number. Can this be done? Thanks in advance! Nic

Hi, I'm brand new to the group, so please forgive me if I commit any newbie errors! In FileMaker 4.x, I have "Field X" which uses a pop up value list that displays data from "Field 1" and also displays data from "Field 2" - In this case Field 1 the Company Name, Field 2 is a Customer ID number. I need the value list to sort on the Company Name (Field1) and place the Company Name in Field X when selected. I want the ID number visible so that all customers, including those who share the same name, are indexed and show on the value list - even if they have the same name (more than one record may share the same Company name, but the ID Number is unique). I…

I'm working on a customer database related to a time billing database. And in the time billing database I have a drop down box that has everyone's customer number in there that a person can select to pull there info from the other database. Is there a way that when a person selects the drop down box it shows not only the customer number, but the company name? But then when one is selected it puts only the customer number in the field? Thanks, Nic

I am obviously a beginner, is there any way to just have the data from check boxes that are checked to appear in the report, not all the boxes, checked or unchecked. For the radio buttons as well.

I am having a problem with a checkbox list. Has anyone else had this problem with FM 5.5? There is an established checkbox list which has always worked. It lists different committees that a person can be on. One of the committees changed its name and got new members. My office assistant unchecked all the old members of the committee. Then she went in under the Define Value List and changed the name of the checkbox to reflect the new name of the committee. Lastly, she checked the new members of the committee. The checkmark does stay on the record. However, now when she does a search she gets the message that "no records are found". If you go to …

I have a database which has a field with a pull-down menu with a very long list of schools that comes from a pre-defined value list. For reasons too long to go into in my short post, I cannot use field validations anywhere in my database so I have been forced to validate each field with a script. I have been using techniques such as "not IsBlank (myfield)" or "Length (myfield) = 12", etc. and it has worked without any problem. I need to know; however, if there is a way to check to make certain that the entry is from the list of schools provided using a script method because, again, I cannot use the standard field validation. I would consider hard-coding a list of scho…

Hello Everyone, I have a small problem which mabey someone can help me with. I have a database with 6 layouts. Layout 2 has over 100 pictures of different products, Each product has a value list of the different models of that product. Everything is working great except for one thing, the value lists. What the end result should be is that the person selects a product on layout 2, then it takes them to layout 3 with the correct value list for that product. I've tried using a calculation with ValueListItems. But when I try to select an item it says this field is not modifiable. Is there anyway I can do this without creating over 100 layouts? Thank You K…

Sorry to say, but no. The popup list size is set by FileMaker and isn't editable by developers. This includes both the width and height of the list. I can conceive of a workaround to increase the width of the list by adding spaces to the end of the value list items, either in the custom value list definition area or by adding a second field with spaces in it if the value list is based on a field. Don't know if it would work, but you could try it. Chuck