Layouts

I'm and advanced beginner with Filemaker. I'm working with a database that's on a server, and am having a problem with some of my checkbox sets. There are a few, but I'll start with the simplest. I have a checkbox for whether or not a record is "active". Then I have a calculation field, whose value is 1 if the checkbox is checked, and zero if not, called "cue count active calc". Then I have a summary field for a total of that field. Sometimes the summary field displays a different total than what I know to be correct. There are records with checkboxes that visually appear to be checked, but they are not making it into the total. I then go through all of my records, u…

Hello all, I am fairly new to filemaker and i am creating a database to be used on tablet pc's. i would like to make it so when i click a field a new window pops up for data entry with a onscreen keyboard. Is this possible? Thnaks Conner

Hi all I would like to create a layout where a field is only editable if a condition is met. The scenerio is: I have an inventory database. A stock item is of one of two types, a 'one-off' or a an item that many copies can be ordered. I would like to create an 'Order' layout that allows me to enter a purchase quantity if an item is not a 'one-off' or automatically sets the quantity as 1 if it is a 'one-off' and prevents the field from being editable. I'm sure these conditions need to be set in 'manage database'. How do I go about this? It would be nice to block data entry into the quantity field on the layout by means of ghosting or something similar. …

I would like to add a grey background without printing it. I can easily add a background color by choosing a fill color in the part...but this prints. I do not want to waste toner and a white background is usually better for prints. I am using a simple technique of creating a square, filling it with grey and making the object non-printing. I set the anchors to fill the screen no matter the zoom factor or screen size. This works but is much to tedious when dealing with many and complex layouts. Any assistance would be appreciated. Thank you.

I need your help. Recently I took on the task of selling over 100 items of high end photographic equipment for a widow of a professional photographer. I am striving to make this as professional an operation as possible. I decided to dive into databases to manage and hopefully automate this project. The end goal is to have a portion of my website dedicated to this sale. The inventory should be viewable but not editable online, and I'd like to have an order form that can be submitted via email / automatically updated in the database. I don't know how much of this is possible or feasible with my entry level knowledge of this software. Thanks for staying with me th…

I have created a report that sorts based on a field called “Transmittal number.” The report page breaks before each occurrence (usually 1-3 pages) and works great except that the records are numbered and I would like the record number to reset to 1 with each new transmittal number. Is this possible? Thanks in advance

Very simple; I want to deny access to part of a layout unless a specific checkbox set is marked as "Yes". How would I go about doing this?

Had what I thought was a fairly simply setup to create: in our student database, I need to build a report to show the number of households within each zip code. So, I merrily create: * a summary field holding the COUNT of field Zip (zSum_HouseholdsByZip) * a layout based on the Household table (actually, a particular instance, holding the primary households) * a subsummary part containing the summary field (and the Zip field, as an identifier) with Zip as the break field * a couple fields in the body for filtering Then I go to find mode, find our enrolled students, sort by Zip, and switch to Preview mode. Lo and behold, all the records are showing up …

I am trying to convert a List View Layout into a Table View. Love the functionality of the Table View. Users love. However, I can't get the Column Names set. They are using the Database Field Names, which aren't very user friendly. In the Inspector, I found an entry, under Positions, for Name. However, the Table doesn't use this for the Column Name. Great functionality, but I don't want to rename the Database Fields. Any suggestions?

I am back again but not sure where to post this so i chose here since i had such great success with the other. ------ Any ways i am creating a database that will help manage animals. I currently have just one layout but need multiple layouts. I want my main lay out to have a multi page feel. For example - On the main page i want the information on the animal then another layout called Husbandry which will hold the information on feeding and such. Next i want another layout for medical, and breeding, and so on. I have tried creating another table to keep things clean but i cannot seem to link info from one table to another. Or should i ju…

I want to reposition the layout part handle so it is vertical rather than horizontal (so that it does not cover elements in the header that I want to work with). I know it can be done (I have done it before myself!) but I have lost/forgotten the way to do it. It is obviously a simple matter - if not I would have made a note of how to do it when I did it before (yes, silly me...). Help please..? Regards, Rramjet.

Is there a way to maintain the cursor position in a field when click on a portal button? The only way I could think of is to set a OnObjectExit script trigger to remember the current position.

Hello, I created a one page report that I need to drop into a Power Point presentation. The problem is the image is fuzzy in preview mode and when I export to PDF. It isn't a complicated image, just text and number fields. Is there any way that I can improve FM's resolution? Any ideas are appreciated. Thanks

