Layouts

Hi. I need help in customizing my file so that when I'm entering data in the Browse mode, I can see which box is active as I tab from box to box. Currently, it is a barely noticable black outline (which doesn't help because my boxes already have a black border. Is there a way to have the cursor flash in red and faster? perhaps a highlight of the entire field?

I don't know what it's called when you embed the contents from a field in text without a textfield. I hope everyone knows what <> is talking about. That thing. Anyway, when you don't know what it's called, it's very hard to search for it, but my problem is this. I'm showing results from a timestamp field in this manner. Is it possible to specify the formatting of it in this manner? It seems to display in DD/MM/YY HH:MM:SS AM, but if I just want it DD/MM HHMM, how would I do it?

I created a series of files on a Mac; I then transferred the files to a PC. I expected to have color differences, but I did not expect that the printed output from several layouts would have all kinds of spacing problems. When I looked at the layouts on screen, they appeared to look OK; but when I printed them the elements of the layouts hsd shifted severely. In order to get them to print correctly I had to move the elements around. This involved a lot of cut and try time and paper, but eventually I got them so they print OK. HOWEVER, now they look all cockeyed on screen. What causes this, and is there a way to fix it? TIA

What would be a good way to allow my database users to access various Pdf forms via the database that they could then print out for later use? Would I place the document in a container field or is there a more effcient method?

Hello folks, I'm developing a simple relational database as a student assistant on my college campus. I have a database set up with 4 tables. In short, its for a disciplinary action department on the campus. everything stems from the incident tables. One incident can have one or many charges, and one or many sanctions. From a layout perspective, I can't figure out how to allow input for multiple charges and multiple sanctions. And then search for an incident and have it display those multiple charges and sanctions. Does anyone have experience with a situation like this, or am i making any sense? ;)

is it not working in 8.5?

I'm wondering if there is a way to auto-expand a text box when printing to allow all text within a field to be displayed. For example: There are 6 lines of text to print. The field in the layout is sized to 4 lines. Is there a way to auto-expand that field upon printing to allow all 6 lines to show?

I have some text formated Diplomas in MS Word and and now I want to import them in Filemaker in order to use my Student database to print the Diplomas. Is there a way to import the Diploma as it is formated in Filemaker? I have looked around in the guide but did not find any answer there.

I am creating a layout which is a letter. Most of the letter is fixed text but part of it is variable text entered by the user. I never know how long the variable text will be. I have tried every combination of sliding and merging that I can think of to get the fixed text to merge with the variable text but I don't know how to get text (variable or fixed) to wrap to the next line (or slide up and merge with the previous line) if it does not fit on the current line. Can anybody help? I have been working on this for days and I'm out of ideas. I'm relatively new to FileMaker so I am hoping someone can clue me in on what I am missing. Thanks.

Hello, This is my first question here so I hope I can explain what I am attempting to do correctly. I hope I have posted in the proper area as well. I keep a small database in FM8.5 of my students, of course some students my have a sibling in my class as well. On my layout I have all the general information for a student as well as the name of a related student. What I would like to be able to do is click a button of the related student and be taken to that student’s record. I have tried to search the Forum but I am not sure that I executed my search correctly. I sincerely appreciate any help or direction anyone could provide. Brian Tann…

When applying colours to layouts, I noticed that I loose my colour pallette when working with the file on another machine. How do I transfer the colour prefs in the colour picker? I don't see an obvious preferences file to transfer. Thanks in advance.

Hi Folks, I have a problem with trying to close a report window shown to a user in a runtime solution because the X is dimmed out. Apparantly you can't close windows in Runtime solutions, so to fix it I will just pause the script running the report, then when the user hits the continue button I will continue the script and close the window. That's all fine, but how can I hide the Cancel button from the status area so the user doesn't invariably hit that and muck everything up ? Any ideas ? Thanks heaps Regards Paul

Hi all, This may actually be a question more geared towards sorting, but I'll try it here and see what happens. What I'm trying to do is report sales by quarters and months with the following criteria: Invoices must list all line items. Monthly and quarterly grand totals must be broken into line item sales, taxes and shipping. As you may see from my example, everything works except the monthly and quarterly tax and shipping grand totals that appear in the trailing subsummary parts. Many thanks in advance for any help offered! SubSummaryReport.fp7.zip

