Layouts

How do you make a layout with tabs across the top or section? I have seen this in many same files but I don't know how to do this. Is this a plug-in you can get?

I'm developing an application that requires someone enter lab test results into it. There are often 30 or so numbers to enter from any given lab report. Unfortunately, different labs have different formats, including the order of the various results. The specifications for my application call for the user to be able to set-up the order of the fields for data entry. I assume that a user would just do this one time only - or very rarely - as users would change labs rarely. One thing that is NOT an option, would be to hard-code it in a few different formats. No one is quite sure of all the differnt lab formats that exist. I'm looking for your experiences and sugg…

Hi all, Is there a way to give the user "controlled" design access to a label layout? I want the user to be able to adjust the field positions on the label layout, so i want to create a button that would "switch to layout view" for that specific label layout, pause the running script, let the user adjust field position (not allow any adding or removing) then return to the main menu. Am I dreaming or is this do-able??!! Thanks Dan

Hello, We manufacture windows and are trying to make order entry system. We have a Glass Order that you put in the Quantity and the sizes and then we have would like to make a assembly list that shows all the components you need to make each size. We would like to be able for it to copy the sizes and Qty. into the assembly lists at a push of the button. Do you have any Ideas on how you would do this I would greatly appreciate it. Thanks Alot Jonathan

Hi, Does anyone know the best way to copy fields from records in one table to fields in records in another table. I've tried using a portal but I need to copy fields from more than 1000 records (the limit for a portal). Any ideas? Thanks.

Anyone else have troubles with how drawn objects appear in FMP? below are pics of the same fields in Layout Mode then in Browse Mode. Anyone else get the shrinking Rectangle problems? If you look closely you will also see the Top field has a nice clean line where the top and right engraved edges meet. The field on the bottom has a jagged edge. I have noticed some other strange things with the drawing feautures of FMP, anyone else have similar experiences? Layout: Browse:

Hi to all, i have a DB with a layout with several different Buttons (all buttons performs differents scripts), and i wish to put all them together in something like a toolbar. That it's possible? If yes, tell me how can i do it! Thanks in advance for your help!

How to add page numbers on a layout. Not using the ## text code, this result only in a pagenumber I need to use pagenumber and total number of pages. page 1 of 2 page 2 of 2 Rgds Mark

Why are number fields sometimes left justified when placed on layouts? I would think they would automatically be right justified but they aren't, and you can't change the justification by selecting Text Format. I placed a few fields on a layout and the number field was left justified. I selected all the fields changed the font size to a larger size. Everything became right justified then. Can't figure out what causes this erratic behavior. The Mad Jammer

Happy 2005 everyone! I'm looking for a way to have FileMaker print two different layouts to a single PDF file. I currently have to click "Save as PDF" for the first layout in OS X's Print dialog box, save it to my hard drive, then execute a second script to get the second part of my PDF created (with another click on "Save as PDF") and finally merge the two parts using Acrobat Pro 6.0.2. Is there a way to get FM to save directly to a PDF file? Can I also get FM to append pages to an existing PDF file instead of doing a manual merge in Acrobat?

I am really new at this; I bought Using FileMaker 7, but I can't find the answer. We have a database of clients, and I want to write letters within FileMaker, then save the merged letter to the client's layout in a container field. I can set up the form letter and the container field just fine, but how do I save the individual letter? I've Googled,and everything I've found relates to ancient FileMaker versions. Many thanks.

I would like to open a new window so that the user can insert data in a small window that opens in front of the main window. The user should insert data and click on a continue button and the window closes and the user will go back to the main window and continue what he was doing. This new window should be Modal. That is a window that opens and the user won

Hi everyone, I like using the send mail feature and scripting for the entire pages contents to be copied into a field so that I can specify this field as being the BODY TEXT of the email. Nice But no formatting at all except for carridge returns. Isn't there a way of including right justified tabs and font size, etc so that I can create an emailable, nice looking invoice document or quotation? At the moment every email I send looks like Date: 20-11-2004 PO Number: GT-11099 To: Rob Larkins Ingram Micro UK Order Details ___________________________________________________ Qty: 1 PCode: 450689394 Descr: dfhhj dfjkhgk hkjddfdf U…

Our company has a mixture of Macs and Windows XP machines. I have several layouts with headers set top print at the top of each printed page. If my layout is sized to be printed in two pages, the Mac prints exactly two pages. However, the Windows XP machines print an extra page at the end with the header on it. Why?

