Value Lists

Howdy, howdy: I have multiple T.O.s in my solution and in a few of them they have a text field named "City." Rather than each T.O. having its own City value list I thought I'd have them all access a single field ("City") in a T.O. named Preferences; it would be accessed via the "Use values from field: Preferences::City, show all values" drop-down menu set-up. My question is: how to enable all the T.O.s to "see" the City field in the Preferences table? Do I need to link every T.O. to Preferences using the typical pk_city_ID/fk_city_ID relationship, or...? TIA for your help! Rich

I can't say for certain, but there seems to be some sort of limit on the number of items that can be in a value list. Say I have a list which is based upon a field: [car parts::serialNo] And then I use [color:red]ValueListItems ( fileName; valuelist ) There will sometimes be items missing. If instead I use [color:red]List ( car parts::serialNo ) This problem does not occur. (Before anyone asks, the reason for not using list in the first place is for backwards-compatibility). Has anyone seen anything similar? Is there a known limit on value list items?

hi all, i hope i'm in the right place for this question. is it possible in FMP 5 to set a default value to a radio box or checkbox. its a simple yes / no function and i recently added it but i need everything to be standard set to yes. is that possible. and if it is so could someone tell me how? thanks in advance

I am trying to combine 2 value lists into one - they are from 2 different tables and need to be use in a 3rd table. 1. TimesheetsTable = table where the TASKS value list needs to be available. 2. ProjectsTable = contains a value list of all the Tasks assigned to that Project. 3. AddendumTable = contains a value list of all the Tasks assigned to the Addendum. • In the TimesheetsTable the person chooses a Project 123 and based on that choice a pop-up displays the list of Tasks assigned to Project 123. Works like a charm. • Now, when we create an Addendum for Project 123 the Addendum info is in a separate table ... the Addendum can include different Tasks…

Is it possible to count occurrences in check box set fields? In other words, if I have three sizes of shirts, S, M, L as check boxes, can I count the number of different sizes as a summary field or calculation field across multiple records?

Hi all! Over the past few weeks we've been building and fine tuning our new contact database and this is the first issue I can't resolve through research or doing countless trial runs. I have a long list of job titles we categorize clients by. They obviously fall into larger groups based on profession. Thus we have a short list of Professions and a longer list of Job Titles. I already have the drop down value list for the professions working fine and could do the same for the job titles but what I'd really like to do is have the second list of job titles shorten based on whatever is selected from the Professions value list. E.g. if somebody chooses Photogra…

Hi I put this post originally in the layout forum and received no reply so I am trying this forum (which I just discovered -duh!) I also tried to search for an answer but, zip so far. I have a field with a defined value list on two different layouts. One a drop down the other a pop up menu. The values are from the field itself. The values are "batch numbers" so it builds the list 1,2,3 etc. Currently the list sorts 1 through the highest number. I would like it to sort the opposite so the highest number is at the top. Possible? Thanks for your patience and any help. P.S. I'm at work on 8.5 Advanced on XP in case my home profile shows up as 9 &…

Hi everyone. I have a script already written that work well that send an email to a bunch of people. Now I need that script to be trigger by a Checkbox. If they click on The X on the Checkbox the Script for emailing is being run . . . How can I do That ?

Hello, I am sure this is probably very simple, but I am having trouble figuring it out. I have a table that contains last name and first name as two separate fields. I would like to create a value list of the format "Last name, First name" so that someone can select from this dropdown list when editing records. How do I create a value list in this format?

Hi, I have a value list which is a related value list using "Include only related values starting from" radio button option. It is a value list from a Date data type field. I want to show user with this value list. The value list should be sorted for the required date field. Pushkraj

I am adding a basic value list to my layout. When I format it for checkboxes, the checkboxes won't "check". It also stops another very small checkbox already on the layout from functioning. When I delete the second value list field, the first, previously working checkbox field still won't work. I've reinstalled the FileMaker Pro 5 software, remade the value box and field from scratch, and the results are the same. The Value List I'm adding has 39 items on the list with a maximum of 18 characters each. It originally had hyphens and slashes on some of the items. I have since eliminated any character that isn't A to Z. I am on a Mac G3 with an 8.6 OS. This sh…

I am putting together a database to input orders. I can't find help on how to format checkboxes to get them to show the correct data in both a data input form, or the associated table. here's the deal: I have a table storing data (yes or no) and a form for people to enter the data. They have a field at the top of the form in which they enter the product number and up should pop the description and whether or not it is in stock (in the form of a single checkbox for each size--size0, size1, size2, etc.) using the associated table's data. There are 12 different checkboxes on the form... They are all number/boolean fields and checkbox format. How do I get the ex…

