Layouts

I know you can change the layout ordering via the layout menu, but the problem is that whenever I open my database, or go to it via the web, it always goes to one specific layout type... and it's not the first layout in the layout order. How do you change which layout type it opens to? I'm just trying to make it start with a list I made. Thanks!

hello i'm new to the forums~ and to filemaker as well, i recently got filemaker 7 to upgrade my company's old filemaker 3.0 database from about 10 years ago. for one of the databases i'm rebuilding is a photo database which i've been using the built-in template that comes with filemaker 7 ( i think its photo catalog). while this is working quite well, i've changed the layout around so that its on a darker background to fit my companys logo and colour scheme better (lol this is a design company no one here really cares if it works as long as it looks good ). however, i keep running into a whitespace proble in the thumbnails section, where if their are not enough records to…

Hi.! I'm making lists of data in a layout. I can make a list of data in a layout but I can't figure how to make several lists on a layout. I am making two product tables named category A and category B(each data is a product) I want to show the whole lists (or the last 5 items) of category A and B.(in two separate list) For example, -Layout WholeProducts- ____________________ category A M&Ms Hurshys Biggy ... category B Coca cola Fanta Nestea ... ____________________ I want to create , modify, delete items in those lists as well as to see the two lists on a same layout. I did try to modify a 'tabl…

I have created a button (that performs a sort script), and have placed it on the layout. Now, what I want it to do next is that, when that page is printed, I don't want the button to appear on the printout. How do I do this?

Hi, I am trying to automate the printing process. I have a form where I need to make a button that will allow you to perform a find first, and then take those results and print a report. I'm not really used to the layout system yet (coming over from MS Access). I make my printing layout so it looks right, but it looks goofy as a form view... only having showing one record. I don't want to confuse the user, so how can I make it so a certain layout (the final printing one) is ONLY in list view? I would like to do that and have a button to perform the search, then take those results and send them to the LIST ONLY layout... is this possible? Thanks Vandy

Is there a way to get field borders to be non-printing? Whether I use borders, baselines or embossing, etc. the borders always print. For my interface I'd like each editable field to have a light gray box around it, but so far in order for it not to print I have to draw a box around the space or duplicate the field and make it non-printing. Is there a workaround for this? Thanks! Espen

I have a layout containing 2 subsummary parts in a database containing different products. The first should sort on a broad type (for ex: cables) the second should take the cables and sort them by cable type (ex: audio, video, etc.) and display the information for the 1st item in the list. Then under that subsummary it would show a list of all of the Cables that were audio. But for some reason it is losing it on the 2nd subsummary. It should be Cables __Audio ____Audio 1 ____Audio 2 __Video ____Video A ____Video B But what it is doing is Cables __Audio ____Audio 1 ____Audio 2 ____Video A ____Video B Any idea what I am doing wrong…

Is it possible to make filemaker start a new page when the data within the body tag exceeds its own part size and page boundaries.I am currently creating a studio manager for an advertising company and am currently restricted to one page for all my layouts and reports. Any ideas people?: Oh yeah and im new here, hello everyone

Hola everyone, Anyone know of a way of getting the FM graphic ruler to begin at position 0? If I go into layout mode and enable the graphic ruler, it begins at the "true edge" of the page according to my current printer configuration. So, the first x number of pixels on the left (could be 8, could be 18, could be anything) are considered to be the gutter and usable area of the layout doesn't begin there. It makes it tougher to position items if I can't rely on even numbers. I.E. if I want to make a 500 pixel wide window and my printer def is currently an Epson Stylus Photo printer, I have to wrap my thinking around an 8 by 508 working area. If I change to…

Hi I hope I'm in the right forum. Does anyone know what might cause sliding fields to stop short of the bottom of the text in the field - by about half a line of text(in preview mode)? it's a mystery to me why it is happening, and causing printing problems at page breaks. thanks!

I can't seem to make the ToggleWindow[zoom] script step work the way I want it to. The doc says that zoom resizes the window to the last previous defined window size. I thought that the way to "define window size" was to go to layout mode, resize the window by dragging the lower-right corner of the window, and then go to browse mode. However, the ToggleWindow[zoom] step still resizes the window to something else. I obviously haven't found the magic sequence. Can someone offer a recipe for creating a script that goes to a layout and resizes the window to a specific, fixed, window size? Thank you, Chap

I entered a label on a layout and put a border around it. Now FM won't let me back into the border function to remove it. Strange. Any ideas. TIA Ivan

