Layouts

I have a database (one table) that is used to monitor our facilities - the attributes (15) are summarized and a percentage is calculated. Two of the facilities have fewer attributes, requiring different calculations for the percentage. I have created three different layouts to accomodate the different attribute/calculation scenarios. My question: Despite these differences, is it possible to create a summary report using one layout?

Hi, I am about to start my own database from scratch. I am pondering over the following. I want to have client contacts, supplier contacts, affiliate contacts, other contacts. Do I create one big contacts table and filter them out to different layouts using a contact type field. or Have 4 Seperate contacts tables (one for each type). At the moment I am leaning towards one table for ease of use but am wondering the possible advantages/disadvantages or pitfalls of both methods. All comments and suggestions appreciated.

I have created a subsumary report. I have field called Disbursements that shows the amt disbursed for different projects. The summary field is DisbursementSum which sums the total of Disbursements. Disbursements is a numeric field that is indexed. The sub summary part it is sorted by location. The summary field of DisbursementSum is not showing any data. I am viewing it in preview mode. Any ideas what I did wrong? Thanks in advance for any assitance.

Hi, I am not sure if this question even goes here, so forgive me if I posted it in the wrong place. What exactly is the benefit of setting up different tables in one database? Right now, I have built a database that I am going to use to manage a collection of artwork, and I have everything - from the item information, provenance information, valuation information, listed in one table. Would to break these different areas up into different tables? If I want to build a seperate area to search just for artist contact information, should this be in another table. Thanks for your help!

Hi. I want to have a certain summary field in a record/table the summary should be like the sum of all records's field "amount" where field "deal_id" equals that record's "deal_id" field. I couldn't find how to do so in the basic sumary field options. thanks for your help, it is really important. yaron.

Hi guys, and good morning. I have a small question hopefully Ill get the answer. Id like to create a button for "Next record" but I want it to take me not to the exact next record but to a record a head where a certain field's value is > 0. I tried several options and couldnt make it work . thanks. Yaron.

I have created a script using Scripts-> Script maker. how do I attach it to a button? thanks.

This is kinda cool. Make a number field and put some data into it, make it italic, and color it red. Now, enter layout mode and change it to be formatted as currency with 2 places. Go back to browse mode. The field is formatted, but is still red and italic, it continues to match whatever format the source text has. It even works for "Format as Boolean"!

Hi, What I am attempting to do with a script (without any success so far) is for the db backup to be created in a designated folder and have a sequential number. The db will be a small one and multiple progressive copies will not be a strain on the HD. Example(where Trumpet is the db name) Trumpet.FM7 Trumpet1.FM7 Trumpet2.FM7 Etc. I was told this could be done, but have not found any outside information on how to accomplish a script such as this and the scripts I have attempted will not work. I would like this to happen without any user input other than pressing a "Backup" button. Does anyone know how this can be done, or a link to…

Can I create a field that requires that the user will re-type the input for verification? Im talking about field like in password when most of systems ask the user to type the same password twice to make sure he doesnt make a mistake. Thanks. Yaron

can i somehow prevent from dialogue boxes with the script? for example when in the find mode none record was found and there is a dialogue with three buttons and one of them is "cancel" but i don't want to have this button there because it stops the script. what can i do?

how can i display high numbers on the layout as an integer, not in a form of real number? sju

Hello Can filemaker 8.5 do this I wonder? I have a database with a layout with some drop down menus. One of these is Grade and includes: GP Principal/Partner GP Private GP Registrar GP Retainer GP Returner GP Appraiser All of these people are GPs but they're all slightly different. What I'd like to be able to do is search for all GPs. The only way I can think of doing that at the moment is to go into the find mode, choose GP Principal/Partner, create a new request, choose GP Private, and so on down the list. Another way would be to display the Grade field as a check-box field in the find mode. So the field displays as a menu in the browse l…

I want to create a buttom to place on my layout to continue a script that is paused. Can somebody tell me what script step to use? Marc

Greetings, Is it possible to insert the current system time into a field via a "click" if not a click is ther a key stroke that could do the same function? What I am attempting to do is have a project start and end time field...while working on the db the user can click the start time and then proceed to add data etc. and when they are finished they click to add the end time. I would guess (newbie guess) that a script could be added to a button to add the time to a field? Thanks, Jim

