Layouts

I upgraded my filemaker 9 to the filemaker 10 trial and when i removed the trial and continued to use the FM9 version all of my pages sizes were converted from 8.5 X 11 to 3.5 X 6 I CANT PRINT ANYTHING!!! I have no idea how to change this back and i tried to call FM customer support but apparently you have to pay. Can anyone help me out?

Morning everyone! My boss has asked that I print a weekly report on updates I make to notes on each company, and export them to an Excel file. Here is the tricky part: When I do the report, only the most recent note/time of creation/creation date, appear. I need ALL the notes to appear for each company, including their corresponding dates/times. The data containing the company notes and date/time is coming from a tab containing a portal with a "note" relationship . Photos are included that display all the info pertaining to this problem. I'm sure it's a simple fix....just not a request I have run into before. Thanks everyone!

Wondering if anyone can help me with this. I'm making this Formula 1 Database that consists mainly of an Event table (the "Grande Premio" sub-area on the attached layout, p.s. it's in portuguese, my native language) and a Results table ("Resultado" sub-area) linked thru the common field Date. I want to include in my layout driver and team point standings after each race ("Classificação" sub-area, based of course on the Points field of the Results table (rightmost column on the layout). Could anyone give me an idea how I can accomplish this? Do I need to create a new table and a portal for that or can it be done with a simple script or calculation? Also it would be …

I know that I can format a field on a layout as a checkbox set, radio button set, drop-down list, or pop-up menu. But what I would like to do is format a field as a scrollable value list, where the user clicks on a value to highlight it. If this isn't clear, think about the interface in iTunes: You have, essentially, three global fields (g_Genre, g_Artist, and g_Album) that you set by choosing from a scrollable list, and then a portal of records whose fields (genre, artist, album) match the global fields. I thought there might be a way to rig a drop-down menu to stay "always open". That would sort of simulate what I am after. But whenever I exit the field th…

Is there a way to show the 'Formatting Bar' in a script. In addition, is there a way to hide the 'Formatting Bar' in a script.

Hi everyone... I'm trying to set the spell-checking (File options - Spelling - Indicate questionable words..) automatically ON on the startup of my solution but I can't figure out the way, because every time I open my base, it appears unchecked! Does anybody know how to set it up to automatically "indicate questionable words with special underline" not having to turn it ON every time I open the solution? Thanks a really really lot for your help!

I'm having a issue with creating regular US address labels. These are the fields I have and how they're formatted: <> <> <> <>, <> <> The problem is when I preview my labels there are blank lines within them because the Address 2 field is blank. Like this: Jane Doe 123 American Way San Francisco, CA 94400 How can I fix this? Is there a way I can only show the field if it has data in it? Please help!

Hi All, Whenever I go into a field in browse mode, all other field's BORDERS get high-lighted, how do I stop this?

I need to find a way to take a field and add to it to form a filepath to an image. For example, My field is SKU123 I need to take that field and use it to display the image at: c:photossku123.jpg How would I create this filepath using that field, then then how would I display the image on the layout using it?

I'm using FMP10 but I've yet to see the new "Find" icon when in Find mode. What setting enables utilizing this new feature? Appreciated.

Hi I have a rather large note field in a layout and in that are various 'words' that aren't recognised by the spell checker. Whenever these words are displayed they are underlined in red making them very difficult to read (some of them are case sensitive passwords). Is there any way in which the spell checker can be turned off for particular fields? many thanks Graham Keeley

Anyone have a royalty free blue button graphic that they would like to share? The button graphics that I have are grey, and don't contrast well with my grey background. I'd like a blue similar to the old apple website.

I want to always see the text entry boxes on the current record, even before I select a field. is this possible?

I have a database that has a half dozen linked tables. As I develop this, I am going to need about 100 different layout views. I can do this with lots of separate layers or I can do this with fewer layers and more tabbed folders within those layers. My question is about efficiency and speed. As the user navigates through this database would there be any performance issues favoring one approach over the other?

I have a table with information about films that includes 6 container fields with images from the film. I want to create a layout that will print a label for each film featuring *1* of the 6 images depending on the user's selection. I was thinking what I could do was to havea field that allows the user to enter a number from 1 through 6 corrsponding to the image of choice and then run a simple 'Case' calculation that would read the number and enter the appropriate image in a 7th container field called, say, 'LabelPicture'. I've been tinkering, and it seems as though I can't get Filemaker to enter container field data via a calculation -- I think I may have …

Can I set a container to have "No Fill Color" I am using .png files for layout visual purposes and dont want fill colors in the box. For some reason it is defaulting to Grey and when i make white creates a white box... UPDATE: Found it... search old topics didnt pull it up for some reason.

Now that the record browser is on the toolbar rather than the status area, when in preview mode in a custom menu set that shows the status area, the user can not navigate to the next pages - it seems locked. It works fine in FM 9.0 I have allowed toolbars, but apparently that is only for the Formatting Toolbar, but that doesn't help. I am not sure why FM did this. Most screens are landscape and have more space in the horizontal than in the vertical plane to give a status area. I need users to be able to preview pages while preventing them customising the toolbar. Am I missing something?

I have a layout that I want to extend several fields on and then slide them upward when necessary but it appears that I have reached the maximum possible length of a layout or at least the body part. I have stretched the total layout to 111 inches (all but 1/4 inch of which is the body) and I cannot stretch it any further. Has anyone else encountered this and if so any ideas about how to deal with it? Thanks in advance.

When you get a listing of layout names on the left side of your screen and you have more than a columns worth it gives you up and down arrows to scroll through your names. Is there any way to get them in multiple columns to see all the names on your screen at once?

Here's some background info: I'm an optometrist making a patient exam data solution. Some patients will have tests done via specialized equipment and the data is printed onto paper. I'll scan the results (2 tests on each of left and right eye, thus 4 tests per patient) and import them as jpgs into the patients record in Filemaker. I now display each test as a small "thumbnail" image in a one of 4 small container fields on the exam layout. I have each container field set with a script trigger that when the field is clicked (i.e. OnObjectEenter)it runs a script to open a new window with a full size version of the scanned test. With me so far? Yes? thanks! H…

Is there any way to make a field have a transparent fill color?

hi all, when i copy a non-square graphic created in FM or another app to a container field, i always get a hite background, even if the original image has a transparent background. can i somehow keep the transparency?

I've created a report and want to show the monthly sales by employees, but I want it ranked from highest to lowest value. My report consists of the following: sub-summary besed on Month_num (contains month name) sub-summary based on employee ID (shows firstname, lastname, summary_sales_total) No report body The report displays the information correctly showing each month followed by the employee and their aggregated sales totals for that month. My only problem is I want to sort it from highest ranking sales to lowest for each month. No matter how I've tried to sort it, it won't come out correctly.

First, forgive me if I'm posting in the wrong place, I'm new here. : I'm trying to create a search layout that has a few different text boxes that each search different fields in a table. Ideally, I want to be able to write a script that finds the record/records that best match the search criteria and then reports them into a portal. The program is still very new to me and I'm struggling with the interface and syntax. If my question is too stupid or the answer too complicated, then I'd ask you direct me to a comprehensive tutorial.

This is kind of a simple question but I can't figure it out. When grouping objects you hit the [command] + [R]. In order to [color:red]un-group (according to drop down menu) you hit [arrow] + [command] + [R]. Nothing happens when I combine these keys. Is there more than one arrow key? I'm grouping & un-grouping all the time and this is getting a bit annoying. What am I missing?

Is it possible to change the column header names for the table view? I'm getting my actual field names from my tables. I'd like to give them some friendly names for my users. Thanks in advance.

Hi, I have a product table which has 10 container fields within the table (to hold a varying number of imagers per product) - [yep they probably should have been put in a separate table but they weren't - have to accept that pro tem!] I would like to produce a report that shows the images one per page. I am happy that the report will only be run for one product at a time. I have put 5 (out of max 10) containers in the body part of a report (one per landscape page) ie so that they are as big as possible and retain their perspective. I have also set all 5 to "slide/reduce enclosing part." The problem I have is when there are only 3 images (say)…

As well as trying to get the last page to be my "Title Footer" - one suggestion being to use the Trailing Grand Summary - which layout part should I use so that my text ("Continued Over") appears at the bottom of the first and subsequent pages but not on the last page? Any suggestions?

Dont know where to post this topic but I'm curious. I uses one of my solutions and deleted everything I could think of in the file, there should be nothing left. the file size is 828kb. I then created a new document and the file size is 52k. What is in the file that makes it so much bigger? Thanks

This is on a project tracking database. I have a report (layout) that shows project details. One of the fields is a note field. There can be multiple notes per project. The notes are stored in a separate table (projectID, timestamp, note) The report is showing the very first note it finds, but the customer wants only the most recent note on this report Is there a way I can tell the report what note to display? I can think of a way to solve this issue if it were in PHP with mySQL... But I cant quite wrap my head around this filemaker thing! Hopefully I am being descriptive enough.

Hi Gurus ! Is it possible to create a "Master Layout" in FM like in PowerPoint? I mean a layout that has pre defined basic elements (like background picture, headings etc.) in place when creating a new layout.

I have a report that lists payment categories and all the payments in that category and then has a sum at the bottom. I would like to create a layout/report that shows the same thing except that it does not list all the payments in the categories. like this: Payment Cat 1: (sum of payments) Payment Cat 2: (sum of payments) etc.. any ideas on how to accomplish this?

It is minor, but a hassle for our users here to have to change page orientation when they print. I went into layout mode and changed the orientation, but the change doesn't seem to "stick". Is there another place to change page orientation?

I have a layout setup in form view designed to print multiple pages, depending on the amount of text contained in each report. I have a few signature lines that I want to print out at the bottom of the last page. I set the sliding/printing on all fields inside the body section to sliding up based on all above and also reduce the size of the enclosing part. I believe the title footer will print the first page and not the last, does anyone know how to accomplish this task? Your help would be appreciated.

Does Filemaker support superscripts and subscripts? I am making a value list that has squared values and want them to display normally not with ^2.

I have created a managed list that has radio buttons, but I want them oriented under the values not next to them; how do I change the orientation of the buttons to do that?

Twitter question from DillionSG Option 1: Merge field - While editing a layout go to "Insert" "Merge Field" (Ctrl-M on windows) Option 2: Edit the field behavior to not allow being entered in browse mode. Nice thing here is you can set it to be entered in Find mode so they can search by the field but not edit it. Option 3: By security roles - little advanced, don't have time to go into it, but could be setup and used eventually. Kevin

Hi, How do you guys would manage a menu in Filemaker (or a forum categories could have the same complexity)? Each menu item can have some child menu item or not. If there's no child, then there's a link to a layout. Here is the structure: menuItem (pkMenuItemID, fkParentMenuID, description, gotoLayoutName, uiParentDescription, ...) So as you can see, there's a self join. In menuItemChild context : uiParentDescription = if (fkParentID; menuItem::description; "") I would like to create a breadcrumb effect to show the parent menuItem, but I only managed to create a single parent breadcrumb, no grand-parent. Thanx for any help

Hi All, I'm building a subsummay report and need to display the number of records within each subsummary section in the header of each section. Is this possible? I've tried several options and am not getting an accurate number. Help please. Cheers -JJ

I would like to add (or copy) layout objects and have them automatically named. I don't need any special kind of naming, just a serial unique ID would be enough. Do you know any trick or plugin that could help? Thank you!

Is there a way to tell if the user layout is being rendered on which specific user platform: Windows, Mac or the Web?

I know that in FileMaker layouts, buttons can have more than one line of text. But in IWP, only the first line displays. Am I just missing something, or am I just stuck with this limitation?

I have a layout that contains 2 date fields amongst a bunch of other assorted fields. When I use a script to insert a date into or even just select one of the specific date fields, the date field selected is always the leftmost one in table view. In any other layout view (form or list), the correct date field is selected, but If I switch to table, it is always the leftmost date field no matter which one I specify in the script. If I swap physical positions in table view then, the other date field is selected with the exact same script. I have tested this with very simple scripts-just go to field or insert date into the specified field. I think this occurred when…

I am attempting to print receipts with the a Zebra LP 2844. I can't seem to control the paper length let alone get the font printing in the correct direction. It worked fine with labels while I was developing this module, but now that I have the receipt paper in use all bets seem to be off. Anyone have experience or tips to share? OS = 10.5.6 FM = 10 Driver = Zebra EPL2 Label Printer, 1.3 Printer = Zebra LP 2844 Thanks, Drew

I just started to use FMP and i cant find out how to make Body in screen size of A4. I want to see everything in Browse 100% same size that will be when printed to A4.

Hi, I am new to programming and I am using File Maker Pro 8 advanced. I have requirement in which I have defined the radio buttons for selection of either payment options (Through Bank details or Credit Card details)as: when we select Bank Details radio button it should display the fields of Bank details below and when we select Credit Card details it should show Credit Card fields on the same page. Note: IF there is any option where we can disable the fields when we select a radio button that will also work. Please can anyone suggest me how we can do this. a sample code will be much helpful.

I'm stumped with a little problem I can't believe I've never encountered before: I have a little text box in a portal that displays keywords from a lexicon. I've made it long enough to handle 99% of the keywords, but I'm concerned that in some odd cases the user won't see the entire keyword. When you enter a field in Browse mode it does that nice automatic thing where it pops open taller to reveal the whole contents of the field -- but I *don't* want the user to be able to enter the field in Browse mode and change the spellings etc. Is there a simple or clever way to handle this sort of visibility issue? Albert

If possible I would like my database to have navigation tabs along the top of each layout, as well as a set of navigation buttons down the side of each layout. However, when I do a "List" layout, the body is only one row high and I can't work out how to get the side buttons to fit around this. Is this possible?

I am creating forms in Filemaker (currently 10 trial, soon 9 pro) and for most of the fields I am asking questions that exceed 100 characters in length. Is there a workaround for exceeding this constraint?

I have a letter that has a sub summary inside the 2nd paragraph. I have it viewing in Preview correctly but when I use the Save as Pdf. script step, it only allows me to use either the current record or all records being browsed to be printed. Does anyone have a work around so that I can get just the sections I want to print that have more than one record???

Yesturday, out of no where, some of my fonts started to look blurred or fuzzy and I have no idea how to fix it. It's only the bold fonts (arial) and a couple others. It has been working fine for years and just started this. Does anyone know of any solutions I can try to fix this? I use Filemaker all day long and don't think that I can handle looking at fuzzy fonts all day. Please help! -Robin

Hi All, I've got a set of invoices that i want to sort by the month and year , which i'd then show in a sub-summary report. That report would produce a list something like: 2007_01 2007_03 2007_08 2008_01 2008_02 2008_03 I'm sure there's an easy way to do it, though i've been searching and i couldn't find anything. I have tried Date_to_Sort_By = Year (Job_Date) & "_" & Month (Job_Date) but the result for Jan is 2008_1 rather than 2008_01). This then doesn't sort properly because of Oct, Nov and Dec (ie 2008_10). Many thanks if you can point me in the right direction, Slater ps am i right in thinking that i can't do an…

Hi, I have a field that I only want to allow data entry into if it is empty. Is this possible? If so, what is the best way? Hal

I'm just starting to work with Filemaker 10 and I must say that I am fairly impressed so far. I am struggling a bit with the new layout tools. As I recall, I used to be able to see at a glance how many records were in my database and which record number was currently active. Wasn't there also a small scroll bar gizmo that allowed you to scroll through the records? There was also a button that you could click and hold down to dial font sizes up or down. Can anybody tell me how to find these tools again? Thanks, Jarvis

Hello, I'm a complete beginner at this, my inquiry may be completely dumb.. I have a layout that is meant to printed.. it displays data from certain fields.. ie: Hello <>, is it possible to add an additional field input ?, only if there is data in the second field? ie: Dear <> and <>, yet, if no data is in "field 2", then only field 1 is display... without the word "and" as well. I know this might be very easy, but after searching I don't where to start.. Thanks for any help possible.

Hi, I am a Biology major with zero programming experience. I've just started using File maker and I'm creating a database for an online store in which, I have provided my customers the opportunity to pay via credit card. In my database, I have two sets of addresses: 1)Billing address 2) Shipping address. I've put in a radio button to check whether both addresses are the same. If the radio button option selected is Yes, I would like the address details entered in the billing section to automatically copy themselves to the shipping address fields. If the radio button option selected is "No" I would like my representative to be able to enter text int…