Hi, Sorry for asking something so trivial, but I don't figure out how to rename a button in a layout. It is often useful to do a copy/paste, but the new button has the same name than the button that has been copied. How to change this name? Thanks for your help, Pierre

I have a file called "sales" showing sales for different companies for two products - A and B. The two products have to be in separate detail files as they have different pricings and definitions. I want to produce an invoice in "sales" showing all sales for both products. I can make invoices separately in files A and B but I can't produce a combined invoice in "sales". I currently have a layout in "sales" with portals for A and B, but when I come to show the results on an invoice the layout doesn't work. I have tried the sliding/printing but some of the portal results for product B are over 200 and my layout cant cope! Is there a way I can have two body and tw…

I have a basic fundraising database for a non-profit org I'm helping. I have a set of fields defining bio info, contact info, etc. They want to have info on the spouse (in the same record), if there is one, but not to show the fields for this is there is no spouse. My thought on the way to do this was to have two layouts, and change between the single layout and the married layout based on the content of the marital status field. I created a script that does this, but I want it to run automatically. Is there any way to trigger a script on the changing of a field? I don't think there is. If not, is there any way to have my fields only show up if someone's marri…

I am attempting to create layouts in a FileMaker database to print CD and Cassette labels. I have a background graphic created in Photoshop that consists of a photograph and a logo. This design prints very nicely on an Epson R300 printer from PhotoShop or Preview, but prints at a totally unacceptable resolution from FileMaker. I've inserted the picture in my layout in every file format that FileMaker supports, but all of them print equally poorly. Surely FileMaker will allow me to print good quality graphics on a layout, Right? What am I doing wrong? Thanks for any help you might provide.

Not sure if this is related to layouts or printing but... I have been asked to fix a FileMaker Pro database that contains cassette labels. Each has an A and B side and a unique catalog number. Generally we need to print out the A and B side of one cassette at a time and we want to fill the page with the repeating labels--twelve to a page total. So we do a "find" on the catalog number which brings up the A and B records. We have a label layout for printing which we choose. When we preview, we only see two labels filled in--the A and the B side just once on the page. What we want is to have the page fill with six of each to fill the full 12 slots on the page. Do I…

I'm trying to print a muiti-page form (with merge fields). Each has different fields, etc. Anyway right now I have each page in it's own Layout. is there a way to combine all the layouts into one? Is there like a "page break" function in FM that I'm missing? Also the curly line that's supposed to tell you the dimensions of the page is off. How can I change it? I tried page Setup, but the page is set to the correct size (81/2 x 11). I have no margins and the bottom line is sitting at 9 1/2. Thanks...

What I want to do seems so simple I can't bring myself to believe that FileMaker can't do it. I have a report with a header and a footer and subsummary parts that I want to print out to look like a table. the problem is, the table part consists of four columns per record that vary in length. I can set field borders, and if all four are one line each it looks right. But if one of the columns is two lines, then it alone expands, and the other three show a line at the one line point - meaning there isn't a continuous line between that record and the next. How can I create a table that will expand the borders for all four columns (fields) based on the largest field in th…

I have created multi page invoices and am having problems showing the totals. If I put them in the footer they show on every page which is wring because the total of the line items will be ALL items not just those on the page. If I put them in subsummary or Grand Summary they plonk themselves directly under the Body and I want them to always be at the bottom of the page. I am clearly missing something fundamental but do not know what! To summarise I want one total per invoice on the last page of the invoice AND at the bottom of that page. Thanks all I am learning loads from this forum just by reading

I have a simple one-to-many bibliography db: one author, many titles. I am unable to recreate in FileMaker what seemed transparent in MS Access. I created with no problem a layout with a title portal for data entry. I am unable to create a report that includes more than the first title from each author (columnar layout with title sub-summary). I understand from one of the other Forum discussions that portals are not intended for reports. Likewise, if I do a find for any of the title fields, it returns the first title only (although the second or third title holds the searched for information). Obviously I am doing something wrong and would appreciate any suggestions…

I want to be able set up my current database so that when you view a file you don't lock that file. I was thinking that I could have it switch between Preview and Browse. So intially it would take it to the record and be in preview mode and then once clicking on "edit" button would take it in to browse. However... 1. Does previewing a layout mean that a record isn't locked and someone else can edit? 2. Can preview be increase as the preview of A4 isn't big enough for my layout? The only other solution I know is to duplicate the record and have it so that the fields are editable - but I didn't really want to duplicate layouts as this is tedious if subtle cha…