My friend an I are working on the same database on different computers. I created the file on my Mac, and he has been adding data on his PC. Everything looks fine when he opens the file on his computer, except that many of the fields don't fit the last few items of their corresponding value lists. I don't know if this is because the field itself shrank, or because the text size increased somehow. Does anybody have any ideas/advice? This is a problem that is fixable by manually increasing the size of each affected field on his computer, but doing this every time I update the template is getting very frustrating. Thanks, Andrew PS: Everything is fin…

Hi, I am wanting to show an image on the browse mode based on some sort of selection from a field box. Example: radio button male , female, unknown if the user selects male i want it to show a male symbol on the browse view mode. I have attached a couple of images to help better understand what i want to accomplish.

I have a value list based on a related field, does anyone know of a way to add additional values to the value list that do not appear in the related field? I tried creating a new calc field using the ValueListItems function and adding additional items to it but in order for it to work properly I cannot store the calculation so I cannot base a value list on the field.

Is it possible to put the value of a script variable onto a layout with something along the lines of the <> function?

Hello, i want to know how to make a database with different indepent layouts and each layout has own different records,... i just got the filemaker 11 version and saw the starter solution the invoice one , it has 3 different layouts on the same file but each layout has different records , can you tell me how?

I need to but all I can rotate are the fields. In short I'm using a runtime on an ultra mobile pc (about 5" x 3" screen) and want to rotate the entire layout a 1/4 turn counter clockwise. The fields rotate but not the portals.... any ideas? Thanks!!

You guys might think I'm dumb, and you'll probably be right. It feels like I'm missing something obvious here. On one particular layout, I have a subsummary part that shows up when sorted by clients. This layout is used for shipping. It would be tremendously helpful if I could calculate how many separate subsummaries are present in a given found set, so the user could pull down as many boxes as there are clients in a given shipping list. This seems like it should be a simple thing to do but for the life of me I can't figure it out. Do I use a trailing grand summary? How do I configure this subsummary summary field? If somebody can point me in the right…

Here's what I hope is a simple one. I want to display field data from a parent record in a layout so that the user can see this information when entering data in the child. The parent information is prose, and the length of it will be highly variable. I *don't* want the user to be editing this parent information while in the child layout. I'd like to just put a textbox there and make it non-enterable so that it's clear its just for display . . . but when I do so, the *scrollbar* is rendered inoperable. Dang. My other option seems to be displaying the information with a Merge Field -- but then the variable length of the prose information will make it i…

Is it possible to have some sort of list (value list-drop down field, portal, etc) that could show account names? I am creating a run time solution with the option to add an account & delete an account. I would like the user to see what accounts are currently active. Does anyone know if this is possible, and if so, how to achieve this? Thanks

Hi, I'm trying to change the colour of text between two pre-defined tags. The tags are always the same - but the number of characters between will vary example 1: Some text which will be red and revert to master style. display: Some text which [color:red]will be red and revert to master style. example 2: Some other text change the colour and revert to master style. display: Some other text [color:red]change the colour and revert to master style. I was wondering how I count the characters and apply the correct text styling. I've searched but can't seem to crack this problem. I hope you can help, thanks David

HI all, Does anyone know of a good site to download free database images? Any help will be very much appreciated! Amram Chayim Eirinberg

Why do thin field boundaries appear when you enter any field for entry? Also fields with a transparent fill become filled with white when you enter any field. Here's what my portal looks like when nothing is selected: And here's what it looks like when I click into a cell to enter text: Please note the fine borders around all fields and the white fill that comes into the fields that should have a transparent background. Thanks.

I have a set of vertical lines arranged horizontally (think: fenceposts). I want to align their tops with the same imaginary horizontal line. I select them all, and click Align Top Edges, thinking this will ... well, align the tops of these lines. Instead, I am seeing them move downward a few pixels... and when I click ALign Top Edges again, they again move downward! As if I were repeatedly hitting the down-arrow key. It's like Birnam Wood creeping toward Dunsinane. Is this actually behaving as it should??

Hi All, my first post! I've just designed a simple layout which features a header (which is an image imported into a container field) and a footer which is a pasted image. The preview shows just one page on an A4 sheet of paper, yet when I do print I get two pages, the second of which is a page with just the header. What do I need to adjust to remove this second page? Thanks,

Hi! I have a list in my orders' layout and arised a design problem: I need Trailing Grand Totals at the bottom of the page but FM put it directly at the end of the list. How can I define TGT to be always at the end of the page? When list is long last page contains just 1-2 lines somtimes. And the grand totals seems like lines. Customers can't see the total amount and call me at phone... Untitled.pdf