Is there a way to begin printing labels to an Avery sheet without starting at the first label? I may print 2 or 3 file folder labels a session. I currently track projects in FMP and print the file folder label in a MacSoft product, Labels and Cards Mac. It works but it has the feel of an OS 9 program. Would the series of roll style (Brother Turbo) be better for this task? I can't believe after all of these years that this is not a standard printing feature in FMP. A plug-in or something.

Hi All, I want to print a layout which has only one field which extends to about 10 pages. When I print that layout, it prints only some pages from the middle. I checked the printer configuration and it appears to be fine. It shows properly in the Preview mode as well. Please let me know what could be the problem in printing the whole text properly. Thanks Yogesh.

I have a field that contains the full name of individuals. I would like to separate the full name which is separated by a comma into two fields, one with the first name and one with a last name. I want to print name tags with just the first name. I imported the original data base from Excel and was able to separate the field into 2 columns at a later time, but FileMaker did not recognize the file so I could not import the information. Thanks for the help. Pillroller

Hi, Any idea how to have the number of pages printed depend on the length of a portal, but in a way that a footer text always prints at the bottom of the page?

Hi, I used to have a nice filemaker pro 4 file on my mac but the machine died and i bought an ibm with windows xp, where i installed a filemaker pro 5. Now the original layout doesn't fit to the papersize anymore (up to three times the size of the paper to print on). I can't find anything to reduce the whole layout, and I don't want to redraw the whole thng. Any ideas? thanks

Hi all, I once started a collection management database with FM7 Pro and had to give out due to lack of time. Now, i'm re-starting everything from the beginning and am facing some problems i don't even remember i already had to ... So, my point is that i have a first layout where i enter new records ; one new record for one new disc. Then, i'd like to create another layout that would only sort the artists that i have discs from so i can pick one artist by selecting his name and beeing linked to a page with all his discs listed on (There shall be at least one more layers of that kind after the artist discs list). What i don't understand is how i can ask a P…

I have buttons in my headers that are using grpahics for display puposes. In table mode, and only table mode, the graphic disappears when viewing the database in Instant Web Publishing. I get the dreaded "x" for missing graphic. Any fix?

Does anyone know if it is possible to set the *paper* size to something smaller than 8 1/2 X 11 so I could print on labels that come on the small sheets? Thanks!

Hi, Is there an easy way to get filemaker to print a sheet of the same label from the same field instead of moving to a new record for each label? For example, I want it to print the product name "Candy Apple" 30 times on the same sheet, formatted properly for Avery 5660 labels. Thanks! Andrew

I'm trying to create a daily invoice report laid out like this: Page Header -- Invoice 1 customer information ---- Line Item 1 ---- Line Item 2 ---- Line Item 3 -- Invoice 2 customer information ---- Line Item 1 ---- Line Item 2 -- Invoice 3 customer information -- Invoice 4 customer information ---- Line Item 1 ---- Line Item 2 Page Footer I've tried the inside-out approach of using LineItems as the master file, sorting them by Invoice_ID, and displaying them on a layout as follows: Header Sub-summary by Invoice_ID (Leading) [contains Invoice cust. info] Body [contains line item info] After Viewing as List in Preview Mode, …

Greetings All! I have a database that I use to keep a journal. Some entries (records) can be as little as 100 words, some can be as verbose as 5000. The layout I use to add to the journal has a 'main-body' text-box of about 30 lines, complete with scroll bars. That's fine when I add to the journal, but what about when I want to print? How can I set up a layout so a 100 word entry prints on one page, but a 5000 word entry prints on multiple pages? Thanks, Sydneytim

Hi all. And happy new year. I can't figure out how to properly get a calculated percentage in a subsummary part. Let's say I have records consisting of People, with data consisting of QuantA and QuantB and a QuantTotal for each record. I can run a subsummary showing the assigned subtotals for each record easily by placing a summary field defined to look at each QuantA, QuantB, and QuantTotal. Easy! What I can't do is show in the same subsummary, a proper ratio (expressed as a percentage) of QuantA to QuantB for the records summarized under that Person. What I'd like to see in the subsummary would be: PersonA QuantA QuantB ABRatio QuantT…

