Value Lists

I am trying to create a pop-up value list to insert an employee ID into a field on an unrelated table (Mail Boxes), so the ID of the employee who opened the mail can be verified and stored. Problem is, employees are in the Contacts table, with all the other contacts. (I thought this would help reduce the number of layouts, fields, etc., especially when hiring an employee already in contacts.) When I make the value list use the fields from contacts, everything is fine, but I get a list of ALL contacts, not just employees. Everything I have done to try to reduce it down to just employees results in . Every contact has a field called Personnel, which contains …

I have one table (Instructors), related to 3 separate tables (Days_Available, Certifications, and Addresses) by a primary key. In a fifth table (Events), I need to be able to select and schedule Instructors based on information in the 3 related tables (Days_Available, Certifications, and Addresses). Ideally, I would like to see a filtered value list of Instructors that meet the pre-defined criteria of the event. In other words, choose from a list of Instructors that have specified they are available the day of the event, but also meet the event certification requirements, and live in the home state of the event. Step Two of this would be to make the Instructor …

Hi folks, New to Filemaker Pro but have successfully connected to our backend SQL2005 server and can read data directly etc. My problem is creating a find/script solution as far as i can make out from reading the forums. Within SQL, I have a database that contains multiple projects all with their own unique id so for example ProjectA = 1701 ProjectB = 1802 I normally file all projects under 2007 with the following projects i.e. Year 2007 ProjectA (Unique SQL ID = 1701) ProjectB (Unique SQL ID = 1702) ProjectC (Unique SQL ID = 1703) etc. Year 2008 ProjectA (Unique SQL ID = 1801) ProjectB (Unique SQL ID = 1802) ProjectC (Unique SQ…

Hi. I'm new to FM and have attempted a database to keep track of conversations, issues and incidents within out staff. What I am looking for is to have a hidden field named 'Final Notice' that will show within the employee's profile if they were placed on Final Notice. I have unique tables for the overall employee stats, issues, incidents and conversations all linked by the Employee ID field. Within the issues and incidents tables there is a drop down list of disciplinary action, ie verbal, written or final notices. I'm looking to have the hidden 'Final Notice' field within the employees table show text (Is on Final Notice, YES or what have you)…

Hi, i can't figure it out how to make a dropdown list depending from the selection of another drop down list. Here is the detail: Drop Downlist named (BRANDS) Shows: AUDI, BMW, ACURA, ETC If i select BMW in the other Drop Down List (SUBBRANDS) needs to show only the SubBrands from the selected: BMW (selection)Drop Down List (Brand) SHOWS Drop Down List (Sub Brand) Serie 1 Serie 2 Serie 3 X3 X5 Thanks Gian

I have a checkbox set. On a report I would like to display the results of the field from the checkbox in a single row with each value separated by a comma (or anything, really). Filemaker automatically places the next value on a new line. Thanks in advance, Marc

I dont remember how I fixed this before. I have a list of products. I pick each color type for the products. SO, 1 shirt might only have 2 colors available. When entering a sales order I want to type in the product id and in the next field show a list of only the AVAILBLE colors. It seems like it would be simple but I cant seem to figure it out today...

Hello, I am trying to create a cost estimator. I have created 3 tables that are as follows: Company, item Category and Item Sub Category. The "category" table is linked to "company" and the "Sub Category" table is linked to the "category" table. Now in my 4th Table "Cost Estimator" I created 3 conditional drop-down menus that depending on what the user choses from the first and second one shows different results. So lets say the user choses company A it shows Category A, B and C but if the user choses Company B the Category shows D, E and F. The relationships are as follows: table 1 "Cost Estimator" has a field called "company" as a unique value and is connect…

Hi there, I have a value list that has about 10,000 values. It takes forever to load the first time it's used, but after that, it is very quick. Is there someway I can preload the values into memory in a way that is not disturbing/slow to the user ?

Hi, How can we get a specific value based on the data that user inputed? user enter U_SIZE(global) ____ " System will show the UNIT_PRIZE(based on the data) $_____ Price cart - If size: <25" = $25 <30" = $35 <45" = $45 This price cart is a database in filemaker. variables: SIZE, PRICE If user entered 19", the price will show up as $25 If user entered 26", the price will show up as $35 Thanks in advance, Zu

I've got a very simple fairly-standard Contact Database with two tables, Company & ContactName. The two tables are related through CompanyID and unlimited persons can be added to a company. I have a third file/table (let's call that "Invoices") that "pulls" information from the ContactDatabase via drop-downs and lookups. First, in the "Invoices" table I use a value list of all company names from the contact database. After the selection occurs, (1) I use a "lookup" field to copy over the CompanyID into the Invoice table and then create a relationship with this ID field and the CompanyID field in the ContactDatabase (just it case the company name changes in…

Hi there, I'm completely new to Filemaker so please bear with me. I have a database (roughly based on the email campaign manager template) in fp9, with related tables. In contacts I add my contact details and in groups I can enter all the groups that individuals can be members of. In Groups I can then add members of each group which is great but I would like to be able to add the members to a group from the contact layout not the groups layout. I added a checkbox set on the contacts layout which takes the group names from a value list, all the names appear and I can select them but my problem is that this assigns new groups for each member rather than assi…

I have a value list that is actually a checkbox set. As a new case is created, the number populates this field. It is great since they just click a box and it is referenced to the case. But here is my problem... What do I do when the list exceeds 100 cases? The checkbox does not allow for a scrollbar to accommodate the large and growing set of cases.

Hi. I can't find out how to do this, but I have a value list that is used in a Drop Down menu. The value list is populated by a "Name" field. So, every Name from every record is in the Value List and Drop Down menu. What I want is to have the Drop Down Menu display only the Names from the current found set of records, instead of all records all the time. Is this possible, and if so how is it done? Thanks for any help.

Can I make a "dynamic" value list? I'm building a solution that tracks a trader's transactions and which 'suggests' the size of the next trade based on various risk thresholds. Would it possible to translate that 'suggestion' (the result of a simple calculation) into a "capped" value list that actually leaves out any values that are greater than the suggestion? Real world example: Trade A: Risk represents 50% of risk threshold. Trade B: Remaining 50% of threshold translates to suggested trade size of '5x' Trade size value list available in record corresponding to Trade B runs in 0.1x increments up to (but no greater than) 5x, so trader cannot actually l…

Hi - i would like to ask please i have a drop down list field with repetition, how can i get a summary which shows only the fields that are filled in. ex i have 5 repetitions of this field if a record has the 5 filled and another has only 3 filled how can i get a summary of the 8 filled fields rather than showing me the 10 of which 2 are empty? THanks for your help!

Hi, I have a value list of multiple publication titles. When a publication is sent out, I would like to select that publication's title from the value list and apply it to all records (recipients), rather than manually going to each record and selecting the value list's publication title in the field. Is there a way to "apply" a value list selection from one record to all records? Thanks. -Seattleflo

Hi, I am wondering if there's a way to format or script a selected checkbox set to display horizontally instead of vertically? Thanks!

Hi I am not sure if this would be the right area of teh forum to ask this question but honestly I didnt know what section to start in. My question is this: I have a simple database that i built to keep track of an inventory. For the last year I am the only person who has entered any stock into this database. Now I will be training someone else to enter stock into the database. What I would like to do is when this person enters a record into teh database, that a field will be auto filled showing which account last edited the field and/or entered the record. I have looked and I dont see where I would do this at. Any help would be greatly appreciated.

Gaaah.... I got myself into a tizzy over what I now know as the "sticky text" issue in popups vs drop down lists. See: http://my.advisor.com/doc/18168 for a perfect explanation. The thing is, I really prefer the UI (keyboard wise) of the drop down. Is there any hope to getting sticky text with drop down behavior? Thanks! -Jeff

Within my layout 'Job sheet' I have a value list of: -In Production -Dispatched -Invoiced They are displayed as radio buttons What Im after is that when a new job sheet is created or committed the radio button 'In production' is activated straight away. Is this possible?? Any help is much appreciated

I have setup a SQL Database on my server and I have an ODBC connection to it. I can make forms and manipulate data with no problem. My issue is, when I try to make a value list from fields that are on the SQL Database, all the tables are grayed out. WTF? If I create a new table in my Filemaker Application, it shows up as ready to use for a value list. Is this one thing that Filemaker cannot do with SQL Server yet?

I need some pointers. My shop sells gelato. There are 80 possible flavours. I am creating a db which tracks production and inventory. I created a list with all flavours, and then every day the worker can check the flavours they produce. I have a field which then counts total number created, time taken etc. But I also want two more things. I want to generate a report at the end of the week, of the number of each flavour created. And, I also want to track inventory levels of each flavour, preferable displayed in a table so the worker coming on can at a glance see what is left of what flavour and what needs to be made. So, is there some decent way to convert my simple …

Hi there. I am very new to filemaker, making the move from Access. I have a very simple question. I have a field with a value list and I want to have a default value that automatically populates the field unless another option is selected. I am sure this is very easy but just floundering a bit with new software. John

I have a drop down list with a few items in it. How do I make it so that users can only use the drop down list and not type in data? Mark

Hi I have a selector field that is not in the tab order and I made it un-enterable as well. I named the field object "SelectorField". The field is a button that basically ends in a go to object script step that sends the user to the SelectorField object. Problem is it doesn't open the value list, it just puts a black border around the field. Anyone know how to make the value list pop open? I don't want to use go to field because I want to use this script on many screens. (when is Filemaker going to give us go to field name by calculation!!!:)

I apologize in advance if this is a trivial question, but I can't figure it out and I've read all the other threads on the topic; I'm hoping someone can tell me what I'm doing wrong. I have a small database that's used by a healthcare provider to keep track of clients and treatments. It contains two main tables: "Client Info" and "Treatments". On the main layout for "Treatments", there is a drop-down menu that allows the user to select a client that the treatment relates to. This works pretty well, except that there are several hundred clients in the "Client Info" table and only 30-40 are active. We want to limit the contents of the drop-down list to only active cli…

I am not sure if this can be done or not, and I didn't see anything after searching for a topic on it, so I thought I'd ask! Is it possible to have a selection on value list, after selecting it (there are only 3) then navigate you to a particular field on the layout? I would want to keep the selection in the value list, but afterwards, jump to a different field. I've tried this with success using a scripted button next to the value list, but wondered if would work in one step. Any help is appreciated, thanks! Karen

I have a main table called Service I have a related table called Containers There is a value list in Service to choose a container for the service call. There are 2 fields within the containers table which the service value field relates to. 1) Container type ( A or B ) 2) Available, which is a calculated field. I only want containers of a particular type and that are available to show up in the value list. I'm at a loss as to how to go about doing this. Filemaker seems to let me use related values for the first field, but will only show values from the second field, which doesn't cut it, because it still shows unavailable containers on the popup…

