Layouts

I have a simple form with boxes on it. they are drawn with the box tool, and are not fields. WHen i proof it, its fine, but after i transfer it onto my other work computers, a little box appears. It has the letters "obj" in it, and appears in the same spot around some of the boxes, not all of them. I went to my copy to check, and did not see it, i went into layout mode, and still saw nothing. I'm thinking something is happening when i Transfer it from computer to computer. any help? I'll try to attach a screen shot of it next time i transfer my files, which should be soon

Hello. I'm using FM 9 and need some help with check boxes and radio buttons. I've created a very basic, simple flat-file database for my movie collection. There are three sets of checkboxes, each linked to the GENRE field. (Some movies belong in more than one genre, hence the use of checkboxes instead of radio buttons.) I'm trying to create a fourth checkbox set, also linked to GENRE, but this one will have only the OTHER field. There are two problems: 1. Whenever I click one or more checkboxes in the other checkbox sets, the OTHER checkbox is automatically marked. I don't want this. 2. When the entry box for the OTHER checkbox…

When creating a stand alone runtime, I am having trouble showing which mode a user is in - for example, if a user clicks FIND, and types a search, the record set is then limited to that find - if a user forgets and scrolls through the records thinking it is the entire list, they do not get all the data. How can I show that Find mode is enabled - I was thinking if I could somehow visually show it... with buttons to clear the find and also go back to normal browse/edit.: I looked over the FMP examples included with the software, but they all have the same problem I am seeing - no visual representation of FIND - except for the status bar, which I am hiding in the …

I have a table displayed in one window as a list view of multiple records. I have a second window displaying one record of the same table in a detailed form view which is adjacent to the first window. I would like the two views to remain synched so that as I navigate around, the form view always shows the data that matches the current record in the list view. How can I achieve this?

I am trying to change the way the table looks like when you change the view. There are 3 view options, for, list, table. When you go to view as a table, you get a list that displays your contacts, items, ect. I want to make that look more clean, but when i go to layout mode, i cannot seem to find out how to edit that"View as Table" View. Any help?

Hello, I'm using FM 9 and have a question about forms. Quite simply, I'd like to have two forms in a simple, flat-file database. The reason why I want two forms is because I don't want all of the data to be in one form. The second form will contain lengthy text, and graphic images, that may otherwise make one form cumbersome and unwieldy to deal with. So, I'd like to have a "primary" form and a "secondary" form, if possible. As of right now, after reading FileMaker Pro's documentation, and after browsing through a FileMaker Pro book I got from the library ([color:red]FileMaker Pro - The Missing Manual), I haven't quite figured out how to do this…or if…

I have 8 fields, one is starting mileage and the others are ending mileage 1-7. I need to find the total miles driven on that trip however if I use this code: Ending Odometer7 - Ending Odometer6 - Ending Odometer5 - Ending Odometer4 - Ending Odometer3 - Ending Odometer2 - Ending Odometer1 - Beginning Odometer I get some wacked out number IE: starting out with 157018 and ending odometer1 157066 and the rest 0, I get 314,084. Now if I place the code "Begining Odometer" in the front of the code I get, -48. So frustrated, I tried this code, Beginning Odometer - Ending Odometer1 - Ending Odometer2 - Ending Odometer3 - Ending Odometer4 - Ending Odometer5 - Ending Odo…

How do I make so if field "A" has data in it, then field "B" will show up, but if field "A" is blank, then so is field "B"? Field "B" is a global. Thanks

I am building a generic report. The report is generated from a script on the recent found set. I would like to incorporate the search criteria in the report. How can I get the search criteria for the last found set?

One of FileMaker's simplest tools is the page number symbol, but I'm having an unexpected problem with it: I have placed a p.## text object in the footer. Am browsing 3 pages' worth of records in List View. In Preview Mode, the page number symbol correctly shows p.1. However when the report is printed, p.0 is printed on the first page, p.1 on the second, etc. Obviously I'm making a dumb mistake somewhere, but can't figure out what it is. Suggestions greatly appreciated.

I'm finally at the point where I am going to "Attempt" to set up a meaningful and useful help file for my application. In analyzing my app I believe there will be approx. 90 buttons, layouts, etc. that will require some type of explanation. I have used Tool Tips to explain what each button does, but, I thought a more complete explanation would be helpful. So, to my questions, does anyone have any suggestions as to how to properly set up a Help File System? Is there any documentation available? Are there any example files that I could look at? TIA for all your assistance and suggestions. Al

