Layouts

I have a field that is a "pop-up menu". It has a value list assigned to it. The field is also set up to "include 'other...' item to allow entry of other values" Are there any functions/scripts that can help manage the "Other"? This is what we would like to do: When a user selects Other, we want the field to show: "Other - " We know some users will be lazy and not put the "Other - ", or misspell it, or not follow format. Any way to do this? Thanks in advance.

I just upgraded from Filemaker v5 to v8.5. on some of my layouts they are not printing. So I went into Layout setup, tab Printing, and i'm getting this error: "The selected value must be in the range 0.000 to -420.000, inclusively." after clicking "ok" the cursor is on a box, so I try to change it. the error pops up. I try to change it into the range, error pops up. I try to move to another box, and the error continually pops up, even when I click OK. Attached is a picture of the error. I have a feeling it has to do with the upgrade. Anyone got a fix for it? There is a complex fix. I can NOT duplicate the layout, the problem goes with it. I have to ma…

Hi I have Company contact information page which as a portal that shows a list of personal in that company I want to recreate an pop up window which has Logs of phone discussion I have had with them. I can make the window pop up and show all the list but I can seem to developed the script to change the layout so it only shows the related records of that personal and also the ability to add a record also with the script The Pop up window is set up as an Columnar list/report The attached is a screen dump show the script I have set-up It would be great if any body has any throughs on this Cheers Damian screendump.pdf

...or something? I am new to Filemaker and these forums. I'm using FM Pro 8.0v3. I've got a layout issue I'm finding I need help with. It's a report which is sorted by a company division, then a person, then resources under a person's area of expertise, logically similar to the following: Division I ---->Person A --------->Resource 1 --------->Resource 2 --------->Resource 3 ---->Person B --------->Resource 1 --------->Resource 2 Division II ---->Person C --------->Resource 1 --------->Resource 2 ---->Person D --------->Resource 1 --------->Resource 2 --------->Resource 3 In any…

Is it possible to change a background field by calculation. For example a menu list you choose a color and the background of a textfield changes colors? Thanks TMAS

One of my FM DBs won't let me enter data. I go into browse mode, try to click a radio button, and nothing happens. Help!

Well, looks like this will be my last problem in this solution. So I have set all the fields on the layout as follows: Allow entry only in Find Mode, and allow the Tab Key to go next object. This is so the users will only be able to find results, not edit them. However, again, even though I've checked and rechecked them, three of the fields when the user *attempts* top enter the field, gives a dialog which says: "This action cannot be performed because the required table is missing." I have checked to make sure none of the fields has been set as a button, nor any graphics nearby. Two of the fields are simple edit fields, the third a checkbox field. Any…

I am pretty new at this, but I have built a few small databases for various personal groups and projects. Currently I have a database that looks great in layout mode, but when I go to Preview (and when I print it) there is a large band of blank space between the body and the footer (both have patterned backgrounds) and the pagination does not print fully, as it is too low on the page. I cannot make a footer "slide up", and I have tried to adjust the size of both body and footer, to no avail. I have searched the Help, but found nothing that helps. Many thanks for any advice.

I have a database of all the books I've ever read (dorky I know). I have a table that has all the covers (actual pictures) and the titles. What I would like is a...well I guess a form that displays all the pictures (say 5 rows across and how many ever down) and when you click on them it takes you to that record in the main book list DB. Can it be done? Thanks gang!

Hi, I have a set of fields which vary greatly in terms of the amount of text in each filed. I have set each field for on a print only layout, and have resized them big enough to accommodate the largest amount of text any record has. Each field is placed one directly above the other, and each field has a field label to the left. I then set all fields and labels to the same setting in Sliding/Printing: Sliding Up based on All Above. This works perfectly for all the other fields and labels, but for some reason, one label "Credits" seems to not allow the next label to slide up -- or maybe that one isn't doing the sliding. Anyway, I have checked and re-che…

I know this isn't possible "natively" in FMP, but I'm wondering what the best way to fake it might be. Within a portal, I need to vary what field/control type is displayed. This will be based on a categorical field in the related table. Basically, for each record in the portal I'll need to hide one control and show another. For some portal recs, I want to show a drop-down list. For others, I want to show a checkbox group. In no case will I need to show both for a single portal row, and I want if possible to show up in the same horizontal position. I could think of a number of ways to do this if I were working with a single-record layout instead of porta…