I have a value list where I have about 10 different options to choose from. For example, there might be SALE, RESET, DEMO, etc.... I would like to be able to display on a report page how many SALE, how many RESET and how many DEMO have occurred. Any ideas on how to accomplish this?

The content of the value lists are field based. I have 3 vl in the same database, all of which behave similarly, namely I can see only the first 200 items of the list. Can anyone tell me why this happens? Thank you.

I have three files, one main file and two sub files (company A, company . The two sub files contain company name and position lists for each. In the main file I want to do the following: if I choose company A from a pop-up menu then I want to see the position list of that company, otherwise if I choose company B, I want to see the postion list of that company. How can I do this...any ideas? If this seems unclear, then go to "www.cars.com". What I want to do is similar. If you choose Chevrolet in the "Make" pop-up menu, then you get only the Chevrolet models in the "Model" Pop-up menu. If you choose "BMW", you only get BMW models in the "Model" pop-up list.

I have three files, one main file and two sub files (company A, company . The two sub files contain company name and position lists for each. In the main file I want to do the following: if I choose company A from a pop-up menu then I want to see the position list of that company, otherwise if I choose company B, I want to see the postion list of that company. How can I do this...any ideas? If this seems unclear, then go to "www.cars.com". What I want to do is similar. If you choose Chevrolet in the "Make" pop-up menu, then you get only the Chevrolet models in the "Model" Pop-up menu. If you choose "BMW", you only get BMW models in the "Model" pop-up list.

I am using tables to create my value list. When I put in a new value in the list in a particular order. When I pull down the list it sorted the list and takes them out of order. I then added a field to group them in a particular order but it will show in the pull down if I sort them by the group. Is there a work around. Thanks in advance.

I have a Products table (Key - Product ID), a Product Attributes table (Keys - Product ID, Attribute ID) and an Attributes table (Keys - Attribute ID, Attribute Group ID). My first Table Occurence from the Products table to the Attributes table goes via the Product Attribute table. I have created a new Table Occurence using the relationship from Products Field 1 (calculation field - number) to the Attribute Group ID (number field) in the Attributes table in order to get "filtered" records (e.g. those available based on this Table Occurence)and want to attach a value list to Products Field 2 (number field). I have defined the Value List to use values from th…

Hi, I have got customers where each customer can have many divisions and in each divsion customer can have many contacts. I have attached the zip file for the purpose. When the application is run you will be able to see 2 customer records. My problem is when i click on Add New contact it displays the contact layout but in the division drop down it does not show the divisions for that particular customer. Even if i select the Division it does not display the name of the division in the text box. Could anyone can have a look and point me in right direction. I desperately need to get this sorted out. Thanking you in advance. Mitesh Jackie…

I think I'm over thinking things here. So I need help. In tableA that has 2 fields Name, Status In tableB, I have 2 fields. The first field has a value list that shows ALL TableA:Name. I want the 2nd field to show TableA:Name where Status = "Active" How do I do that? Thanks in Advance.

Hello! My boss wants me to create a new form in Filemaker but I’ve never used it before. I have spent the last couple days researching Filemaker but I have not been able to figure it out a solution that does what he wants. I have been able to figure out how relationships and value lists work but not how to populate a new value list from several items in the same field and display each with its own radial button. Let’s say that I have a Table called Cameras. Inside that table I have a field named Stock. That field has all the possible tape stock for that particular camera like: Camera: Sony Blah Stock: Tape1, Tape2, Tape3 Camera: Panasonic Bla…

I'm creating a script that will send an email getting data from a particular record. As the primary user for this uses Thunderbird, I'm doing this with a open url mailto: script. There are a couple instances where I am trying to insert data from a checkbox set, however instead of there being a carriage return at the end of each option, it just runs them together. For example Option1Option2Option3 Instead of Option1 Option2 Option3 It works fine if I use the regular send mail function, but I can't get it working with the open url function. Thanks! Matt

Can someone explain this procedure to me. I always use lookups. This is the post number Post#268523 I don't understand how the fields are stacked and what scripts are used to make this happen. When you click in the client field to add a new record the field arrow appears and it will not in any attempt I make. I copied and pasted the fields and it still would not do what the client field would do Can someone explain this step by step? Thanks in advance

I have two tables, table A with a one to many relationship to table B. Table B has 3 fields per record that describe the item. One field is "Category", the second field is "SubCategory1" and the third field is "SubCategory2". In a layout for Table A I want to build a series of 3 value lists that drill down to the item in table B and report in a portal. The top level value list would populate with the Category data, the second level value list would then populate with filtered data based on the category data. The third value list would populate with filtered data based on the subcategory1 value and thereby showing me the records in a portal that meet all these criteria…

Its hard to explain without a visual so I included the beginnings of my db. I am working on the LAYOUT 4 I have a food table and the items are put into categories. On the Form, I want to choose 1 item from my category drop down, then only show the food items in that category.... any suggestions or can someone show me how they would do this?

Hello, I've created a dependent value list. I've toggled the "include other item" option. When I include a new item it doesn't add itself to the value list. I've tried a dozen things, but can't get it to work. Can somebody help me please? thanks

Hi, I'm a newbie and just beginning to learn about scripting in FM. I have about 63 fields that I would like to use a value list to pull up, so that we don't need to scroll through them all to find the one we need. Basically, would like one field that contains the value list, and the one next to it would then populate with the field requested. Are there any suggestions?

Hi, I'm not an experienced developper, but I understand the logic of filemaker. I don't know if Filemaker can do this. I made some search and did'nt find any exemple about this criteria. I think that's a conditional Value list but not sure. I have a drop down list with several item to choose. If I choose one item, I would like to have a second drop down list of this item. Ex:. 1st --------------- 2nd drop down ------- Drop Down =============================== car ---------> Ford; GMC; Chrysler moto --------> BMW; Yamaha; Honda boat --------> Bavaria; Tobago; Carter First I made a Portal row with a dropdown list of my item. I t…

Hello, I would like to create a drop down list that the user can use check boxes to select the multiple values that they want... this is similar to whatis available in Excel's Pivot table. For example if I have a list of employees and the user wants to review the work performed by 3 of the 16 employees I wish to offer the employee list so the user can select the 3 employees of interest. regards,

Is it possible in an upgrade script to import a user's customized value lists into the upgraded datafile? I appreciate whatever advice anyone can give me, thank you.

Hi, I have two fields that are filled in from a drop down list. Once the user selects from the first drop down, the next field needs to be populated from a drop down with the "child list" of the first field. If the first field is changed, then the second field must have values from the related "child list" eg. first field drop down list is: North South second field drop down list is based on the first field choice as follows: If first field north, drop down shows 1a 1b if first field south, drop down shows 2c 2d I have this working except for a validation on the second field. I need to validate that the second field is populated with …

I use a checkbox set to set the value of a field, 'x'. The value list for the checkbox is based upon another field's values. Let's say the other field's values are a,b,c, and d. The user has checked 'c'. Later the value list is different because the other field's values are now a,b,c, and e (d is no longer a field value and therefore no longer in the value list). The checkbox set is now a,b,c, and e. The user checks 'e'. The value of the field is now 'd,e'. The old value, 'd', that no longer exists is still part of the value of field 'x'. How do I get rid of the 'd' in the value of the field 'x'? If the field is displayed using the check box set, there is …

I am trying to create a complex report where the dates are going to be changing every week when it is generated. (First monday for 6 weeks past the report date) I have the two layouts created so the user enters the Report Date then a button takes them to the actual report, but I have calculated fields that are supposed to fill in those future 6 dates. I have those working, but now I would like to view them in a subsummary report. I read in the FileMaker Advisor of a "Value list of fields" feature, but it doesn't specify how I would create it. Any ideas? Thanks for any help I can get!!!

I would like to create 3 reports in [color:red]different language[color:red]s (German, French, English). They all display a date which I then format to display the name of the day and the date. However, since FM is getting he systems format (e.g. German) it displays it in German (e.g. Mittwoch, 21.Juli 2007). How can i get it to display it in all three languages (e.g. Wednesday, July 21 2007) each on a separate report ? Thanks for your help! Martin

I have a State and County table set up for value lists on another form that I want to change dependent on the Value selected in the State field (via drop-down list). What I mean is that I want the counties value list to change dependent on the State selected. Well that part was easy, I have a table with State and County that has all the counties defined by state and a relationship defined to the main "Projects" table by the "State" field. OK here is my confusion...if I create the Drop-down List using Values from Fields on the "State_County" table it will list everything regardless of State. If I define the Field in the form displaying data from the…

Howdy, all: I'm creating a run-time solution where a user will be printing a report that has four different fields in it. What I'd like to have users be able to do is select the sort order without having them manually set it up using the Sort Field command/script step. The four fields are: Cost_Category, Cost_Type, Date, and Record_Number. Ideally, there'd be a pop-up menu adjacent each field with each menu having a value list numbered 1, 2, 3 and 4. In practice, the user would choose the order of the sort based on the value list selections, click the report's script button, and away she goes. Obviously, there's gotta be a better way than scripting for 24 …

Hello, I’m very inexperienced with FileMaker and hopefully I can get some help here. I have 3 color families: - Blue - Yellow - Black The each color family has different shades. For example, for the Blue family: Lite Blue, Lite Aqua. For the Yellow family: Lite Yellow, Pale Lemon. For the Black family: Lite Charcoal, Grey. Each color family has a range of color numbers: - Yellow ranges from 2000 - 2999 - Blue ranges from 5000 - 5999 - Black ranges from 9000 - 9999 I have created 2 tables. The ColorData table and the ColorFamily table. ColorData has 3 fields: - Color Name - Color Family - Color Number ColorFamily lists a…

Ok I dont use FM that much so please be patient with me. Plus I'm in fm6. I have an inventory db that I'm working on I have main category , sub category 1 and subcategory 2. I have so many main categories and sub categories I put them into thier own files. But I'd like to have the user pick from a pop down for main category and then the sub category 1 and 2 only show sub category data based on what the main category is. example pick main category > cars then Subcategory 1 shows > Ford , Chevy , etc, then Subcategory 2 shows > sedan, truck, van, etc. if there's a resource to read Id be happy to read it or if theres another post what…

I have a value list showing me times. The initial value in the field where the value list is attached is already set. I want the use to, when they click the value list, have the starting value be the same as the value that is currently entered into the field. For example: The field currently contains the value "11:30AM". When the user clicks the field to enter new data, they see a value list of all available times for the day starting at 6:00AM with 6:00AM being selected. Is it possible to have 11:30AM selected so the user does not need to scroll?

he's got a list for boolean values, X and NO, and i want to turn a bunch of fields within the record to a single value, a checkbox, and was wondering if there was an easy way to: 1) check boxes off using a script? It's easy enough to go through any field in a record and do an if = insert text to get one box checked, but how do i check additional boxes without unchecking the first? 2) make check boxes show up without their preceeding item, for making a schedule with all the records in list form with one heading per check item and just the x in the body of the list? perhaps a similar trick to my first problem with a second list with as many blanks as there are checks…

Hi, I'm an Access user, trying to convert over to FM. I'm assuming this is an easy one, probably already covered, but wasn't sure. So, I have two value lists (combo boxes). I want to base one list on the other...showing the related items. In Access, this is done thru a "Lookup" command. The data all exists in one table, but I want to filter the results so as to not show every record, so a filtered list is the best as I can describe. Example: Table: Brand X, Product 1 (and on) Brand Y, Product 1 (and on) Brand Z, Product 1 (and on) Form/Layout List 1: Brand X, Brand Y, Brand Z List 2: Product 1, Product 2, Product 3 So essentially w…

I have a value list in my database with various choices and one of them being flower essence. I would like to know how I can insert two fields that would allow me to type in the type of essence ordered and the date it was ordered when I choose flower essence from my value list. Any help is greatly appreciated.

I'm about to create a value list for a dropdown. I know that I'll be adding to it. Will this work? How well will assigned values carry through if the list grows and if the order of items in the list changes? Anything I should do now to make the list more gracefully dynamic?

Hi Everyone, I'm new to Filemaker, and am a little stuck on a something. Can I create a script that will automatically discount a unit price by 50%, if the Customer is set to a certain value in a drop down list? Thanks in advance, R

Got it! HomeBasis23.zip

I have set up this test database to try to have a conditional value list of zip codes so that when I enter City I go to States and the choices are reduced only to those states where there are corresponding cities and then when I go to zip codes only those zip code(s) are a choice. I have played with this for hours and hours and this is the best I could do. It works, I think, but, I'm concerned with the relationships and how I have them set up. I have tried every possible relationship I could think of. The test DB only contains zip codes for NY, CA and FL. So here's my questions: Have I set it up correctly or is this an accident waiting to happen? When tab…

I'm kind of new to FM. I want to know if I can make a value list by calculation. For example a list of Purchase orders that is active or a list of parts from a specific supplier. Is this possible and how do I implement it. Thanks

I have a simple 'patient' table with the fields: ID_patient, last_name and first_name. I would like to have a popup that would show the concatenated first_name & last_name and when the selected, would show the associated record in the same layout as the popup and name fields. It seems like the popup function is designed to just allow replacement of a designated field by the selected content in the popup? Thanks :

I have a database of products which has a sub class identifier. I also have a bunch of safety warnings in value lists. What I would like to do is to have certain warnings from the lists activated based on it's sub class identifier. ie. subclass =210 value list 1= wear gloves active (rest inactive) value list 2= explosive rest inactive) value list 3 = do not use in confined spaces etc.rest inactive) I'm not sure how i should even start... Any help would be greatly appreaciated.

Please forgive me if this is a dumb question. I am merely the brightest bulb in a rather dark coalmine! Oh, and we only have FMP 5.5. I have a simple application and want to prompt a user with a value list that is a combination of two fields from two different files. Example File Rivers.fp5 contains field RiverID File Ponds.fp5 contains field PondID When the user is filling in a transaction record, there is a field "FROM" that I would like a drop down list that contains all of the RiverIDs from the Rivers file, PLUS all the PondIDs from the Ponds file. I have seen some similar posts in the forum, but none quite give me what I want …

1st post so be gentle : OK here we go. I have 2 tables. a) Assets : Computers The concept is that all hardware peripherals and internal computer components end up in the table Assets. A Computer record has an id identifying the computer and multiple fields as a) cpu motherboard c) HD Drive d) RAM slot 1 e) RAM slot 2 f) Printer attached The Assets table has data like: a) type (like motherboard, ram, HD, GFX card etc) title (like "ASUS A8NSLI") c) serial (the serial of the specific part available in the inventory) All Computer fields are foreign keys from the Assets table. I tried making a layout form that would …