I'm an FMP novice, moving up from Appleworks. I like it! I've inherited a database, one of whose layouts has non-field objects in the header part. When I look at the layout in preview mode the objects are invisible. If I create my own layout and put objects in the header, they are always visible in preview no matter how I view the layout. If I copy the objects from the first layout into mine, they disappear in preview. I can't find any explanation of this behaviour anywhere, even in the Filemaker Bible. Can anyone explain by what alchemy these objects can be made to vanish in preview mode? (PS: this post should be in the layouts forum, but there's no obviou…

Hello, I have a layout with four pages which are accessed via "tab" buttons. For some reason, in "Browse" mode the first page jumps out to full screen (horizontally) showing a huge expanse of white space while the other pages remain at their defined horizontal size. I can't figure out what is different about this first page. Does anyone have suggestions as to where I should look to find the problem? TIA, rlbryant

I have inherited a database that somehow lost the FM-generated list and table views for the main data entry form. How can I recreate new list and table views that will be used by FM when the user selects "View As Table" or "View As List" from the View menu? Or how can I get access to the forms FM is currently using for these Views (totally discombobulated!!) and change them? Thank you, rlbryant

Problem: I tab into a pop-up list field. I hit the down arrow until the selection I want is highlighted. I hit tab to go onto the next field. But the value I selected is not saved in the field, unless I hit 'return' instead of 'tab'. Anyone know of a way to force Filemaker to keep the selected pop-up list value when you tab out of the field? I'd like to eliminate the extra 'enter' you have to type. Thanks to everyone who posts on this forum, it's extremely helpful. Hopefully soon I'll have enough experience to contribute back more.

How can I number my records so that the numbering starts over with each Sub-Summary occurrence? In other words, I am looking for a way for the record numbering to restart after each occurence the same way page numbers restart when that option is checked. Thanks, Par

I have a db which has multiple tables which are all linked via a unique number When I create a new record in the contact layout and then want to go a second layout which contains data from another table I cant get into that layout useing the script GTRR as there is no related record in this table. How do I set it so when I create a new record in one table it creates a record in all the tables? Kirsty

I have a set of information that looks like this: last first option1 option2 option3 total jobitz, larry 22.00 41.01 33.05 96.06 largin, marv 14.03 12.22 21.20 47.45 how do i make it so that i can total every column and show up as if it were the final entry in the list? like this: last first option1 option2 option3 total jobitz, larry 22.00 41.01 33.05 96.06 largin, marv 14.03 12.22 22.20 48.45 -------------------------------------------- totals: 36.03 53.23 54.25 144.51 instead of like this: last first option1 option2 option3 total jobitz, larry 22.00 41.01 33.05 96.06 totals: 36.03 53.23 54.25 144.51 largin, marv …

Hi, I have a layout which has a global field, i use this for searching. and it's been decided it should be a button to keep user simply typing something and not pressing the find button - yes an option is to write code to say "You didn't click lookup!! or display the dialog" for now, i'm interested in having the field be a button. I set it to a button, but I can still tab into it and type anything I want. what option did I miss? I unchecked just about everything in field behaviors. what's the solution? thanks, Sincerely, J__

I am currently using the one script to go to certain layouts and changing the script parameter of each button to the name of the layout to go to. The script then gets the script parameter to determine which layout to go to. Easy. What if I want to have two script parameters. One holds the layout name to jump to and another determines whether a new window is opened when going to that layout. So, ScriptParameter = a = staff ; b = new_window and then in the script: If b = "new_window" go to layout "a" in a new window else go to layout "a" end if How can I do that? Widey

Hi! I have one table company and related tables employees, computers, vehicles, etc. I know how to create report to show data separately for each table for example computers: Company name Computers - Computer 1 - Computer 2 ... How can I create report that show all the data for one company like: Company name Employees - Employee 1 - Employee 2 ... Computers - Computer 1 - Computer 2 ... Vehicles ... Thanks

I've created a report using a few subsummary sorts. It sorts by category then by code. So my lines look like this: Category 7 Records $2100 Code 1 3 records $900 Code 2 4 records $1200 Catgory 2 3 Records Code 1 1 Record Code 2 2 Record I need to find out how I can put a formula into the subsummary without it calculating all records instead of records shown. I'm not sure if I understand my own question but any help would be greatly appreciated. Thanks

Hi. I have tree tables vendor, model and category i try to make a rapport where the data is grouped by the vendorname. under each vendorname the models is listet, and i need a field where the number of models under each vendor i counted. Thanks