I want to create a ledger. I have 2 logical tables. Checks Due (amount, date) , id, forign key. Checks Received (amount date) , id, forign key. both of them have foreign key that represent a deal (where the money should be arriving in several payments) and I want a ledger to be created. where the lines are sorted by the date order. and I would have a total down at the bottom (or even a balance field on the right of the line) can I do it in a report? should I combine the "receivables" & the "received" tables into one table? I really dont want to do that. thanks for your help, I know it is not easy question but Im sure there s…

is it possible to disable saving records with enter key? because i need to save records only with hte buttun which resume a script(there i need to check validation of data and then according to it switch the layout). sju

Greetings, Ok, so I am sitting here slinging out tables and fields, in what I like to call a database-a-palooza. Onlookers can only stare in amazement with their jaws slack and agape at the many marvels I bring forth in FM8. And now back to reality…I am working on a db and all is well, I have reports, I have relationships, I have portals…then I decide I need a “User Defined” field and then it hits me or I have gone completely dumb…I have no idea as to where to start to set up a user defined field. On the db there is a list of about 20-30 known items on the list, and I wanted to add 5 or so “User Defined” fields but I am lost. Do I need to set them up as glo…

I want to have a drop down field that has values from another table based on a mach between the tables. can it be done? deeper explanation: I have table A with field "name", filled with 100 records, I have a form where I also have a field "name" , then I want another field called "family name" to be used with drop down list where the "name" here matches the "name" in table A can it be done?

I have a strange behavior. I have 3 fields which the 3rd ond should be validated to be sum on the 2 others. so I declared calculation validation on the 3rd one. but when I put bad number on the sum field - and add record - I get message (this is ok) when I put bad number in any of the other fields and add the record - I dont get error message and ther record goes in the database. did I do something wrong or it is a known FM bug??? thanks alot.

Pressing the ENTER key while in a text field accessed through a web browser creates a small square symbol in the field when the record is viewed via the FM client. Is there any way to prevent this from happening?

Greetings, Is it possible to “Retire” a record, that is to keep it in the db but not have it recalled via a normal query etc. What I have is an employee table, and I want to be able to “Retire” that employee but keep a record of their information for later use. However, since that employee is no longer around, their information does not need to be included in any currently extracted data for the company. I know I could set a "retired" field which I could omit during a search, I want to know if there is another way? Thanks for any information, Jim

I have the FMP 8.5 Advanced edition and I'd like to make a runtime solution that doesn't have the sidebar on the left (so users can only see the navigation I've provided). I noticed that the demo files that came with FMP did not have this sidebar but I can't figure out how to get rid of it (either in runtime or on the guest account). Any ideas?

I have a field that should be validated against 2 constrictions: 1) not empty 2) calculation and I want the error message write " you must enter a value" when user left it empty, and another message on the other validity failure. can I do this & how. thanks.

I am new to using the FileMaker TAB layouts. Is there a way to script/navigate moving between tabs so a user can go to a tab layout as the result of a calculation in a script? Thanks, Steve

i woud like to make new records(with script) in the tables that are no displayed on the layout is it possible? cos i don't want to use switching layouts... thanks for replies sju

Greetings, I currently have an error message which pops up on a db I am creating…however it does not pop up all the time. On my main page of the db, I have a button attached to a script to open a popup window, which has a portal layout in it. When I attempt to enter data into this portal popup, I get the following error (sometimes)…”This record cannot be modified in this window because it is already being modified in a different window”. Now if I go out of the db and reopen it I can call up this window again and enter data. What did I do wrong? Thanks once again. Jim

What is the best way to center windows so that when they open (no matter the monitor size) they will always centered on the screen. I realize one will need to use the Move/Resize function. But how can one use Move/Resize to get desired results?

Hello - this is my first post so forgive me if I miss some kind of protocol - but I need some help. I am trying to create a spreadsheet style report which shows which classes students have attended in a semester. The report needs to show along the left column the names of students (from table:Students). The columns needs to be the specific classes (from related table:Classes). This is a many to many relationship created by a join table (table: Student2Class) which stores information on whether they attended the class or not. Obviously I could do this with a summary report of each student which then lists the classes he/she attended. However, the user wants to vi…

