Layouts

Date field that user set's with drop down calender. For the new year the client has asked for me to clear previous entries in this field. But when the user went to create a value filemaker some how remembered the previous entry (if there was one). Being that all entry's were from last year going through the extra clicks to set a new date is not necessary. To clear the records I did replace field contents with "" Perhaps that was not the proper way to clear the previous records. Anyhelp with this glitch would be great.

I currently have a solution to track my employees' performance based on actual and theoretical data. I have created several report layouts using sub-summary parts and summary fields to create reports of the employee's summarized performance over a set timeframe. To accomplish this, I'm using the "getsummary()" function of actual and theoretical data and sub-summary parts to sort by employee name. Everything works like a charm. I'd like to add a field that summarizes ALL employee's performance (i.e. a group summary for a particular job) during that same timeframe, so that there is comparative data of the individual to the group. I cannot figure out how to accomplish t…

Basically what I want to do is a name based auto-complete edit-box (or something similar) that allows users to start typing in a name and of course suggest the correct name (the list of names can/should be pulled from the existing contacts table). When the user confirms the name I want the ID associated with that name to be put into the foreign key field (not displayed on the layout). The layout itself is based on a "Teams" table which has "Team Members" which is a "Contact". The only field shown on the Teams layout is a first+last name calculated field. Teams: _TeamID TeamMembers: _TeamID, _ContactID Contacts: _ContactID The "ideal" solution …

I've got a layout which consists of a set of buttons. Each button will create a new record in the table and switch to a layout appropriate for that button. The script that opens the layout turns user abort off, hides and locks the status area, then executes a pause script indefinitely step waiting for the user to do something. As some of the database users are keen keyboard-only users, I have set the tab order up so that the user can tab through the buttons and hit the return key to execute the button script, or alternatively click the button to run the script. On entering the layout, I set focus on the first button with a go to object step. The user can then tab to …

i'm using a container field to store a link to a file. On mac it works fine but the same database running on windows will not open up a file. It inserts ok but when double clicked it doesn't do anything? I have tried different files, with the same luck. thanks for any help.