Question 1: I have a variety of Avery labels (they are at work and I'm not, so I don't have the numbers). None of them appear in the FileMaker label list. Most of them are not on 8.5 X 11 sheets but are on smaller sheets (like 4X6 or so). Is there a way to set this custom size? I can put the label size in the custom area but FileMaker will assume that they are on bigger sheets. Question 2: Most of the time I don't need a full (8.5 X 11) sheet of labels printed. In fact, I might only need 5-10 at a time. This seems like a very wasteful way to operate. How do I re-use the sheets and get the labels to print where there are still labels left on the sheet? (I know there …

Hi, I was wondering what the SOP on disabling the layout drop down list on the palette/navigation view of filemaker? I have many layouts right now, which are test layouts that I plan to delete, I really don't want people to go in there. Thre is an option which says "No access" in privledge set, but then they cant even get to the first layout. I know i can disable all the layouts - but i'm wondering (hoping) there is a better approach. I look forward to your input. thanks sincerely, J__

I'm trying to create a simple list/report of certain names in my data base, but after doing a find and sorting the resulting list, I'd like the names on the list to be numbered. I can't use serial numbers because they're not sequential. Any thoughts???

I have a database with three related tables: assets, troubles, and changes. I would like to create a "summary" layout that will show me the 10 most recent records from each of the three tables so I can see, at a glance, the most recent entries into the database. Does anyone have an idea of the best way to go about this? Thanks for any help you can offer.

This probally has been asked before, but how does one create an url link in FM Pro. This is for our internal FM Pro database (not online) so one can click on a link in the database browse mode and the IE browser will open up and go to the specified url.

Hi all, I have what is probably a common question, but my searches in the forums yielded no results. I'm using FMP 7 (mac), and I have a pretty simple invoices table in my database. I also have several other tables in the same database, including labor line items ("li_labor"), taxable item line items ("li_item_tax"), and non-taxable line items ("li_item_no_tax"). Each of these three tables contains a different type of line item (i.e. different fields/descriptions in each table), which feeds into my invoices database, with the invoice number acting as the match field. As far as entering and organizing data, this structure works fine for me. The problem come…

Hi, I hope this is the right place to post, i didn't see a 'reports' forum. I'm wanting to have a reports_main layout, which displays a portral or list of script names in a table. I want to display a nice description of the report, then allow my user to click on the row. Once they click it i want to run a script, something like Launch_Report() and do a performScript on the field name in that row - and the contents of that field contain the script name which is in the current file. doesn't look like I can set PerformScript's parameter on the fly.... is this possible? Is there a design pattern for this kind of 'Report Main View' where your user can pick fr…

Ok, this just might be a total noob question. What I'm trying to do is print the Layout view and showing all the fields and their labels. I'm used to FileMaker 3 on a Mac and now I'm using 7 on Windows. I seem to remember doing it, but just can't find the right buttons to press and online Help just didn't. I can print the layout with blank boxes or with underlines, but not with field labels.

I wrote earlier for help in finding out why my field borders around repeating fields disappear. I have worked with it long enough now to determine that the borders disappear when I use Sliding fields on the same layout. Does anyone know why this happens?

Hi, I'm having a problem getting text in some of my fields to properly center. for example, the text "My Enormously Big House" is displaying like this in my field: My Enormously Big House If I insert a line break between "Enormously" and "Big" it corrects itself, My Enormously Big House But I shouldn't have to do that, right? I don't have any leading or trailing spaces, not sure what's wrong. Thanks! Andrew

Hi Is there a way to let a user choose what he wants to see in a table and what not? (dynamicaly, not to create a layout for each possible set fo fields...) Is it possible in a portal? Is it possible to save these settings for each user? (including the order of the columns)

I've just installed 7.0v3, and discovered that if you expand a part (header, body, footer, etc.) temporarily to work with something in the part, then try to reduce the part back to its original size, it makes the part one pixel larger than it originally was. The great majority of my layouts have objects that appear to continue across multiple parts. This new system creates a one-pixel-wide horizontal white line between parts, which obviously is a huge problem. Does anyone know if there is an easy way to get FM to act like it used to? If not, what other methods are there to solve the problem without going through a ton of laborious single-pixel moving of object…

Is there anyway to create a grapg in a layout. I have created a report that shows sales by customer and I want to have it display as a graph. Anyone know if this is possible?