Hi all, There is a "description" field that may have a single line of text ... or 20 pages of text (it could be book chapters). I would like to have a report that expands or contracts in length; depending on the contents of this field. In form-view this field has a scroll-bar to access the rest of its content, but it will only print the visible text in the field box.

Is it possible to change the format of a pop up menu? Currently I have a menu that has over 40 items which produces a long thin menu with scroll arrows at top and bottom. Is it possible to change the format so that almost the full width of the screen is used and the box is more "wide and short" than "long and thin"? Many thanks

In FM9Adv is there a way to Copy something from one layout and Paste it in the exact same position on another layout? Thanks Sean

FMP9 Adv Win XP Working on school math layouts that will serve as resources for students learning to answer math word problems… Q1: Is there a FileMaker compatible (x-Platform) font that will allow math symbols (division sign -- line with dot above and dot below; fractions -- horizontal line with numerator above and denominator below -- rather than "/")? Q2: Also is there a way to show borrowing, carrying, long division, etc? Don't know how to do that. We want to be able to type model answers in a way more like what the students should write. TIA lpm

I am sure this problem has been asked and answered many times. I searched and searched but couldn't find anything on it. Anyways, here goes. What I need to do is print statements for my clients. Some of these are short, 1 page, header, body, footer. But some have a ton of items that will take 2 or more pages. The data is coming from many tables not just one. First, I am running a script to run over to the deposits table and searching for all transactions that haven't been added to a statement before. It jumps into loop mode, setField to a global back on the statement table, with the date, descripition, amount and such. Goes to next record with exit on last set. Then i…

I wrote a relational database for a therapist. The main database has personal info like insurance company address contact numbers etc. It is linked to a database that contains all the daily notes written on the patient. I want to produce a report that has a cover page containing only the patient name and confidential on it. The Second page contains just the pesonal info and starting on the third page would be all the notes related to the patient. I can't figure out how to achieve this Any help please

I currently produce 4 different reports using 4 different layouts to properly report on my data. I'd like to condense this into one continuous report without page breaks. Is it possible somehow to make multiple distinct find/sort requests, including 4 different instances of records and intervening header info and other static text, to produce this single report . I'm envisioning something like you could do via cdml or ldml on a web page. But I'd like to do it just within fmp and maybe in conjunction with a companion app of some kind.

FM 9, for some reason when I add a field to a layout, is automatically putting the font of that field into Old English 36 point, rather than my default font, Palatino. I can change it back after it's on the layout but anything new on starts out in this strange way. Why this new behavior and how to change it?

So... you would think I would know this but I don't. How do I change my default font?? Every time I added a new field it is formated as bold, italic..blah and I have to go change it to what the rest of the layout looks like. Thanks, Lisa

I'm having a bit of a problem. People have been scheduling panels for a convention using a spreadsheet, with the times going down the left hand column and 7 room names running along the top. They fill each cell with the name of a panel and cut and paste them around the spreadsheet until they get the final schedule. This worked, but it did not keep track of things like who was on which panel and other details. So I created a solution that contained three tables, Events, Panelists and a join table. The database has made it much easier to keep track of things, but the people in question really miss the old spreadsheet view. Is there someway to make a layout that w…