I've searched and can't find the answer to this. I upgraded to FM 11.0v2 and now, it seems, I'm seeing my file sort whether I want it to or not. When I create a new record and then hit the button to view the previous record, I find my total database being sorted. I can then go back and back and back and it doesn't sort (I think that's right). But, I find this annoying sort, that always takes longer than I want to wait, going on after making a new record. . .at the end of the stack . . . not in the middle or elsewhere. I've checked all my preferences and I've checked all my scripts and I can't find any sort other than what I've specified for a script (and that sort on…

I usually hide the toolbar in my solutions but I know there is a movement now to show the toolbar, particularly in FMP v.10+. I have a solution in FMP v.11 and I would like to show the top part of the toolbar (the left/right arrows, found count, quickfind, etc.) but I would like to hide the small section below (Layout: , View As:, etc.) - see attachment for the section I would like to hide. Is this possible, or is it an all or nothing kind of thing? Thanks.

Hi all, This is probably a stupidly simple question but I can't figure it out. I've just converted out databases to FM7 and fields from a certain relaionship show <<Index Missing>> in browse mode, instead of the data. Not all records had a value in these fields in the old system, but they didn't show that, they were just blank. The relationship links to a calulation field and as far as I can tell everything is as it was in the old system. Was something wrong in the old system that just didn't show up or have I done something wrong. Any help would be great.

Hello all I would like to display a list of home inventory items such as the following: Item: Insurance type: replacement cost: Computer Home 800.00 iPhone Home 300.00 Truck Auto 12,000.00 ATV Motor Sport 4,000.00 Motorcycle Motor Sport 8,000.00 But only display in the format of the folowing in a portal display: Insurance type: replacement cost: Home 1,100.00 Auto 12,000.00 Motor Sport 12,000.00 I am using two separate tables for this. …

I thought this would be pretty easy, but I had an extra bowl of Frosted Dingbat Flakes for breakfast! I am trying to make some simple 'Flash Cards' for my school: Each record has a question, a category, the answer, and the reference. The question and category fields need to go on the front of the flash card and the answer and reference fields need to go on the back of the card. The blank cards are set up "four to a page": Each standard 8.5" x 11" piece of paper (heavy cardstock) has perforations down the vertical and horizontal centers of the page to separate them once they are printed, so each card is 4.25 inches x 5.5 inches when done. My trouble is tha…

I apologize if this is not the correct forum for this entry. I have two tables. People: __kp_PersonID __kf_OrganizationID Person Name Person Address Organizations: __kp_OrganizationID OrganizationName Each Person will have 0 or 1 Organization associated with them. Each Organization will have 0+ People associated with them. I want a layout, using the People table that displays: Person Name Person Address OrganizationName being lookup through the People.OrganizationID I need to be able to display the name looking it up using the ID foreign key but I also want to change the Person.OrgID using the same field. Person.OrgID -&g…

Hi, I'm a newbie at FMP, and I was wondering if there is a way to get FM to capture the criteria that end users enter when they are in find mode? More specifically, if the end users want to find all the records for "12/1/2010...12/30/2010", how do I get that date range to print on the report when they see the results? I hope this makes sense. Thanks!

Is there anyway to completely remove all borders (the status, red/yellow/green dots)? I want to make a layout with nothing except a pictures... sort of like the splash screen you see at the beginning of Filemaker. Can you do this? V

PNG graphics placed into container fields and resized down look poor (not smooth). These same graphics have looked good in a solution I produced two years ago and have used in Mac OS, Win XP, and Win Vista. Now, in Windows 7, they look poor. The edges are not smooth and they appear pixelated. Has anyone else seen this issue? This problem occurs in both FileMaker 10.x and 11.x. I've tried the database both locally and opened from a server. I've tried loading gifs in instead of PNGs. Still bad. It appears to be an issue with how FileMaker "smoothly" scales these graphics within the operating system? I'm hoping somebody out there has an answer or at least knows…

I ran in to an odd problem the other day. I have created a calculated containerfield containing a png graphic set from another containerfield in wich I keep the original graphics. I have created a quite large pie chart in Photoshop 259x259 pixels to be exact. Saved as a png (save for web and devices). and inserted picture into a containerfield with 20 repetitions. One rep for each 5%. The calculated container fetches graphics from this field. The actual field on the layout is just 20x20 pixels large, but on other layouts I might need a larger one. On XP (my comp) this looks perfect - nice round pie chart symbomls. Then on of my collegues says that they…

Hi. I have a layout that has a single line of data and is setup to display in List view. For some reason, if that layout is maximised then the screen displays as many lines as there are records, and not the footer at all, but not-maximised displays correctly. I have several other layouts that are used in a similar way and these work fine. I have been through many attributes but cannot see what may be causing this. Anybody give me a clue please? Greg

Is there a short cut key for switching from the inspector to the layout in layout mode?

Hello, I'm looking for a nice way of selecting multiple items on a layout. I noticed you can't do a multi selection list in filemaker. What I have right now is a checkbox set, which seems to do what i need it to, but i wish it was a little easier to use like a multi select list (like in HTML). Anyone have any other tips for selecting multiple items in a value list? thanks

This FM message box, "Before typing press tab, or click a field or choose the new record?" 1) sometimes, usually when just starting the program, going to a patient record fixes it. 2) today i am experimenting with Dragon Speech,,, kind of kool. Every 3 seconds this Dialog Box is popping up. Keep it off?

confused I think i am talking of merged fields? Difficult explaining what these several field are... trying to dissect another code I need to change the relationship of several fields in a portal in a layout, don't think its portal related but dealing with merged field in a layout... trying to edit it If I change the font or click around... its opens to where maybe i can make heads or tails what is// how do i modify or how does one get more info manipulating these merged fields? Haven't used these ... kind of hard to dissect even know what inside i have a date, a hour, a time, a am/pm field seems like their all bunched together? …

?

I have a very simple setup: Table 1 = Accounts Field1 = AccountID Field2 = AccountName Table 1 will have Account named entered manually. There are not many, 6 accounts. Table 2 = Opportunity Field 1 = OpportunityID Field 2 = AccountName - This will come from the import Field 3 = AccountID Table 2 will have weekly imported opportunity data. With the imported data comes the AccountName. What I would like to have happen is when the Opportunity table is populated with the imported data then the Opportunity:AccountID is populated by the Accounts:AccountID

Didn't know the best place to post this but anyone know of anything that can add CAD ( computer aided design ) to FMP.

