Value Lists

I want one layout in a filemaker pro 5 database to display all of the records in a list. I have tried following the instructions in the user guide for leading grand summaries, I have done everything it says, but its not working. Can anyone tell me where I'm going wrong?

I have two databases. One is an employee record and the other one is a payroll. In the payroll file I have a field that you can choose the individual to pay by looking up their name from the last name field in the employee database. I have the field as a pop up list using the last name field from the employee database as the value list. The problem is that the list will not show people with the same last name. The list only contains the first record entered with that name spelling. First, is this the best way to do this and if so is there a way to get the value list to show all of the records in the database?

How can i create a portal with the blank line at the first row?

I am trying to create a layout with a set of 13 similar text variables;each with values selected from the same value list. I am trying to make the inputs via a table of radio buttons, one set for each variable. When I create this, using FMP3.0, each radio button has the text of the associated value right next to it. I would like to get rid of the text and get the buttons closer to each other so the table will be compact. I can't figure out a way to do it. Any suggestions?

I was wondering if there is some way that I can automate the database so that if a particular value in a field is selected and the selection of that value would automatically jump to a text box, or a text field. For example...the field type is called Assessment Scope, and the two values are "General Population" and "Condition specific" where when condition specific is selected there needs to be some way to enter text. So say someone selects "condition specific" I would want it so that when this is selected they are then able to enter text to describe the condition.

I'm new to file maker. I use filemaker pro 5 for mac. I already have a layout for my classes preparation. Since I teach in 4 classes, chemistry, physics, etc, I want a popup menu with all thoses classes name. And when I choose, lets say physics, I want that all my preparations for that classe to appear and not the others. How can I do that?? I've tried to put a value list with the subjects in it. Then I went on every preparation and choosed the right category for it. But whats next? Do I have to put a search button? I wouldnt like it. Please help me or refer me. Thanks Bernard

A local organization runs 4 fundraisers each year. They have 4 databases that maintain records for each. What they want to do is create a master report that lists everyone who's worked one or more of the fundraisers and their total collections for each event in which they participated. Some individuals work all 4 and others just 1. How do we get all the names into one field with duplicates removed. I can display names from any one of the 4 easily but can't get a combined list. A calc field combining participant lists from the 4 databases fails with a beep and message saying "this field can't be found." The organization would like to have their information displayed simi…

Is it possible to make a value list conditional on the values from two different fields? Example: I have a quotations file with quote numbers and revision numbers, I want to use the quote number then the revision number to determine the current price for the item (quote number 5, revison 3) in question. Thanks! I think I've found the answer in another forum.A calculated key is the solution. Create a calc in the quote file, quote number & "-" & Revision. Then put the quote number, followed by a "-" and the revison in the match field in the other DB to join them. Does this sound right? [This message has been edited by markga (edited September 01, 2000).]

i have a db of students. i have a popup with a value list from the student's names. what i want to do is allow the user to scroll down, select a student, and have that student's record appear. can this be done? added hassle. user is not allowed to change the student name data. if i make the field unchangeable the value list disappears and it becomes a regular field. thanks Dave

I need help with how to create a field containing a list of items from another database. I have two databases SUITES and SETS. The relation between them is a 1-N relation with SUITE_ID::SUITE_ID so that I can get a list of all the sets in a particular suite. I can of course show the sets in a portal in the SUITE db, but what I want to be able to do is to export the list of sets together with information for each suite. I have tried just exporting the related fields, and they all are there, but the format is wrong. When I do the export I want the output (in TAB-format) to come out something like this: SUITE_ SUITE_info1 list=SETS SUITE_info2 e.g: 0210A1 …

I am a beginning user of FileMaker 4. I have a two fields in my database: Application and Version. Application is a pop-up that lets you choose Photoshop, Outlook, IE, etc. I want Version to be a popup relevant to whatever application was chosen. For Example, when the user chooses Photoshop from the Application popup, the version popup only shows 5.5, 5.0, 4.0.1 etc. But when the user chooses Outlook Express, the version popup shows 4.5, 4.0, etc. Is there any way to do this? It would be soooo helpful and save a whole lot of time. Any ideas?

I understand that the width of a value list is determined by the width of the field it's attached to but how about the length? I'm using Arial 8 pt. and the value list gives me 10 visible choices before I need to use the scroll bar. Is there any way to exercise control over the length of this popup window and the number of options available without having to scroll?

I am working on a database for a bus charter company, I have a value list of drivers and one for buses as these two items are sledcted and placed into service I need to show them in use, for a date and time and then release them when this time has pasted . Any ideas? ------------------

Hello everyone. I'm a newbie, and I have a question. Is it possible to use a script to choose what value list to use? A little more background: My company uises FM to track the shipping of products. We have certain companies that we have agreements with. We currently have a script that fills in the contact info of the companies, and we would also like it to change the listing of products they can choose from, as each has a different subset. Is this possible, if so how. Please help!

I know it's called a heirarchical value list but I can't get it to work right. I have a field called "Group #" with a value list where the user picks their group. After this I want a value list to pop-up in a field called "Sales Rep". This value list is based on the group # (4 groups and a show all option). How do I get this to work. Thanks for any help you can give

I have three databases, time sheet( a simple portal for entering project hours logged), time sheet line items( for storing that info as separate records), and projects(for distributing that info to the appropriate project record). I want to create value lists unique to each project record and generated each time I create a new record, that can then be attached to a field in the time sheet file. Can this be done?

I am (primarily) a home user, so I hope that my question won't seen to simple. I am still using 4.1 (I'm a student...), and I have a database that I want to have display a list (check boxes or pop-up) that eliminates an entry when that entry is selected. I want it to simultaneously enter the value that is being removed into another field. I realize that this will require a script, but I can't seem to make anything work. Any suggestions?

I am (primarily) a home user, so I hope that my question won't seen to simple. I am still using 4.1 (I'm a student...), and I have a database that I want to have display a list (check boxes or pop-up) that eliminates an entry when that entry is selected. I want it to simultaneously enter the value that is being removed into another field. I realize that this will require a script, but I can't seem to make anything work. Any suggestions?

In Filemaker Pro v5 I want to have a dynamic value list in one layout based on the data entered in multiple fields in a different layout. Example: One FMPro database file. Each record in the database contains info on a different football team. In one layout there is a separate field for each player's last name. In another layout I want a pop-up menu listing all the last names of the players. It is simular to the "get value from field" option but instead of creating a value list of all entries in one field from all records in a file, I need a list with the entries in multiple fields in one record. Is this possible? Thanks, ------------------ Bryan …

Rental categories Rental items Both in a table-like set up of 10 repeating fields. I have Rental Items looking at Rental categories, and then showing only values that relate to the Category item (i.e. Tables: round, square, oblong, etc.) The problem: All the repeating Items fields reflect values of the first entered Category. I have done the categories two ways: from a field, and custom entered. I cannot get the 2-10 Items values to reflect the entered Category value. HELP!!! And thank you, Pat

Hi, I'm working with pop-up menus in FMP 5. I want to restrict the choices possible in a second menu based on their choice in a first one, ie a conditional/cascading menu structure. I've seen solutions to this problem for v. 3 and 4 which are huge and labourious, but I think it's supposed to be easier in v. 5. Any help would be great thanks!