I am an artist and professional photographer who uses Filemaker to keep track of the editing and printing decisions behind my final prints. In the record for a given image, I have a sequence of 10 fields in which I log the major editing moves I make in Photoshop, and they contain entries such as: "Contrast layer, overlay blend, 20% opacity." Because the editing sequence is unique for each image, it doesn't make sense to organize these as Drop-down lists. At the moment, I have a text field in my entry layout in which I have the 20 most used editing moves available for selective cutting and pasting. Is there a way to make that text field available to all new records? Better…

Hey, is there any relatively simple way to have a layout show a graphic and/or text only when in Find mode? It's easy to get something to display in Browse but not Find mode, but I'm looking to do the opposite. I never figured ou a great way to do this in FMP 5, but I'm hoping there's a way in 8. Thanks!

I am an experienced developer, but new to FileMaker. I have two questions that I may need a bit of fairly explicit instructions to figure out how to do: 1. I want to set up my application so interface components are in one .fp7 file and tables are in another .fp7 file. My purpose in doing so is so I can more easily distibute interface updates, by simply replacing the client's interface .fp7 file, while keeping their current data .fp7 file. (On rare occasions, I may need to update the table structures and this would not work.) How do I do this? 2. If I have two .fpy files and one has a layout in it that I like and want to incorporate in second .fp7 file, how…

Ok. I've only spent a day trying to figure this out, I have 2 tables: Customer Table Field 1 = Name Field 2 = Cust Key Transaction Table Field 1 = Date Stamp Field 2 = Transaction Type Field 3 = Amount Field 4 = Balance Field 5 = Cust Key Field 6 = Summary Amount (Total of Field 3) I am trying to print a report (previewed layout) that will print 1 line item per customer per day. 1. Cust Name (sort) 2. Beginning Balance 3. Total of Transactions 4. Ending Balance I can get 1, 2 and 3. I can't get #4. In my report, in order to only print 1 line per customer, I am using a trailing summary in place of the body. I do n…

I don't want to put the descripton of the fields name e.g. "First Name" above, below or to the side of the field, is there a way to get it to appear before the user clicks on the field and then disappear with the users inputs the information. I think this is like a mask but i can't get it to work, I have been searching the forum without any luck. I have a limited amount of space for the look and feel that i'm going for. Thank you.......Tina Marie

This has happened a couple of times: I have a report with body, sub-summary, and trailing grand summary. A calculation field has been defined. The calculation sums the values of another field in a related table. 'calculatedField=sum(relatedTable::otherField)' The calculation field is summarized in a 'total of' summary field. The calculation field displays properly in the body . The summary field is correct in the sub-summary, but the summary field in the grand summary is wrong. The grand summary is wrong in both browse and preview mode. In one case, after setting the parameters for the calculation, the grand summary total self-corrects i…

I wish to recalculate a primary keyfield for a relation according to which of the tabs the user is on - it seems to be imposible to place invisible buttons on top of the tabs except the chosen, where it makes less sense. Is the solution to utilize http://www.onegasoft.com/tools/smarttabs/index.shtml ontop of an invisible (font's and outlines identical with background) tabbed system where the tabs is stuffed away in the upper rightmost corner, and put it entirely under script control ...or am I missing something?? --sd

I have a text field which contains the availability of particular films on the internet. Some of these are also just brick and mortar locations. I'd like to be able to format the URL's to internet locations as "links" to be able to have users click on them and go to that page. Is there a way to do this? Thanks All My Best, Jeffrey

I am designing a print layout that is orginized by Contact ID records. I have a seperate table that contains phone numbers. For each Contact ID record, I want to display the related records from the Phone Numbers table. I would prefer not to use a portal with sliding settings, because as far as I can tell, an emty entry line apppears below the bottom portal record. The portal takes up too much space, and I need the contact records to appear as compact as possible. For fields that are within the Contact ID table, merge fields have been the best for a simple and compact layout. Is there a way to insert a merge field the will display related records from anothe…

I have created a report that has a portal within. I set the portal to 1 to 30 records. Most of my records have less than 30 records for the portal section. Is there a way to have the report print only showing the populated records within a portal?

Question says it. I'd like a button to open a new window of a different layout than the one the user is currently on, but of the same database. Is there a way to do this? nm. Found it. All My Best, Jeffrey

Hi, I'm pretty new at filemaker and I am having troubles with scripting. On my 'Main Menu' layout I have 3 'menu buttons'. Each button is a general category of the 3 areas of the database. Each category has different layouts depending on what you want to do. What I want to do is when you click a 'Menu button' a set of 'layout buttons' will appear. The 'layout buttons' will re-direct you to a layout you select to add records. Example: 'menu buttons' = production, quality control, and inventory. 'layout buttons' for inventory: view inventory, edit inventory, add inventory ... 'layout buttons' for production: orders placed, stock on hand ... …