Hi, Apologies if I've posted this in the wrong section, this seemed the appropriate place. I'm having some problems or at least I can't think of a proper solution to my dilemma. In my solution one of the primary purposes is to allow the user to enter in the necessary data and have it print in a preset template (of their selection). I have most of the templates set up and working just great thanks to the Virtual List Technique. The issue I am coming across is for some of these templates a numbered or bulleted list which requires some user interaction is needed. Unless I've missed something doing this in an edit box is a rather big headache for the user, unle…

I am working in Filemaker 11 Advanced. I have a layout from which I then pop up another layout for some information to be edited (for a form of report) - Except when the layout pops up and I try to edit the record I get the following message: 'This record cannot be modified in this window because it is already being modified in a different window.' I hasten to add that the window which the new layout is launched is closed as part of the script and only reopened when the editing in the new pop up layout is completed (the users click a button) so the message is just wrong! This is driving me slowly nuts so any advice would be more than welcome. Many thanks for any help…

I am using: OSX 10.6 and FM 11 ADV. I would like to create a checkbook layout that resembles a standard checkbook register as closely as possible. I have fields: Date Check Deposit ChkAmt DepAmt Balance RunBalance The simplest plan is to put the whole thing in a portal but the CHECKBOOK table is not related to anything else. Question: "Am I struck with using a 'table' layout or a 'form' layout?" Thanks Ron

Say can some tell me how or what the correct syntax my find command set little image attached.. The the first 2 Set Field.. commands are okay.. The cost field must be empty in thsi find command Tried * Appreciate

Hi, i attached a small window media video... 1K Its showing a couple field in a portal i am filling in with a X Then i click a button to sum a counter of the X's in this portal sort of.. Why must I click my script button twice to count correctly When IF click the layout screen, or focus to a screen spot.. then click my button.. It seems to work, then only need 1 click my button once showing the correct count TIA rod rodsTest.wmv

What is the best method for setting up a notation field for multiple entries, with a scroll function, timestamp, username, etc? The notations would primarily be used to track contact/communication information between clients and staff.

I'm having an issue creating a report, hope someone can help. Ok so here's what I'm trying to do: I have a List of Records (say list A), then I have records in another table (: that are related to list A. I want to display of list of records (list A) and under each record, that records related info. Example. LIST A TREE BOAT FISH CAR Related Records in Table B TREE BARN TREE SKY TREE WATER BOAT BARN BOAT SKY CAR PAINT SO I want to build a report that shows TREE - BARN - SKY - WATER BOAT - BARN - SKY FISH CAR - PAIN If I use Table B as the layout source I wont get record "FISH" in the fina…

Hello, I have written a lot of scripts in filemaker that use the Show Custom Dialog option. Is there a way to change the position of these dialog boxes? instead of them popping up in the middle I want them to appear on the left. Or is there a way to make that a default setting for ALL dialog boxes? Thanks for your help.

Can anyone think of a way to generate a portal in which the TAB button moves you to the same field in the next portal row, rather than the next field in the tab order? I was thinking of a script trigger but I can't quite figure it out.

Looking for some layout inspiration, and am rather new to FM. I have a company-centric file that has multiple contacts and multiple addresses associated with it via TOs. I have a layout called 'Customer Management' that will allow the user to add, view, and modify company details. I was thinking of using tab control to switch views to contacts and addresses for the specific company. However, using a portal just gives me a table form view of the respective contacts or addresses. I'd prefer to make this a little more UI friendly. For example, one method I was debating was having a drop down box that listed the contact/addressee name for the user to select, …

Not quite sure where to post this... I am creating a tool for serveral people to use. It will be installed on each person's PC, and will be s stand alone - no network or unified database. So each person will basically have thier own copy of this. I have a table that will contain profile information that will be used everywhere else in the database. Things like the person's name, phone number, email address, photo, ect... Those elements will be used in conjunction with the data tracked - sales leads basically. They will use the database to print forms that have these profile fields merged... For example, one of the forms will be a follo…

I've got a layout where there's room for a block of text (a concatenated mailing address), the length of which varies from record to record. This particular layout would be aesthetically "cleaner" if the last (bottom-most) line of the text rested just above a row of tabs which runs across the layout. Is there a simple way to do this, analogous to the vertical alignment of text in the cells of a table? Thanks!

I create a layout and while in layout it all looks fine. But when I go into browse mode some of the items shift and some shapes get wider. I am using FMPRO 9. Someone told me about an inspector button under the layout bar but i cannot find that anywhere. Also does anyone know how to upgrade filemaker 9? It always tells me there is a neewer version of 9 but when i go to upgrade it it just takes me to the FM website and offers me FM 11 to buy. Thanks! Erik