Hi, I have a layout to let users input data. At the top of the layout there are some checkboxes. I want to hide or show some fields based on the boxes users checked so the layout will not get too long. I am still using FM 9. Is there anyway I can do that? If not, can it happen with FM 11? Thank you. Please help!

I have a multi-page report with page numbers. Is it possible to start the page numbering at 2 instead of 1? A cover page created elsewhere is always used & is officially page 1. Thanks!

Using v11, in a new layout I create a rectangle that's 300 px wide and a line of the same length. Zooming in reveals that the line is one 'pixel' longer than the rectangle. In Browse Mode "adjusting to fit" the window results in the line extending past the rectangle leaving the background color showing next to the rectangle. Shorten the line to 299 and they look almost the same, but "adjusting to fit" still shows the background color to the right of the rectangle.The line must be shortened to 298 px for correct rendering. I noticed similar behavior in v10 when converting my pre-7 files, so I made all the lines one pixel short as a fix. Now, to eliminate the love…

how we use username and password protected to filamaker database and give specific role to each user.

Hi, in my solution I have a layout with a portal on it. There is a delete button for each record in the portal (the last column). Now I would like to show this button dynamically because some of the records can't be deleted. So it useless to show the delete button. I thought to use a global field and fill it with the button if delete is possible and leave it empty if not. But I'm not sure how to aacomplish that. Could someone help me? Thx by ChiSao

Hi, I'm new. A few years ago I created a layout that tracks jobs coming into our business. I did not create a customers table (did I mention I'm new at this?) Each job is created as a new record. The problem is, we have many repeat customers. Now I have thousands of records, many are from the same customers. When I export my data to Excel, I see I have many duplicate customer fields. Is there a way to get a list of distinct customer names and other related fields such as address, phone, email, etc.?

Hi all A very newbie question here. I'm trying to create an invoice using a demo file as a template which can be found at this link: http://fmforums.com/forum/showpost.php?post/309136/ I have setup tables similar to those in the demo file apart from naming convention. I have created a value list for contacts which shows both contact and contact id by using the second field option. When I add fields to my layout in layout mode I get little magnifying glass icons next to the added fields. Some are green, some are yellow. I'm assuming the fields that are green are for fields from the table that the layout is based on and yellow are from other tables…

Dear Forum - Our users are running FileMaker 9 on Windows XP and have their PCs set for various countries. FileMaker is great about displaying dates in the correct format according to the PC settings, but not currencies. Is there some way to display a number field in US currency format (1,000.00) to some users and EU currency format (1.000,00) to others in an elegant manner? Here are things I have already tried / contemplated: - I know that if I leave a number field in "General Format", then the PC country settings will be considered for a decimal point, if entered, but then the number does not always show the decimal nor a thousands separator and doe…

how can i use flash file in filemaker?

Hello, im making a purchase order database, everything was ok until i tried to make the reports. when i try to make the purchase order report i put the portal rows on the body part and it shows me only the first record not all the items of the order. ' do i am making something wrong ? some advises? thank you very much for your help Maurice

Greetings all, I'm taking the first step in admitting I have a problem. I created a file navigation box and want to place it on each layout so those who like to "see and click" can navigate easily. I place this grouped box just off the page margin on the right side of the layout. I've tried locking it in place, but it slides to the right when I exit edit mode. Any tips/tricks/suggestions are appreciated. Jamie Avatar Energy

In FMP 11, I want to make a field which affects the behaviour of another. Specifically, I have a table for income tax which includes a calculation field which automatically calculates the amount of GST (sales tax). So total in field B is 10% of field A. However, some income does not attract sales tax. I have made a field C with a drop down menu that will allow a choice of type of income - taxable or not. How can I set the database up so that choosing Taxable results in the normal calculation; and choosing Not Taxed results in a null value? I have tried Case and Validate but not getting anywhere. Thanks for your help - it's much appreciated.

Hi. Just found this site! Here we go with my first post. We've recently upgraded from fmp 6 to 10. In our reports we have a 'matrix' made up of four fields with 25 repetitions. Some reports have a few entries in these fields, some have the full 25, some may have none. This is where the problems start!! These fields have borders and are set to slide up when they are blank. In the past (on fmp 6) this worked fine. Now though, if these fields are all blank, we still get the borders showing for the first row (repetition 1). Is there any way we can prevent this happening? I've (hopefully) attached a screenshot of how it is displaying these bo…

