Layouts

hi, i inserted a page number using Insert-> Page Number Symbol. However, the page numbers go in this order (1,1,2,3..) instead of (1,2,3..). Why this repetition of page 1? Thank you so much!

Hi, I'd like to do a list layout, but I don't want to see duplicates of the same content; although I want to see the first occurence of the duplicates. A little bit a detail will help understand. I have DB of different people living in different towns. Each town as a seperate related record in another table (one name can have more than one town but each records in the Town Table as only one of each; so the same person has more than one record in the Town table and the same town can repeat with different people - is it clear??). I'd like to do a layout (list mode) so I could have something like an index of the towns in the Town table. My problem is that I don't want t…

Hi, Using FMP 5 to print postcards for a computer club. The layout is two cards per page. However, when the fields are put on the layout, the same name shows on both cards in preview mode. How do I do the layout or fields so that each card has its own record? Thanks, Russ Conte

When I open one of my databases on my Mac OS X development system, FontAgent momentarily reports it's activating a Helvetica Narrow font, which I have not intentionally used in this or any other FileMaker database. Since I will be deploying this database on other Mac and Windows systems, I'd like to track down and eliminate the Helvetica Narrow reference. I'm hopeful there's a way to do this short of checking the font on every field in 8 layouts. Suggestions? -- Ward

It seems to be defined by the vertical dotted line. How can I make the full screen (except header and footer) available for field layout? Thanks

Hi, Apology if this is not the right place to post this question but this is the most related category that I could find. When running "New window" script step, the currently open window also resized. How can I maintain the currently open window into its original size when calling "New window" command? Any suggestions would be highly appreciated. -garry

Hi all, I have a small problem with printing layouts in preview mode where I have few portals, and other fields spanning multiple pages. The main problem is where I use sliding so portals and text fields slide up when there is no data to fill it. The problem is with page boudries, as fields slide up and cross the page boundry they are not being split up properly. What I mean is I see duplicate data from the first page on the second page, almost bottom 1/3 of what is on first page is repeated on top of the 2nd page and so on. Does anyone know that this is a bug? FM Tech support made me feel like it is me, but I can reporduce the problem on a brand new blank db …

I have 2 layouts for 2 related tables they are conferences and invites the relationship is set up conferences.confID----<invites.confID I just want a button on the conference layout to jump to the invites layout but only show invites for the conference that was the current record on the conference layout. Why is this so complicated? It should be simple . I've tried applying a script to the button it is as follows: -Go To Related Record [From table:"invites 2"; Using Layout: "print_invitesXconf"(invites 2); New window] -View as[View as List] -Sort Records[Restore; No dialog] -Enter Preview Mode [Pause] -Print Setup[Restore] -Go t…

I am writing a database for a school to track student info. In one layout there are a series of check box values in a field named "Areas of need". Values may be reading, communication, etc. If a value is selected, another layout, "Goals" needs to be completed. A record may have 1 "Ares of need" and cooresponding "Goal" selected or 10. Additionally, multiple "Goals" could be required for one "Area of need". Is there a way to automatically duplicate the layout for "Goal" only when more than one is required? Any other suggestions that would be easy for the end user? Thanks, Rick

I apologize if this is a repeat question, but I searched at length and couldn't find my answer. I've been trying to figure this out for years without luck. I would like to make a "full name" field utilizing mergefields that comes out clean. How can I ask it to look at one field and if that field is not empty, to insert a space? For example, <<If <<MiddleInitial>> <> "" " " "">> or if the field MiddleInitial is not empty, insert space. I've tried using separate "spacer" fields but couldn't figure out if it would work with a calculation. Is there a way to do this? Thanks in advance!

Hi all, I have a simple, inventory file, with no portals. I need to print a report like "Sample 1" below, with a number for each line item within a category, the numbers should reset at each category break. I tried using "@@ in the printing layout gives me the "Sample 2". Anyone have a tip on how I can make this work the way i need? TIA (sample 1 - what i need) Summary: - category A Body: - list of items in category A #1 #2 #3 #4 Summary: - category B Body: - list of items in category B #1[color:"red"] #1 #2 #3 ------------------------------------------------------------------ …