Is it possible to have a field display text on an arc? I need to display text from a database on a 1/2 circle and would LOVE to be able to do it in FM. I have version 8.5 now but have downloaded the 10 trial but no luck. Hoping a FileMaker master knows a way! Otherwise I'll be exporting and scripting in InDesign to pull off what I hope is a simple function in FM. Thanks!

I need to change the name of several layouts (ie; from "name" to "name-temp," then after changes to the layouts back to "name"). Is there an easier way than renaming each one individually? Thanks in advance.

Its probably been asked before... If I have a report that is sorted and summarised by 3 fields In this case Customer/Project/Deliverable I would like a page break before each customer and before each project - but not the "first" project for each customer as that creates an empty page? How do i configure the part set up? Many thanks

Is there a way in which to combine reports from different tables into one report without using the PDF features? I have what is basically a kind of contract. Each section of the contract is a single large text field. On my report layout I used a merge field for this text field so it can span several pages in the body part and break properly. I would like the ability to insert some data from another table after one of these sections as per a user selection. What I want to insert is more or less a spreadsheet like chart with data from another table. Is this even possible? Thanks, Greg

Hi all, is there a way to find out what fonts are used in layouts? I can go through one by one of course, but maybe there is a usage menu or script that I"m not aware of. thanks in advance Hank101

