Layouts

I did not know what area to post this, sorry if it does not belong here. Is it possible to change the icon (FM folder) in the top left corner of the bar. Is there a way we can place our own icon there? It would at least be nice to do on a kiosk project. Thanks, Jim

I've noticed that in databases I design, people often end up in the find mode and don't realise. Or they forget. So they perhaps click the find button get a bit confused by something and then forget they're searching. The difference between the browse layout and the find layout isn't great! I was thinking of changing the find layout - maybe a background colour to make sure people are aware of where they are. But I can't figure out how to do that. Any thoughts? Or other solutions?

I work on a report. The report is based on the table which is organised this way: tbSchedule ID Fk_Class DateClass Month Week Desc The report should grouped by Class (Header) Month (Sub-summary) Week (Sub-summary) DateClass (Body) Desc (Body) what should give me this: Class 3600 Date1 Date2 Date3 Date4 Date5 Date6 Date7 Date8 Date9 Date10 Date11 Date12 Page break (how?) and next class: Class 5600 Date1 Date2 Date3 Date4 Date5 Date6 Date7 Date8 Date9 Date10 Date11 Date12 I divid…

Is it possible to merge together several related records? Here's what I'm trying to do: I have a many-to-many relationship between Authors and Books since a book can have one or more authors. In the books database we see a list of the associated authors via a portal. This is all well and fine for data entry screens. However, when doing reports we don't have room for a vertical list of authors, we need them to be listed horizonally. Typically we'll only list their last name. The three things I can think of are a horizontal portal, merge field, or calculation. The first would involve rotating the orientation of the portal somehow so that multiple records are disp…

I am working on a database for an Talent Agent and need to have a section for scripts that they recieve. I would like to created a button where you can add roles and when you press it I would like there to be a pop-up row with fields to enter... Basically on of the records to be a pop-up... Is that possible? Thanks Frida

I had a non-specific question - what is the most common layout size that developers use. I tend to use the FM default - 640x480, and it leaves me cramped for space. Since people have higher resolution monitors now, it is OK to move to 800x600 or even higher? How about full screen layouts? Will customers accept it? Most of my windows customers seem to want a full screen mode and mac customers like a small window. When developing for mixed OS use, I'm stuck in between. thanks indy

I think this is a fairly simple question, but I can't find the answer to it anywhere, either in the manual nor in the 'Missing Manual' book. I need to make an Invoice-like layout, that summarizes a physician's appointments in a particular date range. So basically, I need the user to be able to select a patient, start date, and end date, and find matching records (there is a table which contains the appointments). I haven't figured out how to 'Find' records that lie between the two inputted dates. How do I do this? Thanks in advance!

Is there a way to edit the html page that FM generates for User login for Instant Web Publishing? Why I am glad it has that feature, I would really like to change the way the login page looks.. :)

In my latest upgrade (FM8 Adv) users are complaining that some records in some layouts have anomalous spell check options. Instead of Replace at the top choice in the spell check window they get Next. I can't figure out why this is so, or what to do about it. Seems quite odd. Have tried various approaches, dictionary selections etc. Any clever ideas?

Hi everyone, I am a beginner in FM (using FM Pro 6) and have troubles customizing even though I have went through the help files and book. Hope someone can help me on this problem I have. I have 2 fields; Field A and Field B. Field A is linked to a value list. However, my problem is that I want it customized in such a way that when I select an item from Field A, if would reflect a value list of my choice in Field B. e.g. When I select "Furniture" from the drop down menu of Field A, I would want to see a list of furniture (already created a value list for it). Likewise, when I select "Hardware" from the drop down menu of Field A, I would want to see a list…

Hi we have 200 school,we do job for all schools every day,at the end of the month I have to do report showing school ID,schools name,total of jobs,total of copies. How do I do that? Please(por favor)

Hi, Hate to bother everyone with this (more than likely simple question)… I am plodding along pretty well, with my books and this forum, however I have one I just cant seem to make work. I have a date field, and I have a total hours field (the two fields go together in the same layout). I have a field which I want to show the total hours for all the fields which have a date during 2006.or 2007 or 2008 etc. Example Date Field xx/xx2006 xx/xx/2006 there is an hour field adjacent to the date. Hour Field 22 31 Then a total hours by year Total for 2006: This is what I cant make add up I want to have a field tha…