Hi, FMP Fans! I have a Table that contains a date Field, among others. Whenever a new record is created, the date automatically fills this date Field. I would like to create another layout that shows how many records were created today and for each day of the past week or two. Preferably, this would look like a bar chart. How can I create this layout?

Hi, Hopefully this will make sense and be easy to answer. I am creating a schedule in FM for our employees. Due to the nature of our business, there can be any number of employees on for a given shift (from 1-20 people), as well as multiple shifts per day. I would like to set everything up like a spreadsheet, each person in it's own field. I would like to have, by default, 4 spaces for personnel with the ability to add more as necessary for that particular day. I was thinking along the lines of a button to add another row and a button to move to the next day. Another option is to automatically have one blank field following the full ones, and when that is f…

Hello oh mighty ones. I have a layout with a portal. The portal shows 2 occurences with 2 fields each. How can I make sure that ALL occurrences of the portal are printed? IE if theres 5 I want all 5 on the printout... Can it be done oh powerful ones? Spongebob

Hello! My colleague cut and pasted some data into my database. This means that I have some data in my default font, and some in a weird font from the internet. Is there a way to unify the font across all the records in my database?

Hey everyone, I am creating a quote output for my customers. Is there a way to make a "boundry" line vertically across the body to seperate different fields. It seems like it would be pretty easy but I can't get it to work in preview mode. I eaither can't get it to cover the whole space or it will not show up because some of it is not in the body. I know about the Set/Sliding Printing, but it seems to only be able to slide upwards. Slide down?

can users of a developed filemaker file make his custom reports that have grouped and summarized any way he wants, is there any sample likes this? database has 10 tables, each table has 40 fields, and fields can be combined and make many reports with grouped data from any other fields. 400 reports must made, if developer wants make reports himself.

Can anyone tell me whether it is possible (and how to do it, of course -)) to insert links into a FMP database that then bring up a particular point in the document. At the moment it's a word doc - about 25 pages long with explanations of the rather technical clinical terms that crop up in the database and it would be very helpful to provide a 'help' button next to these terms to minimise frustrations on the user side. I've looked at inserting a container field but can't see how to get to a particular sentence in the document. Any help/ suggstions would be gratefully received. (I'm using FMP-8.0, by the way) Many thanks George

Hi you guys no clue yet about IWP access has no access to files referenced in container fields ? please a help would be nice! tanx palomendes

Hello does someone knows how to avoid the presentation of those records not acessible to user, after a privileges verification. I need that the user only gets the found set of the records he/she can access after the privileges verification. tanx

HI, I am trying to put together an inventory solution that handles unique and non-unique items. The items are computers with unique serial numbers but have non-unique attributes such as family, model, memory size , hd size, processor speed, condition grade, and operational status. The unique computer records will also have child records of the parts INSIDE that computer which might need to be repaired, or exchanged with a similar part. The child part records are also unique. I need to show the origin and the end-disposition for each unique part: for whole machines that would be origin=Purchase Order number, and for end-disposition=Invoice number. …

First, hello to the forum. I have a problem and not sure this is the right place for the post but I'll ask anyway :. I have a database wich stores traveling info needed for expense tracking, it has: no., date, name of the person who travels, costs of the trip, dates of arrival and returning, etc. There can be many such forms throughout the year. In my country we have to submit a summary of all these forms in several sheets of paper at the end of the year. So what I'm trying to accomplish is getting all those records to print like so: page1: header, 25-30 records, footer page2: header, next 25-30 records, footer and so on... What seems to bother me is…

improvments over the network a shared network directory in a separate server, permits file references to files in that folder, and the Filemaker clients can access the files. But in the browser using IWP still no access. Can you help on that Gurus. tanx palomendes

PLEASE HELP is there a way for users to see and get the files linked by reference incontainer fields. Till now from remote client access over the network or by IWP i find no way for users to get the reference files, normaly pictures in my case. tanx to all palomendes

Hi All. I am new to the filemaker world and would appreciate any help received. I have a layout as follows: Entity -State/Prov --Vendor1 Total_Payment --Vendor2 Total_Payment --- TOTAL_PAYMENT_PER_STATE -State/Prov 2 --Vendor Total_Payment . . Enitity 2 -State/Prov --Vendor1 Total_Payment --Vendor2 Total_Payment --- TOTAL_PAYMENT_PER_STATE -State/Prov 2 --Vendor Total_Payment ...and so on The form layout is using the vendors table which enables me to get the vendor, state/prov, and entity which is then sorted by entity, state/prov. T…