Hi All, As I'm on a 10" laptop, every millimetre is precious! I'd like to be able to hide the bottom scroll bar (which includes the Zoom Controls, Status area controls and mode pop-up) in some layouts. Is this possible? Thanks heaps as always! Helen

I have a report that looks like this in preview: Fred Smith -this is the sub-summary part 1/2/09 8 hours - 1 record 2/3/09 8.5 hours - 1 record 3/3/09 8 hours Mary Jones 1/2/09 6 hours 2/3/09 7 hours 3/3/09 8 hours I don't want Fred's or Mary's records to split across a page, but I don't need everyone to start on a new page. At the very least I'd like 'Mary Jones' to repeat at the top of the next page if some of her records don't fit. I suspect this can't be done, but would love to be proved wrong... I hope the question makes sense.

Anyone else seeing this. On vista after going in and out of layout mode multiple times, it appears. Close and re-open it's gone.

Hi All, I want to be able to view a list (that varies from about 15 to 30 items) on the computer. I want large type in columns. Is this only possible in Preview Mode? I have assumed that, so in my script I enter Preview Mode ('Enter Preview Mode [Pause]'), then I have 'Enter Browse Mode []' so I can return to the previous layout, but this doesn't get me back into Browse Mode. Can I get back to Browse Mode without using a FileMaker toggle menu, ie is it possible to have a button on my Preview layout, or do I need to use a different command in my script? Thanks heaps, Helen