Hi; Here is my problem: I have a text type field (It is used for description of a product and has a vertical scroll bar checked) that i would like my DB users to be able to read not edit. So i populated the field and selected vertical scroll bar (no entry allowed) and set the field borders. It looks great but the Vertical Scroll bar will not scroll. The only way I have been able to get the Vertical Scroll bar associated with this field to scroll is when i allow entry into this field (which i donot want to do for db users). Can someone explain this feature to me. I am relatively new at this, but I fear i am misunderstanding some fundamental fe…

Hi all, my problem is when I have two records in the same numbering, how I calculation the pages number? like: number field(INV0001---2 records)Page 1 to 2 and Page 2 to 2. Thank for your reply.

We need a FileMaker 7 plugin or another way of displaying the current window without scrollbars, and without FileMaker 7 zoom/mode/status area controls in the lower left corner.

I'm trying to create a lengthy and complex report that combines research data from about 10 tables and places it into user-defined text templates stored in their own separate table. The report would look like the following (sans blue text): [color:"blue"] template text Category 1.0 [color:"blue"] research data Two boxes and three crates show damage. [color:"blue"] template text Category 2.0 [color:"blue"] research data One lamp was broken in box #44786 etc., etc., etc. My very general question is this - what would be the best approach to assembling/generating the reports? Via each child table that corresponds to the research data found in a…