Hello, I hope I can explain this correctly. I have two tables, one with client information (name/number/etc) the other is a job ticket table. What I'd like to do is have the user pick a clients name from a value list in the job ticket table (that's related to the client name field in the client info table) and have the rest of the clients information auto populate in their different fields. Currently I have the relationship set up correctly between the client name lists on each table, but I don't know where to start to be able to pick a client name and have it auto fill the remaining fields on the job ticket table. Would this be something I would have to sc…

I have a field (called class) using a pop-up menu that is selected from a filed in another table and only uses related values from another table. The related value shows a subject, e.g English. When the user clicks in class they only see the 10 or so records from the related table (which has 100 records) which are pertinent to English. My problem is that the user is likely to want to do a search in the class field. if they do this, the pop-up shows no values defined. I need to be able to do a find from the currently selected records rather than from the whole set with the contents of the subject field retained for the search. Has to be possible....no?

How can you display the value a user enters when they click 'Other' in a checkbox set?

I have a conditional value list (one value list is filtered based on another value list) and was wondering how to enforce that a user ONLY choose the values in the list? For instance, I have 3 Types General Graduate Special Admit Under General, there are a handful of choices that are different from the choices that are under Graduate and so on. But a user can enter Misc instead of General and there is nothing for Misc since it’s not in the value list for types. Any way to not allow the users to enter in MISC or something they think? Thanks in advance