I'm looking for an efficient way to validate an exit of a portal row. Specifically I want to allow users to enter data into portal row fields in any order they want unencumbered. But if they exit the row completely, then I want to test whether the state and country fields have been left empty. In FMP10 is there a way to do this? Much appreciated.

Hi, Is it possible to create a common button bar for multiple layouts? I created one a few years ago, but if I needed to add or change the behavior of a button, I had to copy/paste the button on each layer that would have the button bar. This way is not very "maintenable". Do you have a better idea?

I've set up a simple subsummary report that displays the sum for two levels of break fields. Some of the top-level categories have subcategories and some don't (subcategory field is empty). So here's what I get now: Category I 10 Subcategory a 6 Subcategory b 4 Category II 12 12 Category III 8 Subcategory a 5 Subcategory c 3 What I want is to get rid of that extra "12", in other words, not show the subsummary part if the break field is blank for that category. I tried using conditional formatting comparing GetSummary calculations to try and make the sum field white if the category and subc…

Is there a way to page up and/or down in preview mode without going to the Status Area?

Using Trial Version of Pro 10, hosted up for IWP, with one other person updating via web. While I was working in layouts (via program, not web) something glitched (hosting?) resulting in a freeze up. Had to exit and re-open. Now the layout I was working on is blank, no fields, etc. and I can't delete. I would appreciate any thoughts.