I apologize if this has been asked and answered but I can't find anything in the archives by a search using the title of this post as my criteria. It seems fairly random and I have not been able to nail this down, but sometimes when I am in FileMaker my screen will flicker and roll after running a script or manually changing layouts. Sometimes it will roll several dozen times. It looks almost like a looping script is running in slow motion and the "freeze window" script step has not been set. I can't really describe it much better than that except to say maybe it looks like a slow screen refresh, but the only thing refreshing is the FMP application. I am wonde…

Hi:) While I have created many databases over the years, this is my first FileMaker db. I am used to being able to query, so there has been a bit of a learning curve. Essentially, I created a db that is based off a main table (Organizations). Through the OrgId, a one to many relationship exists between the Organizations table and each of the following 2 tables: Events and Contacts. The clients I am creating the db for send letters to the primary contacts for each Org. with information about upcoming events. I have tried to add the primary contact and the event info to a layout that pretty much is a letter. The problem is if I base the layout on the Events table, con…

I am trying to remove all characters after 18- For example, I want "John Smith Is Confused About This Command" to trim down to "John Smith Is Conf" I tried using Left(cJobName;18) but I keep getting "An operating is expected here" error... Anyone?

Good Morning everyone, Is there a wqay to open a "New Window" using that script step without UNDOCKING the window you are starting from? I have a layout that is maxing out the screen real estate so I want a user to be able to call a "floating" button for information that is only required sometimes. However, when I use the "New Window" script step it undocks the original window giving me an undesired result. I know I could script a close window button in the new window that resets the original window, but something tells me there has to be a better way. Thanks in advance for any help. Steve

I was wondering if anyone has a technique they can share for presenting a report on Orders coming due. If I have a list of orders that looks like this: Order#....Due 1234......4/25/07 4321......4/23/07 5678......4/20/07 7890......4/21/07 4103......4/30/07 7654......4/19/07 Is there a way I get the report to look anything like: Orders Due Today ......7654......4/19/07 Orders Due Tomorrow ......5678......4/20/07 Orders Due Next week ......4321......4/23/07 ......1234......4/25/07 Orders Due the following week ......4103......4/30/07 Ultimately I would like to write a script that will dynamically build this report based on…

I have a database with 2 tables. Both tables have a related field called "match". Table A keeps track of the dimensions associated with individual kitchen cabinets that my company produces. Table B keeps track of how many doors each individual cabinet has. The total quantity for all of cabinet doors is kept track of with a summary field that totals the individual doors from each cabinet. I would like to display the results of the summary fields from Table B in the header of a layout for Table A but I can't seem to make this happen. [color:red]Can anybody suggest a way to view summary fields from one table through the lens of a second table? T…

Hi I would like to get my 4 or 5 page report to have a footer on the last page with the summary calculations. But my report is all in table view. It doesn't seem to allow me to put in a footer under the circumstance of having my page in table view which I need. What can be done? Thanks Dave

Hi, I have a database that manages the attached information, however I would like to be able to preview the data in the same way that excel is currently displaying it, If I use preview mode, I just get a list of records one after the other... Is it possible to view as per the attached in browse mode, any pointers would be gratefully accepted, or should I just stick to excel? example.zip

I'm sitting on "Layout A" which is showing records from "Table A". I would like to create a record in "Table B" without having to leave "Layout A". Any chance of that happening? Thanks, Mel

I have a table for hardware, clients, tickets, etc. Instead of using the "built-in" tabs feature in my layout for hardware, I'd rather choose from a drop down menu what kind of hardware it is (ie, computer, display, printer, router, etc). Once the "kind" of hardware is selected from the drop down menu, I'd like the appropriate layout to appear. I think I want to keep all of this on one table because there is some basic information that is similar no matter what kind of hardware it is (ie, hardwareID, Make, Model, SerialN). The rest of the information, (albeit a lot), is different for each kind. So if I choose "Computer", you see all computer details below. If you choose…

I see a big difference in the way Macs and PCs handle 'go to layout' commands and wonder if there's something I can do. I have scripts that visit multiple layouts while processing the data. On the MAC, only the 'Original' layout shows on the user's screen while all the 'go to's take place 'behind the scenes'. When I run the same scripts on a PC, each of the layouts gets displayed while the script is processing data on that layout. It creates a very herky-jerky, unacceptable, user interface. Short of getting all my users to buy MACs (not very likely), how can I control the undesired layout displays while the script is processing on the PCs? TIA