While it would have saved me about 40 minutes of tinkering and resource scouring to know that calculations cannot be used in value lists, further tinkering resulted in using a text field with auto-enter options as a successful value list. In this case its just a first/last name concatenation used as a second field to a primary key value list. It seems to be working fine. Noob is happy, noob cannot foresee problems in future. Please correct noob if noob in danger. Is there any difference between an auto-enter calc and a calc field in terms of when they (re)evaluate?

I am trying to auto-populate a field in a new record using the value of that field from the previous related record. This field uses a value list from a related table. I also require that I can change the value in the new record without changing the value in related records. The "Value from last visited record" option will not work because, often, the last visited record is not a related record and the field auto-populates with the wrong value. Let me know if I need to clarify or elaborate. Thanks for the help.

Hi, I have a project table where I need to update a contact_id field (a foreign key to a contact table). This is easy with a dropdown list and a value list, but the problem is the contact table is in the thousands of records and therefore it's tedious to locate the one needed (specially when you only know a part of the name). One solution could be to build up a value list entering a part of the name of the contact on a text field, which then would filter the records that contain this string. I've been strugling with this without success, because all I tried involved calculations that could not be indexed. Anyone? I'd thank very much any help! Llorenc

I have the field “Industry Type” in two layouts (“Customer Layout and “About a Company” layout), which are already made and populated with fields. I have a value list called Industry Question: Is there a way to attach this value list to that field in both layouts without manually attaching it in each layout?