I hope that I am not right about this, but it appears that FileMaker 10 Instant Web Publishing has retained the old 'Status Area' instead of sporting the new 'Status Bar'. Any comments?

Hey guys - I'm new to filemaker and I am wondering if there is a way to lock a picture to the background of my body. Basically I don't want the image to scroll when I scroll the rest of the page. Is this possible? A web example would be something like twitter.com where the background clouds don't move when you scroll. Thanks, Will

When I generate a sales order, I can print an address label. How do I pick which label on the paper to print to, as opposed to always printing on the upper left corner label? I'm sure it is easy, but I haven't had any luck finding the answer. Thanks.

I want to create a layout that lists individual names in a permanent table view. I know it's simple, but I can only get one name to show up at a time. Assistance please?

Hi All, I'd like to create a database of legal provisions that will be used in various contracts. Some of the provisions are quite long (up to 3-4 pages each) and may contain formatting of sorts(eg, underline, bold, tabs, indentations, etc.). I'd like the text or container field that will contain the provision to preserve such formatting, so that when the user later copies the contents of the field and pastes it into a Word document, the formatting will come with it so that the user doesn't then have to run around the Word doc reformatting the text. Can this be done? Thanks! J

Is there any perceived wisdom/best practice on the following: I want to do bulk mail shots (not email) using a file maker report to multiple contacts - the quantities are not huge, usually less than 400 contacts per mailing) Is it better to build the list and then print one report for all 400 contacts (with all details in the body part) or is it better to build the list and loop through the list printing a single report for each contact sorry if this is really basic but it obviously affects scripts many thanks Simon