Hello, I have a script launches a 'floating window' for users to view and then click OK to. The Window is an instance of a file (A) and the button that lunches it is in another file (. I have found that if all current instances of windows for file A are minimized then the 'New Window' script step ignores the size and position fields I have specidfied in the script. This happens on Windows and Mac machines. Any ideas how to get round this? I'd like to be able to test if the current file A window is minimized but cannot work out how to do it. Regards Isobel

I have a layout part, Trailing Grand Summary. And I want to have a total cost on my report. In the body of the layout I have the cost field from the Asset table. In the Trailing Grand Summary, I have the same cost field from the Asset table. However, the Trailing Grand Summary Cost field is only displaying the cost of the last line item instead of adding all costs on all lines. What am I doing wrong? I don't think I need to build a relationship since the field is from the same table, right? Help please. :)

I am inserting the date symbol // in a mail merge letter. In the "format date" menu I have selected to show the date in words, eg December 1, 2008, yet when I print the letters the date appears as 12/1/2008. Thanks for any suggestions.

I have created a layout (in this case an envelope address layout) which I want do copy into another database, rather than having to "recreate" the identical layout. The databases are not linked in any way. Is there a way to copy a layout from one database to another (the fields all exist with identical names in each database). Thanks for any suggestions.

I'm trying to call up a floating window for a cross platform solution. A simple New Window, Pause, Close Window when users selects a Continue button. It's fine on a Mac where non-maximized windows are the norm, but on a Windows (via Parallels) it seems that a the New Window script step "Adjusts" the original window and resizes it. I'm not familiar with Windows' window management. Am I barking up the wrong tree here or can I get a floating window over a maximized window in Windows?

I travel alot and I have a database in progress and my employees are wanting to start entering data. I still have a lot of work to do on the reports and different scripts for certain functions required but all fields are there to input the raw data. I need to work on the complete database and save the work that I have completed when I get back home to the database without disturbing the actual data. How do I do this. I hope that you understand what I am asking. I am new to FM so I have limited knowledge to the terminology of this program.

Does anyone know how to format a field so the text is hidden and replaced with asterisks?

I need to know how to get the title header to not interfere with my layouts when printing. When i go to print, it will print my title header. When I set it not to print under the sliding/printing option, it will just leave a big blank space. I'll try to scan 1 of the forms i'm printing, and show you what's happening if you need any more explanation.

I have a fairly complex layout with around 50 fields. The odd thing that I don't understand is that I have a single field based on a calculation that the screen does not update until after I've clicked on that particular field. All of the other calculations are instantaneous. What could I be doing wrong? Thanks in advance!

Hi, is there anyway to auto resize the body part of the layout before printing. I have a layout wich displays email, some are short some are long, i display the email in a browser object so when the email is small everything fits in but when its long i only get the top part of the email. Is there anyway to automatically resize the body part or just the browser object to show the complete email. thanks mfrapp

HELP!!! Please save my computer, because if I don't figure out what is wrong I'm going to throw it out of a window. This is saying something as I am generally a very easy going kind of guy. I created a report with a sub-summary a while ago. It was working fine. The only difference between then and now, that I can think of, is that I have switched from tiger to leopard. Now, my sub-summary section is MIA whenever I switch to preview mode. I've tried everything I can think of. I've deleted the report and created a new one. I've started from "scratch" and deleted the table I used to create the report, recreated it, recreated the report and it still didn't work. …

Hi, I'm trying to figure out how to have my field labels default to a larger size than they currently are. Shouldn't they match the default size for the text IN my fields?

I have decided to change how i will be doing my database, as my last attempt was hopeless. I am trying to put in some checkboxs. When i go to print, if a certain checkbox if checked, then the layout it corresponds to, will print. If it is not checked, then the layout will not. I do not want to do fields that you put an "x" in, I have that, and don't like it. Thanks

Hello all, Apologies if this has been asked already. I searched the web and these forums to no avail. I have an older filemaker solution with 4 different tables converted to filemaker 7 files. I use filemaker pro 9 advance and I know it can be done. Invoices, Clients, Daytimer and appointments. It's a cludge, but it works. I need to merge, so to speak, all these tables into one table and use either tabs or buttons to change the view of the table. Is there an easy solution to this? Thanks for any pointers:)

My database looks beautiful on my Mac, but not so great on a PC -- the fonts don't look at all professional, and the graphics created within FM look coarse and amateurish. I thought I could maybe get some improvement by changing the font smoothing on the PC, but I didn't notice any difference. Any advice? Or will I always have this issue with PCs?

Is there any way to change the background color of a button when it is selected.

Is there any way to change the background of a text field in browse mode. I have a container field that I want to have different text in for each record. Sometimes the picture in the container field is so busy that I need a solid background color in that record only. Is this possible to do?

I have a global field to hold a company name. It is all working correctly, except for this one issue. I make the font to be black, but in the form and reports it shows up as white! No matter what I have tried, changing fonts, colors, backgrounds, etc... it is still white. Any advice??

I created a database with a global field in FM 6 , we have upgraded to FM9 and now use server to serve it. Now the global field erases any changes when we close the file. How do I get it to hold the changes?

I apologise for what seems a simple question, but how do I change the colour of the background fill on a layout? I cant find it in any of the literature with FMP and nor any of my books. I can see that I could edit a theme and then use that to set the background, but surely there is a simple way. thanks

I have a table of contributions containing the following fields: Contributor_ID Date Amount I'd like to prepare a report with three columns, one row per contributor: Contributor_ID.....CurrentMonthTotal.....YearToDateTotal Is there any way to do this simply, using Summary fields, Subsummary layout parts, etc.? Or do the two overlapping control breaks make this impossible without using temp tables or something? Thanks, Chap

I'm attaching a picture of a button. When I click on any field on the screen, I see this dotted outline around the buttons. Any tips on how to stop or cover that up?

HI I'm using Business Productivity Solution - Contacts, that you can download free. I want to add an Invoice Number into a letter that I send to the Client but I have more than one invoice number for that one person. I have just merged field before and it has worked fine till I now have more than one product that was bought for that one person, is there a way that I can get merge field to choose the most recent product Order. Thanks anything would be a great help Thanks Michael

I notced that when you create an edit box the default fill color is "unselected". This creates a transparent fill condition yet their is no easy way to change a controls fill value from having a fill back to this transparent fill condition. The format paintbrush does work however... That's my observation.. my question is .. is their a way to set a "transparent" text color? This would be very useful in portal where alternating lines are filled differently. TAI Kris

Abstract: How to get evenly-spaced alternating bands of white/color for the rows of a columnar layout using a calc field calling a global container? Details: I have a browser list view, columnar. I have a container global field with a color in it. I have a calc that works. The body part is 25px tall. My container field is 25px tall, also. Issue: When viewed in browse mode, the color field is slightly less tall than the "white" background. I have a sneaking suspicion this is related to field border settings I can't quite parse... any advice for me? Thanks!

I'm a beginner trying to establish a FM database for our school. Our teachers teach private lessons to students and I need to generate monthly contracts for them. I have four tables: FACULTY, STUDENTS, PAYMENTS and CONTRACTS. I would like to be able to go to the "student" layout and choose each teacher's students by entering a certain code and when I go to the "contract" layout enter that code and I get that teacher's student list. How do I do that?

Mac 0S 10.5.1, FM Advanced 9.0v3 I'm trying to specify a different font in a layout theme file, but I can't get the change to work. I've changed the Windows Standard theme, replacing all occurrences of "MS Sans Serif" with Georgia, but when I create a new layout using the altered theme, all the fields end up as Helvetica. I've tried this with various font names, but the result is always Helvetica. Any ideas what I'm doing wrong? Here's a snippet from the altered file: <?xml version="1.0" standalone="yes" ?>

I have a layout that's setup for printing from a 3" thermal receipt printer. Right now I just have a little portal in there displaying the items purchased on the order but I simply made the layout pretty tall in order to fit at least 10 items or so. The obvious problem with this is too many items wouldn't fit, and the other problem is that when there is only 1 or 2 items a bunch of blank white space is coming out and wasting printer paper. Any information on how I can make the layout expand based on the number of items in the portal would be greatly appreciated. Thanks!

How often do you guys use the table view in lieu of list view for user entry? I've never done it, but I'm working on this solution there's a couple attractions: 1) Resizable columns 2) Sortable columns 3) Ease of layout development The downsides I see are: 1) I have to rename my fields to something user friendly 2) I've got to come up with a workaround for my single value checkboxes that can now show "1" instead of just the box 3) I can't make the pop up lists "look nice" (I usually remove the borders and make my own without the ugly drop shadow). 4) I can't put buttons on a line (ie "Delete") Any perspectives out there? Thanks, David