I'm a newbie at this. I have a report that uses a field called Last Call from a different table. That table lists all the calls made by a sales person. I want to show just the most recent one (Last Call) in my report, but it shows the first one (oldest). How I get the last one to display (most recent)?

Hi there, I'm trying to figure out the best way to do this: I have a "Passengers" table on a trip. Each passenger must choose several options from a list of "vendorServices" related to a "Vendor" table (for example, there are 5 vendors on this trip, each offering 3 meal choices. Every passenger must choose one option from each of the 5 vendors). The process of selecting the options is currently in place and when a selection is made, a related record is created for that passenger in a "Passenger Options" table. When completed successfully, each passenger will have 5 line items in the related "Passenger options" table, one from each vendor. On the layout I have 4 p…

Greetings I have a text field that I want to populate with members of a value list. The value list contains a small list (about 10) of accounts, eg, 102, 103, 104 etc. I can populate the field with the check boxes just fine. What I want to do is count how many items are checked. Ultimately I need to use that number as a divisor in a calculation. Can I do this or do I need to set up a portal and related field and get a count that way? Thanks

Hi -- I'm new to this site and looking forward to helping out where I can -- and hoping to get some help too! Let's say I've got a table called Films and a table called Actors and I want to build an index of Appearances using a 'join field' by that name. When I add a film record via the Films layout I plan to use a portal to the Appearances table to create the various apearances records. (Each film will have several actors, each actor will appear in many films). In the Appearances portal I have the foreign key field that links the join field records to the appropriate Actors' primary key. I have the field set to a pop-up menu making use of a Value list based o…