This is another one that is probably simple but I have not been able to find the answer. If I have the status area disabled and am in Prieview Mode, is it possible to view all the pages of a multipage report? I really don't want the Status Area enabled anywhere in this solution if I can avoid it.

Hey folks, I ran a search but couldn't find anything on this. The key command for "ungroup" doesn't work on my system (never has) [Win 2K, Dev7.0v3]. Try as I might, control-shift-r does nothing. I've tried pressing the keys in a specific order, crossing my fingers, praying to the IT Gawds... all to no avail. Control-r works fine to group, and commands for lock/unlock work as well. Just not "ungroup". Is this a known problem? Any chance of a work-around? I'm trying to become more efficient in my workflow and mousing around when I shouldn't have to is really starting to annoy me. Thanks! -Stever

I want to know, is there a way to generate a list (ascending order) from the calcualted values of a subsort on a report. Example, Person A had 5 choc cookies, Person A has 6 Sugar Cookies totaling 11 cookies. 20 People. Thank you in advance for your help.

I am trying to format this report so that some rows are separated by a divider rather than have a summary field label above each type. For example, Instead of: Plaintiff Finance co, LLC Defendant Doe, John I want to have Finance co, LLC VS Doe, John How can I accomplish this?

I am trying to create a telephone directory, and I would like to display the page number and the ranges of entries on a given page in the header and/or footer. Assuming page 23 went from John Smith to Barbara Summers the header or footer would display something like: 23 - SMI - SUM Obviously, the definition of the header part is it displays data from the first displayed record and the definition of the footer is it displays data from the last. How can one get around this? -Tom

I'm trying to make a layout that has a header that displays in Browse mode, one that has buttons attached to scripts, a company graphic, etc., but that only prints on the first page in preview mode (like a cover sheet might in Word, except that only part of the page would be the cover sheet - I know, wierd, huh?). It would also be great to have a header that is separate that only has the column labels, that would print on every page. Is there any way to accomplish this?

Is there a way to 'tab' to the next field downwards rather than across? regards Gerard

I have a layout that does not print properly. I can clearly see that there is a striped, gray line visible in layout view that is acting as the margin. I cannot figure out how to move this striped, gray line. I searched the FileMaker help file and the Bible with no luck. I am either not thinking of the proper term to search for or overlooking it. If anyone could tell me how to move this line, I would appreciate it. Thanks for reading!

I have three tables in my database they are conferences invitations comments conferences is related to invitations via... conferences.confID --< invitations.confID invitations is related to comments via.. invitations.invID --< comments.invID I just want to display all comments per invitation per conference some thing like as follows --conference 1 title ----invite_1_LastName Invite_1_FirstName --------comment_1 --------comment_2 --------comment_3 ----invite_2_LastName Invite_2_FirstName --------comment_1 --------comment_2 --------comment_3 ----invite_3_LastName Invite_3_FirstName --------commen…

I have a feeling an obvious answer is lurking on the fringes on my mind but I can't quite get it out in the open. I have a report based on a table CallCodeOccurence I have it subsummarizing by CallCodeType (from the related table CallCode) The rows are basically a date, a call code, a description and a count field. No problem counting the CallCodeOccurence records or totalling them. But at the end of this report I need include a total number of CallCodeTypes that appear in the report (it's filtered by date range and other things). So how can I display a total count of the CallCodeTypes? I tried a summary field that counts CallCodeTypes but I get …

I prepare reports for political candidates and have been using FM to keep track of the basic contribution and expense data. I then export several files (one for each report section) and import them into Excel for printing the reports in the proper format. I'd like to do all of this in Filemaker if possible but don't see a way to accomplish it. Here is the main issue that I see. Each section of the report contains data that's the result of a different FIND operation for the reporting period. There are separate sections, for example, for contributions over $50, expenditures over $100, bank loans, paid campaign workers, and expenditures by category. The attached file sh…

OK - So on some level I hope this question is going to have one of those "Doh!" answers - because I need it answered quickly: I have a layout that is composed of one field - it's a giant checkbox - and it used by calling it from another view of the table, so the user can select from one for 300+ listings in a List; it works great! BUT... when I needed to work with exactly the same field - related to a different table, I copied my existing layout: - Pointed the layout to the new table - Edited the field, so it properly points to the appropriate field on the new table Everything seems fine - BUT the checkbox won't accept a check - seems you can't edit it. Na…