Hello Together, I just signed up in this forum, formerly working with EXCEL I'm new to FM and have following question: how can I define the sequence/order of fields? I have created several fields in my layout which basically looks like two colums. When I use the TAB key I'd first like the curser jump all the fields down in the left column (lets call it column A) and then all fields in the right column (let's call it :. What it does right now is I'm in field #1 column A, then pressing TAB it jumps to #1 column B, then #2 column A etc etc. How can I make it first go all the way down A and then B?? Thanks in advance, Andy

Hello, I created a form to print labels but in order for it to print, when the Print Dialog appears I have to select "Filemaker Pro" from the pulldown that displays "Standards & Copies" and then I have to select "Records being browsed". A similar layout in Filemaker 5 prints just by clicking the Print icon or selecting Print from the File menu. Does anyone have any idea as to why these labels won't just print? Thanks, rlbryant

Anybody have any ideas on how to make a horizontal non printing navigation bar above a header/body on a layout. I want to put my record commands up there but I do not want it to print or affect spacing.

Hopefully I am in the right forum. A simple, I'm sure relationship/layout problem: I want to print a repair report on equipment. One table has information on the equipment. The other has the information on the service work. There is a one (equipment) to many (service) relationship. I utilized a key field for equipment and one for service, so equipmentID in equipment table connects to equipmentID field in service. Layout is to be grouped by item name The layout is set up selecting :item name (from equipment table) date, problem, service company (all from Service table) The report will not show the related field "item name" Layout is base…

Does anyone know if I can setup buttons to show a name when you mouse over them. In other applications if you mouse over a button it will tell you what it does. Thanks

Hi, Gang! I'm working on an address book layout that begins with an imported tab delimited file and creates a phone directory-type layout. I'm using the label feature and I'm hung up on two problems: -when the name is too long, I want the phone number (the phone number resides to the right of the name on the first line of the label) to become the second line of the label and not line break in mid phone number. It seems that if I can define a non-breaking hyphen (similar to a non-breaking space) and use that in the phone number, that would work. I'm not sure if this is possible on the Mac FMP, however. -And how do I tell FMP to include the first record in th…

I am using a PC, Windows 2003, Filemaker 7. I have a report with two sub-summary parts , one for clients and another one for jobs. There is a body part that lists all the people that worked on that job. In the body part I have the persons name, how many hours that person worked , how many dolars the person gets per hour and the total that person should receive, that is multiplying the hours worked and the dolars per hour for each person. I would like to have a report with the totals for each client and the arithmetic mean. I managed to get the totals per client by creating a summary field with "total of" the dolar field and putting this field in the sub-summary pa…

I have a layout which really looks and works best in Table View, but it requires a Trailing Grand Summary Part with summary fields. I can only get it to print in the Footer which makes it appear on the first page, too. Is there some way to get the summary on the last page only? On the first page it is confusing because the Sum = more than the parts on the page.

In the database ive created i set each button to change the mouse pointer to a finger when the user hovers over it, this is especially useful when i use fields to perform a script because it is not so obvious that they are buttons. Problem being that when i use developer to convert the database into a runtime solution this doesnt happen anymore, everything else seems to work ok, and its no big deal, but it would be nice if it still worked. Anyone got any ideas why or how i can stop it?

What is the correct placement of fields in portal lines to make embossed fields all appear next to eachother in browse mode? I have portals with multiple rows. My portal is without lines or color and not engraved or embossed but set to have scrol bar at right. The fields are placed one per portal row and are embossed. The problem is that I can't get the top and bottom field edges to line up against eachother. I've tried making each row 1,2, 3, 4 pixels lager then the field, and either the space between the fields is overlapping, too wide or there is a patter of good placement once every 3-4 rows . I've tried scootting the field up and down but without success. …

i was wondering if anyone knew how to make the layout part label (where it says 'header' or 'body' etc) to be vertical? the templates in fm7 have them going vertically, but when i create a new layout, they're horizontal and i can't seem to figure out how to change it. any help would be appreciated.

I am at a lost in how to even approach the solution to this issue: FMP 7 Mac OS X Have the following Fields in one table (Shift Table): Employee S1 (Employee that works 1st shift) Employee S2 (Employee that works 2nd shift) Employee S3 (Employee that works 3rd shift) Employee S4 (Employee that works 4th shift) ((Employee fields are populated via a Pop up list that uses values from a related table (Employee Table)). (The Employee field can be blank if day had less then 4 shifts) Balance 1 (1st Shift Employee balance (number)) Balance 2 (2nd Shift Employee balance (number)) Balance 3 (3rd Shift Employee balance (number)) Balance 4 (4th Sh…

Is it possible?

Hi All I have three layouts containing a Contract. First layout contains pages 1-6, second layout contains pages 7-11 and third layout contains page 12 Question: Can I create a field that will display page numbers between the three layouts. I need the layouts to print continuously without restarting page numbers. Can this be done? I want the field to display just the page number not "Page 1 of 12" Thanks in advance for any assistance! Sheryl

Hi, Not long ago, rlbryant posted a question that was left unanswered... I have the same concern... Basically, I would like to get rid of the horizontal scroll bar in FileMaker Pro and also in IWP. Is there a way to set the width of the "body" part? Thanks, -GerryGerry

I would like to be able to compare one set of data with the data from the top spender in a market. The problem is I can sum up for a single brand in a row, but how do you combine one brand with another brand in a sub-summary part? Thanks

I am having trouble getting the option in the Layout Setup: Printing to get the print across section to work. I can print down, but it won;t let me print across? There is plenty of room. Thanks for any help.

I have an interview which a research nurse completes straight into the computer which is made up of 621 fields. I wanted to be able to pull certain fields from the interviews into another layout for the analyst to view this would be two tables of roughly 300 fields each...I seem to be running into a size problem that I can only display so many fields horizontally in my table then it puts in a carriage return and enters the next set of fields so I end up with my data for each interview being split across 4 lines rather than being on one line. This is not only annoying in fm but also causes problems when I try to export the data to a statisticall package. Is there anyway…

I am attempting to create a report where records are summarized by month, ie, all records created in January 2004 are grouped together followed by a summary beneath the grouped records. In order to do this, I created a calc field that parses the creation date(auto-enter field) using this formula which returns the value as text... Year ( date_Created ) & " " & Month ( date_Created ) When I insert the sub-summary part into my layout, I specify to sort based on the calc field discussed above. My problem is that when I execute the sort, it groups the records by creation date, not by the calc field I created. In other words, its grouping the re…

I want to have a layout which will be viewed as a list, but with sub-summary part on the layout. I'm currently using FM 5.5 and it doesn't show the sub-summary part. The sub-summary part is only shown in Form view, or in Preview mode. The problem with these are that in Form view, I can only see 1 record at a time (and not the list I want) and in Preview mode I can't get buttons to work (which means no navigation possibilities). The only way I can think of now is to have button (with script) on my normal form to go to Preview mode, show the status area on the right, pause (a continue/cancel buttons now appears on the status area), and have it go back to my normal form o…

I have a project to combine several different FMP 6 databases together. They're all basically name & address lists, but of course using wildly different formats. There are tons of duplicates, but of course not exact duplicates. So I have a lot of hand-work to do to dedupe the combined list. I'd like to make a layout that would allow me to show two records on the screen together, side-by-side, so I could compare them both and decide which fields to use, and then delete one of the two records. Can anyone point me towards a technique for a form (not a list) to display two records from a single database at the same time? -Steve

Hi, I'm newbie . I made a database with only pull down lists, but now I' ve a problem: when I change the selection of one pull down list in automatic the cursor goes on next pull down list and so on. So every time I want to change only one pull down list in a record I'm constrained to change all the following pull down list. This is very boring. Someone has an idea to fix this problem ? Thanks

Hi, I have created navigation buttons that I would like to have appear on all layouts in a file (so I don't have to re-create or re-position them in each layout). Is this possible in Version 4? My appologies if there is an obvious solution. Thanks, Chris

Hi, I have an inoices summary report i'm trying to put together. I'm very new to reports so put the kid gloves on! I have an invoices table and a InvoiceLineItems table. (1-M) relation. I'd like to order by date the invoices and underneath each invoice, display the lineItems which are associated with that invoice. example: Date: 11/01/2004 Invoice1_InvoiceNumber, Invoice1_Amount InvoiceLI_Description Invoice LI_Amount InvoiceLI_Description Invoice LI_Amount Invoice2_InvoiceNumber, Invoice2_Amount InvoiceLI_Description Invoice LI_Amount InvoiceLI_Description Invoice LI_Amount Da…

The date fields in my database are requiring me to input dates in the interational format. When I enter a date like 12/23/2004 FMP says the date is not in the right format and should look like 23/12/2004. My operating system is set to use the U.S. format for dates and my date fields are formatted to display dates in the U.S. format. Is there another preference that I'm missing for date input?

Maybe this question has been asked before but the Google search only gives me 4 results searching on 'theme'. Here's the question, how do you make themes in fmp6? In fmp 5 there was the themes folder with the .fth files but how does it work in fmp6. Where are the theme files and where do I find information about making my own theme. Thank you for reading and eventually answering this question.

I have a strange situation ... I have a Main Menu which is based upon my Preferences table. It contains only one record. The Main Menu display has NO FIELDS - but only buttons. If the User accidently clicks directly onto the layout (form) where there aren't any buttons, the system goes into 'hour glass' searching!!?? And it searches for a long time!!! Displaying the Status area, it is in Browse mode and unsorted and only one record. It drives me totally nuts. I made sure the layout is based upon Preferences base table. Preferences has many relationships but why does it search if no fields are on the layout? Ideas appreciated ...

Hi everybody I am new to this forum, so here goes. I am a keen to change the colour of fields on a screen on condition of its contents. For example there is a "Copy Date" field that I would like to be black but then red if the system date is the same as the copy date. I would also like objects to be visable or not visable on condition. For example only "Manager" accounts can create new publications. I would like the "New Publication" button to only appear if the account = "Manager". I would really appreciate any help here as I am just at the planning stages of a project and the above two issues could make an enormous difference to the design. …

Hi , I am trying to get a button that returns to the last layout it does not need to remember the last four layouts just the last one it was on. I am also trying to link to a pdf document through a button im trying OpenURL but to no avail does the pdf document need to be served at the moment im saying openURL pdf_document/about.pdf thanks for your time , DR

Can't understand why this works in Safari, but not in IE6 (WinXP) over Instant Web Publishing: I have a portal. Over a row, I've laid a transparent button so users can click on the portal row and it executes a script that takes them somewhere else. Works fine when I'm in Safari, but IE6 doesn't "see" the button (no "finger" appears). I do have Javascript enabled in both browsers. This is driving me NUTS. Any ideas? TIA, cooldaze (I'm starting to hate windows again.)

I just opened one of the pre-existing DB's that comes with filemaker pro "purchase order". there 8 layouts and I noticed that when I ever I do changes to layout 1 will not show up when I try to access the DB on the web browser until I do the change in layout 8 with is the web browser layout. My question is why have so may layouts ? do I need to change both layouts ? or do I only change layout 8 which is the web browser layout ? if so, then why have the extra layout ?. thans in advance for your help.

I have a data base of members names, addreses, etc, and wish to publish a directory in a half page format in booklet form (8 1/2 by 11 folded and stapled in half). I can set up the layout to print in half page columns but can't get it to sort so that when stapled together the data remains alphabetical. In other words, the data needs to move to the correct half page on the basis of the size of the data base and pages required. I hope I have described this correctly so you can give me some help. Maybe FMP can't do this but I know their are word processing programs that are able to do this for newsletters.

Hello, I'd like to know if it's possible via intranet (a web browser, ie or firefox), to access preview mode.I want to sort and make sub totals, then print. I am using Fm pro 7, Is there any plug in i can use ? Or can i add a script to make the server switch to preview mode and print ?. ( the user's computers and the server are close). Or any other solutions ... Thanks.

Is it possible to have two bodies, or two dynamic related information listed on a report? For instance, materials (one table) used for this work order (like invoice) listed with the labour hours (another table) as a print report...

Server: FMP Server 5 hosting on Windows 2000 Server OS Clients: FMP 5.5 on Windows NT and XP Pro I have an application running successfully in the above environment that for end users requires no knowledge of FMP, operating systems, and little knowledge of computers: just follow onscreen instructions, click on buttons, select from menu items, radio buttons, lists, etc. Calculations run in the background, and the end user clicks on a button to print the report. It takes only minutes to train a new user. I am writing a new application with data entry screens and reports that I want to print on 8.5" by 11" paper in portrait mode = no problem. But I also need an a…

Finding FM's Custom Dialog somewhat, ahh, limiting, here's a way around it: Duplicate your layout - then change all buttons to Do Nothing and kill value lists - make fields not editable. Group All and lock it. Draw your dialog box on top of it. You have full drawing tools and all fields and effects. With some effort you can make it look just like a real dialog box (see attached screenshot), but it is not moveable. Use a Done or OK button to go to your orginal layout. Place a control on the orginal layout to go to your duplicated (d-box) layout. As you flip back and forth, it appears as though the dialog box is opened above your original layout. In my schedu…

I need buttons. Does anyone have the sample buttons file that came with version 4? I'm to cheap to by the software I've seen available. Hope someone has the file and that they will copy and paste into version seven.

I can't figure out how to add a font to my Filemaker font list. I'm on OS 10.3.6. I have the font I need and I have Extensis Suitcase. I thought I turned the font on through Extensis, but it doesn't show in FMP. Help!

I am a teacher developing a database for staff use at the school I teach at (Sydney, Australia). Given that sensitive info about students may be stored, I want to limit access to certain layouts. When a teacher clicks a button that would normally take him to another layout but is denied access (via Accounts & Privileges), I would like a dialog box to pop up and say "Access to XXX denied" and to stay on the current layout (and not to a greyed-out screen which shows No Access and leaves techno-shy teachers wondering what to do next). Also, is it possible to modify the above so that a password is called for. If they type in the wrong password, I would like a d…

Gang- I'm attempting to create a phone directory from an imported tab-delimined file. The format is as shown in the attached jpeg. (I've blurred the non-fictional entires to respect the privacy of the members.) I have two issues with this. Issue One: As you can see from the non-blurred entries, I'm using the label feature of FMP to create a two column listing of "labels" with a page size that's the size of the directory page that's being printed. Though I'm not actually printing labels, this format seemed the best approach to create a directory listing. Line 1 contains the last name and first names of the adults in the household (this is all one field;…

Hello all, I am not new to FM, but there is one thing I could never figure out: How do I create partly transparent graphics for my Layouts? On the Mac, making one colour transparent (in GraphicsConverter) and then pasting the image to the layout seems to work, but when viewed on a Win PC the transparency is gone. However, there are sample databases (from the ISO CD, for example) that contain lots of partly-transparent graphics? Have all these been created using the "native" FM layout tools? Surely not. I tried search, google etc., but to no avail. Grateful for any help. -- Lutz Pietschker Berlin

We have a contacts database of company employees that we print in a layout using sub summaries for each department. Is there a way to make the 'alternative background fill' work in form mode (which we print from)? I can verify the alternative background fill feature works fine if the layout is viewed in Table or List modes, but not in Form mode. This seems rather strange! Why would this feature not carry through to the one mode that surely most use is made of by the people viewing and printing the database? Is this a bug?

How to show the record number in a sub-summary layout? I need to show the record number starting with 1 at the beginning of each new category. Example: Colors 1 Red 2 Blue Shapes 1 Oval 2 Circle

I am developing a solution for estimating jobs and I was asked if I could make a layout appear like a spread sheet and keep it interactive like an excel document. I was going to create four tables, one for job info, one for materials, one for trade services, and one for labour costs. There are going to be a max of 10 items per estimate and each item can use any combination of labour, materials, or trade services. I was thinking of doing this with portals, but cannot figure out if it is possible. I will attach a file displaying the type of view they would like. Any input is greatly appreciated Len Worksheet.zip

Wondering if anyone knew if there was a way to specify a specific row and column for printing a label instead of creating a whole sheet of the same label. For example If I wanted to create return address labels, but instead of printing a whole page of labels, I just want to print on the label located in col 2, row 3. Any thoughts??