Hi, I'm new to FileMaker. Is it possible to reference an image from the web? In the table, there's a PhotoLink field and a PhotoContainer field which is a calculated value from the link. I haven't found a function doing so and I don't know how to use Insert_Picture to place the picture in the container. I'm using FMP8 advanced. Thank you for your help. Nick

Helvetica has always been the default font for Filemaker. Is there a way to change this default?

Hi dumbo question (its the simple things in life that are challenging): I have a layout with a header that has my "Navigation Buttons" that you need to navigate my app. The Body has the fields. The navigation buttons are set not to print thru the sliding/printing dialog. When I print a record, a large gap is now left on the paper at the top where the header is. Nothing is in it as i told the nav buttons not to print. Question: Can I avoid that gap, ie not print the header at all? Thats what I want if poss without creating a special "print layout" without the header because I actually have 40 layouts like that. Any ideas? Can it be done oh master…

I have a scheduling_table::Instructors, scheduling_table::time and scheduling_table::date_calc (dayoftheweek) scheduling_table::time is 26 time slots from 8:00 am to 8:30 pm in 30 minute increments for each day of the week. Not all instructors are available for each time slot for any given day of the week. I would like to create a limited value list for scheduling_table::Instructors defined by a particular time value in scheduling_table::time and scheduling::date_calc (dayoftheweek), so that at say 8:30 on Tuesday, Bill is available, but not at 9:00 on Tuesday because Bill indicated this in instructors_table:: .... I know I can use calc fields to…

I have two lines of text on a layout, both containing merge fields. When I add a tab stop to the text, it affects the text alignment of other objects on the layout. Has anyone else heard of this problem? I've tried creating a new layout, with same result. Also tried doing a recover. Using 8.0v3 Advanced on two different computers.

Sorry I do not know where best to post this. Also I have done a search but not found an answer to this one. How do I stop my users from using ctr-tab to flip between available windows. TIA Phil

I tried searching for this but came up empty so I appologize if this topic has been discussed already. Is there a way to disable a users mouse wheel to "scroll" through the records in layout mode? I can see that it would be very easy to accidentally change the record during data entry. Any help on this would be appreciated.

We have several Databases, (Orders, Contracts, Engineering Tickets, Contacts, Quotes) We have buttons on the main screens for every database layed out. The problem is, There are too many buttons, valuable space is wasted on these buttons Currently, I have removed some buttons for performing finds. And created a field, that the user selects a drop down of what they want to find, and press "Find" Issue is, thats an extra step i do not want for these main database buttons. I want to know if I can create a popup field. that when the user selects the name of the database, a script running in the background will perform the selection. Without the user p…

Just winding down a FM project. The idea is to spin it offf as a stand alone application PC & Mac. So, after doing all the development on my Mac, I tested it on the PC. Looks terrible. Seems the PC doesn't come out of the box with Helvetica. The entire interface is helvetica.. Arrgh! Is there a best choice for a font that works cross platform? Can I bundle some helvetica font with an installer? I'm sure I'm not the first to run across this pothole. Any hints? Please? Many thanks in advance! -jim lee

Is it possible to move a field to another table after its been created and assigned to a certain table? The reason I'm asking is because when I made the current database I'm using, I just put every field in one table, and now I'm wondering if it would have been more prudent to divide my fields into several tables. (Right now I have like 85 fields in one main table).

I'm creating a 'standard' set of buttons to go on all layouts (navigation, return to menu etc). In the past I have simply added the graphic elements or images to each layout. However, on this particular project some users will be viewing the database (as a Filemaker client) over a VPN link, hence speed is a major factor. If I use global fields to store the graphics and use these fields as my buttons, will this increase the speed for the users? I guess what is mean is, does Filemaker 'cache' images in much the same way as a web browser? Anyone else experimented with this and have any test results to share? Thanks

I would be grateful for any help/suggestions from all the afficionados out there. I've just started using filemaker and am making my first layout. I'm trying to make a button within filemaker that will link to a powerpoint presentation that's also on my hard drive. Is this possible? How can it be done? Thanks so much for any help.

I have a Contacts Database that I have several different Layouts for data Entry. How can I make a specific Layout be assigned to default for a certain record? For Example if I use Layout #2 when I create a record, when I open that record in browse mode, I want it to open in Layout #2. HawkLA