Hello All. I'm not sure if this is the most appropriate forum for this question, but I've always gotten great support from this site, so here goes: I would like to include a font or other appearance change as part of a script. I have many text buttons set on a layout to find various groups (using buttons rather than find commands to make the layout simple for novice users of this report). However, it's impossible for users to tell at the moment which button has been activated, and therefore which subgroup has been found. I would love to find a way to include a font color change as part of a script, so that I can make the button text indicate the butto…

Hi, I'm having a really annoying issue with FM8 redrawing the screen multiple times. If I just click on the windows taskbar my FM8 screen will redraw itself sometimes 6 or 7 times ! I have now noticed that the redrawing is reduced and eventually eliminated by closing other applications. If nothing else is running, the redraws don't happen. But its impractical to have to close everything just to run FM. If I have another application in my active window, I can see my FM8 screen in the background busily redrawing itself over and over continuously. If I click on an FM menu option, I might get 3 or 4 redraws before the menu item I clicked on is activated. …

Hello, I would like to know if some one is using an easy way to detect if some field in a layout has been modified. (I.e. using the eval function). I´m actually using calculation fields for every field that I want to track, but this is hard to use in layouts which has a lot of fields inside them. (sorry for my english) Thank you in advance.

??? I may have misunderstood and misspoke--- and now I am really confused and would really appreciate being informed on the best practices…. I have a main menu- with Data Entry, Query, Reports and Maintenance I am in the process of changing the Data Entry screen so that you cannot do a find on this layout. Is that the best practice? What if a user wants to find a person and edit the record? On the Query, the user puts in the criteria and the find comes up in a table view—but she sees an error and wants to fix the salary or something. Do I link the find results to the data entry field? What is the best practices or what do you recommend? Thanks for …

I have a field which uses a value list drawn from the records in a related table. All the items in the list display perfectly if I format the field as radio buttons or check boxes, but nothing appears if I select drop-down list or pop-up menu. Clearly, the relationship is good and the value list is properly populating - what's wrong with the display?

Hi All, I'm working on a purchase order database with FM8. I have 3 tables (Product, Join & PO). When I create a summary report, only the first line of product from the PO is displayed. There could be multiple products in that PO. Do I need some kind of loop? Or a different layout? Any help on that is greatly appreciated.

Is there a way to make a button inactive if the user is viewing the database from a web browser as opposed to the FM application? I have a script that contains some functions that ARE web compatible, and some functions that are not web compatible within the script attached to a button. If a web user clicks the button, it runs part of the script (the part that IS web compatible) and ignores the non compatibile part, which then breaks the data in the database.

I have a report Day (sub - break before each occurance) Department (sub) Body This will report all department activites for a single day. When they layout is set to a single column, it all works perfect. But when I set it too a two column layout the departments from the next day will flow into the current day if there is room. Please help - thanks

This is my first post, I've tried searching without much luck. I've created a "Part Database" that has all the different Capacitor and Resistor Values we have in stock. Anyways... for some reason everytime I open the file, it minimizes automatically. So whenever I open the file I have to maximize it, I made a maximize script to automate that. But I still see it minimize and then maximize automatically... that gets annoying. I've checked the File Options and all the scripts and stuff... I'm really stumped and getting somewhat frustrated. Someone please help! Thanks in advance.

Hi everyone. How would I go about setting all my layouts to always be maximized? Sometimes, clicking back and forth on buttons will resize the screen. I've tried the 'specify button' options, but then selecting multiple factors (such as the move/resize window and go to layout) will void the first option (i.e. I wished that these would be on a check on option rather than the highlight). Any ideas?

I have a script that runs and opens a layout and it is finding on all the entries that have a specific agent name. It is fine in browse mode and returns the right db entries, but when I switch to preview mode it only shows the entries in the trailing grand summary and the Sub summary when sorted by part is empty. when I take of the find criteria and have the script return all entries in the db it is fine though ?

I'm doing a layout for a List view and I want the top edge of the Footer to seamlessly blend with the body rows. Right now there's a one-pixel-wide black horizontal line where they meet. I managed to accomplish this once, by placing wide rectangles on both the footer and the body and nudging them into some magic position. Today, nudge as I might, I can't find the sweet spot. I've never understood the rules by which FM renders layouts whose parts contain objects that partially extend beyond the boundaries of the part, but I think that is key to solving this problem. Anyone? Thanks, Chap

