Layouts

Hi Guys, I'm running a system that involves switching between two files. If I've got a window from another file open in the background, how can I tell filemaker to select that window, and select a record then run a script on it?

Basically, I am trying to create a punch list for portions of a job that still needs to be completed. The fields I need are - Date Notes Item 1 Item 2 Item 3 Item… the number of items will change depending on the job. But there will be a setup layout to input all Items before records are created. I would like to use check boxes or radio buttons for Items If 3 items have the same date & notes I need to create 3 separate records with one commit button. How can I do this? I hope this makes sense. Thanks in advance

Any way to scroll a text and not let user edit?

Not sure what topic this belongs in but here goes - I have an application that displays questions that need to be answered (not user modifiable). Next to each question I have a radio button set so that a user can select the answer they want and it generates a numeric answer. Some of the questions in a record can be blank. Right now I am using conditional formatting to make the blank fields disappear and a gray text box that covers the radio button if the field is empty. This works, but is kludgy because filemaker leaves ghost lines around the field when any field is selected and when in the radio button set you can select the hidden radio button if you click in the em…

Hi there, I'm working on a billing statement, and I'm trying to sort something out. On the "Account Terms and Conditions" portion of the statement, it shows the late payment interest rate. If the rate is an even number, for example 24% it displays correctly, but if it's a rate like 22.75%, the decimal place doesn't appear. I've tried changing fonts to see if the decimal place wasn't a recognized character in that font set but it does the same for Arial, Times New Roman, etc.. The field it uses is specifically for displaying the interest rate in examples like this Account_InterestRate = 0.2275 Account_DisplayRate = Account_InterestRate * 100 = 22.7…

Hello, I'm using filemaker 10 and I'm trying to get fields to show with quantities. I don't think that makes sense so here's an example: I have a field called products. In this field I have: apple apple apple orange pear pear Is there any way of getting that to display as: apple - 3 orange - 1 pear - 2 or something like that. Thanks in advance

Is it possible to customize layouts so that a particular field size can vary? I'm creating a layout of meeting attendees that displays names, titles, and biographies. Some biographies are much shorter than others, so when I preview the layout there's a huge amount of white space in between each person's listing. I want to be able to tell the layout to adjust the 'bio' field size according to how much text is in it so that each bio is positioned right under the previous one. At the moment I have a very weirdly spaced document.

I think for my problem there is no solution but maybe I've overseen something. Is it possible to get dynamic labels in the tableview? Why? I'm trying to create a multilanguage solution. Almost everything is multilanguage now. only the table views aren't. Is there any way to control names of the labels?

I am a bit confused on how to create a layout with either regular field or a merge field that will expand, even into multiple pages. I am creating a letter function that will allow the user to type or paste the body of a letter into a global field and then print for each record in the found set. I am using a simple layout with just a body part so far. Please Help...

This is a bit difficult to explain, so much so I'm not sure if I have posted it in the correct section. But here goes. Whenever I click on the screen to deactivate a record (click outside a field). The program automatically does a sort of 3 to 5 records. This seems to be indiscriminate of the number of found records and it happens every time I click out of a field. I am wondering if this has something to do with how I have stored the fields but I would appreciate any help. I Hope this makes some sort of sense.

I have a list layout for printing with a header,a body and a footer. Now I would like to duplicate the layout and ad a Fax cover page for faxing. I tried extending the header part down to add the fax cover above the other information. But it won't except the header being larger than the first page. Then I added a Title header for the fax cover and the moment I add the tittle header part my header no longer prints. What am I missing?:??????

Everytime I close my database on my inventory layout it crashes filemkaer completely closing all my other databases. This layout has alot of fields and I dont know if there is a limit as to how many fields you can have in a layout? Or any ideas of what else causes filemaker to crash from closing a certain layout?

I'm working on a database that is used in a production environment. One workstation in particular, is notorious for having 50+ FMP windows open, because they won't shut the windows when they are done with them. Is there a way to lock users out of background filemaker windows, until they have dismissed the foreground window?