Hi Guys, Have any of you got a slick method of printing data out in the footer of the last page in the report. I have for example a 3 page orderlines report, and on the final page, I want to place some text & a total in the footer - what I need is "Final Footer" part in the report which does exactly what Title Footer does but at the end of the report. Thanks

I apologise if this has been asked before, I have been searching for hours and I have read the FM help. (over and over and over...) Basically I have a layout with a description which will need (occasionally) 4 pages of text with a total at the bottom. Since the text is of variable length I have stretched it to the maximum that it will need (as suggested in FM help) and used the sliding/printing option to shrink. Only when this happens it leaves 4 blank pages after the record. I tried adjusting the part 'body' option which removed the blank pages but when text was entered beyond one page it didn't print the extra pages either. So I'm not sure what I'm doing …

I've got a portal set up that is inheriting the text colours from the related fields I'm dislaying. Resetting the portal field's text colour doesn't work - the text format for the field says it's already black (rather than colour-coded like the corresponding fields in the related file). Is there any way of overriding this without changing the related field's text formatting? Kevin

Hallo, I work with filemaker pro 6. I have created a one-to-many relationship and I now would like both, the data + the related data, to be displayed not only in the "view as a list" view, but also in the "view as a table" view. Both views are in the browse mode. If I switch to table view, Filemaker only shows one related field with one value. In my case, there is just one teacher for one course shown,although there are 5 teacher that are being shown in "view as a list" view. Thank You Ralf from Kampala / Uganda

Hope this is the right section of the forum to post this.. I have a Category table. Each table has a optional parentID which refers to the CategoryID of its parent. I need to create a layout, suitible for printing. It needs to show the first category, then its child categorys, then the second category,... My question: 1. how can I say which category is the first to be printed? 2. how to show the child category's after each row? I think I will need to change or add some fields to the table, no?

I have been using FM7 for some time and have just upgraded to FM 8.5 advanced. It seems in FM7 you can only select a colour theme when creating a new layout and not superimpose one on an existing one- can anybody tell me if 8.5 can do that - I know I can manually change the colours in the header/body/footer. I have checked in the (downloaded) 8.5 documentation and I can find no mention of it. Any help would be great

Hi, Is it possible to add custom buttons to the menu pane to the left of the workspace, sometimes when I'm running scripts a button will appear to say continue, I have seen some that say exit. Also can you add buttons in preview mode, so that a user could export a sub-summary report? Cheers, Dan ;)

Hi, I have set up an invoice layout, with each record having a few fields that repeat 12 times. However, often the number of fields doesn't reach this number, so i am left with a lot of blank space between each record. Is there any way to solve this problem ie so that the body section shrinks if the repetitions do not reach the max. The closest I've come is to just make multiple reports with different numbers of repetitions and then when it comes to printing the script can choose the best one. any ideas? many thanks

I'm wondering if anyone has a BRILLIANT idea for highlighting a record in list view so User knows what record is active. I'm looking for something semi dramatic. Something more then the old transparent field, object mask and body color trick. Anyone seen something COOL and NEW! I'm excited to hear any tips! THANK YOU

