Layouts

How to make a field linkable? I read this could be done, but I can't manage to find the answer. All I need to do is have the cust_name field jump to another layout. Will the linkable field work in Table View? Will it work with Instant Web Publishing? Thanks everyone.

I work in a lab and am creating a database where we can store all our information. I have two lists on completely separate layouts, but when I press the new or delete button on one list, an entry gets added or deleted on the other list as well. Is there a way to separate them so I can have them run independently? I've named all the parts of the list different names so they aren't calling the same information. However, both add/delete buttons on either page both run the new record/request script. Is there a way to make this script NOT universal so it only adds a new record on the page I'm viewing?

Howdy all! I got a simple question. Can you restart the numbering (@@) for every sub summary? For example: Fruits ( in sub summary part ) 1. Apple 2. Mango 3. Banana Animal ( in sub summary part ) 1. Dog 2. Chicken 3. Horse Every time, it has new sub summary "subtitle", it would restart the number (@@). Is there any option that I should choose? Thank you in advance for comments and suggestions :]

I'm new to Filemaker so bear with me if my question seems simple. Here's the situation: I have a table that is being used to process receipts. Each receipt is recorded on a single record, but may be accounted across multiple accounts. Is there an easy easy way to create a layout or report for each account that will pull the proper information out of each record? For example, let's say I spend $200 on computer supplies from Computers, USA on July 1. Of that $200, $100 went to overhead, $50 went to printing costs and $50 I charged to a project I'm working on. How can I process all of that information on one record, so that I can sort my transactions by da…

Hello I have an image file in a global container field for a FM web-based layout. The problem is that the image displays properly in the Filemaker client, but it does not show at all in the Filemaker web version of the same layout. Any ideas? Joe

I am building a New Hire form. Based on the position of the new hire, I need different fields. Is there a way to make certain form fields active/inactive based on the contents of another field? Thank you.

I'm putting together an alphabetical guest list. Sorting the guests names is easy, but what I'd like to do is setup the report so that it creates a line break at each letter. See below. How can I do this? J Jacobs, John Jenkins, Chuck Jones, Ed K Kelly, Peter Kramer, Ted

I have a Line Items file. Each record is a product. Each product is in a single category. There are 6 categories, 900 products, and 60,000 records. I'm looking to create a report of a found set, sorted by category, showing the number of products in each category, AND sorted by the number of products in each category (in descending order) The report should look something like this: CATEGORY A Product1 1200 Product3 1150 Product2 1100 ... CATEGORY B Product500 1500 Product150 1000 Product200 890 ... CATEGORY C Product750 2000 Product10 1500 Product151 1000 ... Note the…