I would appreciate any help with the following: I am developing a program for use on my farm- In this instance I have 3 tables: Table 1 has data for medications used (right now totaling 15 in number); Table 2 has information on animal weight (right now totaling 100 but will grow substantially) and the third table is where I want to calculate dose and store the information re drugs given to an animal. All Tables have the requisite ID number for the records. I have established a Join Table in which resides the ID for each record. I want to be able to go to a layout and choose a medication; then go to another layout and choose the applicable animal and its…

I'm redesigning a database solution that uses Filemaker like a page layout program. The focus is how pages appear when they are printed, and because the information in the database varies so much, people are constantly required to change font sizes and sometimes field positions. The current solution uses one popup window for data entry and a second window for the preview (and by preview, I don't mean Filemaker's preview mode, but the display of the data entry on a graphical layout in browse mode). Right now, changing something in one window requires closing the other, and it feels constricted and awkward. I was asked to make editing between these screens more conven…

I am using Filemaker 11 advanced on Windows XP. I have a layout on which I have created a chart. I add a button, go through the button set up process and then find a have a button almost as high as the layout body. When I try to change the height of the button is bounces back to the same size. I can change the width. The anchors for the object are the default, top and left. I tried deleting the chart and re-creating the button to see if the cause was there but got the same behaviour. Just tried on another layout and the same happens but shows it is not related to the body height as the button is the same height as before. Tried again in a different database and …

What methods do you use for displaying status icons on your layouts? ie. Create a calculation field that has a result type of container. The unstored calculation result references an icon that is stored in a field of a table related by a cartesian join.

Hi, I have a text block with lines containing merge fields <> <> <> <> The documentation states You can insert punctuation, spaces, line breaks, and text between merge fields as needed. If I put spaces they shrink as they should, However if I put a tab stop between the items on each line they no longer shrink. Is there a solution to this? Thanks, jim

I'm currently developing a system for our company right now and looking for some input. The part I'm doing right now is the usual Company/Contact entry layouts. We generally deal with a specific person at a specific company, but we have to have the flexibility to set up multiple and default name/addresses as we often ship to different addresses/people under the company name. The DB current is set up with multiple TOs as shown attached. I am envisioning that as companies are first created, there won't be any addresses or contacts associated with it yet - so we want to click "Add Contact" or "Add Address" and it would pop up a layout to add a contact relatin…

Hello experts, Using FM10 I have made a "list" type layout. It shows all the records in my database. I would like it to only show certain records - records where the field DISPATCH_DATE has a null value. I am aware I can do this with an omit request, but I don't want the user to have to do this every time they access this layout. Is there a way to only show records with no DISPATCH_DATE? Thanks very much! -Frosty.

Is there a simple command in FM to preview the current record; rather than previewing the entire found set until one gets to the required record?. Thanks