I can't figure out why this is happening but I seem to have a bit of an anomaly here. I have an address field set up to display in a Brush Script font yet one field refuses to show up in that font. All the other fields display properly but not the address field. I have tried a number of things: - re-typed the values in the field - duplicated another field and then renamed it to the address field so as to copy it's attributes - re-formatted all the fields as Brush Script. - etc. etc. Any ideas anyone?

Hello All, I've just tried a very simple button setup on a field...get related record from table A, show record using layout X, check the "Show in new window" and specify a small window size. When I click on the field, a new window pops up as the size I wanted. The problem is that the main window also shrinks its size to the same size as the popup window. This happens to my test database, which is a copy of the real database. I tried the same button setup on the live database, the main window shrinks too. However it shinks only a quater of an inch. I also tried a scrip with New Window, that the effect is the same. I normally have the database window in full size. …

Hi All, I'm trying to use FM to output invoices of mine, and i'd like to be able to have lines in the invoice excluded if there's nothing in a particular field. For example, the report would show something like: Days worked: xx at rate: yy totals: zz It would show this if x was a value, but if there was nothing in x (ie no work had been done) then the whole line would dissapear. Is this possible? I'm thinking that i have to got to do this with a calculated result, ie LINE1 = if NUMBER DAYS >=1 ; "Days worked: " & NUMBER_DAYS & " at rate: " & RATE etc ; "" This being the case, how would i format the info in the calculation - for e…