I have some drop down menu fields in a database, and when I go into edit mode from a "Instant Web Published" database, all the text in the drop down boxes look like they are too tall to fit in the box. Or that the box is too short to show the enitire height of the selected fonts text in that field. But when you are not in edit mode, they look fine. Is there a way to prevent this?

In a table view, the current record is indicated by a narrow band at the left. Is there a simple way to arrange that the entire row be highlighted (as in Excel, when you click on the row number)? I know you can put a button over the row, and you get a highlight effect when you press the button, but that's not sufficient. I'd like that same visual effect, but automatically for the current record, without requiring any user action.

Hi: I hope I can explain what I want to do: I have a layout with records from Table A, I want to show found records from Table B (un-related)in a new window, but I want to continue to show the layout from Table A as well. From Table A I invoke a script that switches to Table B and preforms a find, if records are found I want to pop up a new layout with the found records. This works for the new layout, but the underlying layout switches to the same layout as the new one. Can anyone give me some guidance, please?

I'm attempting to make a template table with certain "housekeeping" type fields including my primary key field which will always be a serial #. I would like this serial # to be done with a calculation so it will grab the first three letters of the LayoutName and then I want it to include a number starting with 1 but including six zeros before the 1. As the serial # grows, there will be less and less zeros before the # (ex, INV0000124, INV0001335) This is what I have so far: SerialIncrement ( Left (Get ( LayoutName );3); 1 ) I don't know how to write this calculation to force the # portion of the serial # to 7-digits. Can anyone help me out? Thanks! C…

Hi everyone, I have a newbie question...how can I auto-enter a single value in all the repetition fields? For example: I have a field "Color" with 3 repetitions. I would like to auto-enter "Blue" into all the repetition fields of "Color". Right now, when I auto-enter "Blue", only the 1st repetition field is affected. The 2nd and 3rd repetition fields remain blank. Thanks for your help.

Is there a way when using web publishing with FMP to have it default to not showing the left side panel that allows users to select layouts and move forward backward through records? I dont like the way that window looks.

Sorry if this is not the correct section for this question but I did not see a section relating to backups specifically. I have two db’s that I am working with, I have defined the file reference to db #2 so that I can bring up the needed info to db #1. My question is about backup…if I do a backup via the standard method, I am only backing up the working db #1. Is there a script that I can use to backup both db’s in one motion. Thanks, Jim

I'm having a small problem, well small isn't exactly the word for it. I'm attempting to relate a global in the parent table to an unstored calc in the child table and then to display the related records using merge fields --> All i get in browse mode is: . Could anyone please shed some light on this? Cheers, ~Genx

Is it possible to use a merge field and specify a repitition number for that field? If so how? I have a Global Text field with repititions used to hold user-friendly layout names. I want to show the user the Layout Name by setting the repitition number. Thank you.

This may just be a short coming of filemaker's features, but I thought I'd ask. Is it possible to have a layout or part of a layout that will lengthen and shorten itself based on the amount of data in a field? Some records I use have 30 lines of text while others have only 5. It would be great if I didn't have to use space on the paper when I print for 30 lines of text even though every record doesn't use 30 lines. Any thoughts?

Hello! So... I've got a product sheet that contains 8 sliding repeating fields (of maximum 10). As you can probably guess, this takes up multiple pages. I'm sure I'm not the first one to ask this (I did look), but is there a way to stop the fields from crossing pages and starting on the next page? I've fooled around with subsummaries, but I don't like the way they work, as on some occasions, these fields only contain one repetition. Thanks in advance, M

Hi, I'm using FM7 on MAC and I'm a beginer. I'll try to use the good terms to explain my problem. My problem is that I'm entering date and I want to set it up YEAR-MONTH-DAY. I've changed it that way i n the LAYOUT, clicked on my date field and went to FORMAT>DATE and changed the format there. Selected Custom, then Year, Month, Date seperated with "-". No problem so far. Now, in the BROWSE section, it looks as I wanted, YEAR-MONTH-DAY. But when I click on the field, it changes MONTH/DAY/YEAR and I have to enter the data that way. When I hit enter it goes back to YEAR-MONTH-DAY. Now how I do change the fact that when I click on it, I have to enter the d…