I am building a test management system for our company laboratory. This is my first project using FileMaker ( I took over this account from my predecessor whom much like my self was more familiar with traditional programming techniques. I have created the following form to allow them to enter data into the database, but I am not sure how to properly print it. As you can see from the screen shot the text in the text field extends beyond the visible area. Is there a nice way to print this? At some point I will also need to be able to print an entire document containing the "Description" "Procedure" and "Conclusion" fields. I am aware that I will need to creat…

Hi, I'm having a problem trying to enter a value in a layout from a related table. Let say Two tables. evaluationFile (pkEvaluationID, fkSoldPropertyID) soldProperties (pkSoldPropertyID, ckSellNumber, address, blablabla...) Both table are linked via the pkSoldPropertyID -= fkSoldPropertyID. Bigger image The user cannot view the primary key (pk) field. He can only use the candidate key (ck). How can a new evaluation be automatically linked if the user enter the ck in a layout? Any advice would be helpful!

I have an insurance company DB. What I want to do is to be able to add additional agents licensed with each company by clicking a button and it opens up a new line to add a new person. Any thoughts to get me started on this? Right now I am just in the thinking stage about how to accomplish this task. Thank you, Jason

I am trying to get a predefined label layout (Avery 5160) to display a printable page in instant web publishing. Currently when I publish the database the labels view lists records in a single column instead of the three column layout as in appears in FMPro. Any ideas?

Hello. I have a text field. I also have a calculation field whose result is the text of the text field. On my layout I display the calculation field so that the field can be scrolled, but not edited. My problem is that I have noticed some fields that contain certain text that causes the calculation to give a numeric result instead of the text. For example, if the text field contains the following text: Evaluate and optimize ICC profiles for the Creo EverSmart scanner (for scanning transparencies) to achieve the best possible visual match between monitor and transparency when viewed under ISO/DIS 12646:2002(E) conditions (Annex A section A.1). then the calcu…

Is there a way to avoid the originating window being resized when running a "New Window" command in a script? Thanks in advance!

The CD sales database contains the following tables: Products [various CDs by various Artists] Artists Invoices [sales of CDs to various Customers] LineItems I need to produce a report summarizing sales for a period of time, as follows: Artist _______ Product ________ # Sold _______ $ Total I *think* I need to attach my layout to the LineItems TO. From there I can get LineItems::Quantity LineItems::ExtendedPrice LineItems::InvoiceID > Invoices::Date LineItems::ProductID > Products::CDTitle LineItems::ProductID > Products::ArtistID > Artists::Name By breaking at each ProductID, and summarizing on ExtendedPrice, I…

Hi Guys, Is is possible to change the background colour depending on whether the users is in a specific mode. I thought it maybe helpful to my users to identify when they are in Find Mode (as I have toggle hidden), and the best method to identify the mode you are in is to allow the background to change say into a pale pink instead of a traditional white which I intend to use for browse mode? Any thoughts would be most welcome.

Always when the mouse is touching (without click) the filemakerwindow, this toched fm-window comes automatically to foreground. this is very nervy at makes me crazy -)) Other windows come to foreground only with click. Is this filemakerimmanent or ...?

Hello! I'm woundering if it's possible to change tha color of the Body part? I've tried to find a way to do it, but i didn't find anything =/ Thanks!

I would like to add a button rollover feature to my applications. Open the following link: Menu.fmp Move Mouse over graphics, popup text appears indicating what the button does. How is this done?

Can anyone direct me to instructions on building a 'picker' layout? I've got a data entry layout and want the user to choose a client's name from a list and have that client's id entered. There's a couple hundred clients to choose from, so a drop down or pop up is too unwieldy. I'm not sure where to start. Thanks, DJ