I have a text field which I populated using a script and then used as the basis for a Value List. What's weird is that, when I pull up the value list in a pop-up menu, the list will dynamically change — as if FM were treating the text field as a calculation field, and recalculating the value of the text field by re-applying the script. I can explain in more detail, but I'm not sure it's necessary to do so. I gather that this is one of the new features of FM 10 (or 8 or 9) — I only recently upgraded from FM 7. I'm writing in hope that someone can explain the underlying principles of this dynamic. I'm accustomed to FM forbidding me from using calculation fi…

I want to be able to choose one of four possible addresses per contact to create mailing labels. I figured out how to add the radio dials and entered custom values (business, home, home2 and other/foreign). In an ideal world, I want to click on "home" and the data stored in the home street, home street, home street2, home city, home state, and home zip should be placed in to a "Mailto" field (or a Mailto home street, mailto home street2, etc). I have not yet set up these Mailto fields because I'm not sure if the information can be dumped from several fields to one larger field. I believe that I need to set up the "mailto" as a calculation field and using a case …

I am creating a flat database to catalogue my Microscope slides, and using the serial number function to automatically number the slides. If I remove a slide from the collection, how can Filemaker pick up that there is a gap in the sequence and offer to fill that gap when the next entry is created.

Is there a way to control the ordering of a conditional value list? I'm trying to develop a task list for my cabinetshop. If you choose "DOORS" as your first selection, then the second list of values is germane to door making activity. The second list shows up in alphabetical order but I would rather have it show up in sequential order (i.e. step 1, step 2, step 3 etc) [color:red]Is there a way to establish a custom ordering of the conditional values? Thanks for any help, Jarvis

I just wonder if there is a simple way to do this (Filemaker 9) Basic invoice situation: Inoivce Table Line Item table Product File Enter item# in and description and price are displayed in that line item of the invoice. Simple. Now I want to be able to choose multiple item#s for that ONE line item. For example: Items might be - Shampoo $20 Color $35 Set $10 I want to choose multiple items from a list and have it concantenate so the description reads: Shampoo, Color, Set $65 We don't have the space to have a checkbox where you can select more than one item. What's the cleanest solution? I have ideas but they all seem to t…

Hi, I have created a "Values list" that display values from 2 fields. first field : Email second field: Full Name Then selected "Show values only from second field". Now, I have created a field that used a Pop-up Menu to display that "Values list". It work great, it list the Full Name but still seem to store the email address of that person. That way when I press my email button it use the email address of that person . This is what I want. My only problem and it's a very inconvenient one, I can't search that field using the full name as criteria. Even thought the pop-up menu only display the full name. What can I do ?

I have a table of 14 records, each record has a field called description. I have a global field xyz in a second table. I create a layout using the second table. I put the global field xyz on the layout. I make it use a drop down list from the first table, field description. When clicking on the global field all I get are two descriptions. I'm missing the other 12. I tried everything. Any ideas?

I need help in figuring out the best way to use check boxes to tag records in a list layout. The users need to be able to tag one or more records and then select a "delete" or "process" button in the header. Sound easy and pretty straight forward, until you throw in a large multi-user environment. The "tag" field is currently a text field, and I can see where one user may be tagging several records for processing while another is tagging for deletion, and it's just a matter of who hits the button first. It would seem that I would need something like a unstored calc field but, cant get my head around how to make it work. Thanks in advance for any help.

Hello all, I have a value list, that is based on a field. I have chosen the primary key (autocreated unique number) as the first value and another field from the table as the second value. When i make the value list sort by the first value, everything displays fine. I can see all records from the field. However, when I select to only show values from the second field, some values disappear from the list, and instead the end of the list just displays a bunch of blank values? What could be the cause of this problem? I checked that neither the key field, nor the second field contains line feeds.

We are running a relatively simple database to manage information on our students. We have a number of fields, but 2 fields are causing a problem, and they are crucial fields for us. The first is Status- this is a checkbox group (current, active, alumni, etc). The second is Program (MDI, NPD, BTH, etc.) In a list view both of these fields are used for calculating statistics. The problem is that the Status field is not being populated with the information it has for each record. The information on status is sitting, hidden, in the program column. So for a record a student is listed as being in the MDI program. When I click MDI in the list view, below it pops up …

Hi I am looking for a good way to handle a drop down list that would be required to match on three different criteria. It is a list to enter an airport and this can be matched by either a three letter IATA code, a four letter IACO, or the place name itself. Currently I am working in version 9 and while I think I could trigger these entries to complete a join table (from the Airport table) on field exit in version 10, I am struggling to think of an uncomplicated method for version 9. The result I am after is just as the BA.com website, any thoughts would be greatly appreciated.

i have a new problem . i am trying to do a Conditional Value List . in the layout named machine i have the tape of machine when i select it i will get in the model get all the amp's or mixer debencse by what i did select . hisory.fp7.zip