I have a drop down list that is showing me a code and the full name - the code goes in the active field and a look up puts the full name in another field. Because the codes are different lengths (they're actually nicknames) the drop down is not nicely and neatly aligned where the second value is listed. Is there any way of altering this by formatting the drop down list (or otherwise)?

I version fmpro 9... how can i change my measuring from inches to pixels? Jay.

I work for a company that sells plastic injection molding machinery and parts. We use FileMaker Pro 9 for our database. Each record has information like volts, make, model, serial number, and so on and so forth. Well, we also have one Container object per entry that we use to display a picture of the part / machine that the record is in reference to. Anyway, lately the Containers seem to be randomly losing the path to the picture files. Our pictures are on a networked drive, but the connection's fine, and this doesn't happen to every record - just certain ones - and it seems that it keeps happening to more and more records. I've been searching Google for more inform…

I am trying to use the top of one window to move the top of another window to the same spot. I set a global variable using Get(WindowTop) then call a script in the second window with a resize step and set the top field to "$$top" - it doesn't work..... Can one use global variables in the resize dialogue?

I am trying to use the invoice solution from the filemaker 11 and managed to customise it. How ever the Grand Total Summary is displaying immidiately after the body, meaning if i have 1 record in the invoice, grand total summary is displaying just below it. Irrespective of the number of records i want always the Grand Total Summary should be displayed at the bottom of the page. is it possible? I have attached the screen shots. Please advice. invoice_from_filemaker.pdf Required_Format.pdf

I'm trying to be able to print postcards with addresses from my customers table, but the postcards are too small to print the normal direction in our HP printer. Thus, we have to flip the cards so that the card is going in horizontally. This presents a major issue when trying to format the 4x6 layout properly. I can rotate the text, but it becomes impossible to properly place and format the text box. I can flip the orientation in page setup, but this doesn't actually change the way its printed - just the way it looks on screen. I can change the dimensions in the print screen settings and get it to print in the correct orientation, but then its misma…

I have a template to print oversized A4 envelopes. If I set the paper size to A4 (needed for other templates) part of the return address is not printed. The question is can one fix this and how? Thanks

I'm sure that there is a simple solution to this but can't come up with one with my current state of experience. I have 2 Db's.. 1. Programs 2. Purchase Orders I have a layout in Programs that has Harmonized Tariff code info. In the PO side I would like to access that layout instead of duplicating the layout, not that its a big deal but why create it when its already there. The data is not a problem, I can access the program data from the PO side. Thanks Michael

Why is it that when I create my layouts and put certain objects in place and then go to browse mode they shift around? Thanks! Erik

I'm using Filemaker to publish a directory. Details of each entry are presented on a half page and need to fit into specific areas of the page. Occasionally, the name of the organisation is too long to fit in the available space. I am trying to find away of working out how long a string is when presented on the page (the sum of the character widths, not the number of characters in the string) so I can condense the font or reduce the text size to allow it to fit the available space. Has anyone found a way of managing this? Thanks Brian

I have a DB with shippers and shipping items. Shipper is a table, shipping items is a related table. The client wants to have a shippers summary page that shows all the shippers in oneline list type layout layout, which is easy enough, but they also want to see/be able to search the first 3 items in the shipper all in one line. (so columns line up) I know we can't to horizontal portal rows, is there a way to get around this? maybe via calculated fields? IE: Shipper ID, Date, Number of Items, [color:red]Item 1, Item 2, Item 3 Shipper ID, Date, Number of Items, [color:red]Item 1, Item 2, Item 3 Shipper ID, Date, Number of Items, [color:red]Item 1,…

I have an employee database with some drop down lists that allow selection of the department and position of the employees. The Department and Position value lists are sourced from related tables. I'll use the department field for the sake of discussion here. I am displaying the auto entered ID with the department name in the drop down list (ie, "25 Accounting") but saving only the record ID of the selected department in the employee record. This is using the technique of having the drop down list on my layout, only 1 pixel wide with a related field next to it that displays the name of the department. The Department name field is a button that "Goes to" the drop dow…

Hello! I hope I'm posting this is the correct subforum. I have a layout (based on the table patient) in which I am wanting the user to be able to enter a new patient information. I have another table called referrer (which is linked to patient via a pK fK relationship). I have a field tool box set up to auto-complete and use the referrer::lName box as the auto-complete field. This appears to work great, and seems to auto-complete and fill in the name. The issue is that when the user saves the record, it creates a new record for the referrer (instead of just using the existing record for the referrer). I hope this makes sense. I'll try to clarify it a bit mor…

Hi, I've created two calculation fields for a new products release report., 1 that pulls product info from our database and formats it as HTML and the other pulls the product category name and formats that inside HTML tags. The product category name is used a sub summary so you have multiple products to each category. When I view the layout in List View and sort it by product category, everything looks as I would like it too. I've written a simple script to sort and export the foundset as a HTML file, but when I open the HTML file it only displays 1 product per product category, it seems to be omitting several products if I save the report as a PDF …

: OK, I know it was recently Halloween, but gremlins in my layouts I don't need. Anyway, I've been chugging along fixing this and reformatting that in layouts. Now, mind you, I am dealing with an FM6 system converted to FM11, and there are three database files - each with a table of the same name as the database. These are "Inventory", "Gallery", and the transaction table, "Consignment". Some of the button controls got broken after conversion, and these are mainly in layouts that reside in the "Gallery" database. So it looks like any button that navigates to anything other than a local layout (in the Gallery file) or performs a script that involves going to a layout in …

Is there any way to export a layout? I would like to be able to export and import layouts so I can work on layouts at home while users are adding and modifying records at work. Then I could come in to work with new layouts and update them at work without overwriting the database with an older copy of the file. It looks like I will have to work at night to change the layouts, and get into work before any data entry happens.

Hi, Does anyone know if it's possible to remove the slim vertical active selection bar to the left when in List View? I find when I switch from Form to List views, the contents are shifted to one side to accomodate the addition of the bar and visa versa. Thanks

Hi, Id like to print an invoice but of course it can be 1 page, 2 pages, 3 pages and so on depending on the size of the invoice. I have much FM printing experience. Whats crucial i think is how I represent the lines of the invoice. I'm thinking of an approach where I could either use repeating fields or a portal for the lines/items on the Bill. Here are some lines: bananas 10 $2.00 $20.00 apples 10 $1.00 $10.00 etc There are 2 Problems. (1) First, I want the pages to stop printing on the last page necessary. With repeating fields this is hard. If I have 90 long repeating field, and only lines…

I would like to nest my various related databases within the frame of the central database so they dont go hiding on other parts of my screen. Is there any way of doing this?

I've created a nice little report. It shows xactly want I want but as an added refinement I would like one of the summary fields I have used - a value - to be used in sorting the summary report so that as well as having something sorted by product, year and where purchased I can see which is the most expensive. Is this possible - because when I go into the script to the sort function the summary fields are greyed out.

I run a small office network with filemaker server 10 on server 2008 5 Windows Xp Clients FMP 10 1 Mac Client FMP 10 Everything displays perfectly fine on the Mac client and on 4 of the XP clients. But on one of the xp clients the display is being distorted. I have tried adjusting the refresh rate but it doesn't seem to help. Does anyone have any idea what might be causing this and how to fix it?

If I want to create a script or do a button setup to Go to Layout, I only get to pick from layouts in the current file I am in. There does not appear to be a way to select layouts of tables in other files, unless I created those layouts of the tables in the other files from within the database file I am editing. In other words, the list of possible layouts to go to is restricted to those that live in the current file I am working in/on. Am I missing something here? How can I get this done? Thanks!

Hello - I am trying to get a layout to work with. We have patients on floors. Daily work occurs with a layout which includes the floor / room number. I would like to include a part on this layout that has a index of floors and numbers of patients on each floor tallied over a found set. I would need this to be visible in FM Go. is there a solution? Thanks!! ken

I want to collect the different entries folk do in a field, but want to do this automatically. How do I force people (read automate) to do the entry in the drop down menu? Or have the entry automatically show up in the drop down menu? Thanks

I have a report that lists games played from the most recent to the oldest that runs about 5 pages. When I use the "Save As PDF" function, I get the standard save document dialogue box that allows me to name the document and save it to a folder. However, when I go to that folder, there is a new folder inside it with the document name and then inside that is the document I saved, but without a name (I didn't press the New Folder button in the Save dialogue box). Why does it create a new folder and give it the name I want to give the document, and give the document no name? I have never seen a Mac program violate the proper Save procedures like this. If I go to…

I have a DB that pints envelopes. I have set up a calculation field that pulls the information together from other fields. I do this with the following code: Case( not IsEmpty( Title ) ; Title ) & " " & Case( not IsEmpty( First Name ) ; First Name ) & " " & Case( not IsEmpty( Last Name ) ; Last Name & "¶" ) & Case( not IsEmpty( Company ) ; Company & "¶" ) & Case( not IsEmpty( Street 1 ) ; Street 1 & "¶" ) & Case( not IsEmpty( Postal Code 1 ) ; Postal Code 1 & " " & Case( not IsEmpty( City 1 ) ; City 1 & "¶" ) & Case( not IsEmpty( State Province 1 ) ; State Province…

Good day everyone. I have been asked to create sales reports summarised by month with each month running horizontally ie. in a row rather than a column, this seems to break all the rules as the summary parts only work in columns there seems to be no way to accomplish this other than adding fields for each month as it arises which is crazy. Has anyone got any ideas on this or can point me in the right direction, I have looked at a few FM examples of reports but can find nothing to give me a clue. Thanks in advance Vincent

Just moved from v8 to v11 I am unable to find the option where to select what records to print. In the help section I find: See if the Current record option is set in the Print dialog box. Change the option to Records being browsed. To see this option in the Mac OS, choose FileMaker Pro from the pop-up menu. Exactly as it used to be in v8. However not available on my computer. (see pic) So what is up here? Any ideas?

Hi, Is it possible to have the rounded corner fields on the layout? I am using Filemaker pro advanced 8.5. I am dispaying the photos in the field and would like to have rounded corners for the field. Since the image heights vary, I cannot overlap the image border with rounded drawing items. Please advise. Thanks.

i have two databases linked by an auto generated ID. i set up two tabs in the layout mode. i put all records from database a on the first and the b on the second. when i run it all the information is shown on the first tab (overlapping). thanks for any help.

Hello all! I'm hoping some of you can steer me in the right direction. Goal: To be able to populate a PDF form (or a PDF-like form) with data from the FM database. Then I would like that form to be transmitted via internet fax to a fax number which is stored in the db. Here is my question: What is the best way to go about this? Would re-creating the PDF form as a layout be a good way to go? Is there a way to take that 'layout' and have FM internet fax it, so it would look like it was the PDF? I don't need the actual PDF as much as the ability to take a layout that looks like the PDF (which I could create) and be able to take that layout and fax it t…

What's going on here? I have created some text and icon items on this layout. Everytime I go into Browse mode, they move?? Take a look in the upper right corner of my screen shots (I grayed out the rest). Why do items move from layout mode to browse mode? I have checked all formats I can and none of them seem to be any different from each other. I've grouped and ungrouped, I've tried the "lock" from the menu and nothing works. It is as if some of it wants to stay right justified and knocks off the others and moves them over. Any thoughts? Jim

When you define a layout to not autosave data, if the user clicks outside a field they get a dialog box asking them to Save/Cancel/Discard. I want to prevent that dialog and trap it so I can put up a custom dialog or force them to hit my Save/Cancel button. Is that possible?

I what to import two related layouts (one holds data used by the other) from one DB in to a second DB. Can this be done and have them being fully functional (scripts, drop-down menu, etc.) in the second DB? If so the next question is of course, how? Look forward.

I cannot seem to be able to have a layout in table view, and also be able to have a logo or button in the header to display. If i have the layout in List view the header items are visible, yet in table view the field names are the only item allowed above the layout body. How do i have items displayed in the header whilst in table view?

Expected behaviour: From the setup in the first 3 screenshots, the header part should be decreasing in size in the 4th screenshot. Am I missing something?

I would like the DB to open in the same layout and in List View. In FMP (I seem to remember) you did set the opening layout from the document preferences. In 11 I do not seem to find this feature. Is there a way of doing this? Help seems to offer no help.

I have so many different layouts that I can't see them all in the list when I click on the layout dropdown on the toolbar. I'm using windows. On my mac I think there is an arrow that allows me to scroll through them all the way to the bottom. Is there a preference setting or something I need to set in order to be able to see all of them?

Is there a way to change the settings so that the scroll button on the mouse actually scrolls down the page in a layout instead of advancing record numbers?

I have a DB with multiple tables that will store similar items, such as, Cars, Trucks, Vans, SUVs, etc. We'll calls this "Categories". I want to have a popup list that allows them to select the Category and then change the layout to suite that type of vehicle. I thought I could create a table called "Categories" and then a table for each type of vehicle. I then created a table occurrence called "Cars" where the Cars table is linked to the Categories by a key field. Since I need to add records to the Cars table, but not to the Categories table. The Categories table has one record for each type of vehicle and I created a value list based on the rec…

Hi Using Filemaker Pro 11 Advanced on Mac OS X want to make a simple autoresize field (autoheight) in Browse mode showing all the content without scroolbars and can't do it using autoresize. Only get a fixed field's height that hide data when browse and want to see all the content. For instances I want to resolve this: if the field have 2 inches of height then data more than 2 inches are hidden. Solution: If data have 3 inches of height then want an auto-adjust to 3 inches, if the next record is 2 inches of height then want to auto-adjust the field's height to 2 inches and so on. Browsing all the records want to see all the data with autoheight in the field. Can d…

But there is! I have a DB on a small drive. My DB is 864 KB. The disk is 20 MB, and 18.3 MB is available. Every time I try to make a change to the DB FMP tells me to make space on the disk in order to be able to make changes. Is this a bug? Does it need tons of space to make invisible files to safe? If I copy the DB to an other disk it has no problems. Copy it back and the problem is back. Me puzzled, any thoughts?

I just imported a layout from FMP 8. Behind the layout I had a colored square as background Colour. It refused to import, and I try to create a new background colour but it does not show. If I create it in the header it only shows there, but as soon as it overlaps it goes away. If I put it in the body it it dos not show in the header etc. So question is how to create a background colour that runs in header, footer, body?

This is a little hard to explain. I change a starter solution database layout by adding some fields in the table and check boxes on the layout. now in browse mode when i click on of the check boxes all of the ones i added highlight black. and you can't read them. i been playing with it for some hours now and cant figure it out.

how to change it on the fly or via script?

I have a report layout which is based on a table QuoteLines. In the header I want to print the primary contact (and other details about the contact) for the 'job', but each job can have multiple contacts (only one has the field 'Primary' set to 'Yes'). Basic structure: Quote Lines -> Jobs -> JobContacts -> Contacts In JobContacts (the join table) I have the 'primary contact' field. As previously mentioned the layout is based on 'Quote Lines'. I thought I could simply change to the JobContacts layout, filter out all but the one record that is primary and then head back to the report layout but this doesn't seem to work (the first related contac…

Hi I am a newby with a basic lawnmowing database. I have to be able to drag and drop records to reorder at will. Is there any way that I can do this thanks Col

I have created a single table (will add more) with fields such as 'food' 'household' 'insurance' etc. About 30 fields to track expenses. I have entered in a years worth of data and now trying to report it. each record is identified by payee and date, and than a payee might be divided into several fields. I would like any ideas on how best to present the data. I have played around with summary fields and parts, but by no means a master. Appreciate advice or a point in the right direction! Thanks, Michael

I am a new FM user and have been spending hours trying to figure out how to define a Drop Down field to show a list of data. I'm sure this question has been asked before. I've been referring to the FM Help as well as a FM for Dummies and FM 10 (the missing manual) even though I am using FM Pro 11. When I try to create a new Value List from the Manage Value List dialog box, the choices are: 1. Use values from field. 2. Use value list from another file. 3. Use custom values. I can't choose #1 because the data I want to populate my database field is not in this original file. It's in another one. I can't choose #2 because when I do choose my second f7p…

Hi! We have a problem wich we can not figure out. Our company is organized through through a system of lists with tasks, projects, responsabilities and so on. We want to migrate from a simple system in Excel to Filemaker. Here is an example of what the "master project list" looks like: NR PROJECT________________________DIVISION :::::::::::::::::::::::::::::::::::::::::::::::: 1. Install new lamp in office_________Janitors 2. Prepare monthly staff meeting____CEO 3. Decide on which candidate to hire_CEO 4. Move archive to new location______Janitors This is a very simplified version but it serves as a good example. The master list shown a…

I have a text field that I am typing text into. There are probably 5 or 6 paragraphs of information. Every once in a while, when I hit the return key to add a new field, it thinks that I am done entering text. I do NOT have the enter or return key enable to advance to the next field. When I click back in the field to trying and add more text, every time I hit the return key it saves the text and will not allow me to add more text to it. Occasionally, I've been able to hold down the shift, ctrl, or command key and been able to enter a return and then enter more text, but now I've come to the point where I can't no matter what I try. Is there a fix for…

Installing a client using FMSA 11 on a MacMini as server, 4 stations 3 running win7 with FM11 latest update, with one xp also latest FM11. In layout mode on any of the Win 7 work stations, if you select a layout, that layout may or may not be selected, appears random as to which layout may be selected. We group layouts in folders, so this may be an issue with folders, but no time to investigate further. Any of our Mac's running advanced FM11 on OSX10.6 have no problems, neither does the one WinXp station. Only way to select these layouts is to go to them in browse and then go to layout mode. Anyone know if this is a reported issue?

Hi, This forum has been awesome at solving all my issues. In my database I have a picture as the background with all the fields above. They are all set to have no fill. When I click into any field to enter data, all the fields fill in solid, obscuring the picture behind them. Is there a way to keep fields transparent during data entry? Thanks a bunch for all the help so far.

Hello: I am trying to create a customized roster in FB. I need it to have the following fields in my FMDB: 1) Official Logo 2) First Name 3) MI 4) Last 5) Credentials 6) Company 7) Address 8) City 9) State 10) Zip 11) Phone 12) Phone Type 13) Phone 2 14) Phone 2 Type 15) email 16) Committees served 17) Term expiration Thank you!

FM Pro 11, Snow Leopard I created a sub-summary report and in the leading sub-summary area I am trying to display a field from a related table. In Form view, the field displays fine. When I click on the icon for list view, the field won't display at all. I'm going crazy trying to figure this out.

I use new windows to do calculations and finds on my database to avoid errors. Now I am finding that this is taking a lot of time. Is there a way to open a new window and have it open hidden?