I have a layout for printing that combines all the information from other layouts. It spans two pages in layout mode. As the fields' information content varies, I use sliding. In preview mode/printing the follwing happens: All the fields that are slided to the first page show up properly but the text labels belonging to them do not. They just disappear. Turning off sliding or turning the text labels into fields is the only way to get them to show. The second problem I have with sliding: When slided to the first page certain fields get separated (one part of information showing on page 1 and the other part on page 2). This wouldn't be such a big problem if they were jus…

I have a layout on which the only user-changeable field is a date field, which uses the pop-up calendar for entry. The problem is that after clicking on a date, the calendar does not pop back down like it does on other layouts. These calendars seem to have a need to auto-tab to a next field and on this layout there's not one. I tried several things but an extra click out to the side is always required. Is there a way to get around this without adding a dummy field just to "catch" the tab action? Thanks for any help with this.

Hey all, Here;s the issue, i need to produce a report such as the following: Sex - Male________100 (50%) BREED 1 = 5 (5%) Andy Will Ashley BREED 2 = 55 (55%) John Brendan ... BREED 3 = 40 (40%) Joshua William ... Sex - Female________100 (50%) BREED 1 = 10 (10%) Laura Willma Ash BREED 2 = 50 (50%) Joanne Brenda ... BREED 3 = 40 (40%) Lianne Jo ... And so on, i'm just having problems figureing out how to get the percentages of a particular subsummary - anyone lend a hand? Cheers, ~Genx

I apologize if this has been answered before but... I want to create a report based on: Managers Table: Mgr # Cost Center Hours Worked Table: Employee Cost Center Hours The report should look like: Manager Cost Center managed Employee charging time to that CC 2nd Emp charging time ... 2nd Cost Center managed Employee charging time ... Next Manager ... I'm sure I'm missing something obvious, but I don't see how to do this short of creating a new table via a script and then reporting from that. Any help would be apprec…

I have a layout with a background set by a global container field. The Field Behavior has "Allow field to be entered:..." all unchecked. This field object is locked, using the Arrange:Lock menu. In Browse mode, when the user clicks on the background a message window is displayed with: "No records are present. To create a new record choose New Record menu command." The layout is based on a TO and has a portal and a couple of other fields. The background global container is in a separate globals table. Why does this happen and how can I turn it off? TIA

Hello everyone, is there a way to have a button that opens a windows explorer window in a specific directory?

Newbie Question: When someone enters my db, is it possible to open to a blank record? and if so how, as I have looked and looked for the solutions but have found none. I really do not want to enter with the New Record Request as I want a blank start for the user to decide what they want to do...search, new etc. Thanks for your assistance, Jim

Hello, I'm wondering if FM has any way of making something similar to the Title Footer, except instead of appearing only on the first page, it appears only on the last page of the Preview. Any ideas? Thanks, M My apologies, this has already been dealt with http://fmforums.com/forum/showtopic.php?tid/177458/post/208840/hl/footer+last/#208840 Apparently the answer is sort of (with Trailing Grand Summary).

A small thing, but slightly annoying. Everytime I go to a layout and choose print and then from that dialog choose pdf it comes up with a default filename for that pdf. It's slightly annoying because I sometimes have clients over me watching and it's not good to see some other projects name pop up. Any thoughts?

So, if I can't subsummarize a report based on a related field, how do I do show summarized information from several tables? I need to show information about the current school year (table = activeYear which is the base table for my report layout). How do I summarize students and teachers by memberCode (table: activeYear),by school district (table: districts), by school level (table: schools), by school (table: schools), by ethnicity and by gender (table for both: persons)? I know this is a very bare bones description of my problem, but I'm better at answering questions that at anticipating them. Abbe

If you've got two layouts in one table, can you restrict which records are shown by each layout? I know I can write a script that shows only certain records based on field contents, but can I make it work in such a way that the user doesn't have to run the script? I just want Layout A to show X records and Layout B to show Y records, all in the same table. Is this possible? Thanks! Tom

I am trying to invoice a group for membership fees. I would like to keep record of all invoices for each customer. There are some other things which I need to do, but I think if I can figure out how to set up TOs for a simple invoicing. I have members who get billed yearly, and I would like to be able to input past dues information to keep track of what each member has paid as well as ongoing dues which are billed. What is the simplist way to go about this? Thanks.