I am cusotmising an example db that came with FMPRo 9 and it has what appears to be field data in text boxes denoted by <><>. How do you add this? What do the "<<" and ">>"" mean? and why use this method rather than placing a field on a layout? Regards Craig.

Hi, I have two layouts. One for inputting data and one for printing with the same data etc. I have placed a button on the data entry layout so when users click it, it should go to the Printing Layout in Preview Mode. I would like the user have the ability then to click enter to cancel this preview mode view and return to the original layout which would be the Data layout but the script pauses in Preview mode and i can't exit it as i have the Status Area hidden. Is this possible? I have it working on another layout fine with the script below but i'm not switching to another layout. Allow User Abort [Off] Enter Preview Mode Show/Hide Statu…

Hello community, I was wondering if you could help me with the following scenario. Is it possible to enable or disable a field based on another field's input? For example let's say I had a field with a payment option of cash or credit card, and another field with a credit card number. If the payment option is cash then the credit card field would would not accept any data entry. However if payment option is credit card then the credit card number field would accept input. Is this possible in filemaker? Thank you for all your help. Carlos C.

Hi folks, Hope you can help. Using FMP 9. I have a database that tracks customer orders through quote, purchase order, acknowledgement and invoice stages. I generate the various documents (using a wordprocessor, normally), save them as JPEGs, and add these to 'picture' container fields within my database. I sometimes like to print the documents I have stored in these container fields. I can't find a way to do this without first exporting the field contents - am I missing something? The workaround is to create a new layout, single page, have the container field fill the whole page, then print directly from Filemaker. However, I might have 3 quotes …