I have a database that uses about 20 layouts. Each layout has a header section that contains links to every one of the other pages. This is akin to a webpage that has navigation links at the top. Using a website as analogy, when designing a website I can use a template that every page uses. If I add a new page or delete a page, I merely change the template and the changes propogate to all pages that use that template. Is there a comparable mechanism in FileMaker? It gets quite cumbersome to manually change the links on *every* layout if I have to make a change to the links. Cutting and pasting to each layout is still tedious (and silly, anyway). Someone re…

Can you use the New Window command like a dialog box that floats in front of the original window? When I run the New Window command all the other windows minimize which ruins the effect.

hi, can somebody help me? i would like to set fields from the table according the current fields in the layout without showing them. but each script step i tried reqires to see the field on the layout

I searched the site, but wasn't able to find an answer to the following. I have ten tables in a file, each representing a different facility. The fields in each table are identical. What I need to do is combine data from each table into a consolidated report, but cannot seem to accomplish this. I know I am missing something (please see attached), so it is time to call on the Pros... Thanks, John J.

Greetings, this may be long, but I am hoping that I am clear about the situation and my issue. I have the following: people table job table contract table Relationships: People to job (1 to many) and then job to contract (1 to many) 1 person can have 1 or more jobs…. Each job record could create 1 or more contracts. or 1 person (ie Staff) can have a job record but will never have contract records. I created a report (based on the job table) and scripted a find (that follows rules) to display the appropriate data (there are actually 4 reports – 1 for each quarter. Ie Fall, Summer, Spring, Winter). Problem: It’s not displaying the appropria…