This is probably a very simple question, but I'm still trying to convert from a FM4 way of thinking to FM8. I have a "sample" table where records are entered as samples are submitted. I also have several "service" tables, each representing a different "service". Any combination and number of services may be performed on a particular sample. I need to generate reports for invoices and packing lists as follows: Sample (from Sample table) Service 1 Record 1 (from Service 1 table based on sample) Record 2 (from Service 1 table based on sample) Record 3 (from Service 1 table based on sample) Service 2 Record 1 (from Service 2 table …

Is it possible to have a portal inside of a tabbed Control element? I created a tabbed element with 3 tabs, and tried to drag an already created portale into it, but it doesnt seem to work.

Hi, I have a field on my layout which has Get(FoundCount)…am I wrong in thinking this should not show a total of the files found in a search (a total of files?) Mine shows 1, then you arrow over to the next record and it shows 2 and so on. What I am seeking is something to show the total number of records found in my search. Can anyone assist me? Thanks, Jim

Hi, all. What a weird "problem"! I need to put two merge fields next to each other, inside the same "field", right-aligned, for display on a layout. I want them to display in the left-hand third of the layout. The problem is that <><> is so long that I can't slide it into position: it bumps into the left edge of the layout! If I try to resize the whole gizmo, FM re-extends it towards the bottom which results in the "field" being 3 or 4 lines high, which is not what I want at all... Any suggestions? Thanks!

Hi, Beginner here. I'm creating a form letter which is fairly long. About 2 of my paragraphs plus the signature show up in the layout mode but not in preview mode. It looks like the text box is big enough to accommodate it, so I'm not sure what's wrong. Any suggestions?

Im new at filemaker and have a lot of questions. so bear with me... I use filemaker at work and we have 1 layout so far which was created before I started working here. It's a 8.5 x 11 form. Now we want to create a second layout - cue card size -. Will the information I input into the form automatically input into the cue card?? Is there a way I can do this?? Thanks for your help

Hi, I use filemaker at my job, we basically use it to keep track of all our design/web jobs. There was already a layout existing when I started. Basically just a 8.5 x 11 page form. Now we want to create another layout a cue card format. But we still want to have the existing 8.5 x 11 format. So is it possible to have 2 layouts?? Im not very familar with the software so any tips would help! Thanks!

This is fairly complex (to me), and I probably won't explain it right, but here goes. I have two tables, Table1 and Table2, a one to many relationship. Table1 contains JobNumber (the relationship field) and JobRep. Table2 contains Portal1, multiple instances of ItemPrice, and TotalPrice, a summary of those prices. TotalPrice is multiplied by field Commission to return TotalCommission. Table2 also contains Portal2, OutsidePayments, and TotalPayments, a summary of those payments. Calculation field Profit = TotalCommission - TotalPayments. I want to run a columnar report sorted by JobRep with Subsummaries and Grand Totals of TotalCommission and Profit. But when I ru…

I'm trying to make address labels. When I preview them, there are a few little changes that should be made on selected labels. Can I go into separate labels and edit them? I'm pulling my hair out here! Any help would be very much appreciated! Thanks!

I am trying to create a field that uses a drop-down list to allow users to navigate between layouts. I would prefer not use a seperate "GO" button. Basicaly a customized version of the layout navigation system that FM uses, any ideas? jeff

I have assets printing to a report. On the software report there is a notes section. Some items have no notes and others have really long notes. Is there a way to make it so that I could put a field on the report layout so that if there was a note, it would display (to the right length to include everything), and if there was no notes...it wouldn't show at all?

Is there a way for the columnar (list) view to behave like Excel where you can keep the left most column...say, a persons name...as you scroll sideways right to bring out-of-view columns in to view. So you can keep the name visible on the far left as you search across to info in various fields. Can this be done in Browse and/or Table view? Thanks all in advance, Michael

I could not find an area for this question,so forgive me if it does not belong here. I'm sitting here poking the buttons on FM8A and everything is good. I close the program out and go eat. I return to working and open the db and my print options (the printer button on the tool bar) as well as the drop down from the tool bar are greyed out. Anybody know what I did? Thanks, Jim

I am having difficulty getting the Edit button to appear in formatting the layout for a list that uses two fields. When it does appear the "using value list" does not show the list name. When I change it to show the list name I have chosen, the edit button is no longer available. What am I dong wrong?