Currently my database is set up in a typical fashion with records of advertisers available in form view (with many fields) as well as List view (with a few fields & merge fields for quick reference). I thought that it might be nice to see my list while having full access to an advertisers records at the same time, without having to switch back and forth. Is there anything wrong with taking the fields that I had on the form and placing them within the footer of a list? The fields seems to behave the same and everything works just fine, but I have never seen this suggested so I was wondering if it could be problematic. Thank you, Marc

Is it possible to set up a layout to change based on a logical calculation? For instance, if I had a field that displayed either a "Y" or an "N" and I wanted the layout to make the field's text green if it was a "Y" and red if it was an "N"? Does that make sense?

I'm using a repeating field on a layout that contains graphics. I need the graphics to blend from one to next so they look continuous. The field is defined to show the 5 values of the repeating field horizontally, but there is a small gap between the fields. Is there a way to remove that gap? I made sure the borders are not set between values. Thanks.

Hi everybody, On a form I have a list of cities. Each record contains only one name in it's "city" field. On a second layout I have placed a map of whole territory. I am pondering over a script to bring me to the location on the map corresponding to the record on the form. Any suggestions are welcome. Thanks

Hi there, I'm struggling with a problem with checkboxs. I have a table of 'groups' which lets the user add groups and then add contacts to each group. I would like to be able to speed up the process by using a checkbox on the 'people' layout allowing the user to add a person to several groups ( and also add groups through the 'other' check box) rather than have to go in and add the person to each group in the group layout which would be more timeconsuming. When I've tried to do this I run into problems, If I have groups 1, 2, and 3 when I add the checkbox it all looks fine but if contactX selects 1, 2 and 3 my groups layout would show that contactX is a member of g…

Is there any way to disable the scroll wheel function which scrolls rapidly through records? I would prefer it scroll the page up or down rather than change records...

It's been a while since I've used FMP...but I'm trying to get back into database design. I'm on v8.5 now and I can't seem to do the basic task of drag-copying layout elements with keyboard shortcuts...when I drag-copy I get the little + sign like it's copying, but the element just ends up moving. Am I doing something really basic wrong in this version???

Just encountered a problem with calendar popup when using Leopard Spaces. I'm on Mac OS 10.5.1, FMPA 9.0v3 I have 6 Leopard Spaces setup. My FMP window is in Space-2. The layout has a date field with a calendar popup. Following the date field is a text field with a drop-down menu. When I click in the date field, Spaces shifts me to Space-1 and displays the popup calendar floating unattached. If I select a date, the calendar disappears and the drop-down value list for the next field appears, also floating in Space-1. I reported the bug to FileMaker. Has anyone else encountered the same problem? Does anyone know of a temporary fix? For now, I'm for…

I'm working on a membership database/directory for our church. I have created the main layout to be for a family. On a family's record it has Head of Household name, phone, work, etc. It also has the same for Spouse information. Then there are fields for the names of children. I created a report that nicely puts each family into a "directory" with two columns of families per page. So far so good. But now it gets more complicated. I want to have more detailed information for each person. For example, date of birth, date of joining the church, activities involved in, leadership experience, talents and gifts, whatever. How should I do that? Create a n…