I'm working with a school that has a FileMaker 7 database. This is a conversion from a FileMaker 5.5 database. The only way spell check works is to be in a field, highlight the contents and then spell check. Check selection, all, record all don't work. I found a reference in a previous post (Topic#136024) where somebody suggested that this was due to copying and pasting entire layouts (graphics and text boxes). That is not the case with this database - the whole database was just converted. Their solution was to duplicate the layouts and then re-add the fields. This solution has 50+ layouts with over 2,600 fields! Any help on how to get the solution to behave would be…

I've got a date field...with values such as 9/1/1934 12/11/1966 How would I count the number of people that have the same birthday, by date...meaning create a report that provides an export like this: 9/1 312 9/2 278 9/3 289 I know how to do sub-summary reports...but its finding and sorting thats giving me fits. Do I have to break up the date of birth field first to narrow down my set? Ultimately I will have to do an export of all these people who's birthday land on the same day and do a mail merge. I'm using FM8 Thx...

Hello there. I have a database with checkboxes in different layouts. Its a kiosk registration form. I want the final page of the layout display on the checkbox forms that they checked. Its a summary of their purchase and so they can print out a confirmation. I can copy all the fields to that final layout, but it ends up being very long. I don't want to waste paper if they only checked one field and it prints out all of the checkboxes on 3+ pages. Thanks

I have a layout that displays a drop down pulling values from another table. On the layout, when a paritcular item is chosen, I want it's text to change color. Any ideas?

My first ever task using FileMaker is to fix bugs in a single application running on 4.1 on Windows. Six related forms all open up nicely, with main displayed and five subordinate forms minimized. All subordinate forms allow layout mode, but Layout is greyed out on the main form's Mode menu. What might the main form have done to disallow layout mode? Thanks, Tony Scandora Tony at AES Systems Corp dot com

where do I determine what will be the order of entering fields? (assuming the user will pass them using TAB) thanks guys, especially you - who will answer this question.

Hi. I have some optional fields in a record that can be left blank upon a selection in a previous field which is a checkbox. can I make it that a field will not be valid for editing & colored gray - upon another field's content? thanks. yaron.

Hi all. I have a conditional set of fields which should be remain inactive unless another data entry box is checkmarked with a NO (the frist question in the screen picture). I want to not only have them visually different (the grayed out area), but to actually restrict the fields from being entered into. conditional_entry.bmp

first of all good morning. yesturday I posted 2 questions and got answers - so this forum works great. now for my very basic question: I want that when user enters a field value - there will be a manipulation on that value and the field will contain something a bit different than what the user typed. when it was easy I just used the field format. but when I need a calculation (like phone number) I dont know the procedure to do it: I believed I need to create 2 fields - one for the input and than a "calculated" one for the formated value. is that true?? (i hope not) if so than what should I do on the layout? put them on on another??? than…

Is it possible to change the tab background via calculation?? TMAS

Hi, Im extremly new to filemaker and have the folowing question: Can I make layout that will format my input? for example I enter "abc" and after moving to another field it will be showed/saved as "ABC" (making all the letters upper) same idea - can I enter a phone number 2121119483 and after moving to another field it will format it to (212)111-9483 thanks alot

Hello you experts. I have a strange need: can I have 'square' radio buttons instead of round ones? can I make the sleection fill 'X' inside rather than filling the circle? If the answer is yes - please show me how... Y

I suppose this may be more of a wish than question as i am almost certain this is not possible. With the event of multiple windows i find it very useful being able to show a navigation list in one window and form layout in another window at the same time. I only wish that I could have the windows on the same level or specify that one could behave much the same way as the toolbar does and float on top. The real benefit of the list and form being seperate is that the list can take advantage if a user has a bigger screen and display more list items (so it wins over a portal in my opinion). Any ideas or comments would be great ... maybe 9 will let us customise …

While investigating the new Object Name feature of FMP 8.5, I found the LayoutObjectNames function. Here's a brief description from the help: I've used this function in a Custom Function that determines whether a specific object name is defined in the current layout. I'm curious whether anyone has found any other use for this function.

I am doing an extensive data cleaning project with some end users. For one of the meetings that we are having, I would like to deisgn a layout where the potentially probelmatic fields are highlighted in some manner. My idea is to create a corresponding calc field for each field, which has a value of 0 or 1 based on whether the contents of the test field are considered valid. How can I set-up a layout so that the problematic fields look visually different (i.e. different text or bg color)? Thanks in advance! Courtney

I've been using FM since v. 4, and from the beginning I noticed that many of the sample files would split buttons up into a graphic showing a button, and an invisible area beneath (above?) the graphic that had the actual button functionality. Another question on the Forums got me thinking about this practice (since the invisible areas were not lining up with the graphics in IWP), and I confess I have no idea why this practice was ever used. Why wouldn't a developer just set the graphic up as a button? Could someone shed light on the practice? TIA, David

I'm using filemaker 8.5 pro, and I have started with one of the creative pro job tracking templates. After making lots of changes, I now realize that it is necessary to add another table, which means another tab, etc. This would mean changing the nav menu on every single layout, a painstaking task. Is there any way to automate this task by only changing one part, and having it update the others by automation?

am I right in thinking that to get a tri-lingual db, the only way is to copy all the layouts twice, rename them, change the labels and adapt the button scripts so they link to the desired layout of the same language? I just want to be sure not to create an absurdly complex db for a very simple problem. thanks hans peter

I have a table that contains information about a phone call. Things like: Call Date, Call Time, Duration, Extension #, Hold Time... Anyway, when I view the information it's in a list view and I can see all the calls in order by Call Date/Time. I have scripts setup to format the results, and perform searches.. but what I would like to create is a dash board layout. Something that would be setup to count the number of records that have a given extension. This way I can see at a glance how many calls a given extension has took on the day. It's kinda of a PIA to search for each extension then write down the summary results in the footer, onl…

Hello, I am new to FileMaker and I am trying to create summary report. I have a donations database. I have a Donation table that tracks Amount, Date, donationID, etc. I have Cause table that has LocationID, Project_CodeId and CauseId that the donation was given towards. I have created a relationship between these two tables based on Primary Cause Id and Foreign Cause ID in the Donation table. I have a summary field called Amt_Sum that summaries the Total of the Amt field. In my report, which is based on the Cause Table, I have it sorted by Location Number and then Project Code. I have the Amt_Sum field (which comes from the relationship between Cause and Don…

This is probably a simply question for all of you, but I am new to filemaker and databases in general. I have looked all over and either don't understand what I have found as the answer or can't find it. I am tracking sales in several categories in several stores. I would like to be able to pull out the total sales for each store/district for some period. I don't want to see the weekly sales, just the totals. store a 12,345 store b 10,125 store c 14,324 etc... I then need to export this to an excel file (which I am not currently having problems with). I have had minor success by setting up a layout with summary fields using the wizard. I did a search …

I'm developing a solution, and I wondered if there's a way to hide to the bar along the bottom of the window. Not the actual FMP status bar, but the one that displays zoom buttons and the find/browse/preview selector. Reason is I'm using a few layouts as pop-up windows, but they look really ugly with those buttons along the bottom (plus i don't want users to be able to randomly switch into find mode, etc.)

Recently we deleted a few layouts and reorder the layouts in the same file. We found that that particular database starting to have navigation issues with our users. They would click a button to navigate to a specific layout and it would take them to the very first layout in the list. Has anyone experienced this?

Hi All, I want to create a script to attach to a button that when pressed will go to a layout in another filmaker file. I have read that it is not necessary in recent versions of filemaker as you can have muliple tables in one file, but I am stuck with FM5.5 for the moment. Thanks in advance. Richard.

Hello all, I did a search for this and didn't find any reference. I want to make a layout with about 25 A4 pages and print them all in one. The layout size limit is 110in x 110in so I should get about 100 A4 pages on it which is more than enough. But, I can only print the left column i.e. 10 pages. (and they only show in preview mode) Is there any way I can do this without having to make 3 layouts and print them separately (which is OK for hard copy but not so good for .pdf I would appreciate your help greatly. kind regards Tony

I've got a database with five parent tables, three of which you can write to via their relationships, two of which you can't write to via their relationships. Some of the child tables can't be written to either. I've setup the relationships in such a way, so as to maintain data integrity. Here is the relationship graph. New records have to be created on a monthly basis. The two tables [Wells] and [Owners] will rarely change, so all of the new records will be created in the three tables that join them, specifically, tables [Production], [Join], and [Checks]. What I need help with is making a user interface for entering data into the [Production], [Join], a…

I'm looking for ideas for how to present to the user a value list from which he can make multiple selections. This is the "Categories" field of a Contact Manager - a given contact may belong to an arbitrary number of categories. The value list is long (30-40 items) and it may be extended by the user, so whatever interface element I use should accomodate its size and variability. I think this pretty much rules out the usual checkbox interface. When a Contact record is edited, assigning a category should by default add to, not replace, any previous categories. But it must be easy to delete a category from a contact record, too. I almost got a workable solu…

I have a couple of "buttons" on a few of my layouts where the button label will not show, and on others it does. (Note: these button are graphics,not made with the button tool.) I have sent the button graphic 'to the back' and sent the label 'to the front,' and still the label is not visible. Anyone got a clue what is going on? Thanks for the assist!

I hope everyone is having a good week. I have layout designed to be a Columnar Report. It works, as long as I do not perform a find before I view it. After the find is performed, the grouping based on a field no longer works. This is true for all layouts using the table used in the find. "Show all Records" has no effect on the problem. I have to restore a backup of the file to correct the problem. Help?

Hi all My company is required to complete a couple of forms that are two pages long. Ever so often these forms need to be modify and there is where the problem is. The second page at times creeps up pass the page break and needs to be corrected. Is there a way of making sure that the second page does not creep up when someone is going maintance of the forms. Thanks in advance

Is it possible to get rid of or cover the black line under the header and on top of the footer when viewing as a list?

If this is an old one, please let me know the link response. I want to print a report that shows a line in plain text and the next one the text in a shade of light green, just like a regular old computer green bar printout. Gracias, Printery

Hi, Is it possible to have a report title on the printed page pull from the script name? If the script is called Jelly...can the report title print out Jelly ? Thanks, Jim

Hello there. Is there a way to change what the checkboxes say next to them in Browse mode? I define the list values, but I want it to display something slightly different. I am making a registration form that people can sit down at and register themselves at a trade show. Thanks

Hi. I'm having problems with the template 'Registration' (FM7) that I've adapted for my use. When I use the New Registration button to pull a name and then use the arrow to select an individual, it pulls the wrong person (the same wrong person, continually). I don't know why. I've tried duplicating the contact information and deleting the first, but now it just pulls another name, continually. What could be going wrong? Thanks for any help!

98 percent of the work I do, the printing margin is half inch in the four sides. Every time I make a new layout I have to change the margins to half inch. Is there’s a way to set the margins default? Gracias, Printery

Hey everybody Alright, you know you know this one! I know this question is notably silly, but how do I change the order in which my layouts appear on the dropdown list (the main one on the left)? I keep on making new layouts that are more important that I want to put up to the top, but I can't, for some silly reason figure out how. Thank you very much for helping me, Michael

Hi All, I have a client using FMP 6.0v4 (WinXP pro)- They have database 1 (350 records) containing project numbers and project names i.e. [color:red]<> 2006-01 - <> New Office Building. That data is then pulled into database 2 via a value list sorted by [color:red]<>. My question is when there were only about 150 records in db1 they would get the value list in db2 then use the number pad on the right of their key board to go directly to the project number in the value list and select it. However, now they have to use the main keyboard number row to go directly to the project number. Why is that and can it be changed? Any info would be great…

I'm wondering if there is an equivalent type option for having a header that can be used on multiple layouts but which can be edited once and then all other layouts accept the change. I know I can duplicate a layout, but once there are changes, all layouts have to be edited individually. Thanks!

This is an FMP 6x problem which needs addresing while we convert to 7/8. We have an invoice file which utilizes a line items portal. We had to increase the layout to its maximum size to accomodate large orders (300+ lines). When we print, the portal lines print over the footer and successive headers and footers. Cutting the layout back to 200 lines will clear this. This has happened in other layouts in other files which we chalked up to corruption, replaces with a new layout and all was fine. Any idea what is happening?

How can I darken the X in a check box so that when the box is checked the X can be clearly seen? I find the very light grey to be almost invisible, and therefore ridiculous. John Link

i am trying to create a layout with my own graphic tabs for add, edit, delete etc. i want to include number of records and number of records found on the layout independent from the one of the status area. how do i do that? thanks

Can Scriptmaker open my Customer ID value list , choose the selection I want and add that selection to a field?

i'm sorry if there is wrong place to put my question. How to avoid data entry from making mistake duplicated record. actually he or she wants to command F to perform find. is there any way to make the command D not funtion for data entry. tq

Has anyone experianced any difficulty with the sliding effect and use of repeating fields? Im getting some weird effects reguarding the printed preview of things, some fields sliding others not.

Is there a way to control the location and size of a field on a layout in a script? I would prefer not to use a plug in, but I am open to it if it will get the job done. I have 8.5 adv. Thanks

wow I feel stupid but...here goes. I have created individual tables for each category of my job "recipe" (Project, Crew, Contacts, Wardrobe, Craft Service, etc.). Now I want to create a Print layout with the fields in each table laid out in some order. This form wil be used to capture the information we need, manually (pen on paper), then transfer to the database later. I try to use the New Layout function but it will only allow me to import one table vs. all of them (and their associated fields). Is my schema flawed or am I missing some function in FM7pro? You can see my spaghetti-works in the attached file...Sorry if this has been repeated somewhere, I searched b…

Does anyone use this program? I am trying to figure out how to do envelopes from this program.

Does anyone know how to create an envelope layout using Filemaker 8 and Donations?

I have a layout in 'view as list' mode and get a line between the header and the body. Is there a way to switch this off?

Greetings, Is there a way to have my yes/no drop box start with the yes automatically shown without the user having to select? Thanks, Jim

Hi all, Is there a way to prevent users from creating new records by accessing the "records" menu? Currently all these operations are handled by the UI of the layout and there are some scripts that need to be run during new record creation (therefore the user should *not* add records from the menu). Is there a way to restrict record creation to be done ONLY from the layout elements ? Thanks, Thomas

Hi all, I've been working with FMP 8.5 on the free trial, and am nearly finished creating a Guest List database for an upcoming tour I'm doing. The problem I have is getting the report to look the way I want. I want to get the number of tickets, guest passes, backstage passes etc... for each show listed per show, and per person. This works OK, but then I try to bring a related table in as each person that has tickets can have up to 10 guests which need to appear on the list. This is what I want... 23 Sep 06 Barcelona SanJordi Joe Bloggs (no. Tix) (no. Guests) (no. VIPs) (no. Aftershow) Mary Bloggs (no. Tix) (no. Guests) (no. VIPs) (no. Af…

Hope this is the right forum and that I'm able to describe this properly. I have a question concerning making a dynamic value list. This is for a purchase order requisition system. I already have a table of "requestors" that also contains a field with the maximum dollar value that they're allowed to authorize. There are, of course, many more $0 authorization amounts than not. The "Name" field from that table is already a value list for "requestors". I'd like to somehow make another value list based on that table which would only include the "names" of people that have approval amounts over $0. I know I could make another table of "Authorizers", but …

This is driving me loopy, but I am out of ideas. Sorry if this is posted in the wrong place. I have a layout which produces a report as follows... reference Figure b21 55 b32 275 b33 11 b44 19 b51 115 b59 88 ...and then the following b65 68 b65 1 b76 144 It appears that I need to "clean" the 'reference' field, but how? Any help appreciated. John

Sure would appreciate a tip on the following: I'm producing an employee directory and want to have the range of last names (A-C, L-M, etc)displayed in the header in the following format: First letter of last name from the first record on the page, then a hyphen, then first letter of last name of the last record on the page. I created a field with a calculation of the first letter in each record, but can't figure out how to write the calc to display the range in the header. Thanks, Rich

Hi, I'm fairly new to Filemaker and i'm not sure if this is the appropriate place to put this but, I am making a database where in a certain layout, I want to have fields and a portal to be shown/hidden or expanded/collapsed using a checkbox. So if the checkbox is checked, I would like for selected fields and a portal in the layout to be expanded/shown and if it is not, to be hidden/collapsed. I was hoping someone could kindly help me out here. Much thanks in advance.

I am trying to create a report that has subheadings based on a particular field, that field only prints once--not for each record, but several different values can be on a page. Each record has several fields including FIELD1. I want a report that looks like: HEADER ---start body--- FIELD1=A Record with FIELD1=A Record with FIELD1=A . . . FIELD1=B Record with FIELD1=B Record with FIELD1=B . . . etc. I can do it if FIELD1 is allowed to only have one value per page by setting up a sub-summary break, but I can't figure out how to do it if I have more than one value of FIELD1 per page. I don't want FIELD…

Never had this happen! Click on the print checkboxes and the menu popups change contend! Anyone can explain this? T dvready_2.06.fp7.zip

I have seen a db solution built in .Net that has a layout with search fields at the top and a portal of results at the bottom. Once a user enters search terms or selects from valid values, there is a "Get Records" button that perfoms a search and returns the results in a portal on the same screen. Is this possible in FM8? I have already created a screen that has the portal using a self-join and can be filtered with the value list fields, but is it possible to enter a search field where the user can enter a text string and have the results appear in the portal?

I have tried inserting a B&W logo onto a layout, both in tiff and jpeg form. They look nice on the screen, but print out fuzzy on the page. The tiff is crisper than the jpeg. The tiff is at 300 dpi and prints nicely from Photoshop. Is there a better resolution or file type I could use that Filemaker likes better for this purpose? I have had trouble finding information on this topic. Any help would be great. Thanks, KC

I recently upgraded from v6 to v8 for several reasons, and I was hoping that sliding would be easier for me to handle in 8, but it is not to be. And I searched pretty thoroughly [though the search function in fmforums needs some help!] and could not find my problem. Basically I normally use the same layout for screen and print by having my fields in the body part not print. My problem is that the fields in the subsummary, which I want to show after sorting and going to preview, are not sliding correctly, with spaces between each line of text corresponding to the number of summarized fields. I've messed around with this a million different ways. Sometimes de…

[i am not actually sure where to put this post!] I am a landscape architect and have been using FM for many many years to generate plant lists, budgets, etc. Now, I am trying to make things run smoother because there are more people in the office, so I need a more bullet-proof solution. What I want is this: when a person opens the file 'Plant Lists', she gets a welcoming screen that lets her choose the project that she wants to see, and then she clicks on a small graphic representing the desired layout. She does this by clicking on a check box first. So far, so good. The background is: FM 6, and these FM files: PDB [Plant Data Base] Plant Lists P…

Hi Guys, Just as the subject states, what is the difference between the two (Title Footer and Footer). I want to print something at teh bottom of the page, so I would place this in the footer. However I dont want to print it on every page, so I guess I will have to use the trailing grand summary. Unfortunately the trailing grand summary doesn't print at the bottom, as I only have a couple of entries, it just prints after the last record. Noticed in the parts Title footer but to me just looks like another footer, so why have it?

I'm doing a huge image database that I have to put on the web. There will be over 5,000 pictures and all pictures are about 3 megs each. Does anybody have a template that allows for people to search and label, while at the same time having small enough (size wise) thumbnails to make it run quickly over the web? I'm struggling trying to make one. Any help would be much appreciated.

Hi all! Well, the subject says it all: I would like to have a Sub-summary layout part appear when in Browse view? I never need to print this layout, so it is not at all formated to be viewed in Print view, but that is the only view I see my Sub-summary. Thanks for your help! -Conner