Background: Payment Detail Table >- Payment Table >- Payor Table -< Product Group Table -< Client Table also: Product Group Table -< Product Table The troublesome layout is based on the Payment Table with a creation-permitted portal to the Payment Detail Table. Within the portal is a drop-down field for Product Number with a value list based on the associated field in the Product Table. I've tried setting it to "show all values" and "show related values starting with..." (I've tried multiple tables). At best it will display the values from one Product Group (always the same Product Group) for a total of five Product Numbers (no scr…

Hi all, I just started with Filemaker and have been able to find answers to most of my questions, but I can't seem to find one that quite fits this one. I'm creating a packing list for order shipments -- I have several fields that may or may not contain data. I want to put these fields on the packing list as just a line of data with a "," in between each piece of data. I can list all the fields on the packing list but if there are fields that are empty, then I have a bunch of spaces and carriage returns. I want to remove any empty spaces and put the "," in betwen each field that does have data - hope that makes sense. example: field1 = " labo…

Ok I have been using Filemaker for a long time for my own stuff. I have other people starting to use my stuff, and now I need to learn about formatting screen resolution. Can someone give me the gist, perhaps a sample script?

My NAV buttons first/left/right/end buttons work fine When using Mouse Wheel my layouts aren't changing?? Using the RecordRquest/Page Previous GO layout1 or 2 etc RecordRquest/Page Next GO layout1 or 2 etc RecordRquest/Page Last GO layout1 or 2 etc RecordRquest/Page First GO layout1 or 2 etc

Hi All, Okay, by hook and by crook and by kludge, I have made FileMaker print out most any kind of report I have ever wanted. However, it is always "just" a Chapter in any FileMaker book. Where there are several books on some pretty ubiquitous (and IMHO less effective) reporting tools disambiguated from an orderly, repeating arrangement of atoms and molecules. I am at a juncture where I need to "put it all together" where I have Statements by FamilyID where one or most student may be on a single statement, where the header should be for column continuation and the footer is for page numbering, and the title header needs to fit in a window envelope showing …

How do I go about forcing users to use a drop-down list instead of typing in the field? I have a drop-down with six different K9 breeds and of course spelling is important because of some of the searches I have scripted (and of course I have people who get happy fingers and type too fast and misspell). I do not want to use a script trigger. Any suggestions? Thanks, Jim

For a module that generates text overlays over two superimposed picture container fields (one = background; the other a half transparent PNG image) I want to be able to change by script the alignment settings of my Text overlay field on a specific layout (using for instance its object name). I may have overlooked a function or workaround, but till now it seems to me that this not possible. Suggestions (also for plug-ins allowing this) are welcome...

We have a strange situation in FM 10 that we have not encountered in previous versions. Windows environment, server host, 25 users. A user logs in using an account that has restricted privileges – can view layouts but not edit; can create, edit and delete in some tables; run scripts; view lists, menu commands set to all. When the user runs a script to produce a multi-page document, the script pauses in preview mode for inspection but the page arrows are dimmed out and are inactive. The same report for a user with full privileges will pause with the page arrows enabled. A user who has the highest levels for data access and design but not the pre-defined full…

Using Filemaker 9, I have a calculation that summarizes data based on date and and a dollar amt to determine a sales persons commission. For example, if the salesperson books between 13 and 20 loads the sales person gets an extra $25 a day. I have that working fine: Case (GetSummary(Total Booked; PU Date) ≥ 13 and GetSummary(Total Booked; PU Date) < 20; 25; 0) It finds a salesperson and sorts by date & puts the subsummary at the bottom of each date correctly. But I also want a grandtotal, so at the end of the week it adds up each of the days. The problem is the summary field doesn't add it correctly because now it's doing it over. Am I missing something? I…

Hi all, I have a complex summary report I need to produce. I do not want to report on the underlying data, just the summary. The data is made up of a lot of related tables. At the moment I've created a script which essentially searches for each component of the report, populates a set of variables and concatenates it into a text field. The problem with this is I need it to get a bit of eye candy to go to a client. i.e I can't do columns, nor appropriate tabulation in this format So my question is this, in your experience, what is the cleanest, best practice to produce these sorts of reports. I can do HTML, but do not have the knowledge of XML, an…

Hi All, Here's my situation. I have a button to print fax or email an invoice along with several checkboxes for other documents that we may wish to include. For instance there is a checkbox to include a thank you letter (This is a jpeg copy of a signed letter in a container field) or we may wish to send a price list, etc. The way I have it set up now is by using multiple layouts each with a different combination of desired docs. So If I want to print an invoice it goes to a layout with just an invoice. If we want invoice and Thank You letter it goes to a layout with both the invoice and the thank you letter. Invoice, Thank You and Price List, yet another layout. The …

I am almost embarrassed to ask this because it seems so simple, but I cannot figure it out after searching the forums or poking around in the database. Basically I have a field that contains a price value that data entry users have to fill in, however, I do not want read-only users to be able to view this field. Is there a way to have that field hidden to them as described above? Is there a way to create a separate layout that different only privileged users can view? Conditional formatting based on privilege? Thanks in advance.

I have a report that shows client payments. I have a sub-summary that shows the total of the payments. Say i have 4 client payments, this report shows 2 payments per page in preview mode and I can print them o.k. If I put the sub-summary field at the top under the header it shows the total of the four payments correctly. (I need it at the bottom) If I put it at the bottom beneath the body it goes onto a third page with other records. it shows the correct total though. This is driving me mad any ideas?

Hi all, I have searched the forum without finding answer to my doubt. I am setting up an invoicing system with FM10, and I have two tables, one with orders and one with line items. I have set an input layout where the user inputs in a portal the line items for each order. Now I am setting up a print layout, the idea is to print a table with all the line items of a record. The table should be dynamic and show as many lines as the line items in the order. I think that the idea is to put column names in the header and than line item fields in the body. Unfortunately it shows only the first line item. How can I obtain what I am trying to do? Thank you…

Several days... My label routine parent table1 with a cDataID field structure as calculations[50]= Case( GET(calcualateRepetitiveNumber) , Extend(LabelsQty); Extend(Data1) ) Looking at this table-1 calculation field and comparing it with a working example that works.. they both react the same, repeats the field depending on LabelQty I think problem is on Child side or the label layout or creating process.. I am making a new layout using Label instruction dialog I have tried all kinds of combination... and label 5160 including Data1 field etc until i am sick in the stomach not repeating i have create a layouts sets with some m…

My database uses a job Number which is incremented by 1 every time a new record is made. My boss uses the "Duplicate record " from the Filemaker menu to duplicate a record. When you duplicate a record it adds the next job number to the duplicate record. My boss wants to make a duplicate record with no incremented job number. Any Ideas?

Hi All, I'm creating a project management database where the relationship structure is Category (parent), Project (child), ToDo (grandchild). Each category is a record, each project a record, etc. For sake of navigation, I'd like to create a grid layout where users see what is essentially a "home page" grid of categories (categoryName fields are all that need to be shown), 6 across and an infinite number of rows down. Users click on a category and are taken to another grid of projects that belong to that category. They can then click on a project to see details and todos etc. I can make the navigation work if I forget about the grid and use the list layout. But…

This is more of a user interface question, but I was wondering what most of you do with a delete button in a portal. Do you place it on the left or right side with-in the portal? Are there any interface guidelines out there that show people prefer a certain side? Some of my portals also have a go to related record button as well as a delete portal row button, and when I had them together that went over like a lead ballon as I can see now it is to easy to click the wrong one.

I can't figure out why when I try to move layout objects all the way across the layout with my mouse, I cannot place them very far to the right. I can slide these object with the arrow buttons - but I cannot place an object past a certain point with the mouse. Any ideas?

Hey, As you may know you can Freeze pain in Excel, where a selected row of cells stay on screen as you scroll further down the screen. Is it possible to do this with a header in Filemaker? I would like the page navigation tabs to always be in view. Would this also effect print out of records? Any advice appreciated! Mark

I am pretty new to FM but I have created a database that contains three tables. 1) Client list - name, address, etc. 2) Task list - date and work done, 3) Fees - invoice number and charges. I created an invoice layout with appropriate client name and invoice relationships between three tables - one invoice/client with all tasks listed by date with charges. It works fine. Except, some tasks require a longer description than others and portals evidently don't slide to eliminate the blank space inside the description field but keep the set number of lines. Naturally the question is "How do I remove that blank space?" Thanks.