Hi everybody, I am fairly new to this and would need urgent help with some sub summary issue. Everything worked fine until some days ago. Created fantastic subsumary reports of consolidated data. Every since about 1 week, when I close the db and reopen it the layout does not recoginze the subsumary parts no more. Meaning, that the Trailing Grand Summary, Header and body are there, but in preview mode the both subsumary parts are simply not there no more. Happened also a couple of times when I switched between layouts.Looks like the layout does not recognize the subsumary part. Anybody here with similar problems or solutions?

Not sure if this is where to put this, but I'll start here. A user has transferred my runtime application onto a laptop. When the application is run, field, portal, and button borders do not display. Nor do the 'lines' on text boxes or other objects. I don't think any lines display anywhere on any layout. The color content of container fields also does not display. None of these objects uses conditional formatting (I don't think you can conditionally format borders anyway). Fill colors and text appear to display completely. No other user has experienced such problems in 8 years of application. I have no idea how to diagnose the problem, but I…

I have created JPEG button images that work fine in the Mac Version of FileMaker 10 Pro (this problem also occurred in FileMaker 9 Pro) but not when I use this file in the Windows version. The Windows version graphic becomes text: "Quicktime and a decompressor are need to see this picture." What is the best way to solve this problem?

I want to create a report that displays the dates that certain Acts are available to be booked. Now here lies my problem. I have (which relate to this) 5 tables acts, members, events, avails, agents So Acts is self explanatory, members are the individual people who make up the acts because some are in more than one Act (1 act can have many members, and each member can be in many acts), Events are the event bookings for Acts for certain dates and avails are when an act has made itself unavailable on certain dates and agents are the people who look after the acts. So I want to run a find by agent and date range to draw up a report to show, grouped by act, wha…

Is there a way to get a count of the number of windows that a certain database has open at any time? Long story short—my users keep on exiting the database by closing windows (using close buttons I've created) and need to log back in, which they get tired of quickly. I tried a script to let them know when they are about to exit the db, and not just a window, and set it to run when the db closes through file options. But when the cancel option is selected to stay in the db, it closes out anyway, I'm guessing because technically the file is closing and nothing can stop it. I'd like to be able get an open window count and test that when they hit my close buttons…

Okay, I'm probably going to get in way over my head here, but I'm trying to design a rather complex report. The report lists health supplements that correspond to a particular regimen. The doctor wants to see the list in a particular format and order. What I'd like to do, for a given item in the final report, is test the db and see if the item (let's use "nettle" as an example) both exists in the db *and* is flagged as "current (Y/N?)". So I'd like the field on the report to do a find for Name=nettle and Current=Y. I'm thinking along these lines: For a given field in the report (i.e., layout), look for db record where Name = [X] and Current? (Y/N) = …

I'm a web designer struggling with learning FM pro 10, and I need to do something in FM Pro that is easy peasy in web design. I want to insert a tiny 'questionmark' button against a field, so that when the cursor rolls over the button, a text window with information pops up. In web design, I would do this with a hidden layer and an 'on mouseover' command to make it visible. Is there an equivalent in Filemaker Pro 10?

Hello All, I need help with a task. I have a database with 30000 records representing members.... I have a field for 'State' and a field for 'Current'. All I want to generate is a report that lists each state and how many current members within each state. So for example the report would be: AL =96 CA=77 and so on ... So far I have used a script to isolate these records and a summary field to list the total within the state but I cannot list more than 1 state at a time.... Do I achieve this through a portal or :? I may be making this harder than it is, but any help you may be able to provide would be greatly appreciated!

Hello, I would like to create a drop down list using 2 different fields from 2 different tables. any way of doing this? PS - I did a search, and found a few links, but nothing about using multiple tables... thanks!

I want to disable the feature of browing the records using the scroll button. Can it be done? :)