Hi - Me again, with a second question for the same scenario I just described. . . Q2 -- What is the best way to allow users to add new Actor names "on the fly" as they work? Is there a way of doing it in this same portal, or must I build an interface for an "Add new Actor to List" process --perhaps in a separate window? I'm thinking also of situations where I want to use a 'Join Table' to track subject keywords relating to each film, where I want the user to build the lexicon as she goes, adding terms to the Keyword table as needed as she assigns them to specific films. thanks again for any pointers. Albert

I'm new to filemaker and I'm in trouble with this situation: I have 3 drop-down fields Producer (field ProducerID) Director (field DirectorID) Actor (field ActorID) I'm loading all 3 of them with external data from another table as: CrueMemberID - CrueMemberFullName I have already stablished relations between CrueMemberID and all 3 fields I'm only showing the CrueMemberFullName in the 3 drop-down menues, but storing the first value. Sometimes the producer is the director and maybe also the actor of the movie, so I need to be able to click on a button and copy the producer selection into director, and another button that updates direc…

This is a fairly complicated request. I have two tables in one file, Shipping & Invoicing. Each Shipping Record has a shipping_number, each Invoicing Record has a invoice_number. The Invoicing Table has a repeating field populated with the shipping numbers that are being used for that invoice (an invoice can have more than one shipping record). I would like to show the invoice_number on the Shipping Table based on if the shipping_number is included in the repeating field. I can make a value list from the repeating field but I am having a hard time writing the calculation to see if the shipping number on the Shipping Table is a value in the value list on the I…

