FileMaker Interface Features
-
Hi all, looking for a bit of help and was wondering if anyone here could provide some answers! I have a columnar list, and with it I have summaries after several types of sorts. All of these summaries are to appear, and contain (basically) the same information. Obviously, if the sorts have a lot of data to work with, and some distancing appears, then I want to have each of these summaries appear. However, if I have just a single item, is there any way I can go about just ignoring summaries for single items? Thanks a lot! Jim
-
- 0 replies
- 865 views
-
-
Hi there - Fairly new to FM Forum but have used it in the past and you guys have been great in helping me understand where I was going wrong! My problem now is a 'letter' page written to clients that include certain fields from a 'main' overall page. Such as Dear 'John' thank you for your call . . . your quote is 'Quote 1' and the total cost is 'Cost1'. My problem is when I add the field 'client first name' how do I add a comma after his name?? Also when I have a 'project name' inserted and then need to insert another field such as 'on this date' how do I close both together without any gaps?? I've tried useing the 'slide' etc. but cannot get it to look like…
-
- 1 reply
- 851 views
-
-
Ok. I may be confused here so feel free to correct me. So far I've always used portals to show related items to the main one. This is all good and it works for me. Now I face a different problem. I'd like to have a portal of records from one database (like a list view) where items can be checked and then two addditional boxes in the same layout: 1.-A "detailed" box that shows all the stats for the selected item in the portal. 2.-A smaller list that shows the items that have been checked in the main portal. Example (fictional): I have an inventory database. I'd like for one single layout to show a scrolling listing of all possible items in the in…
-
- 4 replies
- 765 views
-
-
Is it possible to put buttons on the portal rows? I have them there at present, but they do not appear to be clickable. I have 2 portals to 2 separate files. 1 contains all records and the other contains a user selected subset. I need to button to 'add' from the all, and a button to 'delete' from the subset. Is this possible? Thanks
-
- 3 replies
- 927 views
-
-
Hi everyone, Can you help me with this one please? I am running a script from a button within a portal. this shows a dialogue box containing the contents from a related record (using Troi's Dialogue Plug-in) Two other very similar scripts (which are NOT activated from within the portal) work fine, and enable me to view both the contents of the dialogue box and an important field in the current file at the same time. My problem is that although the one running from the portal button shows the dialogue box with the related data in it, the contents of the field in the current file disappears until the dialogue box is cancelled. one clue that might be h…
-
- 5 replies
- 966 views
-
-
Hello everyone.. I have a easy one... maybe Setup: Tables: "Main", Policies" On the Policies table I have a field called status -- Active or InActive I wish to make a Portal on the "Main" table that can list all of the actives -- by there last Name. Can anyone help...
-
- 6 replies
- 835 views
-
-
I have a client that needs a patient health record system that has the ability to print out and store their client's health information. One of the problems I have run into is how to setup FM so that it will adhere to their rigid chart template. Can anyone point me in the right direction when it comes to designing single record/multi-page layouts? The multi-page layout is rather large (86 pages). Will FM handle this or not?
-
- 5 replies
- 1.3k views
-
-
Hello Everyone... Here is the situation... I have tables named: "Main", "Policies", "Beneficaries", "Premiums" The relationship between them is: Main has a portal on it that shows all policies relating to the customer Policies has many portals on it; 1 showing all beneficaries on it and 2, shows all premium information on it.. They all work well.. I have now tried to make a report that combines all of these and I am having some trouble.... How do I make a report that can show multipule lines... Let me explan a little better.. I have made a report that uses premiums as it informational start...this works well to show all the premiums f…
-
- 2 replies
- 708 views
-
-
Hello Everyone... I really need help with this one... Here is the situation: I have 2 tables: "Policies" and "Beneficaries" On table 1 "Policies" I have a portal linked to "Beneficaries" on this portal you can fill in name address etc... things like this... I have a contract that only allows for one beneficary at a time on it...SO if I have lets say 2 portal rows each one being a beneficary..Is there a way to print the same contract, but have it replace the beneficary each time it prints until there are no beneficaries left...there could be more than 2.. Help? Joseph
-
- 4 replies
- 726 views
-
-
Hi everyone... Here is the situation... I have 2 tables -- "Policies" & "Premiums" On the "Policies" table there is a Portal that shows "Premiums" relating to that Policy only. Simple so far.. I wanted to make a report that would print some policy information and all of the lines of the "Premiums" portal...(Only the ones which relate to the file I am on). Can some one show me how to do this or show me an example of a file that does this... Thanks Joseph
-
- 9 replies
- 889 views
-
-
hi i have a portal displaying related operations for patients, the operations are categorized and have a name, rather than display all possible operations i want to filter them by category so have 2 value lists within portal, one category and the other procedures problems 1. wont let me create new records 2. db tries to update info in category db, recategorizing procedures? solution i have checked relationships to make sure creation of records is all correct any help appreciated - db schema attached
-
- 1 reply
- 771 views
-
-
Hi, I've got a value list from a field, but when I update the field the value list is not refreshing ! Why ?
-
- 2 replies
- 786 views
-
-
Hi, I am trying to find out if there is a way to make a series of different value list pop-ups in a single record be drawn from just one related table using a conditional argument. Here's the scenario: Table 1 stores student records, including courses taken, which fall under different requirement headings, such as Environmental Biology, Chemistry, etc. Table 2 lists the courses, and one of the fields is a text code that represents the requirement that that course satisfies ("EnvBio", "Chem", etc.) What I would like is for the Environmental Biology Course field in Table 1 to be filled in a by a pop-up list that includes only those courses from Table 2 that have t…
-
- 2 replies
- 805 views
-
-
This seems like this would be fairly basic, but I'm really struggling. I'm making a photo database as a tutorial project. I'd like to be able to categorize each photograph in a record with a user-editable pull down menu value list (i.e. landscape, seascape, portrait, etc.). Then on a different layout I'd like to have a global preference field that offers the same category value list, but in the form of a check box entry that would allow multiple entries. Then I'd like to write a script that says, perform a find on the category field based on the multiple checked entries in the preference global categories field, and then from that found record list pick a photograph …
-
- 2 replies
- 838 views
-
-
Our users have been using my filemaker solution for 3 years without any changes. Now it's time for a change! There is now so much stuff going on in the database that I want to re-do the layouts. I was looking, in particular at the status area. Now what I would like to change is the rolodex-like section of the status area. I'm quite prepared to have a few buttons there, controlling the record navigation, but I'd like somehow to replicate the small button that can move users through whole sections of records, the sort of tab just to the right poking out of the rolodex thing. In its simplest form, I'd like my version to act as a visual indicator as to the c…
-
- 2 replies
- 1.4k views
-
-
I have a fp5 file where multiple users can access but depending on the password, i want to control which layout is presented to that user. Can anyone guide me on how I can accomplish this? TIA, Deo
-
- 2 replies
- 901 views
-
-
Hi all, I'ma relative newbie at FMP so bear with me if I'm not referring to things in the official FMP language. : ) I have a db (or is it referred to as a table or file here?) that has two drop down list. One is a list of our magazines, the other is a list of 2 letter codes of those magazines we use for various stuff such as file naming. What I would like to do is if an item in one list is selected then the correct item in the other list is then automatically selected. Any help would be appreciated but as I mentioned new to the FMP environment so please speak slowly. : )
-
- 2 replies
- 856 views
-
-
Dear Listmembers, I need your help. I am new in the FM and I am lost with one problem. I am making now a database for Art History Slide Archive where all the slides are sorted by their present location. I wish to do the following (and cannot find the solution): 1) First List - Country (choose one) 2) Second List - City - in this particular country (this list should change itself accordingly to the country chosen in the First List) 3) Third List - Collection - with all existing collections from the City chosen from the Second List (this list should change itself accordingly to the City chosen in the Second List). Meanwhile I've got hundreds of names for th…
-
- 1 reply
- 666 views
-
-
Hi all, what is the simplest way to do a count on a portal and how can i do this so that it can count via a certain value list? Thanks for any help Simon
-
- 1 reply
- 578 views
-
-
Hi everybody! I have an annonying problem I hope you pro
-
- 6 replies
- 1.7k views
-
-
-
I'm streamlining a database, and needs to put the data from several unique value fields (check boxes) into the matching checkboxes in one single value list. How do I do that?
-
- 0 replies
- 892 views
-
-
I have a database of Pages in a photo catalog, and images on each page. I need a report that has the page number in the catalog page number in the title, then the items that will be on that page in the body. I got it mostly done by putting the page value in a sub summary (when sorted by TempPage). The problem is that when there are more records for a page than will fit on one page, the second page does not have the page info at the top of the page. I tried putting page number data in a leading grand summary, but that just puts the page number of the first record at the top of the page and all data below. Also tried this with a blank sub summary. Can anyo…
-
- 1 reply
- 945 views
-
-
Hi, I learn that in FMP7 we can set up such that in the same record when user clicks out of the portal, the same records will stay displayed in the portal. I could not figure out. Any advised? Thanks
-
- 1 reply
- 684 views
-
-
hi there... i wanna have a pop up menu. the pup up menu gets it's data from a text box. well now, this text box hast MULTIPLE lines. it doesnt work by standard right? example: i want the pup up menu to show this value: -- Sunset Blvd. 45 78273 Exampletown -- since this text box has TWO lines, my value list (or the pop up menu) BRAKES this text box apart and gives me both SINGLE LINES. so i cannot let the list display BOTH lines at one time but only ONE LINE at one time. well since the address doesnt make sense if its only written "78273 Exampletown" i need the pup up menu to be MULTI LINE (according to how many lines are used in the value so…
-
- 1 reply
- 1.3k views
-
-
I remember seeing a tech note or publication somewhere demonstrating how to use a portal to show matching records for a search. It would display matches dynamically as data was entered into the search fields. I'm looking for a simple solution to search only first and last name and an identifier number, 3 or 4 fields. How is this done. I remeber the use of a repeating field with calculations for the data fields....
-
- 2 replies
- 984 views
-
-
Hi, Anyone aware of any existing font other than Courrier wich would allow a chains of text of same length to be formatted the same, notwithstanding occurrences of spaces or special characters ? Thanks The attachment may help understand the request, or find some other acceptable solution (may be 7 ?) Ideally cross platform of course. FlexiblePortal.fp5.zip
-
- 3 replies
- 1k views
-
-
I'm creating a text field which will generate a text flag via calculation that indicates all of the line items in my portal meet a certain criteria, (ie. "complete" status of related purchase order records from my related purchase orders database). I tried the following calculation but it is generating the text flag if ANY of the items meet the criteria rather than if ALL meet the criteria: Case(PurchaseOrders::POStatus = "Complete", "All outstanding PO's are completed") What can I change in my calculation, or what other approach can I use? Thanks!
-
- 1 reply
- 874 views
-
-
Hi, Since in layout mode FMP does not have any option to draw a tab view or stylist buttons I wonder if there is any software out there to do that. PhotoShop may be the one, but it is too costly. I just want to draw button or simple graphics for my FMP apps. ANy advised? Thanks
-
- 2 replies
- 1.3k views
-
-
Hi all: I'm just working on a project in FMP7, and find that a couple of my portals are displaying very strange behavior indeed. Every now and then I'll reopen the project and find that the fields in a portal are no longer defined correctly. The layout is right, but the actual field definitions have changed. Granted, I've been fiddling with some relationship definitions, but the changes only manifest themselves when I close and then reopen the file. I have yet to try to replicate this behavior on purpose due to lack of time, but wondered if anyone had seen this sort of thing? -Stanley
-
- 2 replies
- 791 views
-
-
I'm working on a database to store and audit profiles. From the text I import I want a layout with just profile name once where auditors can click on the profile and view new profiles. i thought about using buttons to reference searches however new profiles may show up at anytime. Is there a function similar to excel unique record in which I could script to show unique profile names each time I import new data?I appreciate the help.
-
- 1 reply
- 1k views
-
-
Hi. Attached is the database I am working on. It's buggy in that when the "printable layout" is chosen in preview mode, each merge field has an inconsistent amount of whitespace below (above?), despite sliding being enabled. Please take a look and any suggestions would be much appreciaied. Jeremy reup.ZIP
-
- 3 replies
- 1.2k views
-
-
I need to convert a paper flowchart system of asking questions to Filemaker Pro. This is for a family Tech Support. The system would need to be able to ask a question by the Tech Support. Then based on the answer (yes or no)another pop up will come up and ask the next question. Is this possible in Filemaker Pro? And if so then where would I start. I thought maybe it would start with a question database and then based on a checkbox answer to the question it would be related to an answer database. Help, I really need to have some family members help with my calls. Thanks in advance.
-
- 12 replies
- 1.7k views
-
-
hello everyone, i often copy all fields from my contact database records onto the clipboard to paste the data into emails etc., using the "copy record" script. because usually not all fields are filled out (home phone, work phone, home fax, work fax, etc.) the data appears with gaps once it's pasted into something else. is there a way to select all data from a record and have all fields appear on separate lines when pasted, preferably so that empty fields are ignored? so that someone with only name, email and home phone would appear like this: name email home phone instead of something like this: name email home phone…
-
- 1 reply
- 886 views
-
-
I'm trying to figure how to do a report.....that lists how many people are active each month. names.fp7 event name.fp7 event line.fp7 The event line has a date as well as a status field (on waiting list / active / de-activated). I know how to create a report listing activity broken down into months totaling how many people changed each status each month but not a running total of how many people active in each month. ideas please....
-
- 0 replies
- 900 views
-
-
Is there any way to trigger a script (or 'push' a button) via a field entry and then tab to next field. I know this hasn't been possible in the past - wondering if any advancements in V7. thanks
-
- 5 replies
- 1.2k views
-
-
I am very new to file maker pro 6. How do you set up different sorts for different layouts. Say one layout you want to be sorted by date and a different layout you want sorted by client name? Right now I can only do one sort for all layouts...... any thoughts?
-
- 2 replies
- 1.1k views
-
-
Howdy All: I have a relationship set up between two files in my solution. I am asking the users to do a fairly basic find of which the results are displayed in a portal. From this portal, i need to have them select one or two records that apply to the project they are working on, and have those records copy to a table where they can add more detailed notes and follow-up info. I have run head first into a brick wall on most attempts to make this fly. Any thoughts at all? Thanks Lakota
-
- 5 replies
- 893 views
-
-
I'm getting a little confused trying to make value lists based on calculations from a prior choice. Here's the deal: I'm trying to create a paleontological database. Organisms can be arranged within hierarchies (the Linnean system): Kingdom > Phylum > Class > Order > Family > Genus > Species. Here's what I want to do: I want to create conditional value lists based on these hierarchies. For example, when I choose Kingdom value "Animalia", I want all of the Phyla within that kingdom to be available as a choice in the Phylum field. When I coose the appropriate Phylum, I want all the Classes within that Phylum available as values in the Class …
-
- 6 replies
- 2.1k views
-
-
Hi All! I am a newbie, and currently having some trouble. I have a database with two tables, Clients and Orders, which have relationships defined upon the fields name and address. In the orders table I have a clients field, which operates via a dropdown menu with the values from the clients table within it (I have done this via a value list). Each client has a single address, which I would like to appear automatically in the delivery address box on the order form. How can I get filemaker to do this? Apologies if I've missed something really simple. Many thanks Adam
-
- 6 replies
- 1.3k views
-
-
Hi all: I've got this hideously difficult page-layout problem that I've been working with for quite a while now. The client has one layout for the first page, another for the last page, and a third for any pages that go in between. The body is a list of items, and I'm printing from the file with the data in it. What I've got happening now is that the user can enter preview mode & view a 1-page layout, or a 2-page layout, and see which one works. There is no option for a longer layout, because I can't figure out how to determine which record would go on which page. Each of the three layouts has a different amount of body space (due to different headers & fo…
-
- 13 replies
- 1.7k views
-
-
have a question. is there anyway to format information gather in a portal in a non-portal way (as a sentence):.I have a data entry layout that gathers information using a portal (it is for a sales department and when the sales rep is creating a bid for a custumer he creates new portal rows for each item.). in the report/print out layout, I have a portal that display the information gathered from the data entry layout throough a portal, but was wondering if I could get filemaker to display some of the information gathered in the portal as a [color:"blue"] sentence. (with programing languages such as C, I would either use an array, a loop or similar to give a new name to…
-
- 2 replies
- 824 views
-
-
Hello. I have a field "paperwork" that contains a check box value list. An user uses this to check off certain pertinent paperwork as it is received. She wants a report that displays, side by side, reports received vs. reports still pending. My question is: How do I create a field that will display items NOT selected in the "paperwork" value list? Here is a screenshot for your reference: Thanks in advance.
-
- 9 replies
- 1.2k views
-
-
Hi all, I am trying to create a portal with a flexible comment (text) field. For example, if you user type only one line, the portal would resize that row to display only one line of text. If the field is 5 lines, the portal displays 5 lines for the field in that row, while display differently for other rows. Does anyone know if it's possible to do that in filemaker? Thanks, Ha Pham.
-
- 4 replies
- 1k views
-
-
Can anyone please help me sort this out. I've got two related databases (Time and Time Line)...Time creates a daily time sheet for each employee and the related Time Line database records are generated via a portal in the TIme database for each time increment related to a specific job number. My challenge is that I need to have the portal rows sort by Begin time automatically when an employee enters a new portal line that could be for a time increment that's earlier than one that's already been entered. Ie. if the portal records are created in the following order, then I want it to automatically sort the 7:00a Begin time before the 9:00a Begin time. 9:00a - 10:…
-
- 7 replies
- 961 views
-
-
Hi I have created a simple bookkeeping database and want to have a monthly report for sales and purchases. The report should be broken into months with a total after each month. I have searched the accompanying manual but cannot find the process. Can anyone help? thanks
-
- 1 reply
- 1k views
-
-
Have you tried using merge fields? They will shrink in Browse Mode if no data exists.
-
- 10 replies
- 1.6k views
-
-
Is there a way to set different tab orders inside the same layout??? in a data entry layout I have different "sub-groups" of information (they are sub-groups because I have format it them to look like that, but there are all in the same layout/portal/database), and would like to allows the user to tab from field to fiels in that sub-group??? can anyone help??? (I'm probably not explaining my self very well, but hopefully someone out there understand what I mean and have some suggestions) [color:"blue"]
-
- 1 reply
- 882 views
-
-
I have a conditional value list of 5 fields that works fine in FM but not when published to the web. Will conditional value lists work when published to the web? Thanks, Mike
-
- 0 replies
- 738 views
-
-
I am using calc fields as containers to have dynamic buttons. My graphic is made in FM7 (simple figures using the rectangle, circle and line functions). When inserting this graphic into the Repeating container field used as the graphics "bank", my Calc field container displays a warped graphic. I've tweaked the crop, reduce and enlarge functions. I've changed the dimensions of the Calc field container and the repeating "bank" container field, all without help. What am I doing wrong? Thank's in advance. "It's never so bad that it couldn't get worse."
-
- 1 reply
- 1.1k views
-
-
Hi, I was wondering if anyone knew of a way to change the layout of a portal so that it laid out across as well as down. In other words, I have a layout with a portal into another file which is related via a code. The portal shows a container (containing an image file). What I want to do more than anything is to have this in a 4x4 format rather than a 1x8 (ie, I want to be able to display the images like thumbnails on a contact sheet. Is this possible at all? Thanks a lot
-
- 4 replies
- 802 views
-
-
Hi Simple question is there a way to highlight a row in a list? Simon
-
- 2 replies
- 1.1k views
-
-
Hello All: I am stuck here. I have two tables in my database that are direct imports from Excel data. I am trying to use one of the tables as a search form and have the results from the second table display for the users to interact with. I think I am looking for a portal solution, but im not sure. Any thoughts would be great. Thanks Lakota
-
- 6 replies
- 1k views
-
-
-
Hi, I have a field that is formatted as a pop-up list and displays values from a value list. Users are supposed to select one of the values from the drop-down menu; however, sometimes they type in their own values. How can I avoid this? If I create reports based on those values a lot of unknown/entered by the users values appear. I can't really use radio buttons because I have more than 20 values in the list. Is there any way to make users select values from pop-up list and at the same time not to allow them to type or modify those values? Thank you!
-
- 1 reply
- 929 views
-
-
Can anybody offer a hint or trick for printing 2 (of many) text fields sideways? I use FM to fill in the data on a pre-printed form which has recently been revised to include social security numbers along the left edge in a sideways orientation (so that the numbers run vertically along the edge, "top" to the edge). Only thing I could find in FM Help was for Asian text rotation--not a help. Any suggestions? I don't need to print this form very often, so even a clunky workaround would be welcome.
-
- 2 replies
- 1k views
-
-
I have portal only one row (scroll bar active but transparent) and I have buttons Next/Previous/First/Last to move forward and back through the questions in the portal (using script Go To Portal Row [...]). This works fine except the first time going to the layout - person needs to click NEXT twice before it works (understandably, I guess, since there was no 'previous.') But another problem ... Person needs to be able to edit the questions - access to each field - but every time I click on the portal (except specifically into a field) the whole thing lights up and tries to select. I have made sure all fields are set to just enter field and not select all content…
-
- 7 replies
- 984 views
-
-
I want to hide the horizontal and vertical scrollbars and the window header. Is this possible and if so how? I'm using FM Pro 7 on a Windows XP Home PC and the windows are being created with the 'New Window' script step in FM Pro 7.
-
- 1 reply
- 1.5k views
-
-
I'm working with two databases - the first "CustomerData" contains a portal to "ItemSales". CustomerData is customer contact information, billing address, shipping address, etc. ItemSales is purchase information So when I view CustomerData I can see their purchase activity from within the portal. My problem is: I'm trying to define a calculation field in CustomerData that returns the last InvoiceDate (the most recent one) from the ItemSales data inside the portal. For example if I have 3 sales records for a customer showing inside the portal, each record begins by showing the InvoiceDate field.... 1. 6/4/03, ......... 2. 12/15/03, ....... 3.…
-
- 2 replies
- 741 views
-
-
I just had my purchaser freak out on me after changing his layouts around... I changed the navigation buttons around, but he also hated the color. I'm just wondering what you guys think - I know it's not exactly pretty, but I wouldn't say it's downright ugly. As you can see from the screenshot, I use different colors for the main databases. It's not designed to be pretty, but functional.
-
- 28 replies
- 3.8k views
-
-
How do I set up a layout so that I can enter multiple records on one screen. I have a database where we enter sample records based on common data such as customer, address, date etc. Samples are submitted in batches of 10 so I need to be able to enter all the records on one page. The Customer Name etc fields will be common to all the records so as opposed to entering all the records on a seperate screen by creating a new record for each I would prefer for ease of entry to enter them all on the same screen. Each batch of 10 record entries can then be given a specific key field common to all the records on that entry for ease of lookup later when we come writing…
-
- 2 replies
- 1.5k views
-
-
I would like to have a table for all my icons and sounds, so that each record is an individual item. But I can not wrap my head around how I would call the resource up in a calculation. Currently I have resorted to creating a field for each resource. I have considered set portal row but that would be an extra object not clean.
-
- 0 replies
- 914 views
-
-
I'm curious to hear people's thoughts on how fancy to make the user interface graphics. For network speed reasons I use boring FileMaker graphics. --Mike Version: Developer v6 Platform: Mac OS X Panther
-
- 9 replies
- 3.2k views
-
-
I'm assuming these aren't possible. Say I have one layout with certain content, then I have a script go to the next layout. If I set the background colour of the second layout to transparent, presumably it just shows a white background, and not the contents of the previous layout. Is that a feature in filemaker 7? I'm assuming there aren't any plugins to change this as the FileMaker layout system seems a pretty integrated and hardcore aspect of filemaker. Is it possible? Just to save copying a section of layout objects into 20 other layouts every time I make a change. Thanks
-
- 3 replies
- 1.3k views
-
-
How can you show a field in a layout that comes from another unrelated database. I have a file with 5 tables, 3 of which have relational links to each other and 2 which are stand alone. When building a layout on one of the related tables I am allowed to add a field from on of the unrelatied stand alone tables. However, in browse mode the field says '<Unrelated Table>'. Why do they give you the option to add unrelated table fields but not show the data from them. I was under the impression that there had to be a related link to a table before you could view it's data (and add it's fields to your layout). Any ideas??
-
- 1 reply
- 1.1k views
-
-
I have a donor table with customer code, name, etc. When I'm entering donations, I start by entering the customer code. However, many people send in checks without sending in our voucher (on which is their code). We need to do a lookup on the name in order to find the code. I created a pop-up list that included the name field as a second field with the code, and sorted by the name. In FMP 6 and earlier, if you started typing the letters of the name, the cursor would pop down to that name in the list. With FMP 7 that doesn't seem to work. You have to scroll down and look for the name in the list, which is far less efficient. Any suggestions? Am I doing something…
-
- 3 replies
- 986 views
-
-
I'm confused as to why this is so tough, but I seem to be going around in circles with this dang conditional pop-up menu. I on the one hand have a movie database that has movies divided into "Current" and "Archive." On the other I have a theater database where I want to have pop up menus containing only the "Current" movies. Seems like I want to have a 1). relationship where I find all the movies, and then 2). a value list where I trim out the "Archive" movies. But I seem to be running around in circles getting either nothing in the list or all the movies in the list. Any help would be appreciated. Thanks so much...
-
- 2 replies
- 1k views
-
-
Morning all I am working in a db that uses a pop up list of customers in alphabetical order(about 50 customers) What I would like is to be able to go back to the part of the list I was working on rather than back to the start of the list which seems to be the default. eg if my last customer was called filemaker the next find would automatically return to filemaker rather than Abbacus which is the first customer on the list. I hope this makes sence and that some one can help? many thanks
-
- 1 reply
- 804 views
-
-
I wonder if anyone can help? I have tried to use the normal lookup function based on various relationship configurations to no avail. Looks like a portal is the way forward but I am not sure if you can use a lookup within the portal I have 2 Tables Table 1 Fields Sample No. 1 Sample Details No. 1 Sample No. 2 Sample Details No. 2 etc up to 10 sets Table 2 Sample No. 1 Sample Details No. 1 Sample No. 2 Sample Details No. 2 etc up to 4 sets In Table 2 the Sample Details field is set up as a pop up list based on a concatenated value list of all the Sample No. 1, Sample No. 2 etc records in Table 1. The list of matched return…
-
- 0 replies
- 736 views
-
-
I want to try and display a list but I notice that when you have it in list mode the data at the top of the list is fixed (relating to the record selected in the list). Is there a way to have a list and still be able to edit all the details on the top? Thanks
-
- 1 reply
- 1k views
-
-
Hi, I have a database where I would like to select data from a list box, the data in the list box is Small Medium and Large. When I select small I would like the db to auto enter the number 1 into another field. When I select Medium I would like it to auto enter 2 in the field. How is this done? Thanks for any help Chris. FileMaker Version: 7 Platform: Windows XP
-
- 2 replies
- 807 views
-
-
I use value lists mostly to have consistent input in various fields. (as choice lists in other words). I have two identical databases, both with the very same set of vlaue lists. When I copy a field to the 2nd database, the link to a particular value list does not stay with the field. . Is there a way to copy both the field and its associated value list to the target database... so that accessing the field brings up the same choice list as in the first database?? [email protected] FileMaker Version: 6 Platform: Windows 2000
-
- 7 replies
- 1.3k views
-
-
We have several houses, apartments, etc for hire. I'm preparing a dB to control the reservations. I have two files: reservations has the records of every reservation (datein, dateout, house, etc). The second file is the parent one, in which I have a portal. the relation is one to many by the field house: then I can see the reservations for a single house. I would like to filter this portal in order to see only the reservations for a period of time (actual month, three months, or from one date to another). I've been thinking in a calculated field like: housename & datein & PM & housename & month(datein) But whan if the date range doesn't match wi…
-
- 6 replies
- 934 views
-
-
Hi everyone, I am trying to highlight an overdue tasks on my portal. This is what I have so far. The name of the task has a calculated value: Case (Get(CurrentDate) - T_DUE_DATE > 0; TextStyleAdd(Red(T_NAME);Bold); TextStyleAdd(Black(T_NAME);Plain)) Red and Black are custom functions; They do work. Now here is my problem. If I create a task and I entered the due date and that due date is prior to today's date, The task is colored red. For all those tasks that were entered prior and show a due date prior to today, they are ignored. If I go back and reenter the same date, they change the text color to red. I am beginning to think that tomo…
-
- 2 replies
- 780 views
-
-
hi all I'M TRYING TO GET THE OMIT RECORED'S LIST IN THE PORTAL ( 10 ROW'S) BUT CAN SEE THAT I GET THE LIST LIKE - 10 TIMES 1th REC THEN 10 TIMES 2th REC AND SO ON . thanks for quick answer RUB FileMaker Version: 6 Platform: Windows XP
-
- 0 replies
- 773 views
-
-
In FmPro 6 .... When Creating an index on a text field for relational purposes, filemaker indexes the first 20 characters of each word or the first 60 characters of the key, so when you might be concatenating two (or more) words, you can exceed the 20 characters per word limit, but if you put spaces between the words, you are likely to run into that problem and you get each word in your index. So if we put spaces between the words, the 60 characters limit is the only problem for use bigger key in our relation. Did anyone know what is the limit in FM Pro 7 Is same or something bigger...? FileMaker Version: Dev 7 Platform: Mac OS X Panther
-
- 5 replies
- 1.1k views
-
-
Is it possible to format all my newly created fields to make them larger and to have them all spaced a certain distance without having to adjust each field? I know, it is a novice question, but this novice is on deadlines. thanks d FileMaker Version: 7
-
- 1 reply
- 1.1k views
-
-
When I was learning to set up portals last winter, I remember stumbling across a setting for a portal that allowed the rows in a portal to be columns instead (vertical vs. horizontal). I can't seem to find where that setting is. Does anyone know how to do that, or did I dream it? Thanks FileMaker Version: 5 Platform: Mac OS X Jaguar
-
- 2 replies
- 826 views
-
-
Hello could someone please tell me if it's possible to hide fields. Thanks. Chris. FileMaker Version: 7 Platform: Windows XP
-
- 4 replies
- 1.4k views
-
-
I have a long (I guess you can say a "Letter") that goes so far that FM6 does not have any more room left...but I have 10 more pages of print that I need to print with the orginal letter...How many options do I have. Best case for me would be to make FM6 handle more on the same layout... Second Best for me would be to make FM6 auto print the other letters when I print the orginal one. Help.... Thank you FileMaker Version: 6 Platform: Windows 2000
-
- 4 replies
- 1.4k views
-
-
I want to know how to make a Report for any date range with Starting and closing balance. The data base is having debit and credit entries entered chronologically and having running balance. Please help me out. FileMaker Version: Dev 6 Platform: Mac OS X Panther
-
- 0 replies
- 1.1k views
-
-
Does anybody know how I can bring up the LAYOUT DROP-DOWN MENU with a keyboard shortcut? It a pain in the butt having to reach for the mouse simply to invoke this menu. FileMaker Version: 6 Platform: Mac OS 9
-
- 3 replies
- 1k views
-
-
Just got my copy of FM7 Dev this past week--moving all the way up from FM3--which didn't have portals (I think they arrived in v. 4?). I'm beginning to figure out some of the "ins and outs" of portals (pun only partly intended;), but I have a lot of new stuff to figure out here. Since there are no FM7 books on the market yet, would a FM6 vol. be useful to learn the portal system? Or have there been substantive changes in how portals work in v. 7? If so, any recom. on what book might be most helpful? I know FM3 fairly well, and though 7 has a familiar look and feel, I'm discovering just how much more is hidden under the simple interface. Thanks, Decker FileM…
-
- 2 replies
- 949 views
-
-
Please help -- I am sure this will be amazingly simple for some of you out there but I can't get my head around how to do this. I have a file (basic version attached) which parses a block of text into the individual words it contains (each word is made a separate record). These records/words are then sorted and a count of the occurrences of each word is shown by a subsummary. What do I need to do to show the words sorted in ascending/descending order of the number of occurrences [can't sort by summary field?] rather than by word order? Thanks in advance efen FileMaker Version: 6 Platform: Windows 95/98 Parse.zip
-
- 1 reply
- 1.1k views
-
-
Here's an interesting tidbit: In FM7, you can edit fields that are in the Header and Footer sections. Very useful for working with lists. FileMaker Version: Dev 7 Platform: Mac OS X Panther
-
- 0 replies
- 940 views
-
-
Hello everyone. Little problem I'm having at the moment. I'm trying to 'lock down' a solution I've made by removing the status area. I have proper navigation within the solution. Whenever I remove the status area, the text I have within the header area gets.. 'changed'? It appears with the upper half of the text removed. If I put the status area back, the problem disappears. This happens to the text regardless of positioning within the header, regardless of header size. Can anyone shed any light on this? Is this a bug within FM7? FileMaker Version: 7 Platform: Windows XP
-
- 1 reply
- 938 views
-
-
I have 2 tables in a database. There is a relationship setup between the tables using a key field value which uniquely relates the records between the tables. I am trying to set up a relationship/value list between the records as follows: Table 1 Key Field Value - Used to link the records information Sample No 1 Sample No 2 Sample No 3 All the sample numbers are identically formatted Table 2 Key Field Value - Lookup from Table 1 to link the 2 records togther (this I have achieved and it works ok Sample No. This needs to list, as a Value List in a pop up menu, all the values in Sample No 1, Sample No 2, Sample No 3 etc in the record lin…
-
- 2 replies
- 913 views
-
-
No doubt this has ben covered before, i can not find the thread. I want to create a valuelist of which the second field (not sorted on) is a summary field. Obviously, this second field can not be indexed and fm says it will not work. Does anyone have a workaround on this problem. FileMaker Version: 5 Platform: Mac OS X Jaguar
-
- 1 reply
- 706 views
-
-
Hello, My company has decided to recycle the excellent FileMaker solution we have created for one of our projects for use on another similar project. (We are a publishing company and we use FM to handle invoicing, ad tracking, proofing, collections, etc). However, I have to make several changes to our Invoice layouts, issue names, and so on, enough that I think the best way to do it is to make a seperate version of the same database using FileMaker Developer (to rename the files from the current solution) and FileMaker Pro to save new cloned copies of the files. I then reset all of the serial-value numeric fields across all of the files in our solution (all 45 of …
-
- 3 replies
- 1.2k views
-
-
Hello everybody, I have a problem regarding sorting by different fields in the same DB file. After I created a second columnar report (with some summary calculations by a different field than the initial sorting field), I noticed that I have changed the sorting order of the entire DB file. So, my question is, if it possible to have different sorting orders in the same DB file, to sort the records by different fields for different layouts of the file and how could I do that? Any help/suggestion would be very much appreciated. Especially quick ones... Alin Popescu FileMaker Version: 5 Platform: Windows 2000
-
- 1 reply
- 833 views
-
-
FM breaks the object sliding capabilities found in earlier versions. If you have fields that span multiple pages (such a descriptive text fields) you could set the height of the fields to be say 3" each then place them on a layout (some of mine went 6 pages) then set the objects to slide up with "reduce the size of the enclosing part" set on so if the user did not write much in a field it would shrink: most of my pages when they printed would be 1 page long... occasionally 2 pages very occasionally 3 pages. In FM7 these pages print only the fields that appear on each page
-
- 4 replies
- 1.4k views
-
-
Hello, I am trying to produce a time sheet report, and I want it to look like this. Client Name Sunday Monday Tuesday Wednesday Thursday 4/11 4/12 4/13 4/14 4/15 ABC Company 0 2 6 8 8 XYZ 0 6 2 0 0 Totals 0 8 8 8 8 It seems I can not get the report to sort correctly. The name of the layout i…
-
- 9 replies
- 1.7k views
-
-
I am a beginner on FMPro, setting up a portal to view related records in an inventory from a related file. The records and the fields I specified show up OK, but there are no scroll bars at the edge of the Portal. I can click where I think they should be, and the records precess, but its almost like there are two sets of hidden bars as they skip around. I've only been using it for 2 weeks, but the manual is so paltry, I can't figure out what I'm doing wrong. Thanks for any help! GWilson FileMaker Version: 7 Platform: Mac OS X Jaguar
-
- 2 replies
- 743 views
-
-
Is there a way to MS word to have my reports in and print with the correct information in them? FileMaker Version: 6 Platform: Windows 2000
-
- 6 replies
- 1.4k views
-
-
Hey Everybody, hopefully I'm not repeating a post b/c I looked around but I'm trying to figure out exactly how to use a script to find the sum of some displayed figures... Basically our database is set up for donators of which you can view the history of each particular person or company via a portal with the pertinent information. Basically, I want to write a script for a calculation field found underneath the portal that takes the Amount field from each donation instance in the portal and sums them up and places the grand total in the calculation field "Total". Every script I have tried just adds the values in a horizontal fashion but we need it to go down the l…
-
- 4 replies
- 844 views
-
-
I have a portal that hold a subject line and a date line...they are lined by the company name. Really a call log that I made. All I want to do is have the most recent date (newest entry) show up on a differnt form and maybe a report. Is there a simple way to do this. FileMaker Version: 6 Platform: Windows 2000
-
- 3 replies
- 711 views
-
-
Hello everyone, Can anyone help me with an annoying layout problem please? My solution includes an auditing layout with a number of printed questions (of varying length) in a "shrink to fit on printing" field (A) on the left with a corresponding empty box for ticks on the right (. Is there any way I can get the empty field (: for the ticks to correspond in length when printed to the field containing data (A) without the user having to manually enter carriage returns in ( to match the number of lines entered in the first field (A)? Many thanks for your help CJ FileMaker Version: 6 Platform: Windows XP
-
- 1 reply
- 897 views
-
-
I must say I adore FileMaker for providing an intuitive, functional arrangement for Tables, Fields and Relationships. And the ability in Relationships to display nothing from the Table Occurence, only the join fields, or everything (providing a cute scroll arrow at the bottom). I don't display anything on them so they remain compact and only expand to work on certain ones as needed. It is so easy to create, modify and simply develop in such an environment. It took a bit getting used to but now I wouldn't want to design any other way. I am daily amazed at the power of 7 and I must constantly rethink my FM understanding (from prior versions) for scripts, calcula…
-
- 1 reply
- 1.2k views
-
-
I have two tables, Visits with a record for each patient visit, VisitCharges with many records for each charge for that visit. I have a relationship with the VisitID to the many VisitCharges (VisitToVisitCharges) and a portal works great to show all the charges for that visit. I then have a selfjoining portal from Visit to Visit that works great to show each visit in a horizontal fashion, each column shows one row and has a differing starting row. I then created a VisitToVisitToVisitCharge relationship. My problem is when I place the portal with the VisitCharges in this VisitToVisit portal, nothing shows. I believe I have the relationship correct because when the fie…
-
- 2 replies
- 874 views
-
-
I hope this is the proper forum for this: I have a simple sales report. Each line item summarizes the sales activity of a given dealer. There are no Body parts in this report. The summaries are sorted by dealer, then by total sales -- best performer at the top. Viewing the sorted report in Preview mode, the report works perfectly, with one maddening flaw. When (and only when) there are more than 500 to 510 records in the found set being summarized, the TOP dealer on the report shows incorrect summary totals-- Switch to single-record Browse mode and the correct totals are displayed! But go back to Preview mode and these first-summary totals are way smaller-- bu…
-
- 1 reply
- 1.1k views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online