Hey all, I am working on a field that I want to hold the active years of a contract (ex. 2008, 2009, 2010,.. etc). I created a repeating field and I am looking to show or hide the repetitions based on weather the previous repetition is full. Is this possible? I have read about using a portal technique to show and hide fields but I having a tough time understanding that method and how I could apply it to this situation. Is there some sort of simple function to modify object properties? Thanks

Hey all, I am looking at creating a list style report that shows the company names of contacts within my database. company name is a field in the contacts table. I only want it to list the company name once, not every occurrence of the company name. I have created a summary field with the options count of the field "ID" (there is always a value if the record exists) when sorted by "Company Name". However this returns just a count of the records it seems (1, 2, 3, 4....etc) it doesn't seem to be counting the amount of records per company name like i thought it would Any help is appreciated. Thanks Looks like I have a report with appropriate …

How can I control close window or the database, that it will ask me if to close are not? or in a layout i can not hit the X button ?

About 2 years ago I started a project in FM 8 to help track inventory and work orders for the IT department. I can say that the solution functions fine and has been for over a year. Now I have better understanding of what makes Filemaker work and I can correct some of those things in my solution that were just lacking before. Another thing I ignored in my original design was a nice looking interface. I have been lucky enough to get slotted with some free time and I want to improve the over look and function but I don't want to spend loads of time creating cool graphics but I still want it to look cool. Does anybody have a simple but cool layout graphics that t…

Hi all, If there a way or a Plug-in that would allow me to drag-and-drop a "PDF" document in a container. I created a DB to generate and keep track of my "Service-Tickets" and use a container to store the ticket that the customer signed. I would like to optimize the process by scanning the ticket to the desktop and then just dropping it on the container. I am using FM 8.0 Thanks Rudy

I'm trying FM 8.5., so I'm new. A question I cannot solve yet. Is it possible to play a Quicktime clip from a container field in full screen with basic FM 8.5 or do I need FM 8.5 Advanced? My problem is that I cannot try Advanced to find out! Thanks for your help. Knut

I have a database listing contact names. I want to create a report that consists of all the cities listed in my database with a summary field displaying the total number of contacts in that city. I do not want to display each individual record in this report, only a list of cities with the corresponding count. I have been able to create a subsummary field with the contact count, but I cannot figure out how to list each city only once in the report. Any help would be appreciated.

Thanks to the kindest of BCooney, I have been working on a simple Debit & credit db for multiple projects. It basically has 3 tables, one that contains a debit amount, a second for the credits and a projects table. I been trying to create a report that summarizes both the credit & debit info for all the projects but without success. My problem is that I have a summary field for all the credits in one table & another summary field in the debits tables, but I try to use these results via a relationship in either table layouts, I don't get the same figures & the calcs are all wrong. Is this normal? Should create a new table for global results? I have tried ge…

Hi all, Wondered if this was possible. I have a report layout that includes a sub-summary part. Within the subsummary is 1 field called "Sector" the body contains details for the records Each record in the database is assigned 1 of 15 sectors. In the sub-summary part definition I have it set to... Sub-summary when sorted by "Sector" And Page break before each occurrence To run the report the script shows all records, sorts by sector, then goes to the report layout and print. All works perfect. Each page fits 10 records on it. Sometimes a sector has less than 10 records. So this page will just print say 3 records then starts a new…

Hello everyone : I want to know if there's any trick to save the Layout format (text format only without images) of Filemaker to text file. I know that we can save the layout format to PDF file, not text file. Is there any workaround for this so I can see the same format on the text file? Thank you.

In previous versions of FileMaker, if I made a textbox that was too large, I would click on the "single space" button and the box would resize to the enclosed text. In 10, that button is gone... so what do I do now? Help?