Is it possible to override the sort order for a two field value list derived from values in a table where second value only displayed? I noticed that if i have table 1 pk field 2 1 Alpha 2 Bravo 3 Charlie 4 Delta and i make a value list from the values in table 1 field 2 and use the value list as the source for a drop down the choices available are always sorted from A to Z. I want to see the list in the drop down as Delta Bravo Charlie Alpha or some order other than a b c d. Any thoughts? TIA Kris

Hello, I am needing help with this: I have a value list with 8 values. I would like a field to appear next to the value list, the field being based on which value is selected. There are 8 different fields that I am trying to accomplish this with, each based on the value list selection. The field that appears needs to be editable by the end user. Any help would be appreciated.

Hi - I have a drop down field that shows values from a value list, defined to show only the second field in its definition. Works fine except that each time a new value is added (on a different layout in related table), when I come back to the layout where the drop down field is, the new value is not there the first time. If you click on a blank area of layout, and then drop down list again, the new value is there. Sometimes, just dropping it down a second time shows it. Is there a reason it's not showing up the first time, and is there anything I can do in a script after adding a value so that this doesn't happen? Thanks, Michael

If this has already been answered, feel free to redirect me to the correct thread. I could not find it through a search. We are migrating our information from Excel to Filemaker Pro 9. One of our commonly used forms is a Percentage of Completion Inspection form for some large items we manufacture. We use this weekly to track the percentage complete status of our long projects. For example: CAD Drawings Printed: 4% Materials Ordered: 3% Frame Assembled: 6% Electrical Components Installed: 8% I want to place a checkbox next to each of the approximately 40 line items of the project. I then need a summation box at the bottom that will show the runni…

Hi, i've a FM9 solution, with some mysql datq, is possible to define a value list with value from a field of a mysql table ? thanks

I have a value list for a field called “Status”. If the status is “Denied” I would like the word to show up in red. If I do change the field type to calculation, the value list won’t work. Or can I use a script to show the user a pop-up info screen that says “If this is Denied, Please send the form to the Supervisor” ? What is a more preferred method? Thanks in advance