I am working on a report that has three subsummary parts. When I run the report it comes out fine except that I would like it to not brek up a section at the end of a page. If it doesn't fit I would like that section to go to the next page. Every part has allow part to break across boundries unchecked. It doesn't seem to change when I do check any of them. Any help greatly appreciated.

I know but.... I have read the manual (RTFM), Ive used FM for over 15 years, I searched the web and the forums. And still - How do I change the LAYOUT ORDER in FM 11?: Anyone?? It doesnt seem to be in my menu... :

I'm currently encountering a weird problem that I've never noticed before. I'm opening a database from our FMSA 8 server with 9 Advanced client and adding layout graphics to it. They work fine on my machine, but when viewed on another client, I get a square box with the text "The file cannot", instead of the image. The rest is cut off, but I'm presuming the rest says "be found". It's clear that the graphic is being referenced to its location on my computer, instead of being saved in the layout, but this has always worked before, so I'm at a loss to explain it, or more importantly, fix it. Any ideas? Kev

Hello hopefully somebody will be able to help me with this problem. What I need is as follows, I have created a holiday database for staff to login online and put down the holidays they want. Now when their manager logs in online they get a seperate menu screen. How do I get this screen to show the manager how many holidays they have to authorise. I know its something to do with found count but I cant seem to get it to work Please Please Please can someone help as this is the only part that I cant get to work and is driving me insane Thanks in advance

Hi there, I'm producing a solution for a service based business. When they quote/invoice, there are often several discrete items as part of the same service. To aid clarity, they would like to add descriptive text to each group of items (this is standard, but changes for each service they provide). For example: Descriptive text for service 1 Item 1 service 1 12m £5 Item 2 service 1 5m £4 Descriptive text for service 2 Item 3 service 2 4m £8 Is there a way to achieve this using sub summaries? Since the descriptive text is static and I don't require intermediate totals, ideally I would like to a…

I'm trying to change the sort order for a report. The report shows people working different shifts of the day and is based on a join table called 'shift_positions'. This table has a field named shift_type which would be one of day, night, or detail. I have a sub-summary based on this field and the report works fine. However, it sorts alphabetically - day, detail, night - and I'd like it to be day, night, detail. How would I go about this? TIA

Experienced Access Convert due to current employer purchasing FM, needing help with what is a 30sec task in Access, but has so far consumed three hours of my life in FM. The DB I am creating is for Inventory Control. One of the aspects I am having trouble with is Storage Areas and Locations. I have in my item table ´inventory_items´ a field called ´Storage Area´ which is populated with a drop down, that pulls values from another table called ´SA´, values XYZ. I have another field ´Storage Location´, which is also a drop down, but needs to populate with values ABC if X is chosen in the previous drop down - and DEF if Y etc. My question is how the heck do I do it?

I've been a dormant FM developer, and am just having occasion to examine the Layout Script Triggers in FM10, and I am a little confused (this is a normal state for me). First off, I do not understand why there is a trigger for Layout Load, but not one for Layout Close? Next, I am not sure when the OnRecordCommit trigger actually runs. Here is the situation: a client wants to process credit card transactions, and a fellow developer has a technique that allows all sensitive information to be pushed up to the card processor (so my app doesn't have to have the security headache!). However, I will still need to offer a layout in which the user enters the card information …

I have a value list that is populated based on two fields, one is the customer code and the other is the customer name. The problem is some customer codes are 4 numbers, some are 4 then a hyphen then 2 numbers. This creates a messy looking list: For example: 1234-10 St Mary's Hospital 5555 St Thomas 8765-22 St Victory Hospital 2233 Walter Reed My value list is based on two fields from the customer table. I would like to see the columns even so whether the customer code is 4 digits or seven it takes up the same amount of room.What the quickest and easiest way to achieve this result. Do I have to create a calculation field that masks the client code, then cho…

I rearranged View>View as Table by shrinking and moving columns by dragging them all over with my mouse. I would now like to restore the View to Table to its original form without going through trying to re-drag and resize to original positions. Is there any easy way to do this?