FMDev7/Win2k I'm hoping I'm just being an idiot because I'd love to find a way around this issue, and if it's me being an idiot, that's fine by me at this point. Why is it so danged difficult to add a new custom color in the COLOR dialog box to any swatch other than the first? There are 16 swatches available, but, for the life of me, the only way I can see to add a custom color - to any swatch other than the first - is to click on one of the white swatches and then manually enter the color code on the right. Is that the process for entering a custom color? If that is the process, then why can I select - for example - a square filled with a custom color, t…

Hello, I have a floating palette, which has some buttons on it, while my user is using this palette i pause the script indefinately. So you get a 'stay on top' type of effect, in that same palette layout, I have a button which says close, in that I have a script which closes the palette - how do I resume the script at that point, the only way I can get it to work (so far) is by clicking the 'continue' button in the status area OR by creating a button with a 'resume script' action. The thing is I would like my close button to do some other things besides resume the script. Sorry if this is a FAQ or obvious one, maybe i have been staring at the screen too long. …

I create a layout by selecting a table and then the fields to inculde in the lay out. so far so good. I then go to browse or preview and the fields do not resize them selves to accomodate the amount of text in the record. e.g if my layout includes a a textfield that is 400pxX50px then when you go to preview if the record only has a few words for that field I want the space taken up by the textfield to shrink accordingly. If the text extends beyound the field then I want it to expand to accomodate. Also if I have two fields like firstName and lastName that I want to include in my layout I would like them to appear together like this. Shmoe, Joe Not like…

i have a layout from table 1 with a field that loads values in a list pop up from a table 2 that is related. Whe i modified the value in the table 2 the value in table 1 doesnt update, i have to reselect the value. what can i do to auto-update the value. thanks

I'm having trouble getting my brain around how to create a report to show averages per quarter. Let me explain... I am tracking profit data for each customer each month. I have created a layout/report to show total profit data for all customers broken down by sales region. The next step is to take those monthly region totals and average them for the Quarter. Because of the way we track things I can't simply add the months totals. I can't figure out how to create a report that will average the monthly totals instead of the average of the individual records. I tried creating a self relationship based on the month field of the records but it didn't work. I…

Hello. First post. Be gentle. I'm totally flummoxed by Sub Summary Reports. I am trying to create a report that will list/print summary totals for a database membership based on two fields [area] [reference]. There is also a unique field should it be required. Something like the following... (I hope the formatting comes out ok) area 11 reference Total W10 52 w11 128 w12 29 ... w20 77 area 12 n10 55 n11 217 ... n49 59 area 13 p22 84 p23 111 area 14 etc. I realise this is a pretty basic type of report, but at the moment it is beyond me. Thanks John

I'm trying to design some simplified forms which can fit into small windows. One of the things I'd like to do is create toggling checkboxes or radio buttons for yes/no fields, so that I don't have to make room on layouts for both "yes" and "no" checkboxes/buttons. (Those of you familiar with MS Access know what I mean.) I'm fairly new at scripting, and I just can't figure this thing out. The value of the yes/no fields are to be used as markers when filtering a mailing list or generating sums, so I've assigned them a numeric value of 0 or 1. So how do I set up such a checkbox? I'm attaching a small sample file. If you have the time, please tinker with it an…

I have a layout with a variety of information on one business. This information takes up more space than can be displayed on one screen. I would like to be able to scroll down through this information while keeping the general business information (phone, address, name, etc.) displayed at the top of the layout. I am envisioning something similar to a "freeze pane" option in Excel. Is there a way to accomplish this? Thanks again for your help.

Hello, My name is Shyam and I am a student very new to Filemaker. I am using 'FileMaker Pro 7' database on MAC OS X (10.4.1) for a project at my university. In one of my layouts I have a pop-up menu. At the time of data entry, this menu displays the contents of a value list of user-ids. However, I want my pop-up menu to display a list of user-names. Once the user selects a particular user-name, I want the field's value to be replaced with the corresponding user-id (that is found by matching the selected user-name to a user-id from another table). Is there any way to do this? I would really appreciate any help in this matter. Thanks, Shyam