I use FM Pro 5.5, and I'm looking for a way to select an element in layout mode using a drop down list of elements in the layout I'm working on. For example, in MS Access, there is a drop down in properties where I can select an element of that layout whether it be a field, text, or some other element. I'm after a way to do that in FM. My reason is that the layout I'm working on may have a lot of closely spaced elements that are difficult to select or may by positioned behind other elements making it very difficult to select. Thanks

Hello. I think this isn't possible, but asking anyway: I want to sort a value list by a field without the values in that field appearing in the value list itself. For layout reasons I need to use a drop-down or pop-up value list (can't use a portal, for example). The values come from a related table. The values to be selected are unique. The values in the field I want to sort by might not be, so I can't use it as the first field. The values in the sort field are meaningless to the user, so I don't want him to see them, even during the actual selection process. Is there a way?

I am trying to use a value list to display a job selection field that is easier for a user to view. I am using related value lists to display and use JobID numbers associated with a spefic job name. For instance, job_001 is a unique record with a decrption field of "Uptown". In the selection field, the user selects a drop down list of a value list of all related jobID's, but it only shows text from the second field, the job description, i.e. "uptown", "downtown", etc. That part works great. The problem is that when we create an invoice. When the user selects the "invoice" button to run a script, it creates a new record in my invoice table, and pulls info …

Sorry if this has been asked before.. I've been through the FM knowledge base and looked at Conditional Value Lists and such and couldn't figure out a way to do this. Would dearly appreciate any help. I'm using FileMaker Pro Advanced 8.5 on Windows XP. I have one table called Projects. Its unique identifier is the Project Code. Inside that table are eight different fields in which the user can enter text. These are used to label different debts relating to that Project. I have another table called Disbursements. It also has a field called Project Code which is linked to the Projects table. I want each Disbursement to relate to a specific debt on that projec…

I need to have two different value lists for a field. The value lists show items from different related tables. The field is a part number and the value lists are (1) parts from the entire inventory and (2) a subset of the parts based on a job, if it defined. I had the idea of using a Tab field to switch between hidden tabs based on whether a job is defined or not. That would make the part field with the appropriate value list defined "appear". Is there a better way? Can the position/arrangement of a field be scripted to make a field come forward or backward? Thanks for any tips.

I seem to have come across a problem, I am attempting to create a customer contact notes system. The fields we will have will be 'reason for call', 'notes', 'client id' and 'date'. What I dont seem to understand is how I get to have a single line of notes, then once that has been completed for the program to have another empty fields line created, is this possible. If not is it possible to have a large number of available columns within the database, what I dont want is to have loads of columns and having the user to tab through all of them. Is there a good way to sort this? Cheers in advance

I've searched around some for an answer but I've had no luck. I have a value list that has about 5 choices. How can I make the values appear in a specific order when viewing it as a simple text in field. I'd like the values to show up in a certain sequence no matter what order they were clicked to start with.

Hi all I have a steel material db that has 1000 or so records. The program is used at different locations by one user at a time. I was wonder if anyone knows of a way of having the users pick the material they would use from the database and only that material will to be shown in a value list. I have seem this done in other programs where you would pick the data you want to display in a value by placing a check marked in a field and that data is present in a value list. When you deselect that item, the item is not longer shown in the value list. Can this be done in FM. I know how to format a conditional value list but I not sure if this is a conditional value list. …

How can I mark a checkbox(es) in multiple records at one time in FileMaker? Do I need to create a script? Details: I have a field using a Checkbox Set with Custom Values. Each Custom Value represents a specific mailing campaign. My goal is to be able to do a Find that returns all of the records that will be involved in a mailing campaign. I then want to mark the checkbox related to that mailing in all of the records in the found set at one time. I am a newbie to FM so please be clear in your replies, and forgive me if I am posting in the wront place. Just let me know. Thank you!

hi all. i need the expertise of the filemaker pros here. [color:blue]here's what i have: -i have a text field that constantly gets changed. -the data in that text field can be edited as far as deleting the whole data in that text field. [color:green] my inquiry: -is there a way that when you click on this field, a date & time stamp will automatically be filled in and then type in the new data? -is there a way that when the above mentioned is done, editing of the previously entered data won't be allowed as to preserve the integrity of the data that was recently stored? any help would be greatly appreciated.

Hi guys, excuse me if this is very easy to answer but I am new to the Filemaker program. I have set up a number of tables and within the database have set up also some Value Lists, for example we need to add the date when a client was sent an information pack so I have added the following fields - client day / client month and client year. I have set the attributes accordingly as Number / Text and Date. Following this I thought it would save on time to simply have a drop down option when adding, so created a value list with the dates 1 - 31 in it. The problem I have is that when I go to add a new record it requires text input from the user rather than the use o…