I have searched for this here and on the internet, and still don't find the solution. I had this working in Microsoft Access for years, now i need it in Filemaker instead. I want a picture to show [perhaps in a Container field?] based on a field in the record [combination of 2 fields: /dir_field/images/filename_field.jpg] and i want this done at the record's "onLoad" trigger, when the record gets shown. (I don't want to store the picture, nor do i want to import it, there are 8,000 pictures to do that for, instead i want the picture association to be automatic.) In MsAccess I had a "picture field" which was a blank field initially, but upon loading the record …

Hello all -- Is there an easy way to close all Windows except the current window without closing the whole file? Thanks

For some time now I've been using a tip from Ray Cologon to highlight rows in list view using a web viewer. Now I find that when using the trial version of FMP11 this no longer works. I've attached Ray C's original file here and find that it's OK in FMP10, but not in FMP11. Any thoughts anyone? RowHighlightv8.5.zip

Is there a way to limit the input of data into a text field per the width of the field itself? I can't use a "hard" character count in the field set-up because the text font is proportional; I don't want excess text to scroll to the next line. Any ideas? TIA for your help! Rich

I'm working on a file to be used with FMTouch on an iTouch. Since this app doesn't effectively let you choose a year when entering a date field that's set up as a calendar, I need to set it up as a regular text edit field. This is all fine so far, but I also need to format the date as DD/MM/YYYY. I can do this manually under Format-->Date, but the program still only allows me to enter the date as MM/DD/YY. If I try to put in 23/12/2003, for example, I get an error message. If I enter 12/23/2003, it accepts and displays it as 23/12/2003. This would still be OK, but I want to avoid confusion about entering values like 4/3/2003. If someone mistakenly enters…

I've created a database but after trying so many different ways to do the same with relational databases have ended up with 1000 fields!!! I know!! So .. what is the maximum amount of fields I can use? and if I do have loads will it consideralbly effect the speed etc of the database? thanks all.

Hello, I think im having a brain freeze on this problem. I am building a solution which will be used as CRM/Quotation/SalesOrder/Invoice etc... (well there the only bits involved for this problem) but obviously once one bit is working the others is just variations. I have got the Layouts & Scripts/Tables sorted & working how i want.. however there is a need to print a Quotation (and sales order and ultimately invoice) out with the bill to address & the Site Address & then the details of the Quote & any parts to be used. Just to give you the information you may need to understand the problem im having. Tables "CID" (cid is …

Hello, I have a FM database on a MacOS 10.4.11 served with Fm Server 8.0v4. The clients are also on MacOS 10.4.11 but use FM Pro 8.5. The problem is if I set the Page Setup for a layout (Paper Size, Orientation) it isn't saved with the layout. Each time I reconnect to the database and print the layout, I must change the Page Setup. Is there a solution to this problem? How do you save this information in a client/server environment? Thanks for the help. Andrew

The new features of table view are a nice idea, but some of it seems a bit quirky. I have a layout with many fields and when I flip to table view not all of them show up either on screen or in the modify list. In case anybody else has stumbled on this I found a work around, which is to add a new field (or several) in table view and then trash them in the modify window. When they're deleted the original locked fields that were missing suddenly appear to take their place.

I am making a database for work and trying to exclude records from a report. I used the starter database “Inventory”. I have a field named “In_Out” and when a card is put into inventory, this field is set with the number “1”. And when it is taking out of inventory this field is set with the number “3”. I use this field to filter the portals Cards In and Cards Out. This works just fine. My problem is when running the report “ View Inventory Report” I have not been able to exclude the cards that have been taken out of inventory. Any suggestions that would point in the right direction would be greatly appreciated. I have have attached the file. Inventory.zip

Hello all, Greetings from Seoul, Korea. I'm trying to figure out how I can add an image file of my signature to the signature box in a letter layout with merged fields. What I've done: 1. Insert the text with merged fields throughout 2. Added the image of my signature as a .jpg in the signature box. I did this by going into the Insert menu and selecting 'picture.' *Since the length of the letter varies according to the information in the merged fields, it often ends up under or over the text. Is there a way to format the image so that its placement easily adjusts according to each letter without losing uniformity in line breaks and such. …

I've seen that Filemaker 10 has a sorting functionality for developers when defining tables and fields; it's a column with a double head arrow which can be used to do arbitrary sorting by drag n' dropping. Is this functionality available for developers to be used in own apps? I have a layout based on table view and i need to make arbitrary sorting of records available to users. The option i'm using now is a numeric field for sorting, users put numbers to sort records as they want and Filemaker sorts according to this, but it's a bit difficult if table has more than 35-40 records.

Hi all, I sure this will be a simple solution but I just can't figure-out what how to do it. I have two tables; Table A Client ID Client Name Complain Solution Table B Client ID Invoice No Invoice Amount Invoice Amount Total (Summary Field) I also have a layout that shows field from from Table A and Table B. I need to show the "Invoice Amount Total" for a given Found Set without sorting on a Header or Sub-summary part but in Browse Mode. Any help is GREATLY appreciated Thanks RudyM

Is it really worth upgrading to FMP11? The answer is YES - not for the new features that come with FMP11 but for this totally awesome undocumented improvement. I haven't read through all of the FMP11 documentation but I think that what I will discuss below has not been documented - or maybe it has? Please let me know if it's the case and where I can find information about this... The greatest thing about FMP11 is what I call "layout and field immobility". With previous versions of FMP (including FMP 10), fields that don't have a matching background or overlapping fields flash when navigating from record to record resulting in a very poor experience for the end u…

I would think this would be easy to achieve, but I can't figure it out and have searched all over to no avail. I want a sub-summary to print at the top of every page with a maximum of 6 body records printed. Here are some examples of how this should look for various numbers of records within the sub-summary grouping. In this example, there are 18 records in the found set, the sort field breaks them up into 3 groups (3 records, 6 records, 9 records). I want that displayed as follows: Page 1: Sub-summary group 1 record 1 record 2 record 3 Page 2: Sub-summary group 2 record 1 record 2 record 3 record 4…

I have a layout which on layout load performs a few finds so that only certain records are showing. This layout pulls fields from other tables. It is sorted by month and contains a sub-summary leading part sorted by Header::cMonth, a sub-summary leading part sorted by Client_Header::ClientID, and a sub-summary trailing part sorted by Header::cMonth. The layout shows a few clients (that are similar) for every month with their projected, remaining, and spent budgets. I need to somehow get a total of these numbers. I tried putting some summary fields in the last sub-summary trailing part that is sorted by Header::cMonth. The problem is, on one certain month (the busie…

This seems so simple that I hesitated to post it until I had thrashed around with it for a couple of days unsuccessfully. Any help would be much appreciated. I am making a task list viewer that by default lists all tasks for a group of users. I would like to show all the users and the number of tasks they have in a subsummary report at the top of the page, followed by a list of all of the tasks sorted by user: User 1 - 2 tasks User 2 - 1 task User 3 - 9 tasks --Task A User 1 --Task B User 1 --Task C User 2 --Task D User 3 I am getting stuck, however. If I use the subsummary report and place the task list in the bo…

I have an idea that I try to make in my database but cannot get it to work. I am still a beginner in Filemaker 9 and did study video tutorials to understand things better. Here is what I try to make: I need a drop down menu that contains 10 choices to choose from. Next to this I have 10 times 12 text boxes in which I already have my text ready to be used. So every drop down menu choice is connected to 12 text boxes with predefined text description. Lastly, I need to have 12 empty text boxes in which those 12 text descriptions need to appear after making a choice from the drop down menu. Now what I want is whenever I choose one of the 10 choices from my drop down menu…

I've two tables related by a room number. one called "room" and the other "equipment in room". I want a report to list all the rooms with all equipment listed under a "room number" sub-summary. Not all rooms have equipment. If I make the layout show records from "room layout" I only get one piece of equipment listed and if I make the layout "equipment" I dont see the rooms with no equipment. Any thoughts? thanks

"PK_Customer_ID" is defined to contain unique values only. Allow duplicate value? I click on NEW CONTACT in my custom solution and it creates a unique customer ID. Then when I click over to another tab such as Purchase Order or Work Order, and arrow down to that Contact I get the message above. Please help. Amy S

Hi All, I am using ESS and hooked up to ms sql db. I have a column in the db of type BIT. with possible values of zero or one. This is the typical way of storing boolean/true false values.. What is the best way to handle this in FM? I notice with radio buttons the labels and values are not seperate.. And also i can't make a single checkbox.. checked meaning true and unchecked meaning false. Am i missing something? how can i handle this? thanks!

I'm working on creating an interface simply to list all records in my database. For my layout I've created a one line body with a header and a footer that looks great in layout mode. When I display in browse mode the header looks great and the footer looks great. The body starts out right under the header and looks wonderful at first but then, after displaying all the records in the database, there's a huge space between the displayed records and the footer. It's as if there's a set display size (as if this is meant to be a report rather than a screen) that is expected and I don't have enough lines to fill it so the display just shows empty background. I've checked all my…

Hi All, I need someone to push me in the right direction here. I have a number of Products (that can change) and a number of Discounts (that can change) and I need to create a Cross Tab report that displays each Product for each Discount, thus showing the product price after the discount. I tried with Calculated fields, Relationships, Portals, but nothing seems to work. Please give me a hint if you can. I am attaching a small sample database and a picture of what I am trying to accomplish. Thanks. Cross_Tab.fp7.zip

I have a field for number of pupils. How can I prevent a user from entering in something like 275-300? All I need is the whole number or I cannot search on that field. Thanks.

Anyone know what happens in this scenario? You're running a script and you freeze the current window. The script launches a new window, does some stuff and closes that window. Now you're back to the original window. Is that original window still frozen or do you have to reissue another freeze window step? Does the act of opening a new window hork your frozen status on the first window?

I'm using FM Advanced 8.0v3 on Windows 7 64 bit. Whenever I am working with a layout the screen goes solid black when I drag an object. It makes it pretty hard to work with, as I just have to imagine I've got the object where I want it, then nudge again, then again, then again..... It doesn't do it if I just move using the arrow keys, but that's pretty slow too. Any ideas?

FMP Advanced 8, OS 0.6.2. I have a database with a pull down menu (3 options) to change the sender when printing a envelope. Now instead of the company name typed out, I want to use the logo on one occasion and typed text on both other occasions. Does anybody know how to do this in the pull-down menu? or have an other way of doing this? Thanks.

I have 2 tables one containing stock items and one containing Stock Requirements. They have the following fields:- STOCK Stock_code (number auto enter serial) Qty_in_stock (number) Qty_on_order (number) Cost Price (number) Stock Required Part_no (text) related to STOCK STOCK CODE Count_of_part (Summary = count of Part_no) Qty_Required (calculation Case(GetSummary ( CountOfPart ;Part_no )-Stock::Qty In Stock-Stock::Qty On Order â�¥ 0;GetSummary ( CountOfPart ;Part_no )-Stock::Qty In Stock-Stock::Qty On Order;0)) Total_item_cost (calculation qty_required * Stock::Last Cost Price) This all works and allows me to use a layout…

I am remedial with Pro 9 but I am inserting photos in a field and the photos are too small when within proporation and too skewed when I do not keep it proporationate. I have used the graphic enlarge & reduce command. I didn't have this problem before with the same photos is there anyone who can help.

I know I've seen this somewhere before, but I can't find it now. What's the easiest way to limit the number of subsummary categories to the top "N" categories when the subsummary part is resorted based on the count field? Another way I'm thinking about this is that rather than omitting the minor categories, lumping them in together as "other" and getting the count for the rest. Here's an example Bob Methanol 10 Water 8 Chloroform 6 Other 5 Bill Hexanes 15 Acetonitrile 12 Formaldehyde 10 Other 8 etc. This is rather than all the different categories gro…

I have a problem with IWP and Internet Explorer. When using IE some of the fields doesn't allow entering. This happens in a tabbed page. I have used "Open record/request" script step in the script, but it doesn't help. If I move that field out side of the Tab, it works perfectly. So the problem seems to be in Tabs. I know there's some problems when using IE, but is there a way to solve this. Many of the users are still using IE - for some reason...

I have a database that tracks employee performance per part number. Records are entered with the employee name, part number, and a performance value. I'd like to create a report that will summarize by employee, with a sub-summary of each part number so I can easily report each employee's performance summary of each part number. How can I accomplish this?

Just updated from FM10 AdvPro to FM11 AdvP. I have a DB(from v.10) with very specialized vocab; with upgrade the dictionary is, of course, without my laboriously managed library. Can I find and import my v10 library to v11? Where might I find it? How would I do that? TIA

I think I saw this somewhere as a plug-in, but I may be mistaken: What I want to do is have the ability to select from three separate value lists to pop a value into a text field. For example, there's one value list for Building, one for Room Name and one for Room Number. What I'd like to do is click on a text field to pull up the value list for Building; When I select a building from the list then a fly-out value list for Room Name would appear; I'd draw over to Room Name, select a value, then a fly-out value list would appear for Room Number to select a room number. When I unclick the mouse, those three values would populate the field. Is there such a plug-i…

Hey all, I've got a layout with a bunch of calc fields that get the sum of related records. For some reason that I cannot seem to identify, one particular set of fields: "Subcon1" thru "Subcon8" do NOT show a $0.00 amount if they are $0, but all the other sum calc fields on my layout do! I have compared these Subcon fields to all my other fields over and over and cannot figure out what is different! Can anyone tell me how to make these Subcon fields show $0.00 like the others? It has to be some setting that I am missing, right? Screen-capture:

Hi all, I have a slight problem. I need to make labels for the back of peoples badges that will have their conference schedule printed on them. I have two related tables: Organizers (with a record for each person running one or more events). Events (a record for each event durning the conference). I want print a label for each person that will have their name and schedule of events on it, like this: John Doe Event A, 2:00PM, Room 4 Event B, 2:00PM, Room 4 Event C, 4:00PM, Room 6 There has to be an elegant way to do this, but I cannot seem to figure it out. I thank you all in advance for any and all help with this matter. …

I want to do something simple - but I can't see how FileMaker can do it. I want to prevent user changes to a field based on the value of another field (in the same record). Specifically: If FormIssued = "issued" then FormNumber field is read only. Privilige sets only seem to control editablity of whole records, and validation doesn't kick in until the record commits (which confuses users).

Hello, I am creating a letter as a layout. Ant inside the letter, I need to print a global variable which was previously computed in a script. I tried using the Merge Field but it only ended up printing the <<$$variablename>> during Browse mode. How should I do it? Thanks in advance

Hi, for some reason the Zapf dingbats font will not work in Filemaker 10 on my Mac. Instead of the graphic icon, I just get the letter "H" (which is the keystroke for a "black star" in Zapf Dingbats). It works fine in Text Edit. I've even tried copying the star from Text Edit, but it reverts to "H" once in FM, even though FM's font formatting bar says Zapf Dingbats 14 point. I think it may have something to do with Unicode. Can somebody enlighten me?

I Use FileMaker Pro 5.5 , I want you help me please. My document's Layout Mode off.I don't open layout mode and layout.What should I do to turn this? I want to change document but I don't. How do i change document? View>Layout Mode -> I can not click it because it is lock . How do i open it ? Layout and Layout Mode lock . Looks soft . have password but i believe password. password to enter. it is saved file . Please Look, I can not open layout and layout mode.LayoutMode and Layout lock,don't click Problem ; Prepared by the document was locked Layout Mode and Layout.How can i do open these? I don't …

Hi, I have developed a application which will running on run time and kiosk mode in this what i want is that when the user run that application in kiosk mode then it will automatically increase the size of the layouts and its object depending upon the screen resolution.plz help me in this regard. Regards, John wiliams.

I have a print layout where I use sub-summaries. There is no body. That is because the table has thousands of records and I just want the sub-totals. I am trying to get two vertical lines to span the length of the page... on each side of the data field (like a spreadsheet). I am trying to accomplish this by setting each field's Field Border as "Right" and "Left"; Black; Hairline. The problem is that I have a miniscule break in the line at each sub-summary. Is there an easy way to get one solid vertical line accross sub summaries?

This is a real shortfall in FM, I have a databox in a layout with displays results from a calculation. The data can be various lengths. I have the mailit plugin which copies the layout and emails it (FM pleae add html email to the next update). Trouble is layout preview is always A$ so if data is too much I loose some, how the hell do I get round this?

Not sure if this is the right area, but here it goes. I have a grouped set of buttons that I have given an "object" name of "menu". I also have a container field named menu. Is it possible to place into that container field the menu object that I have on a seperate layout? I know you can place an "outside" object, but can you do the same with a true object from the same file?

Hello, The attached file sets out what i am trying to overcome. Any thoughts would be great. Trying to do a little formatting magic. Best Stuart Format.fp7.zip

Hi, I'tried to get my MAC solution to WIN but the layout isn't nice anymore. There are gradiants on Windows which I don't have on MAC. In the demo file I created a search box, which looks nice on MAC but on WIN 7 it's half transparent, WHY? The search box has 3 parts, left, middle, right. The middle part is originally 1px large. In my example I stretched it to 250px, maybe there is the problem but why the difference MAC, WIN by ChiSao demo.fp7.zip

Hello, Is there a way to remove the header from all pages after page 1? Thanks

This is going to be lengthy to explain - please bear with me. A while back, I noticed when I launched my FM6 files, that I got a message "Date and time are not the same as System settings - do you want them to be the same?" Obviously, I clicked "YES" - who wouldn't? Of COURSE I want my dates and times to be the same as the system settings!! After that, I also began to notice that FM wasn't accepting dates in the (logical) UK format of DDMMYYYY - it was insisting "Dates must look like ...." and allowing only the endlessly frustrating, illogical US system of MMDDYYYY. This baffled me no end. The date on my Mac was displayed in the UK format - what had gone wrong? …

Hi all, I have a button that currently goes to a new record. I would like to add a script that will warn the user if one of the fields is empty. On another layout this field needs to remain empty so I don't want to require the field to have an entry. I hope that makes sense. Thanks in advance