I have a db woth two tables one is a list of GPs and the other a list of surgeries these are linked by a one-many relationship useing GP practice (ie each surgery can have more than one GP) I wish to do a find based on area and send a standard letter to each GP in the surgeries returned. I have a layout created for the letter but cannot work out how to generate a letter for eacg GP I can do it for each surgery but not for every Gp at the surgery.

I host a database on an internal network and all my users access the database remotely and interact with it throughout the day. to keep the size of the database down, I insert file references (rather than the files themselves) into container fields from the host computer. When accessing the database remotely, however, when i try to download the file in the container field, it says that it cannot find the file. any idea how i might fix this? thank you for your help.

Hi, Could anyone telle me how comes when i import a form into a layout and then print it, setting the margins to 0 it does not come out as the original A4?? Basically what i am trying to do is put fields over a printed form so that they print in front of blank fields on the actual form..can anyone tell me if maybe that has something to do with printer setup and what size should i set the paper to ?? Hope this is clear enough!!

I set up a text page and insert fields to print in spaces in the text. When I preview, the fields are in the right place, when I print they are down 1.5 lines. Same with 2nd printer too. Tried everyway to correct this. Can't

a question for all the whizzes out there: I would like to structure my database so that if I select an option in a pop-up list, then the database will know to display the record in a certain layout. The database holds projects, but each project is measured according to different standards and therefore would need different layouts for a measurement page. Any idea how I might build this? thanks in advance for the help.

I'm a new user of file maker pro and I need some help. I'm working for non-profit that is attempting to organize members, donors, sponsors, and volunteers. Can some one help me figure out how to view these different groups of people? I have added a field called "category" under which I have volunteer, sponsor, member or donor listed. The main layout only has first name, last name and category. The problem is that I don't know how to make a new layout that will only show volunteers. One that only shows member. One that only shows donors and one that only shows sponsors. Is there a way to set up file maker to automatically display only certain categories? Or must …

How do I control what the scroll wheel does in FM. Seems like sometimes it'll scroll the page up and down- desired result - sometimes it scrolls between records, driving my users nuts? Thanks [email protected]

I'm newer to Filemaker Pro and am trying to build a database that will help me track my companies spending. We do this by tracking PO's, and while I have everything set up, i can not for the life of me get the Report/Summary function to work for me. I've never done a report before, and I can't find anything helpful on the net to explain them to me. I have a database that contains the following fields: PO# Project Character Quantity Part#/Description Amount each Total line item Date created Basically i want to be able to have a report and search in the following ways. 1. Search by project, with a project spending total 2. Search by…

I have a medical application that I am developing. To simplify things

is it possible to go to a related record in another file? Like a related record is shown in a portal and you just put a button next to that row that will take you to the related record?

I'm new to the board but I've been using FMP for years, so I'm not sure if this is the correct forum but there's a problem that keeps bugging me and I thought I'd see if anyone else out there knows of a fix... We keep a database of product information. Information is typically entered manually, as new products come out, by copying and pasting text from web pages into the form layout. The problem is that the text comes in all different sizes and fonts depending on the webpage from which they came. When copying and pasting, the styles are retained regardless of the font assigned to the fields. This creates a big problem for reports since the layout is designed for…

im sure this is achingly simple, but having finished entering data into a field, is it possible to set return or enter to automatically avtivate a button or run a script (different scripts on different layouts)

I am building an estimating solution and I am having problems validating that an active customer number has been entered. I have a Customer Table with all relevent customer information, then in a separate table I have the estimating information. I have it set up through scripts and a custom dialog box with globals to request a customer number and navigate to the estimating table create the new record and lookup all the required customer information. What I would like to do once a user has entered a customer number (into the global field via the custom message) is to compare it to the data in the customer table to make sure that the customer number is valid befor…

Hello all! I have an inventory problem that probably has to do with subsummaries. I keep track of every part that leaves our office by serial number. Every part falls under a specific category. Each part also has a price but these prices vary between the parts themselves. What I want is to show that within a specific category, there is a count of how many parts are at price X with a total sum, while the rest of the parts are at price Y with their total sum. I want to avoid giving a specific value for these prices because they vary so often. I have, so far, a subsummary with the break field "category" that lists the individual serial numbers and the cost of …