Let me explain what I am attempting and hopefully someone can provide advice as to the best solution. I have 2 tables. Projects & Assets. Each project is made of multiple assets. When a single asset is entered into FM, it is given a Project name. This project name is created by choosing from 3 value lists I have created. The field names are: 1 - SerialID 2 - CategoryID 3 - ShortName I need all three of those fields to create the ProjectName field. How do I do this? How do I merge all three separate fields into one field called ProjectName? Concatenation? Script? Since the ProjectName field is the link between the Projects Table and As…

I have a value list of fields called school names. In the custom fields box (or in the entry screen we allow edit) we keep adding new school names as we get them. This way, when you click on school, a drop down list of all possible schools comes up. I would like to see that list in alphabetical order. Is that possible?

hi i had a problem with Conditional Value List i did think that i had it all fixed and working now i found out that i have a new problem i up load a small video that you can see my problem that i can not select the filed named model from the layout. please some one help me. help.zip Snapz_Pro_XScreenSnapz001.mov

I have an Value List wherein ID is first field (do not display) and 2nd field is Name. The ID is a one to many relationship. In Forms, the related field stores the ID, but I want the Name to display. If I choose to display data from the Value List as a Popup Menu, it displays the Name correctly. If, however, I display as a Dropdown box, it displays the ID (1st field) instead of the Name. (It wouldn't be so bad if I didn't hate the popup menu -- it gets in the way when I'm tabbing through a record.) I was informed by a veteran programmer that this is an irritating "bug". Has this been fixed in Filemaker 10? It does not display correctly when I mask the dropdown box…

Hi folks, I am hoping this should be relatively straightforward to sort out but its got me a bit stumped. I am building a print management workflow solution. I have a table called Contacts where customer data, general contact data and supplier data is stored. Each record is either tagged as being "Customer", "Contact", or "Supplier". I have built another table called Purchases where we can raise purchase invoices and relate them to suppliers. What I would like to achieve is a drop-down value list on the Purchases layout which only shows records from the Contacts table that are tagged as "Supplier". I am not quite sure how do get this to work...…

Here's a seemingly simple problem: I would like to use the Go To Object script step to go to a field with a pop-up menu, and display the pop-up menu automatically. In other words, when the user clicks a buttons, he is taken to a field by object name, and the value list shows right away. I've been playing with the different commands, but all I manage to accomplish is going to the field and selecting its content. Any ideas?

I'm trying to use the values entered in a "Ignore Words" value list during a calculation to set a catalog number for film titles (for example, ignoring words like "the" and "a"). I would assume I would use the ValueListNames function, but not sure how exactly it works. How do I test if a text string is in that value list? I tried something along the lines of If firstword = ValueListNames( Get (Filename); 'Ignore Words List") But that didn't go so well. Any thoughts?

I hope I am in the right section for this question. I have only done very basic databases with FileMaker as of now, and basically no scripting. I am sure this is a ridiculously easy question for most of you. I have a drop-down list with several values. What I want to do is when a certain value is selected, change to a layout associated with that value. I think I know the basic idea of how to do this, but not exactly. I'm thinking it would look something like: If "field name" = "specific value" then go to "specefic layout" This is only for one of the values, the rest would stay on the current layout. Essentialy what i am doing is, if Widow is selected then …

Ok, this should be an easy one for you experts but it's driving me crazy- I have 3 tables linking many to many relationships as follows: 1. "Employee Roles" - Out of all the employees in our company, each can preform one or more roles (eg. estimator, engineer, senior engineer, etc.) 2. "Project Roles" - Out of all the projects running at our company, each 'role' is defined with a charge out rate. ie- the rate for an engineer may change from project to project. 3. "Project Employees" - Each emploee must be 'authorised' to work on a project. Simple so far. Now we create a new table called "Timesheet LineItems" on which an employee books their h…

I have a question. I know you can choose multiple selections in drop down menus when holding down the shift key but after I do that and let go, only one of my selections shows up in the field. Is there a way for all my selections to show up? Thanks for any help

Hi, I have a Song table and a Keyword table. Let's say the Categories in the Keyword table are Instruments, Genre, Tempo. Each category has its own field in the Song table which is populated by keywords in that Category. E.g. Instruments would have Timpani, Guitar, Harp, etc. and the user would check off the Instruments that apply. This is displayed by a checkbox from a Value List that is populated by the first field: the UID from the Keyword table, and the Description from the Keyword table. And it only shows the 2nd field. I've been trying to set up a calculation for a field in my Songs table that would show be a list of checked off Instruments. But th…

:P I am not sure why this happens. I am pulling a related list from a third party location. The list has no blank records. However the top record in my list is always a blank? Anyone ever have to deal with this? The record cannot be blank as the field needs to be mandatory. However, it does not read as a blank field? perplexed.

First of all, I wanted to say that everyone on this forum is amazing and has been soo helpful. Here's my dilemma. I'm working on a commissions database for our sales department. Right now, whenever a radio box is checked as a recoat, the commissions will zero out since they can not recieve commission on a recoat. Our problem lies whenever we credit someone for the bad material but then they want a recoat, so then we have to charge them for it, which would recieve commission. But that job would still be considered a recoat. I would like to have a drop down list that would say "commissionable" if there is no recoat and "non commissionable" if th…

Hello, Hoping to get some advice on the attached file. I am trying to track leads coming into my business. I have categories, and then subcategories. I would like to select the Major Lead Source, and then more specifically list the Minor Lead Source based on the first selection. I have attached the file to show what I'm hoping to accomplish. Thanks in advance to anyone able to help! David LeadSource.fp7.zip

Hello, I am trying to create a ValueList from a global field that contains a set of data separated by a carriage return. The reason is that I have a CSV Text values with carriage returns on the global field, I want the user to specify which line item he wants from the CSV Text field. The long way is to dump CSV data file into a table and then create it throug the Value List. Is there a shorter way, where I can directly populate the ValueList without creating a table. I know you can extract the ValueList through the function ValueListItems, but i want to do the opposite, to push the data into the ValueList. Thanks for any help...

I'm using a radio button to select record from one or more matching records from a related table. So far, simple. Now, when I mass import data from CSV or merge format, and visit the record for the first time, none of the radio button is selected. I want FM to pick the first button (or it doesn't really matter which) and just go ahead until I change the selection manually. The thing is that I use this radio button to select which related file to display on the browser. This part is used just for the display/browser functionality and it doesn't affect the value of the stored data in the table. I'd rather see one file displayed automatically than having to choose one b…