Hello, I wasn't search which forum section to post this! Here's my question: Most Dell mouses nowdays come with a small middle "scroll" section, that allows users to easily scroll through documents. However, in Filemaker this can cause BIG problems. For example, if you are inputting data into one record, and accidently hit the middle scroll on the mouse, you could be entering data into the wrong record, and not realize it, because you had accidentally scrolled through several records records without realizing what had happened. Does anyone know how to disable the "Scroll" function in Filemaker, so that if you hit your mouse the wrong way, you won't acc…

I have been out FMP development for a little while so I am a little rusty. I am putting together a project tracking database. I have a main database, ProjectRequest, that has several fields that are integers that are codes to other tables. These codes are foreign keys in my ProjectRequest table. The actual description or name for these codes reside in the code table itself. Example: ProjectRequest has the following fields: PriorityCode StatusCode PriorityCode table has: PriorityCode PriorityName My problem is how to best display these fields on a layout. The code needs to be entered into the projectrequest:PriorityCode field but the user doesn…

Is there a way to take the contents of a container image from several records and display them as a grid? [ ] [ ] [ ] [ ] [ ] [ ] [ ] [ ] [ ] [ ] [ ] [ ] [ ] [ ] [ ] [ ] In the example above each square is a container from a seperate record based on the results of a search query. If the results were more than would fit on one screen then ideally you could scroll down until the last record was displayed. Then you couldd click on any individual square to navigate to the "related "record." I have attached an image from an application that does this. The grid is dynamically generated based on the results of a search query of a total record population. …