Hello, Here is a file containing a report on the available layout space in relation to multiple screen states on Mac OS X 10.4. I would really appreciate it if some windows users could use the file attached to report multiple screen states on your OS... Windows Vista Windows XP Windows 2000 FileMaker captures most of the data but you will have to enter if the FileMaker Toolbar is displayed ... please add any further fields you think neccessary for other windows only states. (I know you can show and hide the "status bar" (not the status area) and would like to see this in action. screen capture sizes may have to be reduced in order to post…

Hi! This is my first post here, so I hope this is in the right place. I am an experienced software developer but I am new to FileMaker and I have to make a simple application for a firm that lists hired people, the projects they are working on and so on... The first thing I did was a main menu with a few buttons on it. Now, from this menu you should be able to move to a list of hired people. Every row in this list would contain date fields, text fields, number only fields, dropdown lists and fields automatically filled when data is entered into other fields. The whole list would also have buttons to add more rows to the list (more people, that is), remove s…

Hi: On a Mac using Filemaker 8.5. I selected a fill color from the CMYK Sliders of: Cyan: 100 Magenta: 50 Yellow: 0 Black: 0 and applied it to a rectangle object. When i selected the object and checked the fill color the CMYK Sliders read: Cyan: 89 Magenta: 50 Yellow: 3 Black: 4. Why would it change like this?

Say I have two subsummaries, for the total hours worked. One is for Employee, and the other Month of the year Is there a way to setup the layout so that the employees are the rows, and the months of the year goes across as the columns? Below is what I'm trying to do. eg.. ---------| Jan | Feb | Mar | Total Employee1| 50 | 2 | 24 | 76 Employee2| - | 1 | - | 1 Employee3| - | - | 12 | 12 --------------------------------- Total | 50 | 3 | 36 | 89 The layout of the months should be dynamic. Thanks, -dave

this is probably one of the most basic questions i can ask, but how do i trim all characters after the space in between first and last name..?

I am currently working on a new project with filemaker, and I need some help. I need to have the ability to store n files for one record. In other words I need to be able to have: Record #1: 3 related files Record #2: 1 related files Record #3: 7 related files Record #4: 4 related files Record #5: 1 related file I have set up two tables: And what I would like to do is set up a layout with a "drop box" of sorts for files. Essentially a container field that clears itself and moves the files into the data_files table, which will then be displayed in a portal as a list of files.

Can anyone tell me if it is possible to have an 11 1/2 X 8 Preview instead of 8 1/2 X 11? Thanks, Mel

hello! I'm beginner.please tell me how to use field/control tool?thanks.

Hi, I have a file that is behaving strangely. When changing the view between Form and List modes, either manually or through a script, the program always asks "Do you wish to save this change with layout?" Under Preferences/Layout: "Save changes automatically (do not ask)" is checked. This happens only when the file is opened from server, when opened locally there is no question. Any ideas how to correct this? Jari V.

Hello, Well I’m stuck again. I am still working on my “Victim” database here at work and have a question about photos. I have an area with a container for the victim’s photo. What I want to do is have the container that is not used for a victim’s photo default to a “No Photo” image in the container. I have the “No Photo” JPEG constructed, but I do not know how to make the Photo Container default to this image. Hopefully to clarify: when a new victim record is created, the photo container automatically shows my “No Photo” JPEG until the user adds a photo of the victim to that container. Can this be done? Thanks, James

As much as I have tried, I cannot find a way to get the 'Directions' option of Google Maps to work. The basic code I am trying to use is: http://maps.google.com/maps?f=d&hl=en&am%20p;saddr=/*source address*/&daddr=/*target address*/ The Google Maps page comes up, but only with a map of the target, it doesn't give me the directions pane.

Hello filemaker gurus! i am trying to use the "set next serial value" function. I have a field ,set as auto enter serial number. So why it does not work? Someone can check it? thanks! stefano trial.fp7.zip

Is there anyway of adding to or customizing the fill and pen patterns that come with Filemaker?

Hi, I have an email address database with three layouts. All three layouts display the same name and email address but different qualifiers (e.g. layout 1 - Safety Committees -- name, email, position, name of safety committee; layout 2 - Mgmt Committee -- name, email, position, name of mgmt committee) I created my layouts to display in list view. Now, is it possible to selectively display records in the different layouts? the reason I'm asking is that there are people that occur in both, safety and mgmt committees, and I do want those to show up in each layout, however there are those, that only belong of the layouts, however they also show up in the other .. (…

Are there any rules regarding amending fields whilst using multiple windows? We are using FMP over Lan network and several users have queried that information they thought they had added to fields has apparrently disappeared. The database is a "One File/Multiple Table" system. Is it possible that it is the use of multiple windows that could cause a problem?

Hello, Since I want to hide the status area, I'm trying to show the record number of the found count within my layout. I'm using Get(Recordnumber), Get(Foundcount), and Get(TotalRecordCount)in a calc that looks like this: "Viewing Record: " & Get ( RecordNumber ) & " of " & Get ( FoundCount ) & " Total Records:" & Get ( TotalRecordCount ) When all records are showing it works fine, but for some reason when I do a find the record number remains the number it was when all records were showing, and the found count remains the total count. For example, if I have 100 records and Mr. Smith is record 49, when I find for Mr. Smith (assuming…

How can I execute a script whenever the person changes their layout? I want each layout to sort records differently. thanks, dave

For months I've been trying to come up with a method to 'hide' the first field in a value list after it has been selected. I want to use a value list that draws from a table and stores the key field while always and ONLY displaying the 2nd field. For example, I have a table called reps that has a rep_id field, and a rep_fullname field. On an order table's layout, I have a field for 'rep' which is a value list that draws from the reps table. Everything works fine so far, I've got the value list definition set up so that only the second field is displayed. Except after the user makes their selection and moves to the next field, it is the value from the key field that …

Hi, my name is Kellen. I am new to Filemaker and I'm making a database for a free medical clinic I work at. I can't figure out a problem that I've been pondering and researching for quite a while now. no posts here hit upon it: I have a layout that shows records of medical clinics in a list (maybe 15 per page). I have other separate layouts that display the same records in different manners, more condensed, different information about the clinics, etc. I want to be able to print a referral sheet for clients that will have major clinics listed in a more detailed way then right after that, more distant or less important clinics listed in a more condensed format (tha…

Hi everybody! New here - quick question which I'm sure is asked a lot, but I tried searching under "list view wrap" "list view row height" and a bunch of other queries, but can't find the answer: Is there a way to set up a layout so that in list view, if the contents of a field are longer than the column permits, the field displayed/printed will automatically get as tall as it needs to to accomodate the data? Basically, the goal is to have each record take up one line if possible, and if any particular field (free-form notes, for example) exceeds the width available, then the record automagically gets as tall as it needs to without making any of the other r…

I am not sure if this is where I should post this question but.... I have a script that finds the current events in a db (FM 8.5). Current meaning active events that haven't happened yet. The layout I view these events is in list form and I would like to be able to quickly spot the events that share the same date by having their displayed fields ( Artist, Venue, Start date, End date, and Engineer status) backgrounds change from white to a color. If anyone here has any ideas on how to do this I'd appreciate it. Chris

Hi I have a date field in the header section of a report format that is not printing, but can be seen in both Browse and Preview mode. In the header section in Browse mode there are buttons, that are not printed, and a title field that is printed in the finished report. These are set appropriately. When it comes to the print out there is no date just the outline of the field. I have checked the font colour, background colour, sliding/printing settings, but can't seem to find the reasons for the problem. Any help is gratefully received Thanks :)

FMP 8.0v3 Avery 5160 address labels 2.625" x 1.0" The automatically-generated layout for Avery 5160 is only printing 9 rows of labels per page. Should be 10. I'm totally confused by how to configure. The top left corner of the top left label is at 0.5" from the top and 0.375" from the left (of the physical 8.5x11 sheet). Each 2-5/8" x 1" label is separated from the next by a 0.125" gutter horizontally and a 0.0" space vertically. The automatically-provided layout for 5160 just looks wrong: for one thing it contains a header part that's 0.236" tall. The fixed page margins (in Layout Setup) are: top=0.25"/bottom=0.56"/left=0.19"/right=0.19". Th…

Has anyone seen an improvement in the window redraw flashing using Vista?

My layout has a field that uses a radio button set. I would like the field to show the No button selected when the layout is displayed, but can't find a way to do that. Any help would be appreciated.

Hey everyone, I'm designing a database that will have information in fields that may or may not be confidential. Rather than creating separate confidential and nonconfidential fields for each piece of info, I was hoping it might be possible to have a checkbox for fields that can be activated when the info is confidential. The question is, how can I do this without creating a checkbox field for every single field that I am making? Not possible?

Hello all. I would like to know the best way to replace/update a layout without causing problems (as I recently did!) Recently I needed to work on a layout (add a few fields to the layout, shift some things around). I created a duplicate of an existing layout, named "Existing Layout Copy", and made my changes to my copy of the layout (while the dbase was hosted). Then when all users were out of the dbase (but it was still hosted), I changed the name of my layout to match the existing layout (since 8 allows layouts with identical names), then IMMEDIATELY added the word "OLD" to the previous layout. I also moved my new layout to the same position in the layout li…

Hello, Could someone please explain how come sorting and preview mode are needed for a subsummary to work? Is this intuitively obvious and I'm missing it? I've read pages 48 and 68 in FMP 8 User's Guide without spotting anything about this! Otherwise, I am just doing this mechanically without understanding the underlying logic. Thanks in advance and cheers!

In searching the forum I see the recommended solution to making a multi page cover page is to drag the Title Header down past one page tall. I've dragged and dragged until now it's down to 46 inches. My cover letter text cuts off mid line at the bottom of page 1, and the body of the report starts at the top of page 2. Half the cover letter is cut off. Do I need to drag it further? or am I making a different mistake (margins perhaps?)? The multi page body of the report works fine. I've not tried the multi page bottom material of the report yet.

I can't get a basic layout graphic to show on the web version of my database? A simple circle won't show (created with the FM tool) or any other pretty things I added "Unless I change them into a graphic in say photoshop" and cut and paste it in... Is it me or what am I missing... Have I lost my mind? Thanks anyone!

I'm wondering if it is possible to open two tables at the same time from a single database. Is this possible?

Hi, Being newbie is always painful. A very simple question - I use a custom dialog box with two INPUT fields. How do I read this values ?? thanx

Hi all, Wow, this site makes me feel dumb...so I hope to learn a lot! I just bought FM 8.5 Advanced for a development that I am doing (having used FM6 in the past and liked it). I have, what is in essence, a real newb question - how to change the focus order of the fields during data entry? When I hit 'add new record' it seems to start at the bottom of my field input list and not where I want it. I've scanned all the documentation but this is not clearly mentioned. Any help would be thankfully received, and I look forward to becoming a member of these forums. Thanks Rich

this seems like it should be obvious, but i'm not seeing it! i have a layout in list format. i want to add a set of values in the list, for a given parent record. is there any way to have a new record created automatically when i tab out of the last field in the view?? i've added a button to the header to create a new record, but i'd rather have it happen automatically, so the user can just tab through a long list....

I currently have setup an employees table with a unique identifier, first and last name. Visually --------------------- | Employee --------------------- | id | first name | last name --------------------- It has a relation to a Time Entry table which contains an employee identifier, a date, and the number of hours worked that day --------------------- | Time Entries --------------------- | employee_id | date | hours --------------------- Now I want to create a layout to summarize the data but at different granularities. Eg. One report would show how many hours an employee worked each week Another report would…

Hello! We run our business from a Filemaker Pro 8 database we designed and built ourselves. It works very well for our purposes, and has been highly customized to make our lives easy (this is the truly magical benefit of FileMaker Pro). However, one aggrivating issue we haven't been able to resolve involves getting text that we paste into fields in our database (usually from a website) to conform to the size, color and font we use for the rest of the database. We've checked through the text formatting options for all of the fields, and eventhough they're all the same, when we paste text in, it maintains the color and formatting of the webpage we copied it from. The …

Hi, I'm struggling with the fundamentals. I've got a layout that works for me but I can't find the solution for my next step. I want to make a nice-looking cover sheet which will be the first thing you see when you open up the PDF export of the layout. I can't work out what I need -- is it a new record that I then re-design, or is it a layout part of some kind? I really just want to put some graphics on an A4 page with some text and stick it at the front. Thanks for any tips. I've trawled help without success. Phil

Does any body know why we can't insert EPS vector art file graphic files? My logo is currently in jpg and when i make a pdf the logo is very lo-res. any suggestion how to increase the look of my logo without increase the size of the pdf. 1 pdf is 10 KB. Maiton Vang

Hi I have produced a layout formating a report for printing. Users add info to the two columns and they change the size of the column so there is not too much white space (as and if required). Unfortunately the resize option is not working for the user. I have checked the tick box for resizing columns, checked the priviledges of the individual, checked the page margins, but the user still has no access to resizing the column part of the layout. Am I missing something here? The full access user is able to resize columns in Browse mode but other users are unable to. Thanks for any guidance

Solution / Multi Page Layouts Description: HI There, We are using Multi Page Layouts using this format: ######################### Header Info ######################### (header part) Body Text ######################### (body part) Footer ######################### (footer part) I know that you can place a blank page at the start of the document, to use for a cover page. My questions is: How do I create a blank page (for terms and conditions) at the end of this multi page Layout. Thanks in advance. Working Under: Solution Status: Beta Pre-requisites: Author(s…

Hello! I want to generate 2 reports. The format is shown in the pdf within the attached archive file. Following the explanation in FM User's Guide, I created the fp7 within the attached archive file. The layout "aggregated monthly report," in Browse mode, scarcely looks like what I'm trying to achieve! In Preview mode, it is totally blank. I searched these forums and found a zip file named "Report_Date." It works perfectly. In comparing "Report_Date" with my file, I must be missing the obvious as to how come it works perfectly while mine flops. Additionally, I am totally puzzled by the following behavior of "Report_Date." 1. In Browse mode, the l…

Hi, I'm using FMP 8.5 Advanced. Simple question: When I have a multiple layouts with the same perfectly-aligned menu buttons, etc. at the top, and I switch among them in "Browse" mode, the transitions between layouts are completely smooth. There is no "bounce" of objects left-right or up-down. However, when I use the same perfectly-aligned menu buttons (and entire layout for that matter) in a layout that is set to List View only, when I nav to that layout, a vertical white line perhaps 3 to 5 pixels wide appears, from the very top to the very bottom of the layout. This is annoying as it causes the entire layout to "bounce" right by 3 to 5 pixels. I nee…

Just wondering, what I am calling dynamic layout. I mean, when you sort records usually for printing purpose we do configure a special layout with fields we would want included. This layout has sub-summary part and also a trailing grand summary, and of course head and footer. Lets supose we have product field named A and category product field named B. It is normal to want reports based on field A and another based on B. Is it possible to have a single layout for both reports? Could be possible to configure a script which would define the parts of the layout, or even change the field positions, change the header and footer? Thank you, Toni

I have an entry layout with some numeric foreign key fields: Location, Client, Worker. How can I make it easy for users to enter the correct numeric key? Currently, I have value lists showing the key and the text name and drop down menus using those value lists but that isn't completely satisfactory. The Locations drop down is between 1-5 values (depending ont he Client). The Clients value list is about 40 values and the Worker value list over 100. That's a lot of scrolling. Then the field only shows the number key (which is really irrelevant to the end user), so I need another field to show the name (a non-enterable field direct from the related table). I'…

Hi, Forgive me for being a bit dim this morning, but I can't remember how to do this. I'd like to be able to use a <> to display the current layout with each of my layouts. However, I can't seem to get the calculation correct to make it actually work. Currently, I've created a calculation field called "Current Layout" and I've set it equal to: Get (Layout Name). This isn't working, as when I jump back into Browse mode, all I get where I should have a Layout Name, is a question mark. I am sure that I did this correctly in one of my recent projects, but I'll be damned if I can find it to copy from my own work! If one of you can please remind me of how to do…

Hi, I was wondering if this is possible: I have a field for a case number. I want to start the number off with the year and then an incremental number following it. I want to make the case number prefix (the current year) change with each New Year. Example (for 2007) 2007-0001 then the next record would be 2007-0002 etc. Then when the new calendar year starts...the number would change to 2008-0003… 2008-0004 etc. Or I could even live with the new year starting over at 200?-0001 I currently have the field set to Auto Enter a serial number incremental by one (2007-0001) but of course that will keep the 2007 plus the increments e…

Is there way to change the display in a field to something less jarring?

Trying not to print a portal, so instead printing a list view of the related records. But most of the data is in the primary table and I need that data to show up in the Title Header and slide.

So I have searched the forum for answers and still can not find something that works. I have a print layout that contains a header, leading sub-summery, body, trailing sub-summery and footer. There is one row of fields in the body and when printed it should look like a spread sheet. The fields are two lines tall and are set for sliding when printing. I would like to have vertical lines between the fields in the body. I have tried to draw in lines and set the left and right borders but nothing works right. Anyone have any ideas?

I have a layout that has no records created in it and in the status bar it shows "0" in the record field "0" in the found field as expected but, "2" in the total field. Any reason why this might be happening?

I am new to Filemaker and I wanted to know if there was a way to have an edit box auto line format for me like Microsoft Word? I would like to be able to type and when I press enter it goes to the next line and automatically inserts the next number. Example: 1. 2. 3. etc.

Hi All, I have two databases, within one is a value list that provides preset timings for the start of a booking in the format 10:00 etc. This just fixes the start of the booking at half hour intervals. When i try and link to this value list from the second database, the link is good but the list has added and extra :00 ( i guess seconds indication) to the value list. ie i now get 10:00:00. I have tried all the different formatting options which only seem to affect the data after you have chosen the relevant option from the value list. How do i change the formatting when displaying the value list? It's bugging me but i'm sure it's something simple! Any idea…

This is probably a dumb question, and one that I bet has already been asked, but I'm a beginner and couldn't find the answer in the search. In my file, each record has a field that generates an automatic serial number when a new record is made. But I want to create another field that if used will search for an old record and will replace the old serial number with the new serial number? Does this make sense?

Ok, this seems like it would be so simple. I have a tab with different buttons on it to signify different searches. I have these buttons named through the Object window. I have done this so I can pass the Object Name, using Get(ActiveLayoutObjectName), through a script parameter. The object name would then be used as a search criteria that would be inserted in the script by the script step Insert Calculated Result. I am trying this solution so that I might only create on script for all the searches. My hope was that when the named button is pressed, the name will be pick-up by the script parameter but it is not happening. Any suggestions would be much …

Hello I have a small database I use in my class. The layout contains general information about a student as well as 3 photos. I want to be able to produce a report (which I already have constructed) with the student’s information on it as well as one of the photos I select from the three. How do I check or select any one of the 3 photos on the layout and it be the one that prints out on the report. Thank you, Kimberly My computer is a Dell 9150 I use Filemaker 8 on XP Home if that helps