I have many advertisers. Each advertiser fits into a category, so there may be 100 advertisers and 25 categories. This will be done in FMpro8 How do I make a simple report that lists all the advertisers sorted by category, above each group of advertisers it displays the category and how many advertisers are in each category. I would also like to make a similar report without listing each of the advertisers. Thanks in advance, Marc

I have recently upgraded to Filemaker 9.0 from 6.0. In 6.0 I could go to "Access Privileges", then "Overview" and see what layouts my fields were located on. I can't seem to find that feature in 9.0. Can anyone help? Thank you so much.

Is there a way to have a button that when clicked would open up a field in it to reduce space on the form? Like having the field, Investigation Notes be in a popup and fillout the info in the popup, and have it stored in said field without having the actual field taking up real estate?

I have a database with 8 layouts Most all backgrounds behind type is lt blue In some layouts when you highlite type it turns the selection yellow on other layouts it turns the selection slightly darker than the light blue and you don't know if you have selected it Is there a way yo make the selection turn a specific color?

Hi all I think this has been ask before but I cannot find it. When there are several records for the same spool number, I would like to display the spool number once until the next spool number and display this number only once until the next spool number appears. The example does not display well once submitted. Example spoolnumber weld number welder id sp1 1 K sp1 2 R sp1 3 A sp2 1 C sp2 2 K sp2 3 A would like the list view to resemble this: spool number weld numbe…

Hi everyone, I've received great help from here in the past, so I am back to ask more questions. I am trying to put together a FM solution for the company I work for. We write and process a huge number of SQL queries every day. I can't go into much detail because of an NDA, but what I need to put together is a combination tracking/formatting system. I am developing this using FMP 8.5 for Mac OS X. The way we do stuff is by client. And each client will have multiple queries associated with it. In general, my idea so far is to have two related tables, one for each client, and one for each query. But I'm not sure how to associate the query with the …

Question about Icon I was looking at some of the sample databases inside of FMP and I noticed that there are small icons next to add record, delete record, and find record. One appears as a rolodex card and the find is a magnifying glass. How do i use an icon like that in my DB and are there any other icons to choose from?? Thanks

It looks like I have found a great resource here! I am fairly new to building FMP databases (although I have been a user for years). I have a basic issue I could use help on. I am trying to show that a record is selected in a list view layout with more that just the black line on the left side edge. I would like a graphic that I have in a global container to show in the selected record. I would greatly appreciate any help with this. Thanks

Hi All I have a layout linked to a table for "To do" items. Each record has a due date field (in date format) and a done field (a simple yes tickbox). I would like the layout to only show items which are not done (ie do not have a tick in the yes box) and in Due Date order. I am using the List View for the form. Is this possible? John

Hi Everyone I've been setting up a User Interface made up of splash menus and Reports tied together by scripts to help new users not trained in FMP (some quite young) to navigate a FMP database to look at video-clips and a range of associated "reports". For any new user the "get me out of here" button - Go To Main Menu - is a critical support. However, some of my reports only give their best detail when they are sorted and viewed in Preview mode - which doesn't allow any buttons/scripts to operate. Now, obviously "I" know how to get out of Preview Mode and back to the Main Menu Layout, but a new user - still learning the menu interface - won't - and will therefore becom…

Ok If I copy a record it should copy the contents of fields but this does not happen, originally I wanted an unused field to have a value N/A so if it isn't used it is obviously not needed. However the auto complete seems to then errase the data when copying the record for the copy at least, not the original..... So how do I keep a new record with the handy feature of displaying N/A but obviously copy data to a new record when you copy the record, this does not make much sense to me.... Thanks in advance....

if a print layout script has run? Reason is if I printout a work order for my assembly people to produce a customers order, then customer changes his mind (as they are prone to do occasionally) - Now I think I need to flag whether a work order was printed, then if changes are made since it was printed, to note in a field W/O Modified Date and Modified By, to be picked up and display only if the modifications took place after the print script was run on that record. I hope this made sense, thanks

I have a login dialog window with one field, into which the user types his initials. There are two buttons, Continue and Cancel. Continue is the default button, and as such I want the user to be able to hit RETURN (or the normal ENTER key on a PC) in lieu of clicking Continue. I'm having difficulty doing that. The login is driven by a script which creates the dialog window, positions the cursor in the name field, sets a global variable to "Continue", and then Pauses. In the dialog window, the name field's behavior is set to "move to next field" for RETURN, TAB, and ENTER (to not do that would allow return/tab/enter to be inserted in the name field). Both …