Am trying to plan database and would like input as to best method to create the following: I want to apply category(s) to a record. (its a table listing schools and there are numerous categories they can be a member of such as elementary, middle, high school, reserve, and other properties). There may be up to 10 categories (or types/descriptions/properties may be a better word) that applies to that one school. What is the best way to structure this? In playing with this, a checkbox with defined value lists works on the interface level, but I think it may be problematic in reporting/sorting/filtering by those attributes. I have this need multiple times …

Say I have a database which was used to control the stock of pets in a pet shop Animals_table has field "Animal_type" which can be Dog, Cat or Goldfish. Then it has "Animal_breed" which would contain a specific breed. Dogs_table contains one record per dog in the pet shop. I want to include a pop-up field of Dog breeds, based on the beeds available in "Animals_table". It's obviously trivial to create value list which contains the breeds of all dogs, cats and goldfish, but how do I filter this value list so that it only contains dog breeds? --Jim

Hello Everyone, I am currently trying to add a set of pop-up menus that allow for us to select what we want for a certain record. I am trying to format the menus as follow. Pop-menu 1) working, not working, in school etc. I want menu 2) based on the selection of menu 1 to give me a related list. Menu 3) needs to be populated based on menu 2 menu 4) needs to be populated based on menu 3 Does anyone know the best method of doing this? I know i have to use conditional value list but I am not sure as to what ways to approach it. Can anyone help me with this?

Hello Everyone, I-m brand new here, so excuse my question if is not appropriate, but I really need help... I have my database of contacts, and I want to give then a value (silver or gold), and I need to open a new tab where I can see only silver and another tab where I can see only gold. How can I do that? I already created a radio button with silver and gold, but I don't how to proceed.... Please Help... Thank you to everyone

Hi all, I am not a database programmer, but I am a computer person in general. I am working on building a simple (at least I think so) estimating database for my construction company. Basically, I want to keep an Inventory list of frequently used building components that also has a price for each item. This part is easy and I think I have that table and form nailed. Then want to build an Estimate Form where I can can categorize the various parts of a job with a static heading. Under the heading, I would have Drop Downs that I can select my items from, enter in a quantity and have the Estimate Form calculate all the final price. I would also like to hav…

Hi all, In my student database I have a checkbox field which identifies students with a disability. I have added a button next to the checkbox which users can click to take them to another layout which provides extensive info. re: the disability. Question: From a design perspective, it looks confusing (and ugly) having both a checkbox and then a button next to it. What options do I have in making this design more user-friendly? Is there an option where the checkbox and button are one and the same?

I have a dropdown list with a value list from another table. If I type fast I can type several characters for choosing a value. But if i type slowly it jumps up and down for the first character only. Sorry little hard to explain, but can I change anywhere so I can type slower?

