Value Lists

Hi, I've got a pool of product IDs (it's for a book database - so these are 13-digit ISBNs). I get these from a pool of IDs that I keep in one table. I'd like to allow users to select an ISBN from a drop down list and assign it to a product in another table, without using an ISBN that has already been used before. I've managed to use a value list to get the drop down box happening, but can't seem to filter it based on whether it already appears in the product database. I tried using a calculation field in the ISBN pool table that verifies whether the ISBN is used in the product database (I set the relationship to link the ISBN field). The field will give me a …

I know this has been solved before. Can someone please direct me to the appropriate thread? I'm having trouble differentiating between what look like lots of similar but not quite identical requests. Here's the gist of the problem: We collect many different types of documents for each of our patients. Each patient is a record in the main table. I also have a document type table with a linking table to store each record that a patient has a separate record (i.e. a line item). I want to create a value list that will serve to provide users with choices of documents to cite when entering data into the system to make sure we know where it came from. And I want to make sur…

I want to add a field to my layout that is a checkbox, which I can tick or un-tick to represent a simple Boolean Yes or No. Do I have to create a Value List of One Item? If I create a Value List of "Compiled?", then that is value that gets put into the field, rather than a 1 or 0 or Yes or No? Is there an easier way, or am I going to have to write a script to sort out this seemingly simple piece of interface? Many thanks

Hi, I'm trying to create Drop downs that only pull the info that corresponds to the previous field. Meaning. I have 4 Drop Down Fields and want to be able to click on the first drop down and only See "Girls", under the second drop down i want to see "T-Shirt", under the 3rd drown dow i want to see "A,B,C" and under the 4th dropdown i want to see only the fields that pertain to the 3rd field. Meaning if i select "A" i want to see on my 4th dropdown "3710" and "3900", if I select "B" i want to see "8000" and if i select "C" i want to see "1300" and "1400". How can i make this happen. Please see attachment. its the last Value List that's giving me trou…

Hello all Can anyone advise me on this one I have three value lists on a table the second one is dependent on what is entered on the first and the third dependent on what is entered in the first and second I have got all this working fine, the only problem is that the second and third drop down lists are coming out in alphabetical order instead of the order they have been entered in the table I have tried to get round this by adding a number in front of each value but ideally I would like this to be invisible - I can make them invisible in the tables by changing the text to white, but this attribute is not retained in the drop down list or in the final entry Doe…

This is something I've never experienced before - but then I've just moved to Lion. I have a text field that I'm trying to assign the 'radio button' option for control types. It is grayed-out and unassignable. I'm trying to assign a 'custom value' value list to the field and it and about 1/2 the other value lists in the solution are grayed out and unassignable. What's going on? Why are some Value Lists unassignable for use and why am I not able to use the 'radio button' control option? This is really frustrating. (i"m using FM11 advanced/Mac OSX Lion. Previous development on earlier versions of Mac OSx did not exhibit this behavior)

I've set up a database for my organization that can take our total client file (about 20,000 records), drill it down using finds to a targeted list, and export that to a spreadsheet. Easy enough. I would like to have the value lists of several fields dynamically update in find mode. For example, if I had the following geographic fields: State County Town Zip Region (we've already defined this) If I select state and region in find mode, I'd like for the drop down lists for counties, towns and zips to only include those values that are in the correct state and region. Basically, I want the current value lists for any of these geographic fields t…

Tables: user: uid, name 1, joe 2, bob 3, millie interests: item_id, interest_id, uid, where uid is associated with user::uid 1, 1, 2 2, 1, 3 3, 1, 1 4, 2, 2 5, 2, 3 6, 3, 1 7, 3, 1 interest_list: interest_id, interest_name, where interest_id is associated with interests::interest_id 1, ecology 2, economy 3, elephants I have a portal that uses the interest_list table as a value list using a standard pulldown menu to add new interests to each user and a delete button to remove them as necessary. The portal works as predicted, but I can add any interest more than once. I'd like to make it so there are no duplicate inter…

Newbie question Requirement - need to have conditional value list which varies based on contents of other field in table. I realize that this is exactly what FM intended when they added this capability, but I do not want user to interact with the UI to create the filtered value list each time it is required. (e.g. - Employee table has EmployeeID and Dept. I want to create conditional value lists which contain EmployeeID, but the value lists need to vary by Dept. In one layout, I might need an EmployeeID value list which displays only the employee names which are in Accounting, in another, I need the value list to include only those in Sales, etc.) …

I'm working on a solution for registrations and roll call for a small art school I'm associated with. I have a layout displaying records from my STUDENT table. There are two portals on this layout: In the CLASS_ENROLLED portal, I have a popup value list with the names of all the courses in the CLASS_DETAILS table. Here the user selects the courses the student is enrolling in. In the SESSIONS portal, each row represents a session (specific date and time) of every course the student has enrolled in for the current month. Each session (row) has a similar value list to the above mentioned, but it only contains the course(s) that the student whose record…

I am an intermediately capable FileMaker coder. I have a solution I created for an activity at work which recently broke in a critical part of a reporting process. Does anyone know if the function ValueListItems() was broken with the 11.0v4 update? It was working fine before that and I cannot think of anything that touched that part of the code. In places where possible, I prefer making code dynamic, rather than hard-coding items. One case in point is that as part of a report I build, I look at a value list and create temporary counting variables for each item in that value list. It's a bit slower, but the resulting code won't break if a value list is modifi…