I have an odd problem... Bot sure how it happened but I get popup text appearing on a button I created, however with Filemaker pro 9 I don't think there are any controls for popup text on buttons ? I have un grouped the button elements and that stops it, I I recreate the button and put a script on it the popup text reappears... It seems I have a ghost in the machine...

Hi all i have a db with lots of fields. Some records need all the fields and some records only need a few fields. Is there any way i can select what fields can be seen in a record? many thanks

I have a global container that is set to Global, Auto-enter Last Visited,Can't modify, Always Validate. My Logo is a .jpg that sits on my desktop. My problem is I want to move my logo from the desktop to a folder inside Filemaker, but I don't know how to change the gLogoContainer to look in the new folder instead of the desktop? Can anyone help? Thanks

Okay, here's the scenario...I have a series of 'number' formatted fields. In the 'number format...' option, they're formatted as "Format As Decimal" with two digits of precision. These fields are used to enter dollar/cents amounts. I'd like to be able to copy the contents of these number fields, and paste them into a single text formatted field, with carriage returns separating the dollar/cents entries. I suppose this would be considered a merge, since I'm copying data from multiple fields, and am pasting them into a single field. Not sure, though. Anyway, I have created a script that goes to these number-formatted fields, copies the content, shifts over to the target te…

I don’t know if I'm just fried from trying to figure this out or if I just cant get it. I have a table called Case_Management (w/ __KP_Case_Management_ID) in this table I have a field called Case Number. What I cant seem to do is have a new window pop up which will contain a large text field for the officers to type in and keep the case nuber from the main table when a new record is created (I have tried putting it in a related table, as well as in the parent table etc.) I also have the Case Number field also on this layout. On the new window I have a button for a new record, when clicked I want it to create a new record with a blank text field(but still b…

Hi, I have a DB in development now that is a fairly modest creation — not more than 35 run-of-the-mill calculations; some summaries, a little conditional formatting. Not rocket science. Yet every time I enter a value in a field (like a quantity of product), the dependent calculations only update when I move the scroll bar or resize the window... they won't update of their own accord when I tab out of the field. Nor will they update when I force-commit the record. I'm running FM9 Pro on a Mac dual 2.5GHz machine with lots RAM and everything else performs perfectly. Any ideas, please?

Is it possible to manage users in a layout, view users etc ? I huess it must be but how do you get the user list ?

I have built a replacement for and excel spreadsheet with filemaker and it is great however there is one BIG problem. Excel will give a preview of an illustrator file, Filemaker will not, so when a file is inserted in Filemaker there is no image, but in Excel it produces the image, this is not great surely there is a way around this so Filemaker can show the Illustrator file :)

hi. happy new year to all. is a table i have name of customer and tape of customer. how can i make a drop down list that it will show me all the customer that are in tape "a"?

I'm using Filemaker for a database of contemporary artists. Sometimes I'd like to change the layout (insert an extra image, add a field)of an individual record without changing the layout of all the other records??? Also, how do I create space in a layout or record (i.e. I want to move the bottom fields so I can add a field in the middle of the layout)without having to move the fields individually?

What is a good way to display *all* of a field's contents automatically and be able to then select options and interact with another table's information? Two examples of the kind of thing I'm trying to figure out with FM8.5, but not grasping yet: 1) a school database with classes, hundreds of students, and the goal of keeping track of progress on academic goals for each student. 2) A sales database with sales regions, stores, hundreds of managers, a product line offering, and the goal of keeping information about where each manager is in the process of deciding what products they might carry. In each case there could be hundreds of students or hundreds of mana…

I have a field that makes a Client ID by taking data from the info inserted. It creates a unique id. However I would like to have the end user be able to change it if they have to use a specific id already in use. Maybe a button that pops up and asks what they want to use as an id for that client. any ideas?? Thanks

Hey, Not sure where to put this topic. I have a text field that is a big box but the problem is when it comes to word wrapping, it cuts off words in a very odd way it might have "finishi" on the top and then "ng" on the next line. I don't see an option for widow/orphan type of thing. It is the same way on the preview format as well. It's not the biggest thing, but it looks unprofessional. Any help? The Lonesome Jubilee