Is there any way to change the default "standard" layout that Filemaker uses ( the one Filemaker throws at you when you first look at your data in Layout Mode?) I always need to see my data in columnar form, and right now I am creating columnar layouts for each table. But I have lots of tables, so I would like to be able to change the standard default to a columnar format upfront - it would save me a lot of time. Thanks.

In one of the layouts of my file I have multiple portals displayed. I would like to eliminate the "white space" of non-used space in the portals and have utilized the resizing/compress unused space option. My problem is that when I look at the record in preview mode (or attempt to print it) very whacky things occur . . . data from the third portal is missing and it almost looks like there is some sort of overlapping that is taking place. Does anyone know how to reduce the white space when viewing mulitple portals without wrecking the data? Thanks, John

How do you creat a list layout? I can not find any info on how to do this? I have a form layout for my invoice and want to know if I should convert to a list layout. I found this quote in a previous thread: "The other way is instead of creating a form layout on Orders, create a List layout on OrderProducts. Then you make a larger header part with all the related order information, and a trailing grand summary for the order totals etc. You will need this technique if you want to support orders with arbitrarily large numbers of lines, because you can't make a portal spill on to multiple pages nicely. I started out creating all my order and invoice print layouts…

this is a post from the portal thread as well. I am redoing the database, making one table that has all the discrepancies. There are 13 different discrepancies that can be chosen. Dependant on which one is chosen, there can be different variables. I believe I can accomplish this by making different layouts wtih the fields that I want. I don't know how to generate a summary report that would list all discrepancies for a certain date and then list the appropriate sub fields. The problem I see is that since it is all one table, I can't specify out which fields I want at a certain time. I hope someone can help with this and give me some insight. Thanks in advance