I am having difficulty generating a filtered value list from existing data. These are the tables: Patient Facility Account Hospitalization Each Patient is related to 0 or more Facilities through the Account table, which serves as a join table. Each Hospitalization is related to one Account, and thereby to its Patient and to its Facility. Each Hospitalization is also related to one other Hospitalization, which is its referring Hospitalization. (For example, if a patient is transferred from one facility to another.) I am trying to create a value list that displays only valid referring Hospitalization candidates according to the foll…

I want to create different record id as per my valuelist: ex.- i have parts and products in valuelist. If i select parts...then...in id field ,after clicking on button, a record id parts_01 should be generated and when i select product...then...in id field ,after clicking on button, a record id product_01 should be generated. After a new record, parts should generate parts_02 and for product, it should generate product_02. please help in a script test.

Hi - I had this formula for a while, but can't find it anywhere. I have a 3-level conditional value list Type > Category > Subject, say I select the type, category and subject, then I go and change Type, the category and subject remains there, but is no longer correct b/c I changed the original top-level setting. Can someone please point me in the formula to remove the Category field when the Type field is changed, or the Subject field when the Category or Subject is changed. I thought it was an Evaluate, but it appears I am wrong. THANKS so much, Justin

Can anyone please help me with this problem (and thanks in advance): I am using FM Pro 10 Advanced. I want the user to be able to print out a letter containing the text of any of a number of letters stored in a table (tLetter) to a found set of individuals from a table tPeople (this group of people need to receive a letter asking them to return their subscription form, or inviting them to come to a meeting, etc). I have a table (tPeople) containing people’s records (table starts with ID field for each person which is indexed), and a second (unrelated) table (tLetter) with the fields ID, title and content, containing any number of different letters (simi…

I've got a table "Products" that has a field called "Colors". (This is a t-shirt business so I've got hundreds of products and hundreds of colors) The field "Colors" is set to create a value list based on all the colors entered for all products. So in short 1 product could have multiple colors (i.e. T-shirt comes in blue, green, purple, yellow.) In my "Orders" table when I select T-shirt I want only [blue, green, purple, yellow] to show up in my "Colors" field. However, every way I try to set this up, I'm getting every single color in the drop down list to show up. I've seen some conditional value list posts around here and have a few examples, but I don't …