we are a post production facility and keep a database of every commercial we make. they are stored on dat as well as wavs and high rate mp3s on an attached drive. i'd like to have the database listings (see attached picture) linked to the actual audio files so i can simply click on a title to hear it. the caveat is that i don't want to embed (if that's the right word) the files into the database or it would become unnecessarily large, i simply want to have the title of each commercial pointing to a location on a hard drive. is this possible?

I have my db set up to handle expenses. I have the main table, "Expenses" and a related table, "Expense Items" The Expenses table is the entire invoice/receipt, where as the Expense Items are each individual line item on the invoice/receipt. I thought about using the tab feature to separate my expenses. One tab, credit cards, the other tab Invoices, etc. Question...does that sound like the best set up for what I want? Any suggestions or advice would greatly appreciated. Thank you, Mary

Hi there, Does anybody know how to get rid of the little black indicator strip at the left side of the window when in list view? I don't need it, but as I give my users no access to the status bar on the left, it makes the screen "jump" 2 pixels back and forth when switching from a Search layout to a Results layout. Sure, I could add 2 pixels on the left side in the appropriate layouts, but then I'd have the same problem with those users who are allowed to use the status area... Best regards, Mike

Hi fellow developers. I have created a subsidiary database for testing out my layout and scripts. They have been tested and finalised. The question is: How can I export these layouts and script to my original project which is in a different file? I understand that records can be exported, but is there a way to export the layout and scripts? *Rewriting the script is an unlikely option because the script is extremely long. If anyone may, please advise me; or email me at [email protected] Regards, Ah Lee

This is a stupid question. On my layout, it shows the white behind it as paper size? Although I already have objects off the "white" I cannot move objects off the white. When I try a "circle with a line through it" shows up. Something has changed because it never did this before. What has changed and how to I put it back? Thanks

I use a long calculation field to produce a text report from multiple fields. I use a header and footer on each page, and often the text at the top of the page at a page break is "clipped"--I can see the bottom 1/3 of the first line of the text. There is plenty of space on the first page/layout, but on some subsequent pages, a part is clipped off. A vexing problem--any ideas? This happens in Preview and when printed.

I know this is a longshot, but .. on a lark, I figure lets ask. I have a membership renewal form that is PDF, is there any way I can import this thing as a layout template, so I can use it as a report for printing and screen editing? The source of the form is a Word file. Otherwise it's a long weekend of fooling with layouts.

[color:purple]Issue: I created a DB for 5 different end users and when I opened the DB on their computers the layouts were either too small or too big to fit their screens. I had to individually re-size each one to fit their screen. Does filemaker not automatically adjust the layouts to fit multiple screen sizes? Is there an option I need to configure?

I am trying to create an estimate form that includes multiple fields that will have the same field name, but different values within the same layout. Is there an easy way to do it, or will I have to create a separate field for each section with a unique name for each field?

I know this must be a kinda noob question, but I've searched the knowledge base and can't come up with a solution (which I'm sure is obvious.) I have a DB with three related tables: (1) Parts Bin, (2) Parts Container, (3) Parts. They are all connected by the same key, "Part Type." I want to print a report showing the contents of the bins. Each bin may contain several containers which themselves may contain several parts. The report should be simple-looking as follows: Bin 1 Part Container 1 Part 1 Part 2 Part 3 Part 4 Part Container 2 Part 5 Part 6 Bin 2 Part Container 3 …

I am sure this was addressed before but could not find the thread. I have a columnar report that summarizes invoices by customer ID. I would like to have a GTRR button in the body to take me to the invoice. However, buttons don't work in preview mode. If I swich to browse mode I can't see the records. I have redesigned the report in list view, I can see all the invoices but they are no longer grouped by customer. Basically what I need is a report of invoices grouped customer ID with a gtrr button that takes me to the invoice or some sort of a work around to this issue. Thanks.

I cannot figure out how to display only the date and not the time of a timestamp field on a layout. For example, the timestamp shows up on the layout as: 1/1/2008 12:00 AM And I want it to show up as: 1/1/2008 Does anyone have any tricks up their sleeves?

I have an" Id" field that I must allow the user to enter numbers, letters or both in any combination. I am struggling to find a way that allows me to sort by this field. Any suggestions? Greg

Sorry if this is a duplicate question. Is there an easy way to align objects layout to layout? I basically write down the numbers from object info and re-enter it to make sure it's identical. Is there an way to do this different or automatic. Thanks in advance Dave

Hey there. I have a few search layouts I want users to run in Find Mode only; and for the results I created a few layouts that I don’t want my users to use in Find Mode (instead they should stay with Browse Mode, List View). My question is: Is it possible to create a layout or a privilege set so, that users cannot (accidentally) switch to a "forbidden" mode? Thank you for your input, polarpro

Hi, I have a system which sores books sold and their publisher. A report I need to display will take any subset of "sales" and give the following sub-summaries: a) The total number of sales in the found set for each publisher in the found set The percentage of the "number of sales for each publisher" compared with the total number of sales in the found set (for all publishers). Fairly simple, if you have 1000 records, and two publishers in the found set, with PubA having 200 records and PubB having 800 records then PubA will have 20% and PubB will have 80%. Sub-summary (a) from the above is displaying correctly. However Sub-summary ( is displaying …

I have a summary report which works fine. It shows actions taken, grouped by staff and the specific action, and then it counts the number of actions. Each action has a date and I want to be able to filter the results if they fall between set dates. The dates which form the criteria for the report are entered in a custom dialogue box and become variables in the script. I have used these dates to give either a Yes or No result in a filed in the relevant table, the idea being to run the filter if the field says yes. So far so good, all works, but when I put the filter into the script the report does not run properly. Does anyone have any ideas? Picture of script attached

I have created a report layout. I have one sub-summary part that displays the "one" record in a one to many relationship. The body of the report displays the "many" part of the relationship. Is there a way to have the sub-summary part print again at the start of the new page if there are still records that are carrying over to the next page? Thanks! Patty

Is it possible to highlight the selected row from a list of items (Columnar list layout) without the use of plugins? The little black box to the left of the row just isn't obvious enough. Thanks.

Hello peepz, Can someone tell me why is it that the objects that has been placed on the first tab control shown in the rest of the tab control in my form? Then when I created more objects in the subsequent tab control, the later tab control objects appear on top of the previous tab control objects regardless of which tab control I am on. Regards, Farah K.

Hi peepz, Is there a spread-sheet like function in File Maker? I need it as it would be a better way to present multiple lines of records. Regards, Farah K.

This one has me scratching my head. I'm working on a touch screen, point of sale retail solution for a golf course. I need to generate a report at the end of a period of sales that summarizes the various "products" sold. There are 37 products, each with a PRODUCT NO., PRICE, QTY and DESCRIPTION. These are sub-divided into 8 logical groupings. On any given day there could be from 0 to over 50 units sold for each product number. The printed report summarizes the number of units sold as follows: NO. DESCRIPTION QTY PRICE Registration 001 Resident 2 90.00 002 Senior 0 0.00 003 Stud…

dear all, i have create a check-box set to accept the user's input but when i tried it out, it wouldn't tick. the other fields works just fine. what is the error about? regards, farah k.

Hi guys, I'm working on a database in FMP 9A and i need to call out specific items from a ".doc" file and import it into various fields... for instance... i need to search a document and pick out the word "call" then put in the entire sentence including "call" into a field also i want to put in images from a .doc document into a container field automatically. thanks in advance... Eukanuba

So I'm a complete beginner at FM, but I'm trying to put together a database where my lab can store all of our info. To give you an idea of what I'm trying to do, we have a bunch of DNA sequences that we want to put into a list. I've tried modifying the included 'Research Notes', but the sorting does not work. Can someone explain the code behind the sorting (I'd like to sort by plasmid name, size of the plasmid, and who created the plasmid)? Or at least tell me the code I'd have to input into the script so that when I press the header thing the list would resort itself up or down? My other question is that with the 'Research Notes', you can have a running list (ie…

Hello, I love the way the filemaker template (task Management) inserts new(or old) customers into a customer portal. You click on assign new contact in the task tab and it pops up a list of customers and you either add a new customer or pick from a list of current customers and then it copies it into the portal. (I have attached an image for reference). Yet, I do not know how to replicate it into my own solution, I basically need to know the script to get the button to popup a list view of customers and be able to select a record to use in the portal? Any help would be appreciated. Thanks

I have a calendar layout with a portal that shows all Jobs for a Day. There are multiple Jobs per Order. The portal is sorted by start time, but different Jobs on the same order may start at different times. It would be unusual to have more than 10 different Orders (and 30 Jobs) per day. I'm trying to come up with a way to assign a highlight color to each Job of the same Order. Having the same color to an Order over multiple days would be ideal, maybe required. An Order would rarely have Jobs that cover a span longer than 2 weeks. It's unlikely more than 20 Orders would ever overlap. I imagine it would require a deconstruction of the Order id and a custom…

I have been working on a request to provide a UI that presents information in a grid view for data entry. The database has Jobs/Job Items/Job Item Tasks. The view would ideally show Job Item and Job Item Task info so a user could create and edit records from. In the task records, there are fields that are common (Qty, Round, Description) but have different context based on what other fields are filled out relative to the record. There are filtered portals to get each task record to show up correctly in the layout. I'm using zippscript to execute a script on field entry but also need to execute a script on field exit. The field entry script execution is performe…

First of all, I want to thank everyone on this site. Everyone is so helpful and quick to respond. So I have a database that keeps track of an exchange program of American and French students, that are exchanged between their home universities. I'd like a layout (almost like a student directory printout) that has French students on the left and American students on the right, sorted by which American University they're going to and coming from respectively. It seems impossible because we'd have to create a list layout with different data from two tables. Is this at all possible? Are there any other ideas/solutions? Thanks so much!

I hope I am in the right forum. I updating to FileMaker 8.5 and want to make some changes to my database. My database contains a service call ticket for each and every invoice that is processed through our company. I want to include a few important pieces of info in a record for each invoice and then link a pdf of the invoice to the record. (e.g. while in a record you can click on a link that will open the corresponding invoice so that the user can view the entire invoice, eliminating a trillion file cabinets and saving time). If this is possible where can I find directions on how to do this? I am working without a server right now, but I am not sure if I need one as this…

I'm looking for a way to hide or show radio buttons based on whether two text boxes have data in them or not. So far, I've tried conditional formatting for the buttons, but this only hides the text, while the buttons themselves stay showing. I've also tried the 'trick' with a single row, self-relational portal containing them. The portal does hide and show when I change the value of the text boxes, but the portal only shows the radio option chosen, not the buttons themselves (i.e. when I choose a different radio button, the value in the portal changes). Is there any way to make the buttons completely 'invisible'? I would like to make it so that when neither text…

For my invoice table, I have a Trailing Grand Summary part. All it really lists is the total for the invoice, but it's important that this total be near the bottom of the last page (above the footer). Being a trailing grand summary, it already appears on only the last page as it should, but is there any way to cause it to appear at the bottom, instead of right after the invoice's body? I can expand the height of the summary, but since each invoice is a different length, it sometimes jumps to the top of the next page.

dear peepz, i have to warn you that although i am an experienced programmer and database designer, i am a total newbie when it comes to filemaker. so bear with me. i was wondering if it is possible for filemaker to automatically create a new record in another table when a new entry is made. for example:- table1: pk id_no, name, address, contact_no table2: fk id_no, field1, field2 so when i create a new record in table1, i want filemaker to automatically create a new record in table 2 for me. i have established the relationship between the each table in my database. for the convenience of my users, i have created a form where the subtable/child t…

hello i have a layout [in listview] and want to trigger a script whenever user clicks on the layout [outside the fields]. almost all the fields on the layout are locked and cannot be clicked in/on with the exception of one field which is active for some calculations. this field must keep a focus all the time for the calculations to work. this is the only reason why i want a layout level script to prevent the user from losing the focus on that field and when the user clicks on the layout i reset the focus back to that field. so this way field will never lose the focus [hopefully]. so how can i link a script to the layout for this purpose? thanx in advance. …

I have a database of transactions that contains a 38,000 unique transaction numbers and customer number field. There are dramatically more transactions than customers. I want to generate a report that looks something like this: 1 transactions - 30,000 2 transactions - 5,000 3 transactions - 2,500 4 transactions - 400 5 transactions - 90 7 transactions - 4 11 transactions - 1 Total Transactions - 38,000 The report simply tells me how many repeat customers i have. How do i create a report that looks like this? I've included the data.

I have a boatload of daily transactions that i want to create a report with. Comparing revenue from one year to the next. How do I create a report that shows 2005 sales and 2006 side by side? It would look something like this: DATE - 2005 - 2006 -------------------------------- Jan 1 - $1234 - $3456 Jan 2 - $3456 - $2341 Jan 3 - $567 - $97 Etc. --------------------------------- Jan Totals - $5287 - $5894 I've enclosed some sample data. Thanks in advance for your help! Peter 2005_2006_transactions.txt.zip

Is there any way to zoom to 125%? 100% is too small and 150% is too big. :

I am creating a layout that will eventually be exported as a pdf and emailed, I have not gotten to the difficult parts of this yet, but have designed a basic layout. The problem is that all i have put on the layout so far is some text and a date field, when i switch to preview mode to see what it will look like the page is blank. what did i miss here?

hello... is it possible to have multiple headers on a layout? like one at the top [default] and one on the left/right of the layout with body after it. the reason why i want to know is because i want to hide the status area bar and add my own there in that very same space/place. also layout is a listview that is why i want the top header for logo and headings for the columns. : something like this... =============================================== LOGO / HEADINGS HERE [TOP HEADER] =============================================== LEFT HEADER | BUTTON 001 | BODY OF THE LAYOUT IN LISTVIEW BUTTON 002 | BUTTON 003 | BUTTON 004 | BUTTON 005…

I've decided I want to hide the left status area. I have easily put the total record count and record number on my layout. Even if the records were unsorted, the status bar showed an incremental record number. In other words, what I have right now on my layout is shows "3 of 97" then the next one may be "45 of 97" etc. The status bar whether sorted or not kept this incremental, is there anyway to mimic this?

i have a list based layout which i would really like to turn through 90 degrees ie headings on the left with records in columns left to right any ideas?

I have youmehub 2, a filemaker pro database... I need some help in getting my address and logo properly inserted into the invoice. The "email invoice" button generates a PDF as a mail attachment in Apple mail and sends it to the contact recipient. There is no place to edit an invoice template, like in their version 3 program. I can upload my logo for letterheads, and this gets used for invoices, but nothing else: I just want to get my address on the invoice... stupid stupid developers for not including the company address in their invoice code. Also, my logo is blurry, even though it is a PNG file. It looks good before the import, looks horrible on the invoice. …

We recently had a fellow whom, being very proud of his Irish heritage, wondered why our system always displayed his name in title case, rather than allowing for a second capital letter in his family name. I figured that this was a simple formatting issue, but I can't seem to turn it off. When the field was originally defined it had an auto replace calc on it to set the contents of the field to title case, but that is switched off at this point. The reformatting happens as the name is being keyed; not at commitment. Anyone have any ideas? At this point it just seems bizarre to me.

Hey everyone, what I'm hoping to create is a check box menu for users to select which fields they wish to see, clicking on a button, and then seeing a table view of all the records with only their chosen fields visible. Is there any way to accomplish this? Thanks for your help

hello as the topic says, i want to disable or completely remove/hide the top right corner buttons [clsoe,min,max] of a popup window n limit the user to a button only to close the current active window. the reason to do is that the button is linked to a script for some calculation and i don't want the user to create problem by using the window [x] button to close it and by-passing the script. so how can i accomplish this? thanx in advance for the help.

I've developed a pretty nice database for running my cabinetshop. Most of the components are in place and running well. I'm having problems, however, with one report. I need to develop a document that shows task fields in a column and cabinet identification numbers in a grid. I can generate this report easily in MS Excel but this would be the only component for my cabinetshop that comes from the dark side. Can anybody tell me how to generate a filemaker layout that looks like this, or is there anybody available to hire for this purpose? Thanks for looking at my problem, Jarvis table.jpg.zip

I have a bunch of nav buttons for the user on top (to navigate from one layout to the next) How do I display the button for the layout the user is on? Different color? How do I make it look like it's pressed? What is the best practice? Thanks in advance

Hi Guys I'm fairly new to file maker and would like to make entering data into a description field easier. The area for entering the data is quite small, however, as the data is entered it enlarges the data field. When entering large amount of data I would like the box to open up - eg - when I enter information into an "other" area - a window opens and the data can be entered. In other programs I have used - when the edit box is double clicked - a window opens up which can be sized up as needed. In this way it is clearer to see the information entered. Question - Is there a way to set this up in Filemaker9 pro : Thanks for your assistance. …

Hello, I am trying to print a list of products by category from our inventory list with each category name being printed first then indented underneath the complete list of products in this category. At the end of the product list for a specific category it would print the next one with its complete list of products and so on. I would like the list not to break for a new page when it's reaching the end of a particular category. This obviously involved a loop (for checking all categories one at a time) with a loop inside to check all the products within each category. What is the best way of achieving this goal? Thank you in advance for your help.

I'm wondering if there is a way to make a certain part of a layout not printer, like the header or footer, I know I can do it with fields and objects in the set sliding/printing option, but I want to make it so that my header does not print and for the layout to start printing at the beginning of the body of the layout, thanks - Jeff

I'd like to make a back button which returns the user to the previous layout. Any suggestions on how to make this happen? Thanks.

How can I make a filed change text color based on input? For example, if I type "red", the text "red" turns into red. Thanks

Hello I am working on a contacts database which requires companies to be classified by Category and then sub-category. So for example, emergency services would be sub categorised as fire ,police etc. Basically I would like to limit the choices on the sub-category field according to what is entered in the main category field ie if category emergency services is selected then only choices related to that category are available (by drop down list), in the sub category. If someone could point me in the right direction re scripting I would be very grateful

I am setting up a database for my emails but the junk mail is killing me. I have set up elaborate rules to get rid of the junk but some always comes through. What I am trying to figure out is how to select multiple records at once in a table layout and delete them. I want to be able to check records 1-3, record 6, and reocrds 11-30 for example as they are all junk mail. The problem is that hitting delete for each one is tedious. Does anyone know a way to just click on a grouping of records in the table layout so that they can be deleted together once Im done picking through all the records? I have attached some samples of what im dealing with. Thanks mail.fp7…

I have a portal in a layout. The layout only has one record and I related the table to a global field in the table for the portal so it currently shows all records in that table. What I want it to do is when the layout is opened it will filter the portal's records to be only when the staff field is the same as the logged in account (using a get function). Is there a way to filter the portal records like this or should I give up and put this data in a separate window.

On Filemaker Pro 9 I have set up a field with numeric values as a currency with two decimal places (e.g. £100.00) however, when this information is merged over to a Layout that i have set up, the merge field only appears as 100 without the £ or the decimal places. The two decimal places only appear if they are not zeroes. Please can anyone advise how i can enable this field to merge as it is shown originally? Thanks

Hi, I'm trying to make FileMaker open and span the application screen (window desktop) across two monitors. Is that possible within FM? If not, would I need to use an VB Script or AppleScript triggered by an SendEvent Script within FM? Thanks in advance, Peter

Hi, I apologize for this dumb question. I have a line item db which consists of cust #, inv #, date of inv, item code, item description, amount. There is an invoice layout with a subsummary. If I manually select each inv #, I can print the invoice without issues. My boss wants to enter one invoice date in a find, which would return a large group of records, and print all invoices based on inv #. Currently, all found records (based on the date) print on the invoice, regardless of inv #. Within the found date, how do I tell FM to print all the line items associated with that invoice #, then move on to the next, and the next?

Does any one know why, or how to solve, that when the cursor is in a FM field, that after Dashboard is invoked the user needs to re-click into the very field that the cursor was and remains in, and where the focus still apparently is, in order to continue typing?

Does anyone know how to crack a password for FileMaker 4.0 PC version? We are updating the database and the end user forgot the admin password. Any Ideas? Thanks Rob

I am entering text only on a set of layouts providing "help" information. Some of the text areas automatically return to the next line as I type. Other areas push the right hand margin further to the right if I don't do a manual carriage return. I can't find the setting that makes the return to next line automatic. Thanks in advance for any shared knowledge.

Is there a way to have an IF function return a graphic if the criterion is met? Let's say, IF ( This = That , {graphic} , "" )

Hi, I was wondering if there is a function or script that would automatically resize user input text in a field so that it fits to the box. I have a form that requires user input, as well as the ability to print the form, so if a user inputs a lot of text into one field, I have to have it so that it makes the font smaller to fit in the box. Is this possible? Thanks for your help!

I have a database with pilots names, aircraft flown, hours, etc. I am having a meeting tomorrow with some people in my dept and want to bring a list of this basic information. However, with the layout I made the 5 necessary fields are next to each other across the top of the page, which is what I want, but the layout only prints one record per page. I want to have multiple records per page so that I won't waste a million sheets of paper. How do I make it so that I can use multiple records per page?

hello... as the topic says, i want to open a popup window [though a button in main window] without resizing the main window. as of now, whenever i open the popup window it resizes the main window which i don't want. is there any way to accomplish this? thanx in advance.

How can I get the [color:red]cursor [color:green]position for recent click of the mouse? in X,Y I mean in the Browse Running mode. How can I use a function like [color:red]Get(current_cursor_point_click, x,y) to catch the cursor information? Is that possible?

I want the responses to radio buttons on a layout to read "yes" or "no" but enter "1" or "2", like you can do with an http radio button. Is this possible in FM? Thanks

Hi, Im pretty new to FileMaker and need to import a table from another FM database. I need to print out the table layouts from both FM databases to ensure I import the correct fields. How can I produce a table layout...its easy in MS Access ?

;) I am attempting to create a new table and have it display in a portal. Problem is, the field entry areas do not display when placed into browse mode. I have even attempted to copy an existing portal and have same issue. If I create the table/fields and add them to a layout without a portal, same thing happens. When I look at the relationships graph, table looks like the rest of those that do work, but it doesn't display. I am probably not understanding some small item, but it's become really frustrating. Help is appreciated! :P

Has anyone run across the issue of invisible buttons behaving awkwardly in IWP on Internet Explorer? Our solution has a series of radio buttons that, when selected, perform a script. The scripts are triggered by invisible buttons placed over the radio selections, unfortunately in IWP on I.E. 6.0 (XPsp2) the buttons are to the far left and far right of the scripted buttons and are not over the intended area, i.e., directly over the radio button itself!?! It's as if the radio buttons are in the foreground but they're not. We're running FM Server Advanced 9 on Mac OSX 10.5.1 and our clients are accessing the database using IWP via I.E. Anyone else experienced …

The icons under "Functions" work on the Mac. However they are blurred and have a blurred white border around them in Instant Web Publishing. The icons under "Buttons" work on both. Am I doing something wrong? Are their any other icon packages that anyone can recommend?

When I try to create a tab using Filemaker Pro 8.0v2 on my Mac (OS version 10.4.11), it displays correctly in "edit" mode. But when I enter data-entry mode, FM "sees through" the tab - and displays all fields (from all the tabs) stacked on top of one another. Clicking the other tabs, I see the same thing - all fields stacked. Worth noting: one of the tabs contains a large table. The *first* time I created the tabs, I dragged all the fields into the proper place and went into data-entry mode. It worked properly. I then went back into edit mode and moved the tab window slightly, changed the color of the two tabs to make the display more aesthetic. *Then* it stopped wo…

I am trying to create a report that shows line items from numerous tables. I have a layout with portals for each table showing the records I want to display, however I cannot get the portals to shrink down when displaying the layout in Preview mode. This leaves me with large blank spaces on my report. Also, is there a way to make graphic objects such as lines used above "Total" fields, to not print if the "Total" field is empty. Thank you

hi.. i have two layouts(reports) than use the same fields but differen order.... one report use first in subsummary "customer" and another subsummary "product".... and another layout the same but inverse ... when i watch the report i have to go to order registry and change the order .. if i go to the other registry i have to do the same?... is there some way to block the order for each layout? is like they were conect...... thanks for your help

I have a solution converted from FM 5.5 to FM8. I am working on tweaking all scripts, etc. The solution has a dozen files. Like in FM 5.5, navigation is from file to file via buttons that call scripts from another file. The issue is that when I move from one file to another via scripts (it looks like a typical tabbed folder system), I briefly see a "ghost" of the files. Example - I am in one file and click a tab to move to another. While it changes, I see a flash of the other files behind the current window. The window is maximized, but the ones I see are shrunk - as if I had resized them. They appear to be where they were many sessions ago (I ha…

I have a very crowded layout with several portals in full screen mode. Is there any way to have another table open as a smaller 'pop-up'window rather than adding another portal to the layout, without the main window dropping out of full screen?

Hello All, I'm fairly new to FM. Have a question: Is there any way to validate a currency field so if the user makes a mistake and types two decimals fields i.e., one for the comma and one for the cents...have some error that just says "invalid format" or something? Also, same thing with commas. The field is already a currency field with two commas..so some extra validation is what I'm looking for. Thanks

Greetings! I am trying to figure out how to get a field to 'auto-commit' (automatically move to the next field) without having to hit the TAB/ENTER/RETURN keys. I want my users to be able to enter a single digit in a field and have it auto move to the next field. Thank you ;)

I have a list of 99 records, and they all have different Dates for the next 3 weeks. What i want to create is a report that will show me this week in 1 page, next week in another page, and the 3rd week in the last page. I have the following Fields. Customer Item Number Qty Print Date I want to be able to create this report so i can see what customers are printing this week, and so on. This is driving me nuts. Thanks in advance.

I have a script that waits for user input, and the user can either click a button, or press the enter key on the number pad to resume the script. Is there any simple way to let them press either enter key to resume the script? Also, keep in mind that i'm using windows, cause i'll bet it's different on a mac.

I have a field for an insurance number that contain up to eleven digits, but may be less. I would like create 11 little boxes in the data entry layout so that the person entering data can see that they have entered the correct amount of digits. Something like this, except 11 boxes: (sorry my drawing will not "cut and paste") (for now lets assume I do not want to use the “define database” field validation options) Also each time a digit is entered the cursor moves to the next box. I have tried using the drawing tools and the field control setup but I cannot seem to achieve a neat result. Any ideas please?

Is there a way to force a sub-summary part to display at the top of each page if sorted data spans more that one page? Ex: I have a list of sales, sorted by employee one employee has 100 sales I want their name at the top of each of page(kind of like "NAME cont"). I don't want a page break after each employee because there are a lot of employees with 1 or less sales.

Hi, all. I'm trying to draw a graphical grid over a portal. For some reason, when I do this some of my vertical grid lines disappear when I switch to browse mode. 'Very annoying. Please give me some helpful advice if you can. Thank you.

Hi everyone, A couple of questions. First of all, is there any way to edit a layout object's attributes (eg. width or distance from left of screen) using a calculation/script? Second, is there anyway to 'freeze' objects, as you can do to cells in microsoft excel? I need fields on the leftmost part of the screen to scroll when the screen scrolls. (eg. i want fields on the left of the screen to do what fields in a header in list view do). Thanks in advance, Chris

Anyone know why fonts that normally have additional marks in Thai in MS Word for instance don't have them in a FileMaker field? Thanks, Lee

I have a State layout form which displays State records. I would like to create a 2nd form layout that displays records for Cities. The Cities need to display for the current State record that is displayed on the State layout form. Any help will be appreciated.

Ok on my database I made 10 records. I added a button for deleting the current record only. If I delete record 10 then 9 and then 8, it deletes ALL the records! If I right click and delete doing the same process, the same thing happens. Any advice on how to make it only delete one at a time??

Hello there. I was wondering how I can create a floating control box that will allow a user to navigate and execute scripts on the layout beneath the float. So far I've got a button called "Show Controls" that performs the following script: Adjust Window [Resize to Fit] New Window [Name: "Controls"; Height: 396; Width: 408; Top: 150; Left: 300] Set Zoom Level [150%] Show/Hide Status Area [Hide] Got to Layout ["ControlBox" (Patient_Information)] The control box looks real snazzy! The trouble is that the scripts associated with the buttons I've put in the control box don't operate on the layout below. Thanks for any help you can offer.

hi .... can i print mailing labels ordered horizontal and not vertical? i have a field with customers name and i want to be printed this way: 1 2 3 4 5 6 7 8 9 the standard template print like this 1 4 7 2 5 8 3 6 9 thanks for your help

I am new to this site and asking for help on line, please excuse any errors I might make. Is there a way to make sure that a field has data in it before leaving that field by tabbing, changing layouts, clicking, quiting, or anything else? In this case I want them to put in a quantity before doing anything else. I have tried the valadition "not empty" and some "If" calculations, nothing I have tried is totally fool proof. Thank you for any advice.

Can I change the layout type after it's already created? From standard to list or table view? Thanks

I have been using a dropdown list. All of a sudden it stopped dropping down. I went in to check it, and the message "This value list will not work because the field "ID code" cannot be indexed". What could change to create the inability to be indexed when it was before. Thanks The Tramp