when i copy something from the internet and paste it into a field in filemaker, it always takes the font, color, size, etc. from the web browser when i want it to change into the font i've specified for the field. i've made all the changes that i thought would fix the problem (in field behavior setting input method to synchronize with field's font, changing default font in filemaker preferences) but the problem persists. how can i avoid the step of having to re-format bit of text i paste into my database?

I often use << and >> around field names on layouts like letters..... Dear <<First name>> for example. But how do you do it when the field you want to put on is a related field? I've tried <<:fieldname>> but the :: automatically puts in the time! Anyone got a solution? Thanks

Hi everyone I have a graphic in the background of my main screen to create a brushed aluminium effect. I also have a menu of buttons. No problems with the buttons but if I click anywhere other than the buttons, ie onto the background graphic I get a message saying 'This action cannot be performed because the required table is missing' Does anyone know what action this message is referring to. I opened the specify button box to see if I had inadvertantly set it to do something but I hav'nt. It is now set to do thing. I am in the early stages of learning about 7 so my file only has 1 table with no fields I have attached the file in case it helps …

Hi, Can anyone help me on this please.. I'd like to create a script that prints a layout from another one.. We enter billing details on layout A and from this layout be able to print the invoice in layout B Many thanx!!

Hi folks, Is there a way to use more than one of the built in FM templates in a database? For instance, what if I want to use the time card, project tracking, and employee data templates all in the same database. I can't figure it out. Thanks, Evan

Hi Folks, Filemaker is constantly redrawing as I move my mouse. The worst seems to be the relationship view. Any ideas? Thanks!

Is ther a way I can have certain choices in a value list Formatted differently than other choices? Example: Task status field - "In Prgress" (formatted in black text), "Overdue" (Red text in Bold) I have tried entering Textcolor tag directly in the value list but it didn't work. Thanks for any replies....

We have a contract form that we want to insert into a layout and then just put the field over the form..the problem is that when printing the image file (photoshop or jpg), it takes ages and does not come in good quality...anyone has any idea on how to do or how to insert this document and keep the quality Many thanx

How do I set up a report that is printed horizontally across a page?

Is there any way to change a theme after you have created a new layout?

Join two diffferent databases into to one database. Or moves the tables and portals of one into the other.

Can i make a button that will open up a layout from another table in another file? When i use the "go to layout" button it only lets me choose from layouts in the current table/file. Do I have to use a calculation (don't know how to do this...)? thanks in advance for your help.

I created a lovely (OK, more functional than pretty) layout, which looks great in Preview mode, but obviously Preview mode does not allow data to be edited. How do I allow another user to see this nice, sorted layout and edit records without forcing them to use the Browse mode where only a single record shows at a given time (of thousands of records in total) in its current state? Is there an easy way to use a Preview layout in Browse mode, to make managing records easier? I tried choosing this specific layout in Browse mode, but that still just shows one record at a time.

I've done something that's probably non-standard in my layout. I've got a sub-summary part (leading), and I made it really tiny (.025 inches high) and just put my summary field barely touching it and mostly overlapping to the body, in order to minimize white space on my report. When I then use the "alternate background fill" property on the body, the fill covers up the summary field in every other row. I've made sure that the summary field is "brought to front" in the layout, but I'm hoping there's a button or checkbox somewhere to fix this little problem. I can live without the alternate background fill, but it sure does make the printed report a lot easier for…

I have set a tab in a text field that contains a numbered list in a series of records, so that the second line can be tabbed to line up with the first letter of the first line. Whether I set the tab in the layout mode or in the browse mode the results are inconsistent - using control+tab, sometimes the tabs moves to the tab setting and other times it doesn't. On some records, the first attempt using control+tab doesn't move the text and on the second attempt it moves past the tab setting. I have removed all tab and indents (not used) which I thought would affect the tabbing, but apparently this is not what is affecting the tabbing.

I have a field "Quoted by" that is the employees name. I have this field checked to "always validate"; "Not empty"; "member of list"; and show a message if empty. I have a record where the "Quoted by" is empty and when I click anywhere on the layout should not the message appear? What am I doing wrong?

Hi, Has any tried to do a report where they have a form the user enters a start date and a end date from two different fields and create a report based upon the range of information? I am having a time trying to figure out the scripting. I know that if you use one field you could enter for example: 5/1/05...5/31/05 and that will give you the range of dates for the month. Now I want to use two different fields (defined as globals of course!) to get the same report where the user just enters the dates and their criteria selection. Thanks! Chris

When hovering over an object in a layout is there any way to get a tool tip or a help ballon?

I am trying to set up a report that gives a count of records based on a part number and a location (2 fields- where there is 50 or so P/N and 20 locations). Easy enough to get a list, but i would like to veiw it as a matrix where 1 column = a location and rows = part number. Is there an easy way to do this without creating a calculation field to count records of each location ?

Hi guys, Never noticed this behaviour in FM6, so maybe it's new to FM7. I have found that when I Ctrl-shift-drag to copy a vertical line, the object moves up a pixel instead of staying in the same horizontal position. To test this, draw a longish horizontal line. Next draw a short vertical underneath the horizontal and just touching it. Now hold ctrl and shift, click the horizontal line and drag to the left. If you do it several times it will quickly become clear the line is moving upwards as well as across... Has anyone else noticed this? Another bug? Cheers, Sean.

I have several filemaker reports that use patterned shading on alternate rows. Since yesterday, when I print these reports, the patterned shading does not print. If I remove the pattern and use solid color shading it does print. (I am using Mac OS X Tiger, updated the Tiger system yesterday, and am using a HP Color Laserjet printer, which I re-installed today to try to fix this problem) Any suggestions? Do I give up patterned shading? Thanks!

Hi. This is my first attempt at generating reports, and I am wondering if it's possible to use more than 1 subsummary sorted parts in a report. The relationships are simple. I have a set of dockets, and each docket contains a list of civil suit records, which in turn have a list of plaintiffs and defendants within each case with their attorneys. The report will basically give me a list of dockets for a given court date, and between each docket I want to see suit ID numbers, and between each suit ID I want to see a list of plaintiffs and defendants. I'm not sure if it's possible to create a three-tiered subsummary setup like this. Has anyone else done s…

I have a "flat-file" type of database (ie, only one table) in FMPro 6 (under MacOS9). A (numeric) field contains a calculated result for each record. I have a script which searches for those records which meet a certain criterion, and then displays them in a columnar layout. What I can't figure out (silly me!) is how to display on that layout the sum (total) of that field for all the found records which are appearing on that layout. Thanks in anticipation. PHILIP CAPLAN

I'm VERY new to FM. I would like to know how to make an "invoice layout" that I would be using the "standard layout" fields at the top (columns?) of the invoice. For example, we have a subcontractors to work for us, they get a certain rate & the company charges a certain rate. My fields are Date, Ticket #, Truck Co., Truck No., Weight in tons, Price per ton, Total Bill to Sub, Total Amount. This would then be sorted by Truck Co. with a subtotal, and a Grand Total for all Truck Cos. All of my records would be included on each invoice. Please HELP!?! Jody

Please look at the file: page1,page2, page3 in exel format. How can I print the invoice like the example attatched? in other words, how would file maker extend its product content to the second page? What do I have to do HELP please InvoiceLayoutsample.zip

I use FMPro as a database for clients. Sometimes I want to change the text color of certain words. Is there a shortcut. Normally I would highlight the text, go to format, then text color, then pick the color. Is there an easier way?

I made a database and a layout that lists the field labels and the values. For example Plan Number: 1 Plan Number: 2 Plan Number: 3 Company Name: ABC Inc. Company Name: KMG corp Company Name: KCG inc Life Insurance: $20000 Life InsuranceL $45000 Life Insurance: $30000 The above is exactly how it appears in my layout and preview. Plan Number, company name and life insurance are fields / labels in my layout. While 1,2,3..ABC, KMG, KCG, $20000....ETC are values under those fields. I would like to have only one field column to the right and not how it repeats above....eg Plan Number: 1 2 …

Hello, I have a report, which I can only display in preview mode. to allow my user to print, i am looking into using a 'palette' style layout on the left, which has some buttons - for printing. I also would like to page down, page up and go to end and go home. I know how to do this with the Scroll Window sript - in browse mode this works great. But in Preview mode, it just goes down to the page. Is there anyway to do this in preview mode? thanks for your help in advance, sincerly, J__

I am trying to set up a Custom Paper Size layout in Page Setup but after specifiying a height of 5.5 inches I note that it is being ignored in the layout on the screen (it is set to 6in and I am not able to drag and drop it to another size). Does anyone have any idea why it would be doing this? Could it be my printer? My printer accepts custom paper sizes. thanks for your help! Stephanie

Is it possible to create your own templates for layouts in Filemaker? I have a standard look-and-feel for each layout in my database and would like to define it in one place and use it as a template for all layouts. Much like the 'Master' works in Powerpoint.

Hey all - I was wondering if it's possible to compile multiple layouts into a single one so that, when printed, the pages will be sequentially ordered. For example, can you write a script that takes Layouts A, B and C and "staples" them together, then prints, so that Pages 1 and 2 come from Layout A, Pages 3-whatever come from Layout B, and the remaining pages are from Layout C? (Or something to that effect?) Thanks!

Hi, Is there any way of having a "watermark" on a layout which won't get in the way of sliding/printing? Thanks

When I printed my report in fileMaker 7, it just came out half page, rest of them got cut off. I checked margin in the layout mode, all the content was within the page margin. When I printed a report on a different user computer, the report got cut off again. Any idea? thank you. Jackson

I'm new to FM and am having some real difficult getting it to do what I want it to. I'm used to using MS Access. Anyway, I have a form with company details (name, address, etc) and one of the fields is 'Primary Contact', which indicates the name of the main person in the company and links to a 'Contacts' table. I want users to be able to open a popup window to add a new contact for the company. I know that I can use scripts to open a new window containing the current layout, but how do I get it to open a small window with the 'Contacts' layout in it? Thanks.

Hi, Suppose you have a list of tasks and you some workers who do those tasks. Each time a task is entered into the Tasks table, a worker is picked to do the work. I have a table of workers and a table of Tasks. I'd like to display a list of all the workers the and the number of tasks they have worked on. ex: Fred Flintstone 25 Barney Rubble 300 Dino 5 how would you go about doing that? thanks for your help in advance, sincerely, J__

I have created a mailing label layout using avery 5164 - This is a template with 6 medium size labels to a page. For some reason, in Preview Mode - information only comes up in the first top right hand corner label. Again, I AM IN PREVIEW MODE - not browse. The label has a text typed directly onto it in the layout with the company's logo / return address - this DOES show up in the labels. I have other smaller labels (regular letter labels) that work fine - any ideas? Thanks! Sarah

Yes me newbie alright! Ill do my best to describe the issue I am attempting to resolve. I have two tables, conferences and invites. I have related the field conferences.confID to invites.confID (one to many). I would like to create a layout that would display invitations per conference. I envisioned, and this may be completely the wrong way, having a dropdown on the layout populated with all the conference records (confID, confTitle)from conferences and hopefully be able to [color:"red"]select/click a particular conference from that dropdown and then finally [color:"red"] display all the invites (invites.confID) to that conference (conference.confID) …

I have multiple tables in a database and am wondering if there is a way to format the window to the specific size of the particular table. At the moment, when I open the database, there is often different amount of white to the right and on the bottom, and I want the window to be tight to the layout. Thanks! Sarah

Hi, I have a list view for my solution. I have attached a button to a job number so when clicked it will go to a related record. My problem is that my users would like to be able to do a find on that layout for that field, but when they go into find mode and click on that field, it runs the script. Can you set a button to only trigger in browse mode or can I script it with an "if in find mode" function? Thanks for any help you can give

I'm new to FM and am trying to figure out the best way to create a time tracker for jobs. I could have anywhere from 5 to 50 lines for my billing records so a Portal looks great and takes up little space. I'm just not sure this is the way to go since the fields display values from a previously defined relationship and I will be entering data

I have a checkbox that displays values from a related table. How do I get those values to sorted within that checkbox? Thanks.

I have a database with some tables for families. One table is for children, one is for parents, and a third, "map": fields: internalkey child.key parent.key family.id I'd like to have a layout that would list parents and children and allow the user to select/highlight each and click an "associate" button. The script for that would use an approriate family.id if either the child or parent is already "related" in the database, but otherwise generate a new family id, adding a record to the map. If both are related, two records should be created that map both people to each family id (family structure really is complex that way, I think). The main probl…

Hello. I am a relative newbie "STILL". I am creating a database from the ground up. I have many tables already defined. I have one main table from whence all my data comes from. I have broken down into different sections smaller tables relating to the main one. All of this is linked (or trying to link) by ID #(serial #). I chose to import the main data and each smaller sections data from excel (seperately) (easier to break down that way, I thought). How can I use the get the ID#'s to coincide. I thought lookups, but being so new, I'm not sure I'm doing it right. All tables are related via ID#, doing lookups based on ID prove no results brought over. What am I doing wrong?…

I'm having some difficulty figuring out how to align fields in a report using the Object Size window. I think I have things aligned to use up the entire width of the page ... but when I print it out, a text field that I have defined to be 8 inches wide, is in fact more or less 6 inches. Why?

Hi everyone. I have searched this forum but cannot find the answer to my question. I have a database called 'Projects.' I have created a layout and want to put a text on the bottom which says "Record # of #." I know how to get the current record number, but not the total number of records. How do I do this? I cant find a Get() function for calling this. Thanks for your help.

Hi there I am trying to find a way to output continuation pages where necessary from my database, where I am importing into a text field and I'm am very stuck! My layout contains just a text field. But the amount of text in this field changes depending on how much text I may choose to include. How do I make a page layout that will resize to fit the number of pages and hence the line breaks required depending on the length of text on the page? I know that you can just setup a layout with your text field so it is say three pages deep. But the problem then is that the text will not start at the correct place on page 2. And you have to enter the layout in br…

Anyone know of a way I can produce a multi-page layout. I have a few forms that require 2 or 3 pages. I want to avoid 2 or three layout pages. Any suggestions?

I may not be using Checkboxes and Radio Buttons correctly. I have what amounts to two fields, say Type & SubType, in a single table. The table is then equijoined to another table with lots of data. I have a layout from the two-field table and a portal to the records from the other table. I've set Type up as a Radio Button set and SubType up as a Checkbox set. That is, the user can select a single Type and one or more SubTypes within that Type. When I go to Browse mode and hit Cntl-N to make record in the two-field table, I can then click on a Type and then click on one or more SubTypes - and I immediately see good hits in the portal. So first: is this a pr…

Thanks for the response to the label layout question below! Now for custom sized envelopes...I have gone into Page Setup and set the Customized size but for some reason the height of 5.25 inches that I selected is being ignored. The width is fine. Is this the correct way to adjust the width and height for custom sized envelopes? thanks! Stephanie

I am trying to put vertical lines in an invoice. They can be seen out of the portal, but when I drag them to the portal they disappear. I have tried sending the portal back and bringing thr lines to front. They were working fine until I moved a field. TIA IW