I have a value list displaying names in a repeating field. My problem is that with the list containing, for example: Bill Wyman, Keith Richard, Mick Jagger, Charlie Watts and Brian Jones, no matter who I highlight, I always get Charlie Watts (who, you've probably guessed, lives in repetition 1). Why am I able to see and highlight content that I can't use? Am I asking too much of repeating fields? Or, am I overlooking something?

Breaking my brain here... I have a company table and a person table. Records from the company table need to show up in a value list in the person layout, so a company can be selected for a specific person. This is easy and works. Now, what I thought was also easy does not work. I have a field in the company table which makes a company active or not (1 or 0). So what I want is that the value list only shows the active companies (1). I made a global number field in the person table with value 1 and made a new relationship with the company table, linking the 2 fields. Supposedly when they're both 1 there's a link... But not. Please suggest.

Is there a way to create a value list that can incorporate both a checker box and text format? For instance, there are four options for a particular field: normal, unknown, abnormal (explain), and other (explain). I'd like to incorporate these values as checker box options, and if either the abnormal box or other box is checked, then a text explanation is necessary.

Hi Guys: I have a portal that holds a value list that it populates from another table. I would like to have the list to filtered if the value has been selected in the portal, so it doesn't repeat itself. For example If I have Machine 1, Machine 2, etc... and select Machine 2 in my first record in the portal when I create the second record it will take Machine 2 from the value list. My relationship is as follows. Shift Table kp_shift_id ..... Machine table kp_machine_id ...... Transactions table kf_shift_id kf_machine_id .... Shift and machine table are already related to my transactions table in the relationship graph. My val…

When setting up a value list is it possible to set it up so that it only includes values from certain records within a table. For example I have a table with authorisation passes in that have an expiry date. I have a calculation field set to display either 'Valid' or 'Expired' dependent on the expiry date in relation to the current date. I would like the value list to display only values from records that meet the 'Valid' criteria. Does that mean that I have to create another table that only contains 'Valid' authorisation passes or is there a way to do it from the table that contains both 'Valid' and 'Expired' passes? Thanks in advance.

I know this has already been answered on here, but the conditional value list threads I keep findings seem to be asking slightly different questions from what I am after. I have a field of interest [status] on a table called "Checklist" with many possible responses in its value list. I am ultimately trying to create a running list that shows the last names on each record where [status] is any value other than "Complete" (others include "Need to request", "In Progress", etc.") I decided to create a second field [status Incomplete] on the same table ("Checklist") with a single value (*Yes") so I can perform a much simpler find for all records where [status Incom…

Hi: I'm a Novice user of Filemaker 11 getting trouble finding a solution to link 2 tables from a set of values located in a Value List. The first table Products:Product_ID holds the list of products The second one Products_to_Products is used to show in a portal the products that have the same specs and that can be considered as "similar" or "compatibles". I need to create the link between this two tables using a Value List. Example: 4 products has been selected and the value list contains the Product_ID for each one separated by a CR: myValueList 1 2 3 4 Now, based on this list, I need to create in the table Products_to_Products the …

Hello, I'll build a database for a simple order system. On the first layout i'll have a drop down menu in a portal. Now i want to disable users to type text in this drop down menu how can i do this. I only want that they can choose values from this list and no typing at all. Thanks already,

I have a value list set to use the value of the first field and to display the value of a second field. If I use a pop up menu, both values get entered into the field. If I use a drop down list it works as it should and only enters the first value. Am I missing something obvious?

Hi all, I would like to use a value list for summarizing part of the data in my database. My database is a linguistic on - the main table is 'Sentences' in which sentences are stored, then there is a table 'Morphemes' which stores information on words from these sentences (I enter data into Morphemes through a portal in Sentences). I want to make a list with the unique values present based on two combined fields from the table 'Morphemes' individually for each language, and also have Filemaker count the unique items on that list (so I basically know how many morphemes of one type each language has). I created a new table, called ‘Analysis’, in which I created a …

Hi Gurus, When a user is to add items to a Purchase Order, I run a script that takes them to a new window in the raw materials table, does a find based on the supplier ID, and shows them only the raw materials we get from that supplier. They are then able to select multiple items, they want to add and this then is scripted to add those items to the PO. Some suppliers, may only have a few raw materials and others may have hundreds. I need to be able to give further filter finds within the found set, based on the default supplier ID, so that the user can narrow down what they are looking for. I have already created qualifiers for the raw materials (within …

I have an emergency situation! I need to migrate the old database to the new database on Saturday and I can't until I can solve this problem. Any help is greatly appreciated! Table jobinformation Table Billabletime - Table Billabletimeselected is an occurance of table Billable time Table Codes - Table CodeType is an occurance of table Codes - Table CodeType is an occurance of Table Codes - Table CodeCode is an occurance of Table Codes Table occurance billabletimeselected has a field job id and a field billableid Table Job Information has a field job id and a global field billableIDselected. The relationship between the two i…

I have a file I call Instruments (as in psychological ones, not musical!) which has two tables: scales (for the names of scales) and stems (for the text of each scale stem). I have another file I call Assessments, which is where the data field resides for all responses to any of the scales. I envision creating a script which would call up in one portal the assigned scale, showing all of its stems. In another portal, I would like to show the required number of rows for the data which would correspond to each stem. The challenge is that each stem can have quite different answer sets, e.g. one might be the 'strongly agree - strongly disagree' type while another could…

Hello all, Recently I downloaded a version of Filemaker Pro 11 and now after a few days of playing around and looking for answers and solutions I am stuck. I created three tables, first a companies table (only company names), second a user table (only user information with a valuelist showing company names in a drop down). Third table is a projects table where the company name is a valuelist showing the company names in a drop down). The last field is where I want to select a user with a dropdown, however I only want to show users in the dropdown that relate to the 'already' selected 'company name'. * note, tables as described are simplified to the fields…

Hi all, I have a three table situation. 1. Tablename "Begraafplaatsen" 2. Tablename "Graven" 3. Tablename "Reserveringen" In "Begraafplaatsen" is a pKey field begraafplaatsen::id. In "Graven" is a fKey field id_begraafplaatsen. This fKey field exist in "Reserveringen as well. There is a one-to-many relationship between begraafplaatsen::id and graven::id_begraafplaatsen to show only the relatedvalues of a specific record in "begraafplaatsen". This works fine. In Table "Graven" Is a field "Rij naam". The values in this field exist more than once because for every "Rij naam" more then one position is available. The sum of the positions is stored…

Hi I'm not sure this is the correct place to post this. If there's a better place, please let me know. I have a list of items that I need to categorize. I have a table called Category which has two text fields defined. "CategoryName" and "ItemNames". So each row of the Category table contains a category name and a list of items. The list of items is a carriage return separated list of item names. So there are no "Value Lists" involved, but the list of items is kind of like a Value List, I suppose. I have a script that extracts the item properties for all the items in the related set and then builds up a string to send to a web viewer using a U…

Hi, I have a text field (OutcomeVariable) in a table, that is displayed on a layout. I want the user to enter a value in that field based on a value list. I have two different value lists that can be used for this field. If User 1 enters the layout, I want the layout to display ValueList 1. If User 2 enters the layout, I want the layout to display ValueList 2. Three items that are in ValueList 1 are not in ValueList 2. Could you comment on the following: 1. Is it possible to set it up such that User 1 sees ValueList 1 and User 2 sees ValueList 2? If yes, how? 2. Should I just have two different tables, one for User 1 and the other for User 2?…

I have a Supplier Pop up list in a Quote table. When you move into the Supplier ID field a list of all Suppliers pops up. If you type a 't' the system jumps ahead to the 't's. If you type a 'b' it jumps back to the 'b' suppliers. This works fine on Windows. We have introduced a brand new Mac which runs the database just fine in other respects. But when you type a letter with this pop up list showing the system just beeps and does not move to a new part of the list. Is anyone else experiencing this? Any solutions?

I have a value-list field that contains values from another field in a related table. In the table the records show up as 2 5 4 3 6 8 1 10 7 In the value list, however, it sorts them 1 2 3 4 5 6 7 8 9 10 How can I set the value list to mimic the order they actually are in the table? Seems like it would be such an easy thing to do but I cant figure it out. Im using FMP10 if that matters. Thanks

Hi Gurus, Struggling with this one. I have a raw materials table, suppliers table and a join table between them of rawmtrlsupplier. While in raw materials table, user can add one or more suppliers for a particular raw material, and see this in a related portal. I have that working fine. In the portal of suppliers I have a field "rawmtrls_RAWMTRLSUPPLIER:: _MainSupplierID" with a checkbox set that has a value list of "1". It also has a button applied to it as shown below: Scripts: Set Default Supplier Set Error Capture [ On ] Set Field [ RawMtrls::_kf_DefaultSupplierID; rawmtrls_rawmtrlsupplier_SUPPLIER::__kp_SupplierID ] Refresh W…

hi, I'm working on a donor/donations tracking application for my son's K-5 school and could use some advice. I have a Donors table that holds donor records including address information (address, city/state/zip). There are also a Parents table that holds records of parents of students at the school including address information and a Families table that holds records of families including address info. The Donors table has foreign keys ParentID, and FamilyID pointing to the Parents and Families table respectively. In the Donors layout, there are the fields FamilyID and ParentID; and either or both can be populated. The behavior that I w…

Hi, I have a table of suburbs, about 15,000, which I use in a dropdown value list, works fine AFTER the initial choosing. I thought I read somewhere about pre-loading the value list into the cache would recify this but haven't been able to locate the post. anyone help .. or other ways for such a huge value list BTW, the FM file is hosted, it's not so bad on the local copy regards cate

I have a task management program for my cabinetshop. Tasks are assigned priority 1-2-3 from a valuelist. There may be 10 items on the list but only three are in play at any time. The focus for 1-2-3 essentially means: Do this one now. Do this one next. Do this one if you something hangs you up on priority 1 or 2. By constraining the priorities to 1-2-3 we minimize the things under consideration. THE PROBLEM IS: when we perform a descending sort on this value list all of the tasks that have no priority assignments show up at the top of the list. I would like the sort to be essentially equal to: 1 2 3 "" Is th…

Let me start by saying that I do not need a Conditional Value List here...I already have two of those in use and they work just fine. My issue is as follows: I have multiple tables in a Finance Database, One which holds transactions and one which holds Accounts and their info. In the Transactions form there is a field "Account" which is set to a Value List that simply gathers the Account names from the "Accounts" Table. What I am after is being able to "Filter" the value list, in other words, if I could put a check box on the Accounts layout that said "Include in Accounts List" and if that check box was empty that record would not appear in the value li…

I am new to Filemaker so apologies if this query is a bit basic. I have a form based on a tblExpenses which contains transactional data. Within that table there is (for example) a field called CategoryID. This relates to a CatID field in a seperate tblCategories. What I want is a way on the original form that when the user tabs in, they can start typing the category description but be restricted to that values from tblCategories.The resultant value though needs to be stored as the ID (not the description) in the tblExpenses I've tried using drop downs and pop ups but this doesn't seem to meet the requirement. What I think I need is an edit box which auto compl…

I'm working on an inspection app to be used on iPads using FM Go in the field. The inspection type I'm currently working on requires that elements receive different weight across multiple categories. I have already entered the maximum valid values for each element into the database, and have been using validation to ensure that the user-entered score for that element is less than or equal to the max allowed value. Instead of using free-form data entry I would like to implement a pop-up menu, but I'm not sure how to populate the value list to show integers 1 through the maximum allowed score. Thanks in advance!

What I did: CREATED A CLONE After that: Proceeded to import from original DB to Clone Import summary Message: "total records skipped due to errors : such and such" I am not able to import all records into the clone. WHY? IS THERE ANYBODY OUT THERE? I have already tried the validation fields... by the way Thanks!!!

Be gentle -- a Newbie looking for help from the many experts on this forum on the following: Requirement: I need to mimic existing field layout of an existing web-based solution to provide for future "import" capability to that system. There are ~140-150 fields in the existing solution, 40-50 of which are "multi-value pick" lists, most of which have static values. These value list fields allow for 2-20 picks per field depending on the field in question. Total option counts are typically 5-20 options from which the user can select. The web-based solution returns the selected items from pop-up window in the form of comma-delimited lists of value-ID's. If you c…

Hi, I am trying to use custom graphic images as checkboxes instead of the filemaker ones and can't quite figure it out. The checkbox graphically works, the only problem is I need it to check off the original filemaker checkbox (it works in a script of mine). How do I tell a multi-valued checkbox to click on a certain value without disrupting the other ones? The original checkbox is the basis for a find query ending in a report with over 20 values. Thanks, Jimmy

Hi all, Hoping someone can help me out here. I have a pretty standard "Time Log" table in which the employee can put the client, project number, task, and time. I also have a table for the projects, which contains the project number, client, due dates, status (Open, Complete, Hold, Canceled), information, etc. In the Time Log table, the project number is a drop-down value list, so that once the client is picked, the value list only shows the project numbers related to that particular client, and this works perfectly. However, due to the sheer volume of projects we can have for each client throughout the year, I would like the drop-down list for project number…

A pre-emptive thank you to the great contributors that make up this forum! 1) I am creating a music database, with one field being "Format" in which I have music release format values listed as a checkbox set. These values include, for example: 7", 2x7", 12", 2x12", 3x12", CD, 2CD, 3CD. 2) I want to create a separate calculation field that creates a simple comma-separated list of the checked values, in the same order that the values are listed in the checkbox set. (example: if 7", 12", and CD are checked, they appear in that order) 3) I've tried using calculations that I've found on other forums, but the fact my values have quotation marks integrated became prob…

I have an external database (MySQL) with the following tables: tbl_Products tbl_Product_attribute tbl_Options_values tbl_OptionsValues_to_Options tbl_Options The tbl_OptionsValues_to_Options is there because the solution may be shown in different languages. When making a new product attribute record, I need to chose an option, and then a value for that option. The last field should be based on a conditional valuelist. I am simply not able to make it work. I have made the following relationships, where I have tried two different solutions: either to make a link between tbl_Product_attribute and tbl_Options_values, or between tbl_Product_a…

From what I am reading, this may be impossible or at least improbable. I have a table of status made up of the following: status_ID;status_active;status_sort;status_text It is related to a contacts table via the status_ID in a 1 to 1 relationship (i.e. each contact can have 1 status). I am storing the status_ID value in the Contact table. My question: I would like to be able to keep a user from selecting an inactive status from a popup list and I would like the values to be sorted by the status_sort values. I have previously programmed in MS Access, and creating a list this way is somewhat trivial using a query to sort values. FMP doesn'…

i suppose it would be helpful if i posted the file with my tables in it!!! if anyone has any suggestions regarding this feel free to comment on it. here is my file If there are any questions regarding what i am trying to achieve please dont hesitate. many thanks Jess Hose DB CLONE.zip

To store a field id that is related to another table but to display a text field from the related record on a layout, I believe the common solution is to create a field that stores the id but uses a value list for data entry, with only the second record displaying in the value list. One then overlays a field displaying the related value. I provide a simple example of this solution in the Data layout of the attached file. Is it possible to get the id not to show up in white on light blue when one is in the process of selecting a text value from the drop-down value list? The id number might only confuse users who need know nothing about IDs. The only way I can thi…

I have a value list of competitions, hiding the ID. RegionA 2010 RegionA 2011 RegionB 2010 RegionB 2011 and so on, for many years. I've created a value list for a popup menu that lists the competitions alphabetically. Is there a way to list the competitions by year descending (year is a separate field from name) without changing waht is displayed in the value listing? I'd like the value list to appear as: RegionA 2011 RegionB 2011 RegionA 2010 RegionB 2010 tia, Barbara

Hi, I have 'region' and 'city' fields in my table. I have defined drop down list for my region field with 14 entries and city with 81 entries. Each region has cities, what I want to do is, after I choose region, only cities in that region should appear in drop down list. Thank you very much for your help.

I have looked everywhere for some information if there is a possibility of using a checkbox set with a script to manage rooms in a hotel format. My two questions are... 1. Can I use a Checkbox set to check the rooms that I want to use. 2. Is there a way to write a scipt that checks to see if a room that is clicked is available during a date range. If not, an error message would pop up. Background: I am very familiar with scripts and filemaker. I just don't know if it is possible. Thanks for any help! :D

This should be easy but it has me stumped: Tables: Companies Contacts Comp_Cont_Many (table joining many contacts with many companies) Orders Many-to-many relationship between companies and contacts. Each order may have only 1 Contact and 1 Company. On the Order input form, there's a drop-down menu for Contact, and another for Company (to assign a single Contact and a single Company to the order). The Contact value list on the order input form is not conditional. User may select any Contact from the Contact table to put into an order. The Company value list should be conditional, based on the Contact for the order. Example: Jon Doe (co…

I have a database for my music library in my band room. I also want to be able to list concerts and for each concert which songs were played. In that database I have a table for pieces in the music library, another table for concerts and another table for the selected concert's list of pieces. When I click on a concert right now it pulls up a list of related concert pieces in a portal beside the list of concerts. In that portal I have a field set up to display a value list from which I can select a piece of music from the library - the value list shows the Title only (but it is also based on the ID of the record for that piece of music) everything is working jus…

Hello, I have two tables: Process Document Process table fields: __pkProcessID ProcessName ProcessStepName Document table fields: __pkDocument ID DocumentName ... What I want to achieve is to have a portal on the Document layout where to put the processes and processes steps where a document is needed. For instance, Document 1 could be needed at: Process 1 step 1 Process 1 step 5 Process 3 step 4 Process 10 step, 2 Process 10 step 5 ... I surfed the web in search of help and I got an example that describes how to setp up conditional value lists both for fields and for portals. No issue on the fields part. …

Hi, I have a value list which is containing spare parts ID/Name How can I filter it an show filtered value list? Regards to all

I can't get around that every time I want to use a field validation It is triggered at the beginning and not at the end of a new record. I want the validation to be triggered when I want to create another record or simply before I quit, so that the field is filled with the information intended for that field. This validation issue is quite an issue for me. I'll appreciate any help on this.Thank you

Hey all, Anyone know of a reliable way of making a very large value list resolve correctly? Example: I have a table of data from an Internet source of network adapter first six MAC characters to vendor. Really simple. Two fields. First six of the MAC and the vendor assigned to that prefix. Ex: 005056 = "VMWare, Inc.". The table has 5630 entries. I have a field in a database to hold the full MAC of a device and a companion calc field to take the first 6 digits after stripping out any colons ( or hyphens (-). I have a double field value list of all the values from the Internet source table (first field is MAC first six, second field is the Vendor string). …

Hello, i would create a value list that only shows the articles with belongs to the customer number (debiteur number) But i don't know how i'll create a sort of filter for it. Orderinvoer.zip

Hello, I have a database for a summer music camp program. I currently have a table of all faculty that have taught at the camps over the last several years. The database I inherited had a Year field that would have "yes" entered into it when faculty taught at the camp that year. Most of the scripting and sorting would start with a find for whichever faculty member was teaching in the current year. I would like to be able to create a value list of all the current teaching faculty for this year. The value list would be used in several layouts for ease of pulling class rosters, contracts, assigning to classes (though a join table to the student table), etc. I've s…

I can't understand why a field that displays a value list as a radio button does not show all the characters of each item in that list? I would greatly appreciate if some one has an idea. Thanks

I'm sure this should be easy . . . he said, I have a table CLIENTS, each record has room for up to 2 people to be named. They start as LastName1, FirstName1, LastName2, FirstName2 Then there's a calculation for FullName1 and FullName2 Now in the SESSIONS table I want to be able to choose clients with a drop-down list So I want to have a Value List with both those names in it. I can't see how to do that in the Value List interface. I've created a field in SESSIONS that does a Lookup of the value in CLIENTS::FullName1(FullNameA) , and also CLIENTS::FullName2 (FullNameB) How can I put FullNameA and FullNameB in the Value List? Thanks, ji…

Hi I'm trying to implement a new feature in my database which involves two tables. the first is called 'salesline' and the second is called 'options' Options has a mixture of records of various options that are either 'inclusive' or 'chargeable' I am trying to get two value lists displayed in 'salesitems' table. one is for the inclusive options (i want to use radio buttons so users can only select one). the second is for 'chargeable optons' whereby users can select multiple optons by means of a checkbox set. the problem i am having is getting the value lists to correctly display the correct records - i've done this sort of thing before and not had a prob…

Hi I need a script to let me set a value list field in a loop, search related records and save it as excel. I don't know how to write the script. any help? Nader

Hi Does anyone know if it possible to chart (bar or pie) the number of entries in a database based on a selected value from a value list? IE: I have a value list containing values of "Product A" though to "Product K", I would like to create a chart showing how many records with Product A etc. Thanks for any advise.

Hi All, I have a drop down list on my Invoice table in a portal from my Line Items. The Line Items table looks up the information from the products table. I have had to create two different part numbers for the same product determined by how the product is stocked but when I create an invoice it only shows one item in the drop down list not two, any ideas why.

This question addresses a larger issue, so let me start with that larger issue. I have made an FM database template that many of my colleagues use for specific events. Each event is different, so the users start with a clean version of the template for each event. Of course, the easiest way to do this is to provide a Cloned copy of the template. However, I would like to be able to add a User Preference feature that each user could set for their specific convenience. Unfortunately, I know of no way to preserve any "preferences" (values) in a Cloned database. One solution would be to be able to edit the Custom Values used to generate a Value List. I know one can …

FMP10 mac OS 10.5.8... I have a value list in a file... that appears to have no name, no value list items and can't be edited or deleted. What gives? backstory: I was updating a file, added a field (number, global) and it needed a value list. So I set everything up from a client, added it to a couple of layouts, set the value list, then quit out so I could do some stuff with the host machine (compress copies, make backups etc.) When I reopened this set, that field came up as "value list missing". When I went to layout to reset it... there is an entry in the value lists (only two value lists in this file) but it shows nothing (blank) for a list …

I am using FM 11 Adv 11.03 I have a popup that shows these values: When a selection is made, an evaluation script is run: I can't for the life of me see why the last (high lighted) else if doesn't evaluate. All the other choices work. FM, in debug, just skips over (evaluates as false) this choice. Perhaps your eyes can see what mine can't. Thanks for looking...

Hi All, Ok.. I want to make my new database easy for admins to add/remove value lists as products change or grow. Typically, I would just make Value Lists and enter in values there, but for future use, they are tough to edit add/remove items as things change, So this time I am making a "setup" layout that they can enter in values via portals of common items that can then be used later as value lists. My dilema is that I have roughly 20 values lists I would like to create.. so do I make 20 databases with the list items for each, or one database with all the value fields for everything and then in the setup page, just filter the records to those with the data…

Hi. As part of my database, I have a photo field. My question is: Can i add a field that automatically shows to name of the attached photo file? Thanks

I have a dwindling value list I created ( see attachment) which appears to work but if I make some changes the value list does update straight away (as least on fields where a change has be made). I guess it is an indexing thing. Any ideas around this? thanks the test file is pretty straight forward. cheers dwindling VL test.fp7.zip

Hi, new to Filemaker and these forums. I'm using Filemaker 10 Advanced. I have a conditional value list in a drop down that works great in Filemaker; however, when I tried to use the conditional value list through the web published version of my database it no longer works (that is, the conditional list is just empty). I guess this is due to the selection being local to the web-browser and not sent back to the server, so a related value list cannot be constructed for the secondary dropdown. Is there a way around this in the web interface? Can I fire off a script or something to get the related value list? Thanks

Hi, Is there a way to get a list of what is in a portal that uses portal filtering? Relation ship will not wok because this is a calculated field that cannot be indexed... tnx

Hello Everyone, I've got a question about value lists and haven't been able to find a definitive answer searching here or elsewhere. I've got a database for tracking the recruiting of research participants. Each participant gets screened to see whether he or she is eligible for a research study, so there are several tables: a Screening table, with fields for the person's answers to the screening questions, and several tables that allow for multiple answers to a screening question. These related tables are Medications, Medical Conditions, and Illegal Drugs Used. I'm trying to refine a system for tracking the reasons that a participant may be deemed ineligible fo…

I have a layout that has three levels of conditions. The first level is "related to", the second level is "job number" (which is conditional based on selection of the first), and the third is "hull" (which is conditional based on the second). The first and second work great, however, the third only works halfway. This is basically setup as a filter. There are four options in the first level: related to - "vessel", "overhead", "warranty", "facility". Once one of those items is selected, the second level "job number" is filtered into those four categories for selection. Once the second is selected, I need to third level to be a constant and not a selection. There is …

The idea is that IF a field has content, its name does no longer appear in a value list. For example, if the field "Organization" contains a value, the string "Organization" needs to be omitted from the choices in the value list. Here's the stored calculation which I'm using to create this dwindling list: Substitute( "Location¶Insured By¶Main Artist¶Organizer¶Curator¶Other¶"; FilterValues ( "Location¶Insured By¶Main Artist¶Organizer¶Curator¶Other¶"; Case(IsEmpty(Location); ""; "Location¶") & Case(IsEmpty(Insured By); ""; "Insured By¶") & Case(IsEmpty(Main Artist); ""; "Main Artist¶") & Case(IsEmpty(Organizer); ""; "Organizer¶") &a…

Here's what I want to do: I want to create a list of items for a user to select from. As an example, it's a list of pies: pumpkin apple rhubarb lemon key lime I was going to use a checkbox list for selecting them, but I want to be able to select one of them more than once. For example, I'd like to choose 'apple' twice and 'lemon' once. Naturally, a standard checkbox list doesn't quite work, since it only allows for each item to be selected once. Also, I'd like to be able to add an entry. I know there's an option for that, but the implementation is odd. I'm wondering if there's another method. Currently, you select 'other' and put it in the pop-…

Hi there. I was wondering if it is possible to add two unrelated fields into one value list? I want to combine my supplier emails (Supplier table) and my customer emails (Customer table) into one value list, example value list called email address... Any ideas or comments?

Hey all, first post. I am a novice filemaker user since I had to construct a series of databases for my employer. I don't know too much but I learned enough to make databases that worked well. I come asking for help. On one of my layouts it needs to be trimmed so that multiple copies of the layout can fit on one page. However, some of the fields may have more entries than allowed. Is there a way to make the field spill over into another field right next to it, and if so, how? I guess a two column approach would work the best, but how do I get it so that it won't repeat the values, and instead continue from where it left off?

I have a value list called PLAYERS that is populated with the following custom values: Architect Contractor Cabinetmaker Electrician Painter I have two fields: People who should be notified People who have been notified These two fields are displayed as checkbox fields using the value list PLAYERS I would like to have a third field that just displays a checkbox list of the Players who NEED to be notified. Any way to do this?

Can anyone tell me how to control the width of a drop down list? I have a DD list that drops down from a semi hidden field (1px wide) that always truncates anything more than 7-8 letters long. I'd like to find a way to control the width of the list so it could display something like 20 characters. Anyone know how to do this in FM10Adv?

OK. So I have been working on a db that tracks an event that my church puts on every few months. I have the basic structure set up thanks to "comment". And maybe you can help me with this one too. I have a table set up that contains all the people in my db (I called it tblPeople). I also have a table set up for the events (called tblEvents). Additionally I have a table that contains all the registrations (tblRegistrations). This table allows me to chose a specific event for each person to form a registration. This registration also allows me to pick a role that the person who I am registering. We have a role that is called guide and if a person is a guide, they have other…

Hi everyone I am a verry big noob when it comes to filemaker pro 8 advanced and I need some help. The problem is: I have a table called hardware and a table called software. In my software table there is a field called: computers. I want the computer field to be a value list with a condition. My hardware table has records for not only computers but also for peripheral devices. So my question is how would I make a value list that does the following: if (Hardware::Category; "Server") or if(Hardware::Category; "Laptop") or if(Hardware::Category; "Desktop") then show the value list of Hardware::Name in my software::Computers field. How would I do…

I just got Filemaker Pro 11 Advanced for my business. I have created three Databases: Inventory, Contact Managemet, and Purchase Orders. I need my purchase orders to take from Inventory and update the stock level. I need the bill to (address, city etc etc) information to be chosen form my contact management list. Can someone help me provide step by step instructions for these tasks. I have seen other topics relating to the same thing but for some different uses and I know there are steps i am missing. Step by step instructions would be very helpful. Thank You

I have a database (OS X FM 11 Advanced) I am working on for a personal business and have a complication that I need some assistance with. Here are the tables: Customers -> stores customer contact info Prints -> predefined artwork prints with inventory for sale for any customer Custom -> artwork that is custom based on customer input that is tied to one particular customer Invoice -> invoice sent to a customer for artwork (both custom and prints) bought Invoice_items -> each line item to be added to the invoice total On my Invoice form, I have a portal tool that links to invoice items. In the portal tool I have a dropdown to select ar…

I have just made my first foray into conditional value lists which seem to be working ok when I add a new record. I select a value from the first field which then gives me the correct options on the second field and so on for five consecutive fields. My little problem is that in find mode when I select a value in the manufacturer field I am given the correct values to select in the model field but after that the next three fields have no value in the value list. Because it works fine in browse mode when I add a new record, should I expect it to work the same in find mode?

Level: Beginner OS: Win 7 X64 (not listed in profile options) Hi everyone. This is my first post and I'm rather new to FM so I apologize in advance if my question is very basic. I'm trying to create a drop-down list with a value list based on IDs and always showing the corresponding name (not the ID). However the ID must be finally stored in the table. To do so, I created a value list with the first field referencing to the ID and the second field referencing to the corresponding name, showing values only from the second field. Back to browse mode, clicking in the field shows indeed the list of names (OK) but once one name is chosen it then s…

Hi, I'm sure this has been asked many times, but I haven't been able to get my head around the answers in other posts. Here's what I need to do: I have a CONTACTS table with a client type field, eg. Supplier, Intermediary, Customer, etc. What I want to do is create a value list that only shows the Contacts tagged as Intermediaries. How do I go about doing this? Thanks in advance!

I've created a really basic 'Gender' drop down list with custom values 'Male' and 'Female'. Why can't the user drop an item from the list into the associated field? I can highlight 'Male', for instance, but it won't go into the field. The field has a default setup, ie: it's marked to accept data entry in Browse and Find modes. Every drop down list, in this particular db (my first in v11), acts in the same way. I have tried switching to pop up menu (ppm) and, whilst that worked, it altered the look of the field. The fields are 1pt embossed, grey fill with black line applied – with standard fields and ddl, I see what I want, a grey field with 1pt emboss (no black…

Have looked around but not seen anything that seem to cover this. Question I have is: I want a value list that has a bunch of titles that a user can pick to enter in info on that title, but I want that title to disappear from that value list if it has already been chosen. So only that titles that have not been chosen show up in the value list till they are all gone. Is this possible? Thanks in advance!!

Apologize if this has already been covered but I've been looking for a while now. All I'm trying to do is to create a value list based off a global field of available unused numbers within a set range. I have unique serial numbers for each record but this is a housing rentals db and they are assigned key numbers per property. These key numbers are within a set range so I'm looking for the easiest way to pull up a list of numbers that are not currently being used. I created separate tables with say 1-200 auto entered serial numbers to compare my key number field to but I'm not exactly sure of the next step as far as the wording of the calc etc. If I can get lis…

Hi guys, Sorry if this seems like a newb question, I have a time card data base keeping track of my hours, and now have come across a Stat holiday which I want to account for. I have a column marked paid, which is a value list, of (Paid,Un Paid, Carry Over,Time & 1/2) ect. I also have a column for work hours. Now what I want to do, is if one of fields in the Paid Column is selected as Time & 1/2 then the work hours field for that day which is directly besides it, gets re-calculated to include the time and 1/2. If that makes any sense. Also on another note, in My database, I have 3 sections for entering in "what time I started" and "what time I ended", f…

Is it possible to hide the text on radio buttons? I'm trying to create a survey that looks like this with headers (with a few more options): Agree Neutral Disagree Question 1... O O O Question 2... O O O Question 3... O O O ---okay, the columns aren't lining up properly in the post; hopefully you'll get the idea. Instead of this: Question 1... O Agree O Neutral O Disagree Question 2... O Agree O Neutral O Disagree Question 3... O Agree O Neutral O Disagree Thanks! Using FMPro 11 Advanced

Hi, I have a database of client profiles. To make data entry easy, I used a value list and check boxes for one of the fields, "School". The values include: Sch of Med, Sch of Dentistry, Sch of Engineering, etc. It is possible that some clients have multiple school affiliations. What I would like is to be able to split the field into separate records, the same way you can split repeating fields into multiple records when you import them. My template is set up to make the report if I can split the field. Thanks

Hi, i have following four tables with their data 1) Table Name: years. Fields: id (Number, Auto-enter Serial), year (Text, Indexed). Data as follows 1 2003 2 2004 3 2005 2) Table Name: departments. Fields: id (Number, Auto-enter Serial), name (Text, Indexed). Data as follows 1 A 2 B 3 C 4 D 3) Table Name: Rel_years_deps. Fields: id(Number, Auto-enter Serial), year_id (Number), dep_id (Number). Data as follows 1 2003 B 2 2003 D 3 2004 B 4 2004 C 5 2004 D 6 2005 C In this table, the fields year_id and dep_id are pop menus showing all the values from years and departments tables,…

Dear Friends, I am working with a School project, and I am very confused while working on Fee Receipt layout. I want that if a student has deposited the fee for a particular month, then the Collection Department or Student should be not be able to recollect or deposit the fee again for the same month. For example, if a student has deposited the fee for month 'January, 2011', then Collection Department or the student should not be able to recollect ot deposit the for the same month again, i.e., 'January, 2011'. Therefore, I need your help in doing so. If someone having some solution regarding this, please let me know about it, and if pos…

I am creating a database for cars. In need to create to two drop lists. One for the manufacturer - say BMW, Ford, Ferrari Then when I select BMW in the second drop down list I can select 3 series, X5, X6, etc Hope I have explained myself OK but I am new to Filemaker. Thanks