Hello all.. Stuck again this time with a layout/report have a db careproerties that a layout with a portals relating to housedetails db. This is so a careproperties be given details to what rooms it has , what surfaces etc. set up a portal for each room eg Kitchen # Floor counters apliances Cabinets Notes 1 wood marble oven oak dont clean 2 tile tile microwave oak Livingroom # Floor counters apliances furnishings Notes 1 carpet oak tv silk each type of room has its own fields kitchenfloor, livingroomfloor etc this looks great as a layout cept for the usual problems of pri…

I have a layout that sorts cabinet parts by size. These parts are sorted first by crossgrain width. The widest ones should show up at the top of the list. The second sort is by length, from longest to shortest. The list should read: widest, (longest to shortest) next widest (longest to shortest) etc. I have this layout set up to display in TABLE VIEW. I would like to be have this re-sort occur without any additional keystrokes by me. Is there a way for this table to automatically update and resort itself as i add parts? Thanks for your help. Jarvis [color:"red"]

New to FM (only been using for six months)... Is there a way to create/design a Summarized Report (i.e., a report with subtotals or "sections" of information -- WITHOUT including the field that's being used as the Summary delineator? For example, I might have a field named "color" and want to sort the report BY color (in sections)... all the blue ones, then the green ones. Can the report be displayed (on screen or print) without showing "blue" and "green" as the section dividers? FM "compels" you to choose the summary field(s) during the layout wizard -- I just don't want them to be displayed on the output. Any clues are appreciated.

Am using a modified template from FM solutions and have the following problem. Setting tab order works in the application, but fails when using web sharing. This problem was supposedly fixed in release 7.2, but still occurs after applying the update. Tabbing moves randomly from field to field, not in the order set.

I hope someone can help me out, I designed a Extended columnar report that is approx. 20 pages long. It is set up like a test. I pasted MS Word text on the left side of the layout and an answer field corresponding each question on the right side of the page. My problem comes when I print the form, the fields do not line up properly with the lines of text on the left. It looks fine in Print Preview, but does not print properly. I even tried pasting the test from NotePad and got the same results. Your help would be greatly appreciated. Steve

Hi, I'm new to FM and haven't been able to find an answer to what I assume is a trivial task. Any help is greately appreciated. I'm trying to create a report based on two (three) tables e.g. Table 1: Contract contractId clientName contractDate Table 2: Performer performerId firstName lastName Table 3: ContractPerformer contractId performerId Based on this table structure I'm able to assign a number of performers to each contract. I achieve this using a portal to the Performer table while entering data into Contracts table. I can create a report using the report wizard that generates a list of all contracts grouped by a…

I use the word trashing because it has changed all my files. I opened my original solution in vs. 6 on a new installed copy of FileMaker. All of the fonts on every layout changed. I am out of town and can't access my files at home or at work. Of course, I already switched to Browse - unlike vs. 7, it automatically saved this mess. Does this mean I can't continue the design on it - and globally reassign the fonts when I get home. I use Verdana but this current system doesn't have verdana loaded in FM fonts. I hope I'm making sense .. pretty upset ... I can't believe FM would just change fonts! It should come up with "this font doesn't exist. Would you like …

Posted

Hi, this seems to be an easy question but it has caused me to rack my brains over the weekend. I want to have a layout which display only certain records from a particular table. How do i go about doing it? I have a table called employees. This table has a field called UserType which store either "Manager" or "User". I want a layout which only display those records with usertype "Manager". I have tried creating table occurrence and performing find but they don't seems to work. Maybe i did not do them the right way. Pls advise.

Hi I have a layout with Header,Body,Footer and Title Footer. I'm trying to isert a picture to be printed on this layout placed inside the Footer area. It just doesn't print it! I can see it in "browse mode" but not in "preview mode" and so doesn't print it at all. Any hints? Images can't be placed in the footer? Any reply is appreciated.

I'm setting up a columnar report in the layout mode. I'm using the report to view info not to print anything. I'm trying to move some fields to the right to give myself more room on the report but every time I do they revert back to where they were. I've tried adjusting the right margin but that doesn't seem to help. Any advice would be appreciated.

Not sure if I

I have a field that goes to multiple pages. I run into one of these 2 problems. 1 - First page of data doesn't print, just a blank page. Rest of pages are fine. 2 - All pages print but lines are cut in half and it prints on top of the Header and Footer. I've tried changing sizes of everything, just doesn't work. I think printing from FM is turning into the most difficult task I've had with it.

In MS Access when you got to the last field in the record and then pressed <tab> it would take you to the next (new) entry. In FM P it takes you to the beginning of the same record. How can you make <tab> take you to a a new record?

I have a layout with just one field and a button to run a script. I want the user to be able to enter data and hit the "enter" or "return" key to activate the button and run the script. Is this possible natively in FM 6, or is there a plugin that will accomplish it? Thanks Paul

Hi Folks, Creating and using portals... I want a portal to do exactly what "Table View" does (don't ask why), so I go into relationship view, pick my table and drag a key field (ID) back onto itself (self-join). Then in layout mode, I assign my layout to use the new table, but refering to the fields in the old table (seems to be the way to get it to work). The portal looks pretty and adds to a feeling of euphoria, but both "Find" and "Sort" seem to do nothing. "Find" returns all records whatever you enter in the fields and "Sort" sorts it exactly as it already is. Any ideas :

I'm having some trouble putting together a report of summaries. I have an orders database with many orders in it and some aggregate calculations (i.e. Total quantity sold by product, total revenue by product, gross margin by product, etc...) I'm trying to make a report that looks like this: Broker (Sales Type) Product 1 1555 $30,000 Product 2 (Quantitity sold) (Revenue) Product 3 (Quantitity sold) (Revenue) Product 4 (Quantitity sold) (Revenue) Direct Product 1 (Quantitity sold) (Revenue) Product 2 …

I've created a new layout for a report, and at first it displayed info in any of the four Views (Layout, Browse, Find, or Preview). Now, when I go to look at it, each layout is completely blank -- except for Preview, which displays the report. I want to make some changes to Find criteria, and also to the layout itself, but I can't, because there's nothing appearing on the screen! How can this happen? How to prevent this from happening??_____

I have two dbs (GAME and LINE-UP) linked thru the field "date". I created a layout for the GAME db and inserted the LINE-UP db thru a portal on this sane layout. It looks fine and functions correctly, with the players

Hi. How can I display multiple record fields on one page, like in table view, yet also be able to customize it, like in form view? For example, each record has a date, and a bunch of data in that record. I need to list multiple records, showing the dates across the top, and the corresponding data below, like in an excel spreadsheet. But I need to be able to customize how it all lays out. Anybody know how to do this? Thanks. -Emery

Hi there! I just wanna know if there is a way to get a hint when a user passes mouse over a button. I didn't find anything about that, but I am sure there is a plug-in somewhere for that. Is there a FM way to do it or do I have to buy a plug-in? Thanks in advance!

For a class-enrollment application, I've got a set of classes that sometimes have multiple teachers and always have multiple students, i.e. two many-to-many relationships with join tables. One of the requirements is for a grouped-data report that's supposed to look basically like this: sub-summary by teacher - sub-summary by class (each teacher has four) -- list of enrolled students (5-20) The goal is to get a big report that can be broken out into a printout for each teacher listing the students in each of their four classes. (If classes had only one teacher, this would be easy.) When I do the report with "Show records from" set to the teacher-class j…

<Standard disclaimer about being new and clueless.> Using FM 5.5, I've created a basic phone log. I made a data input form in the related file (containing client demographics) which includes a portal that shows the specifics of each call made to/from the client (stored in the master file). Now I want to add a button *in the related file* that will go to a call log summary layout. I want a chronological list of each call received at the office each day. If I place the layout in the master file, this works fine. But a similar layout in the related file doesn't work. It only contains as many records as there are clients. In other words, the client f…

I am new to Filemaker Pro7 and have a couple of trivial (I hope) questions. 1. When you click on a "popup list" and select an item from it, Filemaker automatically sends you to the next tab item. If this is another popup list, it opens it up. Is this by design, and if so, can I switch it off ? I have tried "popup menus" but prefer the look/feel of the list. Also, I thought of using a dummy field behind the main field which is ahead in the tab order - but on a large layout this would be painful to implement. 2. Can I dynamically set the colors of the Header/Body/Footer ? For instance, is there a function like SetHeaderColor(RGB(...)) 3. Can you pro…

what i would like to be able to do is either; 1. once i have a list of record search within that list for a keyword but i want to keep the found set in place but simple scroll through similiar to a spell check' or 2. the ability to do a search and be able to highlight certain words throughout any ideas on these anyone ?

I've been tring to sort reports based upon the contents of a field that the user selects (checkbox set). I started by saving various 'sort records [restore]' scripts but after typing over 100 scripts from the possible combination of 512 I got fed up and visited fmForoums. So all you kind bods of much knowledge? Is they a way out of this, can I script sort orders? Thanks

My FM7 database has several tables and reports (layouts).One layout is the "main panel" with buttons for invoking specific reports. For some of the reports, I'd like to be able to specify the Find criteria (such as a date-range like yyyy.mm.dd...yyyy.mm.dd) and other selection criteria values at the time I request the report, without having to get into the cumbersome Find Mode screen (which I know can be displayed with a script command). The selection criteria may include both AND and OR conditions, and involve one or more fields. Is there a more elegant (and "foolproof") way to achieve this on the "main" or a "sub" panel?____

Hello, I'm working on an old database and I find regularly a kind of field I don't understand. It is used in list layout and shows several fields in one zone. If I go in the properties, the option "Specify Field" is not shown. There is in example in the attached file (it is just one layout with a copy/past of the mysterious field. It is useless to precise I am a newbie in FileMaker (and in English too ). Thanks for your help, Pierre Example.zip

Hi, I have a columnar/list report containig three fields while field 1 is always only one line, the fields 2 and 3 may contain one to four lines. To save space I would like to use sliding, but i would like the three fields to slide together and assume the hight of the hightest box (the one with the most lines) eg. if the box with the most lines contains three lines all boxes are 3 lines high. Is there a simple solution to my problem? Thanks in advance, Shao

I want to simulate the back and forward buttons on Web browsers in FileMaker while offline. Does such functionality already exist? Thanks, Gordon

I have a form that is filled out via the web in Filemaker. There is a place for 4 separate text comments. Since I never know how long the comments might be, the Filemaker layout has a single text box with MERGE FIELDS (like <<Comment1>>) so the comments flow nicely. The problem is that some users have exceeded the normal length of a comment which resulted in the last comment being cut off in many cases, So, I decided to add a second page to the layout (I just slid the body downward) and made the comment text box longer. I set it to slide up. This way, if there were normal comments, the second page wouldn't print. I was thinking the 2nd page would o…

Anyone else notice that the Size box in layout mode list the demensions in the order or Width and Heigth, but the Window scripts to sepcify the demensions are in Heigth/Width. I know this of course.. but it never fials, everytime I go to use the little object size tool to estimate a window size, I get it backwards when I enter it into the script! ..funny how the more powerful and improved an application gets, the more we complain about the little things..

Hi Having trouble with a layout.... I need to show and make editable the data some related tables. I have Week which contains some Days which contain some Sessions. Day has a number of SessionIDs and Week has some DayIDs. Since I am using repeating values, I can get the sessionID's listed easily, but cannot pull all the other info out ... how do I get the repeating fields out? eq Day::Session::StartTime Am I doing this the wrong way??? Thanks Adam.

Hi there I am trying to figure out how to have a layout where I can store data within multiple pages with buttons along the top which will take me to different pages within the same layout. Am I making sense? New to FM and finding the online help really useful but can't seem to find info on this. thanks in advance, Diane

Hi everyone, I want to create a report layout, which can display, the number of all active cases for each individual in the database, in a single layout. I either want to do it with a click of a button or when I open this layout. There are several individuals that are assigned a case and the status of a case is either active or closed. I dont have a clue as to how to start doing that. Thanks.

We are in the process of converting our Excel database of calendar information into a Filemaker database which we share between Mac OS 9 and Windows 98 computers. In Excel, we often pulled reports into Word using mail merge, creating 3 column formats that are easy to distribute to the public and our media and academic contacts. We have now set up a layout on FMP to do this, but there are a few kinks we are trying to work out. This past week I figured out how to do sub-summaries to have the dates sorted by Month on the layout. Next on the agenda is to fix the spacing. I'm using merge fields so the internal spaces are cenched up. I am also using the sliding option…

Lists are great.... However how can I setup a custom list so that from a drop down selection the selection field is shown in the list. I was considering: 1. Global field which has the selection you want 2. An extra calculation field in the list that says if(global field= X,display x, else..... But isnt this quite a slow process particularly on long listings Any other solutions?: S

I created a form with different attributes like font, color, etc... for each field. This is good as I can give a particular field a greater prominence over another, which looks great on forms. When I change this form to table view, the resulting table assumes the same attributes for each field as in the form view. This is not good as I want my table to have all fields with the same font, font size, etc...giving it a more "regular" or "traditional" look. I also don

yeah.. i've run into this before, so I know that it is something that filemaker doesn't let you do, but I am hoping someone may have a workaround... I want to interact with a global field in a header while in a list view. basically what i want is to have a field at the top of my list view, that the user can type into and hit a "find" button and it will then run a script that does a find. Kind of like a quick find thing. The only problem is, I can't interact with fields in the header, so the user can't type into it... I am using Filmaker 6

Howdy, I want to show a custom dialog with a message that resides in a table in another DB file. So, I have set up a related ID field in the current table matching the ID in the other file. By setting it to a particular value, I can access particular text. However, problems arise when I move to another layout - I need another related "ID" field in my new current table. AND SO ON, AD INFINITUM. Is there no easy way of getting at fields in tables in other files, without resorting to specifying related fields in the CURRENT TABLE ? ie. Perhaps a global field in a not so current table ? (tried this but didn't appear to work) This post is re-wor…

Ok...I have a very weird thing...When I go to layout mode...the background changes to look like 1/2 paper and 1/2 gray...some of my objects are on and some are all off... Looks very funny...but when I try to go make some new objects on the gray area it will not let me? When I try to drag them off the white area it shows my a "do not sign"... It was not like this when I started designing my page but now its like this...what can I do to fix it? Thanks Joseph

probably a simple answer I hope. I have a list layout with a header and a body. The body list the values that I want but I have the header background as white and the body as a grey. In the contacts listing it gives the whole of the bottom part of the header as grey which is great. But in the company list it only display grey on the individual line of the companies being listed. Any idea how to get it all grey Thanks Simon

OK this should be an easy one for someone out there to help me with. FileMaker is cross platform. It's great! It means the guys in our design studio can access all our company records in the main database. I've recently started upgrading our company solution so that macs can use the functions also. But most of my layouts use the windows Tahoma font. Does this display on a mac? I cannot test it at the moment as I am making changes to our database out of office hours, using the remote desktop so I can't fire it up on my mac. Just wondering if anyone could give me a quick answer so I can change all the fonts tonight if necessary. What fonts d…

Hi all, looking for a bit of help and was wondering if anyone here could provide some answers! I have a columnar list, and with it I have summaries after several types of sorts. All of these summaries are to appear, and contain (basically) the same information. Obviously, if the sorts have a lot of data to work with, and some distancing appears, then I want to have each of these summaries appear. However, if I have just a single item, is there any way I can go about just ignoring summaries for single items? Thanks a lot! Jim

Hi there - Fairly new to FM Forum but have used it in the past and you guys have been great in helping me understand where I was going wrong! My problem now is a 'letter' page written to clients that include certain fields from a 'main' overall page. Such as Dear 'John' thank you for your call . . . your quote is 'Quote 1' and the total cost is 'Cost1'. My problem is when I add the field 'client first name' how do I add a comma after his name?? Also when I have a 'project name' inserted and then need to insert another field such as 'on this date' how do I close both together without any gaps?? I've tried useing the 'slide' etc. but cannot get it to look like…

I have a client that needs a patient health record system that has the ability to print out and store their client's health information. One of the problems I have run into is how to setup FM so that it will adhere to their rigid chart template. Can anyone point me in the right direction when it comes to designing single record/multi-page layouts? The multi-page layout is rather large (86 pages). Will FM handle this or not?

I have a fp5 file where multiple users can access but depending on the password, i want to control which layout is presented to that user. Can anyone guide me on how I can accomplish this? TIA, Deo

Hi everybody! I have an annonying problem I hope you pro

I have a database of Pages in a photo catalog, and images on each page. I need a report that has the page number in the catalog page number in the title, then the items that will be on that page in the body. I got it mostly done by putting the page value in a sub summary (when sorted by TempPage). The problem is that when there are more records for a page than will fit on one page, the second page does not have the page info at the top of the page. I tried putting page number data in a leading grand summary, but that just puts the page number of the first record at the top of the page and all data below. Also tried this with a blank sub summary. Can anyo…

I'm working on a database to store and audit profiles. From the text I import I want a layout with just profile name once where auditors can click on the profile and view new profiles. i thought about using buttons to reference searches however new profiles may show up at anytime. Is there a function similar to excel unique record in which I could script to show unique profile names each time I import new data?I appreciate the help.

Hi. Attached is the database I am working on. It's buggy in that when the "printable layout" is chosen in preview mode, each merge field has an inconsistent amount of whitespace below (above?), despite sliding being enabled. Please take a look and any suggestions would be much appreciaied. Jeremy reup.ZIP

hello everyone, i often copy all fields from my contact database records onto the clipboard to paste the data into emails etc., using the "copy record" script. because usually not all fields are filled out (home phone, work phone, home fax, work fax, etc.) the data appears with gaps once it's pasted into something else. is there a way to select all data from a record and have all fields appear on separate lines when pasted, preferably so that empty fields are ignored? so that someone with only name, email and home phone would appear like this: name email home phone instead of something like this: name email home phone…

I'm trying to figure how to do a report.....that lists how many people are active each month. names.fp7 event name.fp7 event line.fp7 The event line has a date as well as a status field (on waiting list / active / de-activated). I know how to create a report listing activity broken down into months totaling how many people changed each status each month but not a running total of how many people active in each month. ideas please....

I am very new to file maker pro 6. How do you set up different sorts for different layouts. Say one layout you want to be sorted by date and a different layout you want sorted by client name? Right now I can only do one sort for all layouts...... any thoughts?

Hi all: I've got this hideously difficult page-layout problem that I've been working with for quite a while now. The client has one layout for the first page, another for the last page, and a third for any pages that go in between. The body is a list of items, and I'm printing from the file with the data in it. What I've got happening now is that the user can enter preview mode & view a 1-page layout, or a 2-page layout, and see which one works. There is no option for a longer layout, because I can't figure out how to determine which record would go on which page. Each of the three layouts has a different amount of body space (due to different headers & fo…

Hi I have created a simple bookkeeping database and want to have a monthly report for sales and purchases. The report should be broken into months with a total after each month. I have searched the accompanying manual but cannot find the process. Can anyone help? thanks

Have you tried using merge fields? They will shrink in Browse Mode if no data exists.

Is there a way to set different tab orders inside the same layout??? in a data entry layout I have different "sub-groups" of information (they are sub-groups because I have format it them to look like that, but there are all in the same layout/portal/database), and would like to allows the user to tab from field to fiels in that sub-group??? can anyone help??? (I'm probably not explaining my self very well, but hopefully someone out there understand what I mean and have some suggestions) [color:"blue"]

I am using calc fields as containers to have dynamic buttons. My graphic is made in FM7 (simple figures using the rectangle, circle and line functions). When inserting this graphic into the Repeating container field used as the graphics "bank", my Calc field container displays a warped graphic. I've tweaked the crop, reduce and enlarge functions. I've changed the dimensions of the Calc field container and the repeating "bank" container field, all without help. What am I doing wrong? Thank's in advance. "It's never so bad that it couldn't get worse."

Hi Simple question is there a way to highlight a row in a list? Simon

Can anybody offer a hint or trick for printing 2 (of many) text fields sideways? I use FM to fill in the data on a pre-printed form which has recently been revised to include social security numbers along the left edge in a sideways orientation (so that the numbers run vertically along the edge, "top" to the edge). Only thing I could find in FM Help was for Asian text rotation--not a help. Any suggestions? I don't need to print this form very often, so even a clunky workaround would be welcome.

I want to hide the horizontal and vertical scrollbars and the window header. Is this possible and if so how? I'm using FM Pro 7 on a Windows XP Home PC and the windows are being created with the 'New Window' script step in FM Pro 7.

How do I set up a layout so that I can enter multiple records on one screen. I have a database where we enter sample records based on common data such as customer, address, date etc. Samples are submitted in batches of 10 so I need to be able to enter all the records on one page. The Customer Name etc fields will be common to all the records so as opposed to entering all the records on a seperate screen by creating a new record for each I would prefer for ease of entry to enter them all on the same screen. Each batch of 10 record entries can then be given a specific key field common to all the records on that entry for ease of lookup later when we come writing…

I'm assuming these aren't possible. Say I have one layout with certain content, then I have a script go to the next layout. If I set the background colour of the second layout to transparent, presumably it just shows a white background, and not the contents of the previous layout. Is that a feature in filemaker 7? I'm assuming there aren't any plugins to change this as the FileMaker layout system seems a pretty integrated and hardcore aspect of filemaker. Is it possible? Just to save copying a section of layout objects into 20 other layouts every time I make a change. Thanks

How can you show a field in a layout that comes from another unrelated database. I have a file with 5 tables, 3 of which have relational links to each other and 2 which are stand alone. When building a layout on one of the related tables I am allowed to add a field from on of the unrelatied stand alone tables. However, in browse mode the field says '<Unrelated Table>'. Why do they give you the option to add unrelated table fields but not show the data from them. I was under the impression that there had to be a related link to a table before you could view it's data (and add it's fields to your layout). Any ideas??

I want to try and display a list but I notice that when you have it in list mode the data at the top of the list is fixed (relating to the record selected in the list). Is there a way to have a list and still be able to edit all the details on the top? Thanks

Is it possible to format all my newly created fields to make them larger and to have them all spaced a certain distance without having to adjust each field? I know, it is a novice question, but this novice is on deadlines. thanks d FileMaker Version: 7

I have a long (I guess you can say a "Letter") that goes so far that FM6 does not have any more room left...but I have 10 more pages of print that I need to print with the orginal letter...How many options do I have. Best case for me would be to make FM6 handle more on the same layout... Second Best for me would be to make FM6 auto print the other letters when I print the orginal one. Help.... Thank you FileMaker Version: 6 Platform: Windows 2000

I want to know how to make a Report for any date range with Starting and closing balance. The data base is having debit and credit entries entered chronologically and having running balance. Please help me out. FileMaker Version: Dev 6 Platform: Mac OS X Panther

Does anybody know how I can bring up the LAYOUT DROP-DOWN MENU with a keyboard shortcut? It a pain in the butt having to reach for the mouse simply to invoke this menu. FileMaker Version: 6 Platform: Mac OS 9

Please help -- I am sure this will be amazingly simple for some of you out there but I can't get my head around how to do this. I have a file (basic version attached) which parses a block of text into the individual words it contains (each word is made a separate record). These records/words are then sorted and a count of the occurrences of each word is shown by a subsummary. What do I need to do to show the words sorted in ascending/descending order of the number of occurrences [can't sort by summary field?] rather than by word order? Thanks in advance efen FileMaker Version: 6 Platform: Windows 95/98 Parse.zip

Here's an interesting tidbit: In FM7, you can edit fields that are in the Header and Footer sections. Very useful for working with lists. FileMaker Version: Dev 7 Platform: Mac OS X Panther

Hello everyone. Little problem I'm having at the moment. I'm trying to 'lock down' a solution I've made by removing the status area. I have proper navigation within the solution. Whenever I remove the status area, the text I have within the header area gets.. 'changed'? It appears with the upper half of the text removed. If I put the status area back, the problem disappears. This happens to the text regardless of positioning within the header, regardless of header size. Can anyone shed any light on this? Is this a bug within FM7? FileMaker Version: 7 Platform: Windows XP

Hello, My company has decided to recycle the excellent FileMaker solution we have created for one of our projects for use on another similar project. (We are a publishing company and we use FM to handle invoicing, ad tracking, proofing, collections, etc). However, I have to make several changes to our Invoice layouts, issue names, and so on, enough that I think the best way to do it is to make a seperate version of the same database using FileMaker Developer (to rename the files from the current solution) and FileMaker Pro to save new cloned copies of the files. I then reset all of the serial-value numeric fields across all of the files in our solution (all 45 of …

Hello everybody, I have a problem regarding sorting by different fields in the same DB file. After I created a second columnar report (with some summary calculations by a different field than the initial sorting field), I noticed that I have changed the sorting order of the entire DB file. So, my question is, if it possible to have different sorting orders in the same DB file, to sort the records by different fields for different layouts of the file and how could I do that? Any help/suggestion would be very much appreciated. Especially quick ones... Alin Popescu FileMaker Version: 5 Platform: Windows 2000

FM breaks the object sliding capabilities found in earlier versions. If you have fields that span multiple pages (such a descriptive text fields) you could set the height of the fields to be say 3" each then place them on a layout (some of mine went 6 pages) then set the objects to slide up with "reduce the size of the enclosing part" set on so if the user did not write much in a field it would shrink: most of my pages when they printed would be 1 page long... occasionally 2 pages very occasionally 3 pages. In FM7 these pages print only the fields that appear on each page

Hello, I am trying to produce a time sheet report, and I want it to look like this. Client Name Sunday Monday Tuesday Wednesday Thursday 4/11 4/12 4/13 4/14 4/15 ABC Company 0 2 6 8 8 XYZ 0 6 2 0 0 Totals 0 8 8 8 8 It seems I can not get the report to sort correctly. The name of the layout i…

Is there a way to MS word to have my reports in and print with the correct information in them? FileMaker Version: 6 Platform: Windows 2000