I was hoping to figure out a way to easily set a section of a form layout to be similar to the columnar setup, where every other line is a lighter or darker shade of grey. Is that possible without manually drawing the boxes and coloring them manually? I want a NOTES field, similar to an address book, but I would like every other line colored differently. thanks

Many examples I see online have nice icons for the header menu items. Like COntacts,phone book, things like that. But I dont see anywhere in the program where there is a selection of clip art like that. Is there one? Is there a web site that has a collection of icons for use with filemaker? I was hoping to just find some, and not have to make any.... Thanks

How do I have buttons remain visible in View as Table mode? Thanks!

I'm trying to display multiple full, printable multi(15-20)-page documents in FileMaker. Now, I realize that as opposed to copying and pasting the documents into FileMaker to print them, it would be more feasible to simply allow FileMaker to print them through their own file with a script, but I'm supposed to have them viewable (all 20 pages) in FileMaker. It seems, however, that FileMaker has a maximum page limit of 11. Is there a way I can properly display all 20 pages and print them from FileMaker? Thanks a lot! M

Hey there, I'm working on making a database of products for a company. I can't get it to end up displaying properly though. Firstly, my portals go across pages, a no-no. I've grouped them in with the parts that they should stay with, but this still doesn't prevent separation over pages. I've looked, but couldn't find out. How do I accomplish this? Secondly, because it uses portals, it also slides. However, the first slide never seems to work properly (the second part doesn't slide up far enough) unless there is a certain amount of data in the portal. Is there a reason for this? Lastly, in looking at my example (sorry I had to clear it and fill it up again) is ther…

I am trying to create a column/list report that summarized data by department. The problem is report has spaces where the body is for each record under the department. I have shrunk the body down all the way, but when you have 450 records the space is still large. Is there a way to build the report without the body so I just have the summary data showing? Thanks, Scott

Hi, hope this is the right place to post this question, as it sort of straddles a form/portal divide. What I am trying to do is add a "Find Duplicates" function to a major contacts database for the university I work for. Idea is that: (1) Find Duplicates button on the main Contacts form pops open a dialog box. (2) The dialog allows the user to choose which field (Surname, Organisation) to check for duplicates and what other information to factor in when considering a record a duplicate. (3) On clicking OK, a table style view of every matching record opens in a new window. (4) User can click on any one of these table rows to open the full record ca…

Hey gang, Is there a symbol or merge to insert the total records in a table onto a layout. I thought I saw something like that somewhere. I have @@ for the record but I want it to have @@ out of ?. Can this be done? Thanks Mike

I'm not sure this can be done and I haven't seen this discussed recently so let me ask the question. Can you change backgound or border colors based on the content of a field? I have a field called "Type." Choices are "Client", "Candidate", "Source." I'd like to have the backgound color change based on the type of contact. Any help would be appreciated. Thanks. Al

Is there any way to create a navigation "breadcrumb" menu on a layout (similar to one on this page)? I am looking to create something dynamic depending on where you are: Home > Planning > New Request So that you can click on the names and return to the previous layouts.

i have a database with both software and non-software assets in it. i was told to keep it in the same table within the same database but with two different layouts. as it is now, there are the two layouts which i have a button to switch between when i get to something that looks like software to see it in the right form. i was wondering...is there a way to set up a filter or something so that if someone was going through all the assets...if it got to a software asset, it would display it in the software form, and if it got to a non-software asset, it would display it in that form? i am new to filemaker...i have done a little scripting in it so far, but i can't …

Drop down menu 1 display all results from table X row A. I want drop down menu 2 to display table X row B where row A matches the selected value of drop down menu 1. I also want drop down menu 3 to display table X row C where row B matches the selected value of drop down menu 2. How is that done?

Here is my relationship diagram. My problem is that I can't add records to fields whose relationships are set to allow records to be added to the "many" side only, but not to the one side. All of the relationships in the database are set up so that records can be added to tables on both sides with the exception of those whose "1" side would never change. Specifically, refer to table [interestTypes] (at left in diagram ). There will never be more interest types, so the relationship between table [interestTypes] and [interests] is set so that records CAN be added to table [interests], but not to table [interestTypes]. The same relationship exists betwe…

Hello everyone, I am going nuts trying to get a sub summary report to work. what is crazy is that I got it perfect in another report just a week or so ago. two tables. Quote and QuoteItem this is a one to many relationship; One quote number to many or one quote items. Now I'm trying to create a "job card" based off these tables. I just want a subsummary based off Quote #. Layout shows records from QuoteItem; sub-summary by Quote #. When I find records for certain Quote #, it is only showing one record per page. This is so madening because I set up a purchase order database basically the same way, and it works fine. I should probably post my …

I have an invoice which looks great in browse mode, but when printed or viewed in preview mode, the content of several fields disappears. I'm stumped. Please let me know if you need more information, and thanks in advance for any suggestions you may have!

In an effort to boost performance, is there a way to force load graphics into memory when a database is opened?

FMS8 1.) Are there any performance advantages using embedded versus linked graphics? 2.) If I am running a solution off of a server would there be any benefit in performance by having the graphics stored in a separate folder on each client's computer so they are not constantly loading over the network? 3.) I have several tabs with several different interface graphics on each tab. When I open the tabs on a client computer I notice a slight delay when the tab is viewed for the first time. After each tab is viewed once it seems to load the tab almost instantly. I assume that the tab graphics are being loaded into memory.