Hi there everyone, I'm starting to explore the wonderful world of Filemaker. I'm trying to create a specific report. Here are the details. I'm trying to create a report of a list of numbers per category per location by date. So if I look up a specific date, I want the report to first list everything grouped in locationA, then in categoryA, but list out every number. Then repeat by categoryB and so forth. I've tried changing the amount of columns, and that sort of works, but I would like a cleaner look with each sub-summary and result all on one line instead of each being on separate lines. I hope this makes sense. Thanks for your help.

I have a row of 12 buttons, each of which finds a set of records. When I click a button, it momentarily changes color, but I would like it to remain a different color when the particular set of records is found, so that the user knows which set is operating. I have set a conditional formatting for the button to change the color of the button and text, but am not sure which formula to apply. I figured a variable to toggle the button on and off using Abs ($$color -1), but this only applies to a single button. What I want to do is loop through the other buttons and turn them all off when the button pressed comes on. Does anyone know a script which does this?

Hi, I have 2 fields Time_from and Time_to. They are both time fields. They are formatted as 24 hour HHMM. when you click on the fields they show the time and the seconds and I can not get rid of the seconds, any ideas?

Help with Merge Field in the body of a letter I'm very new FMP10, teaching myself from "The Missing Manual" I have a merge field that shows the info from some records but nothing in others (in Browse or Preview modes) I've tried all I can think of. I would be glad to send the DB if need be. thanks raustin (Rich ...

Hi, I'm having a small problem trying to resolve a puzzling language problem. How can I create radio button set which change language depending on the user settings? I attached a file to show what I'm trying to do. PS I know there is a problem with attached files so click the link to download the file. http://www.mediafire.com/file/n4wuykjyezm/Languages.zip Thanks

Hi everybody, this is my first post here as I have just recently landed on FileMaker. I am trying to develop a simple program that my mother will have to use for her job. Basically she will have to input several fields in tables and then she should be able to use those data to: -track orders -generate invoices I have some knowledge with MS Access but I am looking into FM as I am using a Mac and she is using a PC, plus I would like to make somehting graphically more evolved than Access. The structure: Table 1: client contacts (name, address, email...) Table 2: client order numbers (name, order number, order date) Table 3: order detail (order…

Let me try to explain. I have 3 Tables called - "ContactManagement";"AssetManagement";"ServiceManageMent". All tables are related to each other based on ID: (equipment) and Contact: (Full Clients' Name). My issue is with the layout I call "Service_Form". On this form I have several fields for typical help desk stuff but 3 fields I want to populate via my example. They are: [color:red]ID; [color:red]Asset; [color:red]Serial;. I have inserted a portal that relates to the "Contact" field that lists all equipment assigned to the [color:red]"Contact" that is pulled from the "AssetManagement" table. Ok. . . so this is what I am trying to do. . . In the port…

Hi, Is there a way to copy the tab order when I duplicate a portal? The problem is I need 4 portals since the data needs to be disp-layed horizontally. Each portal is a copy from the first one, except for the shown record. The tab order doesn't follow the same order as the first one. Thanks for any help

I'm running into formatting issues when copying layouts and then trying to resize the body part of the layout. For some reason Filemaker sometimes decides that it will not let me drag a part size to the same size that I have on another layout. While this is a minor issue, when navigating between different layouts that are relatively similar, it's very annoying to see things jump around because a part isn't exactly the same. Is there a way to specify an exact part size in Filemaker? Whenever I click on the part to resize it I can see its size the status window, but as soon as I unclick it I loose the ability to specify the size.

I'd be most grateful if any of you could tell me of a way to disable the right-click/copy mouse option in Filemaker 6, so as to prevent people from copying the images in the container fields of a layout Any method that prevents unauthorized copy/paste would be welcome. Sorry if this has been answered elsewhere, but I've been checking and couldn't find it. Regards

Hello. I am working on a filemaker database for a small sales team that keeps track of contacts, companies, projects, and leads. Most projects start out as a lead. In other words, some leads turn into projects, but most don't. My client wants to keep track of projects and leads on separate layouts. Since projects and leads share 90% of their fields in common, and I need to be able to easily convert a lead into a project, it makes sense to have one table called "Projects" and a boolean field to specify whether or not it is a lead. Then, once a lead graduates to a project, all that needs to happen is a change of that boolean value. I have a Projects layou…

I'm a filemaker user/developer with a small 3 Mac network which has been running without issue for years. I upgraded a machine recently to a new Imac Intel core 2 duo (as I do every couple of years) and as per usual, transferred all applications from the old to the new machine including FMPro 10.0v3. On the new machine FM launched OK and opened the FM application on a linked machine but most (but not all) of the portals are not working (only) on the new machine. In Layout mode on the new machine none of the field names are visible. In the portals on the new machine there are dotted outlines where the fields should be and double clicking these will correctly open linked f…

Oooo-kay, here I go again! I'm working on an expenses db currently. For report purposes, I want it to look like this: [Category] [sub-category] [individual entries] . . . (etc.) [sub-category] total: [total by sub-c.] [next Sub-category] [individual entries] [next Sub-category] total: [total by sub-c.] (and so forth... followed by:) [Category] total: [total by Category] (and then at the very bottom:) Grand Total: [total of all items] I'm attaching the db in question, so some smart person can take a look at it. The thing…

Hi Guys, Im creating a merged letter within filemaker, is it possible to create 'conditional' lines of text without having to introduce another field which does the calc for you. Im thinking along the lines of - if(field value = "M") then display "Male" as in the text....and I'm trying to avoid creating unnecessary fields in FileMaker to do this as its only used for report purposes. Thanks Jalz

I am having a difficult time getting a multiple page report to print out via a script. My goal is to print 3 separate pages; a dynamic fax cover sheet, a second page containing order line items, and a static page containing pre-created text. So far I have got everything that I need working up to 2 pages by fiddling around with the title header, header, body, and footer parts, but I am unable to get filemaker to print a 3rd page. Admittedly I don't even know if this is the right way to create a report like this, but it was working very well up to 2 pages. Any ideas?

I have a Microsoft mouse that scroll wheel moves my records in Browse any clues how to fix this other than disabling my mouse

Anyway to load watermark images in the background and keep multi column printing? I need it to fill the entire body. If I just enlarge the image, then I just get one record per page. And if I use a portal that works fine, but then I get half the watermark in each column. I guess the question at this point is if there is a way to make a graphic fill the entire page when using columns or if there is some other way to create columns where I can have a background image span the two columns. Or do I really need to use Word to do this... FM9 advanced. Thanks, -leo

Hey. Not sure if this is the right place, but as a "learning as i go" user, i wanted to share a tip that i had to learn the hard way... I have a database setup which works great for my needs. I was trying to write a script to run on all the computers that use the database...some Mac, some XP, some Vista. All was fine until Vista. The short story is that the script would not work on Vista no matter what i did. It wasnt until i realized that my date used in my script was being pulled from a global date field, however the field type was set as TEXT, rather than DATE. This caused the formatting of the date to not jive with the rest of the fields being called in my scrip…

Is there a way to change the color of an object (a button in particular) in a script?

Not sure where this one belongs, so here goes. I have a storefront file, and in the register part, upon checkout, I have a dialog box that pops up at one point asking how much is being paid - normally it's the whole bill as one payment, but let's say you want to pay part in cash, then the remaining on your credit card. So what I have done is when the dialog box pops up, the total remaining due (whether the whole bill or what's left to be paid) is in the entry field, and highlighted. That way if you are paying the full amount due, the clerk just hits enter, or they can just type in the partial amount. That part all works great, but the problem is I can't format…

How to number pages in preview mode in Filemaker ?

Two clients, (multiple users, similar solutions) have reported this problem beginning a few weeks ago. We have FM 8, 8.5 and 9 users with this solution as well and so far, no report of this problem. A user will be typing in a field and the cursor will suddenly exit the field; subsequent keystrokes are not entered, no other field is selected. The user must click back into a field to resume entry. It is described as the keyboard freezing or the screen freezing but a click in a field or on a button seems to reestablish focus on the FM window. I don't believe it is a slow screen redraw issue because it can happen in a screen that has been open for a few minutes. There ar…

I have a database with many layouts: 1. is there a way to sort the layouts? 2. is it possible to edit the layout numbers? I also found the very helpful layout file from 'genx', would anybody know about an updated file of his version? http://fmforums.com/forum/showtopic.php?tid/181969/ Cheers Greg

After upgrading to FMP 10, I started noticing that the fields would lockup on me in Layout mode when I tried to move them. The fields are unlocked and un-grouped. This behavior is only visible on our PC systems and not the Mac's. Currently we have a Mac Server hosting to a variety of PC's and Mac's, and the operating system for the PC's includes XP/Vista/7 and all exhibit similar behiavor. Does any one have a solution for this? Thanks in Advance for any assistance. Byron

Hello, Is there anyway to print a list of the field name on a layout (not the whole database)? Thank you.

Hi, I'm working with FileMaker Pro v10. I'm back mucking around with it after being away from it for awhile. I find the text or data in the cells easier to read if there's a little white space between the edge of the cell and the beginning of the text. I figured out how to go to Layout Mode, then Format > Text > Paragraph and then specify an indent value. So the leading edge now has that lovely little sliver of blank space before the text starts. However, (and this is not a huge deal, just frustrating because I keep thinking there *ought* to be a way to do this), I haven't been able to find a way to do the same with the vertical spacing. I see the Line Spacing secti…

Not sure where to post this. I have an annoying feature/bug that I can't figure out. I have a FM10 DB shared on one computer. On the remote computer when the DB is opened, the FM window is small, narrow, and off to the right side of the screen. (Used to be the size I wanted on the left of the screen.) I can resize it, but next time I open the remote file, it's back to small and on the right. I've rebooted both computers and trashed all the FM preference files I could find on both computers. Nothing makes a difference. Any idea where I can find that setting and clear it? Any help would be appreciated.

This will sound strange, but I am looking for a dev platform that I can allow the end user (of a runtime solution) to move or resize fields on the layout. This would be kind of like a simplified report writer. I have written a DB project in FMPro 8 before and am familiar with it, but wonder if there has ever been anything that can create an on-the-fly customization tool. (am willing to upgrade if need be.) Any thoughts would be most appreciated.

Please bear in mind that this may be a stupid question but I'm going to ask anyway. I have a series of invoices that I currently have displayed based on due date, then by invoice number, finally the items per invoice as below, the invoice date and Invoice number are in one table, the line items are in another related table. 01/01/2009 (this is in a subsummary part) Invoice #12345 (this is in a second subsummary part) Item1 (these are in the body) Item2 Item3 01/05/2009 Invoice #12345 Item1 Item2 Item3 I would like…

I don't suppose there's anyway to have custom-shaped buttons. like if you wanted a map of the 48 states with the area of each state being it's own button. I'm surprised that filemaker made that pretty impossible. (so i'm wondering if there's any chance that there's a way i have not discovered) even, if there were a way to group lines, and make their shape into a button, but there seems to be no way, because the only the actual lines would be buttons, not the shape.

Here is my issue. We got in a new laptop that has the number pad on the right. When I am in a field and number lock is off and I hit the enter key it works great. If I turn on number lock and hit the enter key it will tab to the next field. I wish it to ad another line. I looked at the behavior and only tab is selected for moving to the next field. Thanks Thom

Hsppy New Year and thanks all for your help, especially yesterday! I have a field that has a calculation on it that looks at a field and then copies the contents into the field so that I will hopefully be able to use it for printing labels. The calc code I used was: If (AF1L1P1 = "YES" ; AF1L1N1)& If (AF1L1P2 = "YES" ; AF1L1N2)& If (AF1L1P3 = "YES" ; AF1L1N3) etc... The problem is all the text copies but leaves no spaces inbetween. I would like a line break inbetween the text. Is this possible? Thanks all

Hi, Thanks for the previous help. I'm almost there now!! I want to have previously entered data on fields for all of my records. I thought I could use the auto-enter data option but this only works on the fields where I have just put the conditional formatting. When browseing the remaining fields remain blank. Any ideas? Thanks

Hi, It seems an easy task but I've been going around in circles!! I have a radio button with "yes","no" and "working towards"(WT) I would like the text color to change in another field if yes, no or wt is pressed.(I'm using fm10) Thanks all.

Can anyone lend a hand. I am trying to make a report that uses two tables. I have a table called “visain” and table called “cashout”. What I am trying to do is track the visa card (who turned it in and who cashouted it out. Sometimes the card comes in and gos out several times. Each card has its own number.

I created 7 tables for an invoice management solution. I find the seven layouts. But, only the primary key and Fk fields appear on the layouts. Why do the other fields like First name etc do not show in the Customer layout? M K

I have tried and find very useable Mikhail Edoshin's approach to cross tab reports. I get the report in preview looking the I want, my problem is I don't want it in Preview [i have no interest in printing]. What I want is to see the whole thing in browse mode on a particular tab. Using Edoshin's approach I get only the last row of summed data. My question is: How can I show the whole array on the tab [i am using years as rows and months as columns with performance % in the fields]? I want to see each year and each of the corresponding month's performance.

Hi All, I am wondering if anybody encountered an issue like this. " I am using global container fields to hold interface graphics and as soon as I exit the solution... all of the graphics in the container goes away!" I am lost with this and have been searching for the answer for days with an obvious answer of no success. Help! Allan :

I'm trying to do something like OP in http://www.fmforums.com/forum/showtopic.php?tid/179306/ What I'm trying to do is have a footer that appears at the end of every page. I want the footer to contain a "Comments" field as well Total$Amount. I want the "Comment" field to appear on every page but I want the Total$Amount ONLY to appear on the last page. Like the previous post, I'm trying to make a container with a white image and another as transparent. On a 3 page order, for example, the white image is over "EX_sLineTotal" on pages 1 and 2. However, on page 3, it is transparent and the "EX_sLineTotal" is visible. I'm having NO success. Any help? Plea…

Hi everyone, I'm trying to develop a medical database. My problem is: I' m trying to make a field about the status of smoking. Ex: Do you smoke? Yes (if yes nothing will happen) No (if no another field containig 2 other radio buttons and a text box will apear next to "no" button) How can I apply this trick to my database. Thank you.

Hi, Is there a way to adjust the height of the rows in Table View? It's easy to adjust column width, but I can't find a way to adjust row height. With my previous databases, this hasn't been a problem, but for some reason with this database, the rows are very tall (the text is at the very top and the rest is empty space). Why would this be? Is there a way to correct it? Thanks!

Does anyone have an easy way to set up breadcrumb navigation in FileMaker 9? I would like to have something that would be similar to a basic web browser but in a FM setting. Basic Forward and Back. Histroy would be a bonus but not necessary. Thanks, Eric

Hi.. I am trying get the content of my layout to fit the resolution of my screen. I have build it in the highest resolution. I have achieved to make the screen fit to the size of the screen, but not the content. Thanks for any help in advanced!

How do I SPEED UP the changing of text color and other characteristics? In a page of text, I want to change the color, then make BOLD, every 2nd, sometimes 3rd, line of text... without messing with the ones in between. This means I have to triple-click the line of text, then turn change the color, then turn it bold. Doing this to 12 or so lines on a page makes it take a minute or two. I'd rather simply position the cursor, then call up a script (e.g., Cmd-4), but I can't see how to do this in a script, though I've looked and looked. Any clues for this non-programmer? Many thanks in advance...

HI i want to know that in layouts there is a line between the mid of the layout.that line suggest that the part that is on the right side of that line will not come in preview mode.i have tried so many times to extend that line but unable to do so can u tell me how to resolve that issue.

I have a field on a layout that uses a dropdown list to select an account name. The dropdown uses a related table to populate the dropdown list. This table includes the account name & account # for each account name. I want to be able to select the account name from the dropdown so it can be entered in the account name filed of the record & have the corresponding account # automatically entered in the record's account # field. Is ther a way to accomplish this without a button? Can it be triggered in some way? I have FM Version 9 Advanced.

I have just started working with FM10, so please excuse my newbness. I have imported several tables from CSV files downloaded from Survey Monkey. The goal of this database is to easily import CSV files downloaded from Survey Monkey that will automatically calculate the statistical data. The CSV files that Survey Monkey gives you are: Collectors (gives the survey title and a unique CollectorID for each survey) Respondents (gives a unique RespondentID for each person completing the survey) Questions (gives each question a unique QuestionID) Question Options (Gives each option for each question a unique OptionID as well as the text for each question option, and…

I've made several form letter layouts where the user could add variables to pull info from the different recipient's records. Usually this involved creating a button for each variable with the basic script step to add text to the body of the letter such as "". From here there would be a second "body" field that would look for any variables in the text and substitute the correct field data. However, here is a way to save a lot of work. And get this, it uses a repeating field. As you can see in the layout.jpg I placed a global repeating field in the layout with enough repetitions to hold however many pre-programed variables I wanted to make available. I gave the user a…

Hey guys, I have a value list assigned to a radio button field, but the values or text I have displayed in it is lengthy. A user would have to use the scrollbar to scroll across the page in order to read the entire text, that is if I extended the field the full length of the text. In Filemaker I noticed it will not wrap my fields to the next line if my field is too small, however, with IWP my text does wrap to the next line just as I would want it to. My database will be used through both IWP and the FM Program. I have both Asian and Roman Line Breaking selected under File/File Options/Text. I've also tried to change my font smoothing settings in windows…

Hii, my name is Darlan. I'm a very new filemaker pro developer. I want develop a system for a business of my family, but i don't know how to start... I like to know how to do a menu in header for every layout, without use command c and command v ... Sample. _______________________________________________________________ | | | Menu | | | | …

I am creating a layout for a resume for print. I am having a problem with the work experience. Some people only have had only one job and some people have had 4 jobs, and so on. When i made the layout i have added all the work experience fields. There is a total of 5 experiences. If Joe had 3 jobs, I only want the first three work experiences to show up, if Betty had only one job than only the first experience will show up, etc. This has to be done by omitting empty fields and a conditional formating but i am not sure how to do it. I have also a language section, training/schools sections, and many more. When all of these are on the resume it takes up 4 pages(there are ov…

I feel as though this should be a simple problem, but I can't figure it out. I would like to replicate the "New Request" button which is on the Status Toolbar in Find Mode as a button on my layout. (I'm creating a Find Mode layout for my users.) Eventually, I'll also want to recreate the "Delete Request" Status Toolbar button and create a button which creates a new OMIT Request, but let's start simple. Any help is welcome! I'm relatively new to FileMaker, though, so the simpler the better! Thanks!

Is there any way to use conditional formatting on the colour of the tab box? I have a tab box with several tabs, and would like to colour a tab 'Green' if there is data in a particular field in that particular tab, to indicate that this tab contains data and should be looked at. The Conditional Format box is greyed out when I click the tab background in layout mode, but there may be some other way of doing this.

I am very new to filemakaer 9. I want to copy a Mappoint 2009 map into a container in filemaker that is 200x217. When I copy the mappoint map into the container it is too zoomed in and does not show the entire map that I created. I have tried to manipulate the map by using microsoft picture manager. I can shrink it down but the map becomes too blurry and is unsuable. Any help would be great.

I designed a generic layout in which users can perform a find with various criteria. I would like to display that criteria to them in the header so when they print out the results it includes how they found them. Any Ideas on how to do this?

Hey guys, Is there a way to create a dynamic layout with sections that expand and retract according to how much information is present? We create callsheets for jobs so people know when they have to show up, who's who on location, etc. There are categories like Talent, Clients, Camera, Props. The number of people who fall into these categories change with every shoot. In our Filemaker database you can assign people to a job, now I want to create a layout that fills up with everybody name with everybody falling into the correct categories, one for Talent, one for Camera, etc. Ideally these would expand depending on how many names fall into that category for a spe…

I have a weird problem that I'm wondering if anyone else has come across. I have a layout in LIST view show 500+ records. In the header I have drop down boxes that when selected will alter the found set of records. Ok no problem. If I move the scroll bar down the page the drop down boxes stop working and I can't select them but if I move the scroll bar up to the top again the drop downs work. Am I going crazy or what? This is happening on a windows platform (XP Professional). Anyone have any ideas? Thanks.

Hi there I'm just a beginner in FM and new to this forum. I don't know if this is the right section for my question... I've created 2 databases: one is called ClientInfo and the other is WorkOrder. Easy enough... They're both linked with common field k_Client_ID. On the WorkOder layout, I have a Customer box which will list the Client name, address..etc the usual stuff. I need 2 similliar boxes: One for Billing Address and the other for Shipping Address. How can I accomplish this? My second question: How to define a button that will open a database (or table)on new window? Better yet, how can I embeded in the drop down menu (Like Add New Client...) Thanks you all …

Is there a way of making a layout read-only regardless of user permissions?- read-only to everyone. Via scripting or conditional formatting? Thanks,

Hello, is possible to show near a editbox a icon (ex up arrow) if the value is too higth and show another image i the value is too low (ex. down arrow)? help!!!

I've placed the line on the right side of the column on the layout in order to visually separate the columns; it appears on the first page just fine, but not on the second (and succeeding pages). It doesn't seem to matter whether I have title heading and heading or not. Nor does setting the sliding/printing seem to affect it; the record ends properly at the end of the page, etc. Mysterious.

I tried to sum the problem up in the title, but to make it clearer. We have helvetica as our default font, and regularly copy/paste text from other programs into FM. From the web/word/pdf etc. We would like the pasted text to adopt the default font but currently we are pasting the text with the font from the original text/document. Is there a setting or method for consistantly / easily adopting the default font upon pasting? Many thanks, Brendan.

I'm new, so forgive me if this is too simple. I have 1 table called PEOPLE. Each Contact has a required "category" field (Child, Student, College, Adult). I have a layout for each category, because I want to display slightly different fields for each group. I want to make sure that each layout only EVER shows people from 1 category at all times. I've been able to do this on a basic level. Where I run into problems is when I want to Go To Related Record. For example, I have my people related to each other in a FAMILIES table. I have the family relationships showing up in a portal on each layout. There is a button on each portal row that directs me to the rel…

Question: If have a lot of fields without size limit. Now I'm looking for an option to show the user the whole content of these fields without giving access to modify the content. If I disable Browsemode I can't scroll down the field, the scrollbar is also disabled -( Any ideas?

Hi, I have a project database that handles quotes for construction tenders. The way I need it to run is that we have one project(parent table) with multiple clients(child table) that we send it to. The problem I have is with the layout for the report where I want to replicate the report once for each of the clients showing their contact details but the remainder of the report (with sections, section items, and item components) stays the same. My tables are similar to this Project (Project No, Project Title) | -Clients to send it to (Client Name,email etc) | -Sections (Section Name) | -Section Items (Item Name, Qty) …

I have a student record keeper, main table is name, etc., and related daughter table is assignment name, date, and score. I have a layout that lists all current students and those names are linked by GTRR to a layout that displays the name and below that is the related table that will show all assignments and a grade total. I switch to Preview Mode to print. Sometimes I wish to print a student's records only for a particular month. From that screen, how might I be able to query the user (me) for the number of the month (or month and year) and restrict the displayed records of the currently displayed student to that? I have been doing a "manual" search but it is tedious.