Thanks... Now that that working I have one difficult question related to topic but a spin off. I want to be able to select items from the imported list but limit what can be picked from based on what customer name shows up in another field. So If I selected Jim Bob as a customer from an existing drop down (Fields from customer table. In the roll selection field drop down I only want the rolls starting with CF to appear in drop down list that was pulled from the excel file. roll_id qty_avail CF1001 1000ft CB1002 1000ft MF1001 1000ft MB1002 1000ft

I have earlier done some Access programs but are now a happy Mac user. I have done a nice application but have one problem, so I made a new databse just to describe the problem. I have one table called "street" and it carries a street register with the postal number and address. In my other table "delivery" adress I will add streeets from table "street" and if they are there it will add the postal number & adress automatically. You should be able to write a new address if it is not found and change the postal number and address if you want. My example works except that if I choose the street "Andersson Street" and selct the secon Andersson street wi…

Hi Fellows, It is possible to use differents value lists relationed? For example: Two Fields - Category and Group: Category: First Value List Group: Value List related to the first value list(Category) Example: Category: (Value List of 3 items) Finance Marketing Sales If Category is "Finance" The value list to field Group is accounts If Category is "Marketing" The value list to field Group is Promotions It is possible? Thanks in advanced, Andre Luiz From Brazil

Hi All- I have a database of films for my company. We're creating digital assets for each film, and I'm tracking those. I'm also tracking the various platforms these assets will go to. To this end, I have a table for films, a table for assets and a table for platforms (among many other tables for other functions). I have a dynamic value list based on the platform name field that generates a list of all platforms. Users use this list on the asset table to specify which platform a particular version of an asset is for (via a portal). However, some films will not be available on some platforms. I have a checkbox in the films table where users can check off which platfor…

Sorry to bother with my neophyte questions... Several years ago, I developed a fairly extensive database on another platform. It handled value lists mainly through a lookup table. One could add multiple fields through queries and set the data source field independent from the list displayed value. This technique became handy for saving abbreviations and displaying descriptive text in forms and reports. The query would form the basis for the drop-list; and the drop-down control would have its source value set to the appropriate column. The simplest explanation relates to a State lookup table. StateID => CA StateName => California The drop down …

I'm creating a database for a company which fixes computers. Whenever a customer comes into the company's shop, a record is added to a "session" table. This record includes a customer ID, computer ID, the time the session started, and the time it finishes (left blank until the session finishes, obviously). I have another table called "session events". This table contains one record for every event that happens during the session: for example, "replaced motherboard", "installed filemaker" etc. "session events" is linked to "session" via a session ID number, which is a serial number generated when a new session is created in "session". I want to create a cond…

Hi everyone, I'm having trouble using Value Lists when a relationship between two tables is by UID, but I want the the Value List to be populated by a non UID. I have two main tables: (1) Users - each user has a pk_UserID field (permanent) - each user has a Fullname field (which can be edited later on for spelling etc.) (2) Jobs - each job has a pk_JobID - a job can involve multiple contacts (not sure if this is relevant in presenting my issue) In my Job layout, there is a portal to a different table where it creates a new record joining the Job with a User. (fk_UserID, f_Fullname, and fk_JobID) I I want to be able to select the…

I have looked at a few sample files uploaded in some previous threads, but still am a little confused about what mistake I am making with my file. I have three tables, with the following fields: Customers Job Id Name Material Items Material Category Material Description Material Price Job Id Material Pricing Material Category Material Description Material Price Material Pricing is set-up with each of the categories, items and prices for our list of possible supplies. I have a portal in the Customers layout for Material Items. I have it set-up so that the Material Items & Material Pricing are joined by a Material Des…

I have set up checkboxes and value lists to populate my database in which I have many-to-many relationships with multiple choices for each field. e.g. -- I have a table with PROGRAMS and a table with FORMULAS Each PROGRAM can have multiple FORMULAS S so I set up a checkbox using a value list from FORMULAS... Now I have each PROGRAM with several FORMULAS listed. Now I also have a table with BOTANICALS Each FORMULA can have multiple BOTANICALS so I set up a checkbox using a value list from BOTANICALS... Now I have each FORMULA with several BOTANICALS listed. But then Each BOTANICAL can have several THERAPEUTIC USES, and I need to link e…

A picture is worth more then a thousand words Direct-link: http://img443.imageshack.us/img443/9283/listdatabasege1.jpg What would be the easiest way to achieve this? Please be very specific, I started using Filemaker yesterday... my filemaker-knowledge is seriously lacking. Any help is appreciated

I really hope I haven't missed something in my searches, but I have been unable to make this work. I have 2 tables, components and computers. In my components table, I input all the info about each part of the computer. Now I want to create a list for each part of the computer, (motherboard, processor, RAM, etc) that pulls data from the components table, but filters the results to the corresponding field. I am not sure what I need to do to get this function to work. Thanks in advance. Jason

We are working on developing a tour guide database for our student workers that will track information about each tour, tour guide, and the tours they gave. The problem or request that I am trying to work through is that when creating an assignment to a tour, they only want the value list to display those tour guides who are currently active for the term. Their activity can and will change throughout the course of the year and the relationship needs to be dynamic while also not losing the tour history feature for each tour guide. I am continuing to research how to adapt a conditional value list to work in my scenario, but any help would be greatly appreciated. I am at…

Hi, If I have a 3-tiered conditional value list, how do I prevent users from selecting invalid combinations (or how do I prevent them from being displayed in the first place)? Example: in a state-county-city hierarchy, the user selects the state, and the counties field (drop down) only shows counties in that state, then the city field only shows cities in the county selected. I think I have the relationships right, because my drop down lists are showing the appropriate choices. However, if I select a state and county, then change the state, the county selected remains (an invalid combination, like state=New York and county=Orange). Can someone suggest a s…

Hey all, I have two tables, a "sponsor" table and an "events" table. The "sponsor" table holds info specific to the sponsor. Each sponsor can sponsor ONE event. The event that is sponsored is held in a field within the "sponsor" table called "sponsored event", there is also an "event id" field that I want to hold the ID # of the event for a stable relationship between the two tables, as creating a relationship on names isn't totally reliable. The "events" table holds all info specific to the event. This includes a field called "ID" which is a unique number for each event, and a field called "event name" to hold the english name of the event. As well a fiel…

i have created a drop-down list with the first field hidden and the second shown. the hidden field is a key. id and label. (using it like an array) the drop-down is for a field of a child table of that sits on the parent layout in a portal. the drop-down value list is not related to the parent or child record. in a script I need to get the second field based on the first field. i looked at getnthrecord, but I need to get by key not record number. anyone have any ideas? thanks

Forgive me if this is answered elsewhere but I've searched for a few days and been unable to find it on the forum. I'm a beginner. My wife and I own a shop selling wedding dresses, bridesmaids' dresses, etc. I'm creating a database containing tables for stock items, customer details, invoices, and lines (individual items sold which will then be shown on an invoice). I also have a table called "make_item" with two fields; the designer name and the item that designer makes. Some designers make more than one type of thing. For example, Mori Lee makes both bridal gowns and bridesmaids' dresses. The "line" table has fields for "make" "item" "style" "colour" and other…

I am new to this forum and have not developed anything in FMP for a number of years. I have started an ambitious project. I started an "Issues Tracking" project to build aworking prototype tracking / reporting system and get the users away from using Excel. I started with a FMPro Template. We have an internal IT app that tracks projects. This system can export the data to a xls file. I have created a QA Main db that maps these fields so I can import the xls file. There are 3 situations in the daily export: (1) dates changed in some records (there are 3 different dates for projects status: DatePushedtoQA, DateQAComplete, DateUATComplete), (2) records h…

Is it possible to use a drop down to select a job number and be able to auto populate fields based off that job number that have been entered in another table? What would the formula(s) look like if its possible

I have a Parent (Party: includes Contacts & Companies) to Child Portal relationship (Companies only) to Grandchild portal relationship(Shareholders: Contacts & Companies from Parent). I have a button on my grandchild portal that I want to perform a script to return me to the related record in the Parent. Does anyone have a suggestion on how to write such a script? Thanks in advance for any assistance.

I want to make a value list display values based on what another field says. What I have is a field to describe what role a person plays on a Production i.e. "Contractor, Talent, Interview Subject". If the user selects Contractor, I want the next field to list "Producer, Director...", but if they select "Talent", I want that next field to list "Voice, Actor, Musician...". Can this be done? Thanks in advance for your guidance.

Hi, I have a field where the user currently enters a product code into a text box, made up of 4 letters, and then 3 numbers. I need the 3 number part to be automatically generated. How can i do this? I haven't written a script before, but can easily learn as i have a good knowledge of programming functions in other applications. Or maybe it is a simple text control. Thanks in advance.

Value lists have the option of being populated with values from specific fields. Is there a way to allow the value list to consist of values from more than one field? Can these fields be in different tables?

I want to recreate a "Pop Up" Value List with people who are marked as donors. Currently, I'm getting all people, regardless if their "donor" field is set to "Yes." How can I get a value list with only people who are also marked as "donors?"

Hi all, Is it possible to use a drop down menu using a value list within a Custom Dialog box? Using FM9. Many thanks Ed

Is there a quick way to import (move, copy) value lists from one database to another?

i made a global field that shows a value list ( Pop-up menu ) from another field in the same table, then i need to get number of selected items in this pop-up menu & aslo i need to get the selected items thanks for r time

Not sure if or how to do this but here is what I would like to do. I have built an event planning database. I need to add flights to events. I also need to assign passengers from my personnel table to each flight. What I would like to do is add a flight and assign it to an event. after that I want to be able to select what passengers will be on that flight have my value list only show personnel from the event that this flight is assigned to. Hope that makes sense. Thanks for the help.

Hello, I am trying to understand how to use a checkbox field in a portal to make a selection. Here are the details: Music: - Music ID - Type (checkbox with defined value list) - Song Title Themes - Theme ID - Music Type (drop down with same value list as Music:Type) ThemeMusic - Music ID - Theme ID In Themes I have a portal (ThemeMusic) used to select which songs to use. I can get the portal to do this fine, but I want to limit the list of songs available to those that have been checked the same as the chosen Music Type. I know how to limit the records in the portal field if the original field (Music:Type in this case) can onl…

Let me start by saying I'm truly a newbie, in all senses of the word. Don't let me fool you with my fancy talk, I KNOW NOT OF WHAT I SPEAK. That being said, here's what I'm trying to do... In my contacts database file, I have a check box field called "shows" which is a value list of 8 different tradeshows that each client or contact attends. Each client may attend 0-8 of these shows, and the list may be adding new shows in the future. Here's where it gets complicated. Each show is done 1-5 times a year, and should also be listed by month - each show has it's own schedule, so there should be a related but separate field titled "month", which would be conditional. …

I am working on an application for garments and I want to use a drop down list in the user interface for garment sizes. My problem is mostly aesthetic in that I cannot figure out a way to sort the sizes into the logical order they come in. I need to use related records because the sizes vary depending on the garment, so using custom values doesn't work, though in my example I use one to show what I am hoping to accomplish. Any ideas ? Size_Example.fp7.zip

I have a repeated field with text content. Each entry may be multiple lines, having a 'paragraph'or enter/return character in the text string. I would like to use the repeated fields in a value list, but when I do, the values offered in the drop down list are not the field values, but each of the individual lines from the field values. E.g., Repeated field 1: Line1 Line2 Repeated field 2: Line3 Line4 if I define a Value List for the repeated field, it shows 4 choices in the drop down list: Line1 Line2 Line3 Line4 when what I want are 2 values: Line1/Line2 Li…

Is it possible to have multiple value lists for the same filed based on another fields data? For instance if Field A = Yes than I want the drop-down in Field B to be ValueList#1. If Field A = No than I want drop-down ValueList#2.

Greetings - I am working on an job quote system. The tables are Clients - fields - the usual stuff Quotes - fields - totals, address of job, etc QuoteDetails - fields - Quantity Manufacturer Part# Cost etc Items - Database of the items in the QuoteDetails - Manu. Part# etc. So far things are working well. I have a layout with my quote and a portal for QuoteDetail. QuoteDetail includes fields for Manufacturer, Part# and Description with are data contained in the Items table. What I'd like to do is this: I create a new line in the portal and enter a Manufacturer so when I go to the Part# field a popup or pulldown appears with only the Part#'s as…

I have spent some time trying to find this… hoping someone could help. Is there a way to get a list of all current Account Names for a database. I want to then use this to populate a value list. I have done this before for layout names, table names etc. but can not seem to figure out Account Names??

Is there an elegant way to count the number of different values for a field in a found set? I can think of using a calculation field that has the field value if in the found set, empty if not. Then defining a value list for that calc field and counting the items with a values function. But that seems rather cumbersome. TIA

Hello all, Sorry to bother you all once again with my neophyte questions, but I have another... In my database, most of my tables are related... There are a couple, however, that I have left unrelated, since they need to be related to multiple tables (and FM tells me it cant do that and needs to add another copy of the table or some such)... Basically, here's all I want to do... The tables are, for instance, lookup_states and lookup_countries... These tables look like this: lookup_states ------------- id (auto generated, serial number) state_name (text) state_abbreviation (text) lookup_countries ---------------- id (auto gener…

I run a tradeshow company and have written a couple of separate databases to track our business. Currently I have a main database that tracks all of our events and the exhibitors who will be attending those events. I have a separate freight database that we use in the warehouse to track their inbound shipments to us. To expedite the data entry for the freight database, I use a filtered value list setup so that they can pick the name of the show and then have access to a second drop down that shows the list of exhibitors filtered by the show name. Currently I export the customer list from our upcoming shows and manually add it to the freight database and then delete …

Can you have a pull-down menu in a repeating field?

Hi I'm currently trying to get the hang of FM. I am stuck on lookup lists. I have googled myself silly trying to resolve this as I am sure I am missing something very simple I want to use a drop down list to present a list of values from a 'lookup table' and have the selected value put into the main table. ie Main table is a list of properties in a property portfolio, it has the following fields... PropertyID PropertyAddress PurchasePrice etc.. [color:red]fk_CurrentStatus The Lookup table has the fields.. StatusID StatusTypeName StatusTypeName contains for example... 'Under Offer' 'Awaiting Mortgage Offer' 'Owned' etc. On a layout …

I need to auto check a 2008 Holiday Card check box based on a found set. I also don't want to update any in the found set which may already have this box checked. I've tried to use a loop with set field where the calculated value equals the current field & "2008 Holiday Cards" however this isn't working and I'm worried it may add the value to records that are already checked. Any ideas? Thanks

Hello, I've got a self-joining table in which each record can have a parent record and multiple child records within the same table, like so: (people) client vendor employee (artist) (performer) studio_artist actor (dancer) musician ballet jazz hip_hop modern belly (values in parentheses are parent records to the subset below) I'd like to be able to create value lists using this hierarchy, i.e. a performer list which gave me a choice between actor, dancer, and musician, and which in turn let me choose one of the types of dancer. Because of the directions in which my company is expanding, I need for end users to be able to create these value lis…

Task / Call Log Report List. I've created drop-down value lists for filtering purposes. So far so good. For now it will show records by the choice made which is great. Wondering if extending the found set through the drop-down field choice is possible. ( maybe with a modifyer key? ) Is there a way to allow a second choice (thrid or foruth etc.)either in the same drop-down value list or another to the displayed records. Also, is it possible for a value list to find empty records? Regads, Mike.

Hello, I am trying to do something wich is kinda complicated to me since I am a recently FM user. What I've to is something like this: _____________________________________________ Field 0 | Field 1 | Field 2 | Field 3 | September | 20€ | description | checkbox | November | 30€ | " | checkbox | _____________________________________________| --- Total = ? How can I sum the values on Field 1 so it would give me the result on Total field. The values on field 1 are already there , they are always the same, but they only Sum when I click on the checkbox. Can anyone help me! Thanks and sorry for my bad english. …

FMP 9.01 - I've been using a value list which showed a set of customer names from the name field in another file. I wanted to filter the list, so I changed the list to look via a relationship from a global field to a text field in the second file. This works, although the list takes much longet to appear. We run this in a mixed network of PCs and Macs on a peer to peer system, with a dedicated 'server' Mac running FMP9. The real problem is that typeahead on this filtered list no longer works on the PCs, although it works fine on the Mac - albeit much slower. Any suggestions of why this is happening - is this a Filemaker bug? TIA Brian

I use an FMP 7 database to control circulation for a trade magazine. For each subscriber record, I keep track of whether they're a buyer or seller. I do this with a "Subscriber Type" field, with a radio button value list displaying the values "Buyer" and "Seller". I want to set up a layout that will automatically tally the numbers of each value for a monthly circulation report. I've tried some of the Summary functions, but they'll only give me a summary for one value at a time. How do I set up a summary that will give me the individual totals for each value in the list? Thanks, Brian

I would like to be able to provide an interface for users to be able to select multiple items from a value list and have it create a new record per item selected. Check boxes or radio buttons would look the best. I know this could be done with a multi-value field, but I would prefer to have one item per record. The image is what I am trying to achieve. Is this the impossible? Any advice would be greatly appreciated.

I've created a new relational database using FM6. I've got portals to access the individual databases and they are working well. I have two issues when I access the database through the builtin web server. 1. When I go to the main database, I want the newest record to display in the form view. I can't figure out where to change this. 2. I have lookups for values in one of the fields for one of the related databases. Everything works great in the FM client but when using the web interface the lookup doesn't work. Is there a way to make it work? Thanks for your help. Brad

Is there a way to trigger a script in FMP 8 by exiting a field? I have a drop down list displaying values from a field, from which I make a selection which gets pasted into a Display field. Problem is I need to Set Field [Display field; '" "] first to get rid of any old info in it. If I put the script button in the value display field, then the drop down doesn't work. Any ideas?

Umm... I have database for projects that I have done and will do. I did create drop-down menu for project styles. That list works fine yes I can choose what I want from drop-down menu, but I can also write what I want in there. Idea is that there is drop-down menu that contains several values example music, movie, etc. But you cannot write anything own into it. that is idea, but for some reason I cannot prevent user to write his own values in there and add that information into my database. Can someone help me to fix this up. Thank you... (I know there is lot of text that doesn't matter in this case, but I just feel like writing it there…

When i duplicate a record it will not duplicate a field with a Menu Popup. Is there a way it copies all fields? I failed to mention one of the Popup Menue Fields is a second field value, the first field is a Serial number. T

I'd like to build a value list that is based on fields containing dates. If the date in the field is a date in the future I want it in my value list. If the date is in the past I do not want it in my value list. What are the possible solutions?

Hi everyone, I posted a similar question earlier, the response I got contained good recommendations but I do not understand most of it, so I thought I would repost. My problem is common, simple to many I'm sure, but try as I may - I couldn't figure it out. I have a drop-down list with values, I want these values to auto-fill at least five fields with various records through look-up. : Main table = "Employees" Field 1 = "OCCCode" (OCCCode is a drop-down list with values) Value List = "OCCCode" Field 2 = "JOB TITLES" (Job Titles contain records) Field 3 = "STATE" (Is another drop down list. I want "STATE" to show related re…

Hi folks. I'm stumped, and could use your help. Sorry if it's a dumb question, but... how can I make scripts and calculations use the various separate lines of data in a checkbox field? I've got 3 big Filemaker books, and none of them address how you can actually separate out the data from checkbox fields so you can use it. (maybe because it's so obvious, and I'm just missing it). Here's the context: I have patients, about whom I have to write reports. I have to write back to the doctor who referred the patient to me, and also send copies to other doctors who are involved in the patient's care. When composing the report, it seems an ideal situation to…