I have a Meetings table with the days & times for various meetings: Meetings CourseCode // e.g. 209ALG DayOfWeek // "Sun" - "Sat" StartTime // e.g. 9:30 pm Notes For a class that meets 3x a week, there would be 3 records: 209ALG, Mon, 9:30 PM, Lecture 209ALG, Wed, 9:30 PM, 209ALG, Fri, 7:00 PM, Lab I would like to display the schedule for a meeting in a calendar format, with 7 columns labeled "Sun" through "Sat" and rows containing cells with the start time and notes in the appropriate columns. (I don't know how to force a monospace font, or I'd supply an example - hopefully you can imagine what I want it to look like :-) …

This probably has a simple answer, but for main menus or navigation menus, I put buttons on top a square (that I drew and added a color). Now everytime the square is clicked on, an error pops up saying the required table is missing. What am I doing wrong? Thanks in advance for your advice and guidance.

Hi I want to use a text block as a dynamic label. For example the contents of the text block could be This is a <> The problem is that the text block auto expands to fit the contents of what you type in, however the labels are short and so the text block is always too big on the layout - you make it the correct width and it gets deeper, or adjust the depth and it grows in length. Is there something simple I'm missing to force the size of the text block, or do I have to work around this by making a block with no background colour & using a filled rectangle behind it to get the background I want - (seems cludgey!).

Can I set the horizontal end to a layout? See, I have the these nice looking grey bars that run horizontally through my layout. They separate the layout sections. But, as you can see in the attachment, they end and the layout sections' background color do not end. If I extend the gray bars, the horizontal scroll bar appears, implying to the user that there is more too see to the right when there isn't. Any suggestions? Clipboard01.bmp

I would like a form where a user inputs data into a new record with 4 or five fields, presses a button and the new record appears below as in list view. The next new record I would like to appear next to the last one so that it produces a record group in a box on two lines with the new one beside it. I would like there to be about a maximum of 20 of these records in a row. Help please

Is there anyway for a customer to customize a layout template external like with text or xml or similar and hav filemaker load the template with existing fields in the solution?? Thanks TMAS

Hi, This is my first post and I am a beginner at FM and at the moment only use is to store and match my data. I primarily work in browse mode but I can only see the first 85 field columns of my data. There are a fair ammount more and I can export them etc but cant see them. It this a limitation of FileMaker Pro (V6 for Mac OSX) or can I change settings. Sorry if this is too basic a question. Matt

Hi, I'm trying to create a new database for my invoicing. I'd like a little advice on "where" or which Table Occurance to make my layout. I've begun familiarizing myself with relational databases and portals but before I go into any details I'll explain my needs. First, I was doing my invoices through Word documents, meaning I would manually enter each time the invoice numbers, client info, and services provided (this as you might know can be redundant if you've worked for the same client before). With auto-enter functions (serial #'s, dates) I know that much of what I manually type in can be simplified. So . . . . what I'd ideally like to have is: with each "new rec…

Hi All! Does FMP have a feature like Excel's Conditional Formatting? Conditional Formatting is an option where a formula is created for a cell (not in the cell) where if the formula is true, the format of the cell changes. Can FMP do this for fields? -Conner