our contacts database always opens up full screen (which on a 20" imac is a lot of white space) whereas our invoicing databases open up to approximately a4 size. can i restrict the contacts file to open much smaller? the empty file is here if somebody wants to have a look at it: http://www.redfacilities.com/fm/ContactsEmpty.fp7.zip many thanks max

Ok so this is a two pronged question... prong 1 - When looking at the layout ruler...be it pix, inch, whatever, How do you change where that ruler starts for the layout... I ask this because I am an new employee and working with some existing files... some of the layouts start @ 0 some dont... how can i change this? prong 2 - in the same file i am trying to change the print margins for a layout... they are all set at .25...Now this is where i get concerened..I get the limitation warning for this configuration and i cant close the box... ie it pops up..i close it it pops up again immediately!! i get stuck in this loop and have to force quit out... Any taker…

Hi All, I'm using FMP 8 Adv to create a new database that uses portals and have found a bug I had not experienced before. When entering data in a portal field, with a transparent background, all editable portal fields turn gray. The user ends up entering and editing black text on a gray background. I have been unable to fix this, except by adding a background color to the field. I don't want background color, since it I have alternating color bars in the portal. Is there any way to fix this bug? I am running 8.0v3 on OS X 10.4.7. I have not tried it on the PC yet. I welcome all suggestions. Thanks, - Miles

Is there a way to duplicate a table and all the fields within it within the same file. start with: Table1 ... Table1::name1, address1 And create from this table and its fields: Table2 ... Table2::name1, address1 I am sure there could be piles of instances this feature would be extremely helpful..... Thanks

Hi all, I've set the window size of my database using a script that runs on startup, but I'm now trying to figure out how to enforce that window size. Unlike the "Show/Hide Status Area" and "Show/Hide Text Ruler" steps, there doesn't seem to be a lock option. Anyone know how to do this? Thanks in advance for any help!

Is there a way to specify as opposed to averaging (layout/arrange/distrib) the spacing between selected objects? I'm working on recreating a layout that displays small grouped tables in various areas of the page. I've kinda figured out that if I do the math and then position and lock the top and bottom objects in the group I can get pretty close to getting the space I want between my objects vertically. But that's time consuming, not exact, and that doesn't work horizontally since all the text objects are various widths. I've been using the T-square and object info tools, but that's also time consuming. And then if I have to make changes to the layout, I have to sta…

I want to copy a field in layout A and paste it into layout B and in the process, I want FileMaker to remember which field it is rather than pasting an unknown field. I am sure this was possible in v4/5/6 but it no longer seems to work in v8.5. Am I going mad or do I have a problem with my system (Mac OS 10.4.7)?

I am creating a new window with specific size settings that closes when the user is done editing info. For some reason, it changes the size of the original window if it was maximized when the button to run this script is pressed. Any ideas?

Hi everyone -- in using Brian Dunning's excellent Chartmaker Pro 7 in my recently upgraded FM Advanced 8.5, I have noticed a lot of weirdness in trying to set field and rep widths. For instance, when Chartmaker calls for a rep width of 1 pixel, I cannot get FMA8.5 to cooperate. I have tried to mouse-drag the primary/left-most rep to 1 px, but the object size viewer only allows to 2 px... If I try to manually enter a 60-px width for a 60-rep field, it defaults to 61 px..? I thought zooming in, a la Illustrator and other graphics apps, would afford more precise setting, but not so... Any advice, or at least a witness!?

Hello, I'm hoping that somebody can help me out. I have spent the last 2 days trawling through this resource and others looking for the answer with no result. I have produced a fm system for my my graphic design business. Its fantastic (the software that is, not necessarily my system) and has eased up the workload considerbly. However there is one area that needs attention, namely sales invoice statements. Basically I want to produce sales invoice statements for my clients that display the total of: 'Invoices that are Over 30 days due, Over 60 days due, Over 120 days due. The invoices at the moment capture the 'Total' and 'Issue Date'. I think that I shou…

I recently started using the business productivity kit that you can download from the filemaker site my only prob is that the invoice only has 8 product fields, how do I add rows as needed. HELP. thx

These commands do not work!!! Select multiple objects - (If you press ⌘ while dragging, the selection box does not have to completely surround the objects.) Duplicate an object by dragging it - Option and drag the object These were directly from filemaker help. Neither works!!! Its been a year. Its driving me craZZZZy. I have deleted the prefs and reinstalled. Mac OS 10.4.7, Filemaker Pro Adavanced 8.5

Is it possible to click on the column field label in "View as List" mode and have it perform a script?

This is a great forum, I have been able to create and modify my database with all of your help. I have simple question. I have a portal which pulls records from a product table. I need the "description" field to wrap the text if it doesn't fit in the portal field. It seems like a really easy thing to do but I can't figure it out. Thanks, Sharon

Using FP6. Last year I created a labels layout of 40 labels, 4 across and 10 down, which I need to do again. According to Avery website, this should be label L7654. I have US, UK and AUS labels in the FP program files but when I try to create the layout, this label and its inkjet equivalent are not there. Is there a way of checking the layout I created last year to confirm the Avery number or, even better, a way to copy a layout from one file to another which has the same fields? Any suggestions gratefully received.

Just upped to 8.5... besides the ability to end a script in such a way that you are at a button or tab rather than a field, I'm wondering what can be done-interfacewise-with the new functionality. Seems like that GetLayoutObjectAttribute function should have been half a dozen functions! At any rate, can't figure out how it's useful. Is there a "guide to using objects in 8.5" somewhere?

Hello, I'm sorry this is such a simple question, but I have tried to find the answer and I just can't. I have a table with 60+ fields. When I am browsing records and I choose to view my records as a table, I can only see about 50 of the fields as I scroll horizontally. Is there a preference that determines how many fields are displayed in the table? Thanks

Hello, I'm a new filemaker user, trying to set something up that will allow me to enter, browse and analyze the data from a rather large and involved survey. Each record has a rather large number of fields: thirty questions each with five parts, plus another fifteen independent questions. The amount of data that will be in each field will range from nothing or a few words to several paragraphs. Right now, I'm designing a layout for data entry and printing, and am having considerable whitespace issues. For the independent questions, I've figured out how to use sliding and everything is dandy. For the five-parters, however, I'm having trouble. What I'd like to do …

I have a layout setup with all of the data that I want in it. However when I changed the view from form to list or table I don't see everthing that I want. How can I change the layout of those particular views?

I have a container field in a table (using FM 8.5) which holds a document. I can set up a button to display the document, but I'd like for the button to only be visible in the display if there are actually contents in the container field. I can't quite figure out how to optionally manage the presence of the button in the layout. Does anyone know how this might be done? Thanks!

I noticed that when I create a field with "create label" selected, the text-object created for the label automatically fits the size of the label text. Is there a way I can set text-objects to auto default to the size of the text contained as I create and change text labels? Thanks.

Hi everyone, I'm having problems with ## for page numbering. It shows "1" for all pages printed. Any suggestions? I don't know if it matters, but I've set up a global for last page and put in my script. Go to record/request Last insert page in global Go to record/request first The last page insert is working correctly. In layout i have "page" ## "of" g_lastpage

I hoping i've got the right area to post this query. I'm trying to get it that when my solution opens a new window from a button click that the new window in front is the only one selectable and if you click on the back window it stays in the back until you have clicked a close/commit button on the front layout. I've had rough success with this through the pause script step in the button script that creates the new window, but doing it this way needs the operator to click the cancel/continue button in the status area. My solution doesn't use the status area in any of the layouts so i was hoping there is a script step that i'm not seeing that may achieve my goal. …

Hello I'm designing a database where I'd like to have some fields hiden on my print layout if they're empty. The fields in question will rarely have info in them. Is there a way of hiding them (or more specifically their labels) from a layout if the fields themselves are empty? I can't think of any little tricks to achieve this. I thought they'd maybe be a script that would use the sliding/printing control but I can't find that option. Any thoughts? Thanks

OK so im planning a purchasing layout and have no idea on how to do it. Basically i have fields for Vendor, Manufacturer, item#, and description (that need to work with this layout). I want to find all unordered items, sort them by vendor and make a new page (to be printed faxed or emailed) containing all of the items associated with each Vendor. Can anyone give me some hints and ideas? Thanks!

I have two fields, "forename" and "surname". They sit beside each other on my layout like so: FORENAME[color:white]....SURNAME Sometimes a guy might have a very short forename, so I end up with this unsightly mess: ANDY[color:white]............SHAW Is there any way to make this look more like: ANDY SHAW ...without having to resort to using a third field to display the combined values?

I have a database that relates to another database that contains 5 competitors and their monthly spending. Each competitor has their own record in the other database and their names are contained in the same field. I want to be able to bring each competitors spend into a single record on a TAB layout and show each comeptitors spend. I can bring in one competitors spend but am having a brain freeze on how to get the other brands in. Any thoughts? Am I being to vague? Thanks

I am have a strange problem where the cursor appears to be out of alignment. The cursor is 5 or 6 spaces to the right of the characters being typed. Hence, if I am typing here[color:FFFFFF]..........|<--the cursor is here. I have tried changing fonts and recovering the file with no luck. Has anyone else ever heard of or had this problem?

hi, please help me.. i need to be able to create a calculation that counts the number of different items purchased.. the count function doesn't work since it counts the number of items purchased and not the different types of items (based on item number).. Can someone please help? Thanks!!

Hello - I've got a puzzler, at least for me... Here's my setup: I have a data-entry layout ("Certs") that allows the user to associate an inspector with a part. There *should* be only one record which links an inspector and a part, but it's the record ID field that FileMaker checks to see if the record is unique. A user can click the New Record button and FileMaker creates a new record. The user then selects a part and an inspector. What I'm looking for is a way to not allow the newly created record to be committed if there is already a record that links the inspector and the part. I created a self-join relationship based on the inspector and the part,…

So I have a (necessarily) fairly complex form with lots of fields. I would very much like for the user to be able to mark some of those fields in [color:red]red and some in [color:green]green. I'd like them to be able to do this on the fly. So, regardless of the field's content, the user can mark it red or green. What's the most elegant way to achieve this?

Hi, I have an invoice, which contains a portal, which brings in the orders that have the same 'invoice number' as the current record in the invoice layout. It has multiple pages, which are basically duplicates of the first but the portals are set to display the next records, so 1-3 for the first page and 4-6 for the second etc. I have read that it isn't proper database practice to print portals though, but I can't think of any other way to do it. I also need another way to do it because the portal method seems to be playing up. The best way to describe it is that its like the portal is showing one more row than it is supposed to, but this extra r…

Hi-- I'm replicating a layout where I need to be able to find a range of dates, then have subtotals for all transactions within that range, hence: Transactions Processed and Closed between and including March 01, 2006 and September 11, 2006 Sale Transactions:77 Return Transactions:3 Total Transactions:80 Totals Visa Sales:$2192.43 MC Sales:$628.05 AMEX Sales:$191.70 Discover Sales:$34.95 Total Sales:$3047.13 Returns:$(104.85) Total:$2942.28 Averages (194 days) Sale Transactions Per Day:0.39 Amount Per Sale Transaction:$38.21 Amount Per Day:$15.09 I've tried setting this up, but can't get the…

I am Previewing an Invoice-LineItem layout that is based on a List View of the LineItems table, and uses subsummary parts (breaking on Invoice ID) to print the top and bottom portions of the Invoice. Usually it works: more often than not, as I page through the previewed page images, everything looks right. Every now and then, however, I come to an Invoice where none (or almost none) of the fields are filled in. Here's the kicker: if I page forward, and then page back to the blank invoice, usually it's properly filled in. It's as if FM Preview mode displayed the record before it was able to chase down the related fields, but eventually caught up. And th…

Hi, im new to using Filemaker. I was wondering if there is a way to make a master layout? I know I can duplicate layouts, but say I have a set of standard buttons that appear on every layout in the same place, and I want to add or change a button, I have to create (or copy and paste) them everytime. Copy and pasting them is ok, but getting them in exactly the same place everytime takes a lot of time (unless there is a easy way I dont know of yet). Is there at least away to get them on exactly the same posistion as on the other layouts? Help in this matter would be greatly appreciated.

I'm using the tried-and-true technique of printing Invoices (and their line items) using a layout with a leading and trailing Subsummary parts and a Body part containing a single line item. The layout shows records from the LineItems table, which is sorted by Invoice_ID. When the layout is shown in List View and Preview Mode, I expect to see a leading Subsummary part (containing customer name and address and other stuff from the Invoice record), one or more LineItems, and the trailing Subsummary part (containing totals, shipping costs, and more stuff from the Invoice record). The leading/trailing Subsummary part definitions both specify Invoice_ID as the sort…

Hi, I saw/heard this somewhere (maybe maybe matt petrowski???) that if you rename a layout in 8.5 the change to that name will no longer automatically propagate throughout your the file. this is a 'gotcha' i think. I am going to call this 'auto renameing'. In in previous versions if you renamed the layout, it would be renamed everywhere in the file. I actually liked this and couldn't believe it worked (reliably)... but it did. Worked for scripts too and so on.. If I understand this right, it seems that this new 8.5 feature(?), while giving the developer more control/power, it also opens the door to making more , uh, mistakes. Unless they've added somethi…

I'm printing a report with Sub-Summary parts in the layout. I would like to have a summary of the subsummary parts, the same way a trailing grand summary would work except multiple occurances on a page. Example: Office Supplies 25.00 Internet Provider 50.00 Phone 30.00 TOTAL EXPENSES 105.00 Sales 200.00 Subscriptions 75.00 TOTAL INCOME 275.00 I suppose I could use a Trailing Grand summary and print each one on a seperate page, but is there a way to do this all on one page?

I am a newbie so forgive me if I have posted in the wrong section. I have a database I created to manage incoming orders. When an order is complete I would like to be able to click on the complete button and have it put some kind of stamp across the front of it that says "closed" I know I have seen this done before. I often have repeating customers so when I search for customers orders I want to be able to easily see the ones that are closed.

hi Is there any way to permanently change the order of records in my database? I know I can sort them by right clicking in a field but I want to change the order that they are in when I open the database - at present they are in creation order, so if I create a record for a journal volume 9 issue 3 then create volume 9 issue 1 afterward, my database will always show issue 3 before 1. I've been told that's just the way it has to be but would appreciate anyone's advice or confirmation of this many thanks Carol

Hi I have got an invoice layout, with a trailing grand summary that has the totals and some text. Is there any way to only make it display on the same page as some data? in other words so that it is never on its own on a page. thanks

OK so I recreated the nav buttons onto my header along with a record count field. But I have a script that is a goto and come back script, in which to come back you need to click continue or to stay there you click cancel in the status area. Is there any way to get these onto my recreated nav area in the database? If not is there a work around to only show the status area when the script requires it? I assume that show status area then hiding it will solve this issue?

Does this option store a relative or absolute filepath to the location of the image? I'm pretty sure its absolute, but i thought i'd ask anyway.

Hi All I am having a weird problem. I have a date field named "activityDate". This field has been formatted to display date as "dd/mm/yyyy". I use this field in a Portal. The problem is when I click on this field and enter a date and then exit out of this field, it changes month to day and day to month. Eg: if I enter 11/12/2006 for 11th, dec, 2006, then it gets changed to 12/11/2006 when I exit the field. It works fine if "dd" has a number greater then 12. Any help would be greatly appreciated.... Thankyou

Hey FM addicts, I'm tossing around the idea of building a forum style solution for my work. Was wondering if anyone out there had an idea where I might find a good template? I've looked around the FM site and in here, but haven't seen anything. I'm wanting something to run from FM server 8 on a private business network with about 12 computers or so.

Hey everyone, I have a Customer Quote report that totals line items I have quoted. Everything is just how I want it except one thing. Most quotes contain 4 items or less and I have had no problem keeping it all on one page. Because of this I put the totaled summary field in the footer so it will always print at the bottom of the page. Well I just did a quote that needed 2 pages. As you may know, now the "grand total" is not only on page two(where I want it), but on page one. In these situations, because it will happen again, how (if possible) can I make the Grand Total only appear on the last page at the bottom.

hello everyone my first post is very basic - I want to add a field which only has YES or NO options - but I want the default set as NO so that I only need to click to YES on the few occasions this is needed - is this possible please?