I have recently reloaded my computer, and unfortunatley started FMP before installing all of my fonts. Is there a way to remap that new font to the original, and I have never really worked with custom fonts on a solution before, but do those fonts travel with it, or is it a waste of time to even try to use them?

I have made several basic databases with containers, they all work great no problems, some are from flat files, some are for related tables etc…just no problems. Now today, I am working on a layout and I add a container (this is also a flat file db w/just a few fields and 1 container). I right click in the container to add a photo and !!!Nothing!!!. I think it’s a mouse problem so I install a new mouse…still nothing. I check all the setting to make sure the container can be accessed and it can be. I then click on the container again and boom..it works. I close out the db and reopen it, and now it will not work. I am lost, has anyone ever had this …

I'd like to create a layout for a file so that when particular (restricted) accounts access the layout, some of the fields are hidden from view and the remaining are view only. I'm new at FileMaker. I assumed the way to do this is as follows... 1. Define a privilege set. 2. Assign the privilege set to the restricted accounts. 3. The privilege set is defined as follows.... -- Open the 'Edit Privilege Set' dialog. -- On the 'Data Access and Design' panel, select 'Custom privileges...' for the' Records:' field. -- On the 'Custom Record Privileges' dialog, set 'View' = yes, 'Edit' = no, 'Create' = no, 'Delete' = no, 'Field Access' = 'limited...' …

Hi, Could some tell me if this is even possible or tell me of a better way of doing it. Our officers go out and take (lets say) 20 digital photographs, they return to the office and start entering their information into the database. Is there a way to either attach that folder of photos to a specific record? Or what I would really like to do is import all the photos at once(not a reference but the actual photo as space is not a problem, and the volume of photos will never really get to be too large) to a layout containing containers so they could add notes as well. If an import can be done, is there a way to make it a simple operation so they…

Hi, Does a Footer part ALWAYS "stick" to the bottom of the screen? Is there no way to make it stick to the bottom of a list of records instead? So, aligned TOP rather than BOTTOM. I have only perhaps five, shallow records in a file at any one time and I have a giant void of white space between the last of them and my footer. Many thanks in advance.

I have an ORDERSTATUS field that stores the numbers realted to the names: 1 - Open 2 - Pending 3 - Closed Is there a way to store the number and display the NAME of the status in the field instead of the value? I have overlayed a non-enterable field over it to show the related name but was hoping there is a better way.

Can one stop lines of text being shaved when printing portals across page boundaries? I am trying to print a directory of departments with department members appearing in a portal below each department field. All fields slide up to produce a continuous list and the 'Allow part to break across page boundaries' is checked. On some pages the top of a portal row prints at the foot of one page (the top of the characters), and the bottom appears on the next page. It appears FM does not know how to deal with widows and orphans. Preventing the part breaking is not an answer as this will mean some pages are only half full (where the following portal has man…

Hi guys, I haven't quite figured this out yet, but I want to add one button to find mode that will return the user to the full record set. What is the best way to do this? I don't really want to create a completely separate layout if I can avoid that. I thought maybe some kind of conditional formatting? Cheers Chris

When dragging a new field into a layout, what determines the size of the field, font, attributes, etc???...I can't seem to get this to change from the current HUGE fields that are created..I know it's a simply solution but can't find in Help or anywhere else...

We have several databases that are all interconnected. On them it seems that if we get to many layouts we have a problem where we can not manualy move to the layout using the drop down on the left side of the screen. On a couple we have over 200 layouts 1 has over 350! If I have to get to layout 100 I have to type the number in while in layout mode. I can often get to the first 50 or so layouts without any problem. It seems to be after 75 or so that when I select the layout I get sent to the last layout. Anyone have any idea if this is a bug or what. I can provide any info needed.

Hi Guys, I've been poking around in templates and google and what not trying to figure this one out but I just can't seem to get it right. I have a text box for entering first name and last name with a light grey label so that users enter text in the right spot. However, once they enter text, you can still see the label through it! Is there a better way to do this? either a way to make the box background go white when there is text in it or a different way to label *inside* a text box that will automatically disappear when there is text and reappear when there is none (but preferably not thing that will be entered in to the DB when the record is saved if a sp…