OK, this has to be simple, but I can't figure it out. I want the user to be able to scroll through the records in the Form view, using a "next" button, and a "previous" button. There does not seem to be a script step that makes that happen. (of course, there is the little book thing that we use on the left hand side, but I don't want to use that) I'm able to get it to work as long as the records are sequential, using a global field, and a find.... but that doesn't work when there is a break in the numbers. Any hints? Thanks, Cin

I have a database with 2 tables and 2 layouts. I'd like the fields in the second table to auto-populate with data when a selection is made from the first field. For example: The first table contains records of personal info The second table contains fields for listing that info along with other stuff. My first layout is for data entry for the personal info My second layout contains a pull down menu for last name, and text fields for first name, and title. I want the user, when using the second layout, to select a last name from the pop-up list. Then I want the first name and the title to auto-populate using the related data from the firs…

Hi, I don't know if this is possible, but is there any way you can disbale the "X" (Close Window)button within Filemaker? I just want users to be able to minimise or maximise the window, but not close it. The only way they could close the window, is via a button I create that will perform a script to close the window. This is not as a runtime version also. This is only closing windows within Filemaker, not closing the filemaker application. Thanks

Please refer to my relationship diagram. I'll just talk about one field whose records I want to repeat. If I can make one work, then I'm Rn my way. refer to the upper left-most table, specifically the Well field, or in Filemaker speak, "[Wells].[Well]" and to the second table from the left, specifically [Royalties].[OwnerId]. The [Wells].[Well] field should appear as many times as the related field [Royalties][.[OwnerId] equals a given number, say "1." Next I want to limit records to those created today or since a certain date, but I'll worry about that later. I've made the layout's table [Royalties] and the portal's table [Wells], but it won't work…

I posed this in another location on this site and didint get any responces so I am trying here as it might fit better here Oh so I've got this to work in a sense but not how I need it to work. I have 3 databases: 1)List of Activities 2)Scheduling Database that uses a of activities generated from Database 1 3)A video logging database that also uses the activities list generated from Database 1 As of right now for summaries if you are in the Logging database there is a layout with a dropdown and you can chose a activity and it will tell you how many time that activity occurs in the logging database. The dropdown is a dynamically created list from the a…

:P I have a layout with a Header, a Body, (consisting of one line horizontally) a Sub-summary (trailing), another Sub-summary (trailing), and a Trailing Grand Summary. In the first (highest) Sub-summary I have a Summary field and a Date field under which there is a .5 pt. rule above a 1 pt. rule. If there is an amount of records sorted that would continue on the next page, I would like the report to break after the 1 pt. rule. In other words the groups of sorted records (in this case by date) should not go across two pages. How does one accomplish this? Any help will appreciated. Thanks.

Is there any type of method to allow for ad-hoc reporting? i.e. allowing a user to select what fields they want to include, what to summarize by, etc.?

I'm building a database that tracks companies and their employees. I'd like to create a report that lists all employees by their company. Here are the relevant relationships: Company::id = R_Employee_Company::companyId R_Employee_Company::employeeID = Employee::id and the other relevant fields: Company::name R_Employee_Company::title Employee::name Here's how I thought I would do this, i.e. here are the sections on the report, top to bottom: Sub-summary when sorted by Company::name - contains Company::name field Body - contains Employee::name and R_Employee_Company::title fields Now, this will list all employees at all companies, but …

Application layouts have grown exponentially due to several designers working at once; now, with over 200 layouts, we need to put them into some kind of order. (And yes, we learned a very good lesson!) The drag capability of Set Layout Order is very cumbersome; is there an easier way? Thanks for any suggestions or I shall be devoting a weekend to "dragging" but not the speedy kind....

OK, I give up. My title headers and footers work wonderfully. However, what I would like to do is have a footer that only prints on the last page of a report. Any suggestions?

Hi, I am integrating a Contact Log into my database. There is a Recontact Date field that shows the date, in the future, that you are supposed to contact someone. I'm displaying all the data in a portal right now. If the recontact date 2 days in the future or sooner, I want a button on the left of the line in the portal to appear red. If the recontact date is within a week, I want the button to appear yellow. If the recontact date is more than week in the future, I want the button to appear green. I know how to calculate the date, but I dont know how to make the button change colors. How do I do this?

I have been playing with the demo of FM8. Is it just me but on the windows platform does fm blur images? For instance icons when viewed at a higher percentage look blurred. Anyway cheers for any help. James