Layouts

I understand you can block a individual field in a record in the table field outline. But, can you leave it open in the table outling and block minipulation in the layout to protect the information in normal data entry, but have it open to editing or adding to in another field? Thanks The Tramp

Not sure if this is the right location for this question, but here goes. I am not sure when FileMaker made the change, but it is starting to cause some problems for me. If a user is in a field and selects another window, that record is still active, which locks the record from being changed by others users. Before, when you changed windows, the field/record was exited. Is there a way to change it to exit the field/record when another window is selected? Using FM 8.5/9 on Mac OSX. Thanks for any help Shawn

I have a Dymo 400 with 99012 labels and am trying to create a layout so that I can print out labels from my database. I have tried using both creating a new layout and choosing labels and also just creating a box and moving it around until it happens to line up. Has anyone had any experience successfully getting labels out. Any help would be appreciated

I am using Filemaker 9 and 7 I need to display a number in scientific notation to one decimal place For example, if I create two number fields, A and B and a calculation field A:B ratio, and: Field A = 1 Field B = 654321 A:B Ratio = 0.000001528301858 I want the A:B ratio to display as 1.5e-6 If I use “General format” for the ratio field, it displays 1.528301858e-6 Is there a way to truncate the number of decimals in the display of the calculated result? Any suggestions most gratefully received…

I am trying to make the LayoutNames function work without success. I calculated the following (see attached screen shots) from Define Database. It creates an empty field; indexing brings up the index list box containing nothing; the database contains nearly 100 layouts. Thanks in advance for wisdom and assistance.

I am in need of creating a report which summarizes Test scores by Job (not by person). Each person does a particular job and is tested for it. Those people pass the "job test" by a Weak, Moderate, or Strong amount. There are ranges for that which are calculated and I am getting those to work just fine. The problem is, I cannot print a report that shows this by Job. When I choose a sub-summary by Job, I get EACH person's score. I want to just show the total for each job i.e. Total Weak, Total Moderate, and Total strong. I have "total" fields created however it displays multiple times. Why are they showing up as many times as there are records? I don't ge…

First, let me apologize if I've chosen the wrong forum to list this under. Those in the know will probably move it soon...thank you for that. I checked the knowledge base first and nothing came up for Xerces Panic Error. Here's the problem. I'm having trouble copying portions of one layout to another. When I highlight what I want to copy and press Ctrl+c or the Copy button at the top of the window, I get the following error: [color:red]Xerces Panic Error...Could not load a transcoding service. When I click OK, FileMaker shuts down. Is anyone familiar with this error and what causes it, or better yet, how to fix it? I would appreciate any feedback. …

This should be simple?? Whenever I create a new layout, its size is limited by the print setup page size. For a layout that I don't want to print from I want to have an unlimited size if possible (at leat so I can fill the whole screen? Any suggestions? Thanks

I am having an issue with Layouts that I don't understand. Lets say you have just finished entering a new record with all the data in the tabs as well. You go to hit the "New Record" button and accidently hit the "Duplicat Record" button instead. So needless to say you hit the "Delete Record" button. Well, when you delete the new duplicate record it also delets the origional file and all the data in the underlying related tables as well. Why, and How do you stop it. I can logicly explain why it would delete underlying related records but why would it jump to another record by the same ID number and delete it as well. Thanks The Tramp

Hey Forum, this is ridicoulous...I cant get my bottom margin to work right. I have a brandnew layout and am testing printing "to the bottom of an A4 page". I put one big Text item on the layout filled with "test test test " about 10000 of them. All in all it goes over the bottom of the page onto the next page (561x904 pixels just for info). I then print page 1. The Margin it leaves at the bottom is EXACTLY 21mm. Thats much to much for what I want. But I have an example of an old old old FM Printout clearly showing that a margin of just 10mm was achived a long time back. In Printsetup I correctly choose A4 Format. I have tried to play…

At the moment in my Table View Layout all fields run across the top and all records run along the left is there any way of changing this around so that records can run along the top and fields to the left?

I have a layout with check entry record fields in the top section and check distribution record fields in the bottom section. The purpose of this form is to enter check entry information and the 1st check distribution information. The two records are joined by a relationship. Entry in the layout is fine except that the dropdowns fail to populate their respective name fields the check entry record (see next paragraph). They work fine in the check distribution section. Example of the failure: The check entry section has a Vendor ID field and a Vendor Name field. The Vendor ID is the dropdown field and this field works fine. The Vendor Name field fails to appear (it has…

I have an invoicing solution and need to put a summary of all outstanding balances on the invoice layout that I send to the client. I send the invoices out monthly and do a find to print all the current invoices for that month. The problem is that when i do that find, it doesn't let me show a summary of each clients outstanding balances. Only shows for the current month. Thanks

Hello everyone Is it possible to insert a left frame in the layout, like the one for example when you browse a database using http? It should be a frame with butons and links, always available on the left, indipendent on the scrolling of the page. Thank you

Hi there. I'd like to know how to put an svg graphic into my header. Please tell me if there's a way to do this; I see only options for jpg, bitmaps, png, etc. Thank you.

I created a layout and then later went back and moved some fields around. Now when a user is in the data entry form and uses tab,enter or return to go to the next field, Filemaker goes to the field that was originally in that same place but is now in a different spot on the layout. Do I have to re-create the layout and add the fields in the order that I want them to be tabbed to?? There has got to be a way to avoid this and set the go to next field in Field Behavior to what you want... Any info is greatly appreciated. Thanks!

When I want to print an envelope I must change the printer setup options. Then it stays that default for all my layouts How do I save the layout (such as an envelope) with those printer options

Order entry description, on occasion, can be really long. Our products are remanufactured, and sometimes the description of what is being sold is, well, a short novel. How can I conditionally display, say, on an invoice, the detail behind the line item? Most line items are under 30 characters, and fit fine, but the occasional one either needs to support a really long description, or the attachment of a descriptive note. The other alternative, which poses a similar problem, is the invoicing of the top line of a bill of materials, with the bill of materials displayed below it. I'm thinking that a sub-summary report might solve both issues, but other ideas …

Is there a way to bring up a window and NOT allow the user to resize it? I want a fixed window for data input but I dont want the user to be able to resize it at all?

I have a old fm file that I changed to english but the system format in the file displays german, euro signs, index and so on. Is there one global setting to switch to english? I checked prefs and doc setting but I cannot fine anything.

How do you change the text label on a button after it has been created?

I would like to display a set of application buttons on every layout along the left hand side of each layout (without copying them on every layout). Is this possible? If so, how?

Hi I'm working with multiple tables in one filemaker file. I have different layouts for the different tables, and sometimes need to have two windows open at a time, reflecting different tables. Is there a way to assign a windowname to a layout? The scripts I've created for navigation depend on the windowname, and being able to assign a windowname to a specific layout at all times reduces the risk of error for my scripts. Thank you!

Hello, is there any way to duplicate a record without duplicating certain fields? Thanks, Samuel

I have a Database that does calculations and displays data for a report. I have a script that does a "Delete all Records" at the beginning so the old report is cleared out, and re-imports data for the new reporting procedure. The problem is that even if there are no records, my Layout is still reporting values in some variables just before I import data. Most reports do not use all the Display variables I have so these "no data" values are still showed. Is there anyway (other than a script step that sets all these fields with nulls and zeros. And I'm not sure that will work anyway because there are no records in the DB when I need to set values) to do th…

Is it possible to have the header not move in a database when in form mode? Similar to how frames work in a webpage, if you scroll down the body, is it possible for the header to just stay put and not scroll down as well? That way you always know what the title is of the record, even if you're at the bottom of it?

(Not sure if this is the most appropriate sub-forum for this question. If not, please suggest a better one and we can move the discussion there.) Can anyone suggest a technique for transferring a found set from one window to another, already existent, window? I know that one can use the New Window script set to create a window whose found set is the same as the one active when the script is executed, and I know about using Go To Related Record to show related records in the same window or a new window. But the missing piece is showing the records in a distinct, but already existent window. I'm using a workaround that first destroys the target window and t…

I need to archive a lot of paper documents in manila envelopes. I would like to include some information about each project on a mailing label and affix the label to the envelope. I've tried this a couple of times in the past without success. I can't remember what the meltdown was but I recall it had something to do with the particular Avery label I was trying to use. Before I go to the office supply store in search of new labels, can anybody recommend a particular label that's about the size of a business card. I would like to be able to do this with a pre-set layout from the labels menu. Thanks

I'm adding a Flight Tracking Module to my Event Planning Database. No problem building the relational tables for tracking multiple flights or anything like that. The only problem I am having is with the Flight Tracking Report I'm building. The summary/sub summary report is sorted first by Home Gateway, then by Arrival-Departure Pattern, with the body containing delegate information (of not all the sorting functions and that output is working flawlessly). The specific problem I'm having is that in the record row (body) which is one per delegate including their name, passport number, etc., I cannot get the multiple flights information to slide up if the above fields are…

is there a way to select what row or column a label will print in? it's hard when we are printing one label and it always does the first row/column thanks!

How do you get pasted text to comply with a field's formatting? The online help says that pasted text is supposed to take on the filed format settings, but mine is not. I am copying info from .pdf manuals and I have to adjust indents, etc. Fitz

I am very new to filemaker.A complete beginner.I have a table that has a field named date and a field named #of nights. This is associated with room bookings. I need to create a calculation that will generate the actual dates associated with the number of nights. Example: Start Date: 01/01/08 Number of nights: 5 I want to generate the dates as follows in separate rows: Calc Dates: 01/01/08 01/02/08 01/03/08 01/04/08 01/05/08 How can I do this or what formula can I use to look up the start date and multiply the nights?

Hi All. Please bear with me as i try to explain this! I have a report layout that I need to create that will replace a paper form currently in use. The form allows for the inputting of several fields for an invoice. The fields are repeated 4 times on the form to allow for 4 invoices. I have my database created to where the invoices show up on the recreated form in the database, but the fields only show up for the related invoice records. For instance if there are two invoices, you will see the fields for both, but the form will not show the blank fields for two more invoices. Is there a way for the form to show the fields for all 4 entries? I am required to…

I think this is the best place to post this question? I am using Filemaker Pro version 9. I have a text box that allows user to enter text. I also have a portal item that allows user to enter many records associated with the text box I just described. How can I update records in the database to reflect the text in the text box item and have it associated with each portal record being entered? The index is correct I just need the ability to update each item with the text from the text box??

I am new and seem to be having problems with layout I want to create layouts that relate to each other such as writing letters or forms that use the same fields such as persons name and address but when I enter a new layout it ask that I enter a new record and does not carry the persons name and address over to the new layout. I have set up my relationships and can not work out what else I am suppose to do.

This is so weird! I have a database that has about 3000 names. Every time I have a layout with a merging "first name" field, all the names turn out to be fine except one "Elizabeth" is always in a smaller font than the rest. I tried erasing and retyping the name but did not work. Any ideas? Thanks!

[color:blue]I need to figure out if its possible to create a Windows Explorer style layout, where I can create a list view of customers on the left-hand side, and write a script so that when a customer in that list is clicked, a list of jobs for the customer is displayed in the main body. Does anyone know if this is possible? I think I can figure out the scripting part, I just can't figure out the layout part...

Has something happened between fmp8 and fmp9 to mess up the technique for making objects appear and disappear from a layout? I'm referring to this technique: -- Define unstored calc uc_Charge = "Charge" -- Define self-relationship ShowIfCharged based on uc_Charge = PaymentMethod -- Create 1-row portal based on ShowIfCharged whose dimensions are 217x63. -- Place a 215x61 box containing some text atop the portal, being absolutely sure it nests fully within the portal. Finally, I want this text box, if shown, to slide upwards. I select the portal and all the stuff lying inside it, and set sliding on / directly above / reduce enclosing part. It worked on …

Hi everyone. First i would like to say thanks to those who have helped me previously in this forum. This should be a pretty simple question, but i need someone to point me in the right direction. I am building a database to manage sales, inventory, employee and customer records amongst other things. A part of this includes a record of every sale made with the foreign key ID of the salesperson, date of sale and item sold. the details are based in two tables labelled Sales and Sales Lines. Sales containing the date of the sale and the fk Employee ID and Sales Lines containing the quantity and item sold and is related to the table Sales via a Sales ID for…

(Sorry, I couldn't come up with a better subject line.) I'm still trying to create a DVD rental system using FileMaker. Please, don't get hung up on the general structure of the tables and their relationship, unless it disallows me to do what I want. I have two tables, Customers and Movies, which are related through the table Rentals. Rentals is another table which keeps track of the movie ID number, the customer ID number, and rental dates. Now I want to create a simple (at least it should be) layout which will allow the user to search the Movies table for a movie name and the Customers table for a customer name and take the related movie ID and customer I…

I just need a little help. I am trying to figure out on how to add a dotted line before words in a field. Say for example (the field in red is what I want automatically changed) Measurements: [color:red].............7.45 x 5.46 x 2.53 mm Measurements: [color:red].......................0.76 x 1.26 mm I would like the dots to be autimatically added or subtracted in the length of the field before the word or numbers. Thank you

How do i pass a field value in one layout to a field value in another layout? I'm trying to pass a patient name from the contacts table over to the 'estimated costs' table. Any help would be greatly appreciated. I'm very new at this. thx, bill

Hello Everyone, How can I display the field label inside the field and make it disappear when an entry is made? Your help is appreciated. Thanks

Hello, I bought brian dunnings FM7 chart maker...i can not figure out how to change the colors of the bars...does anyone know how to do this? i included a printscreen of the chart. Thanks! Rick

GetLayoutObjectAttribute("blue_box";"bounds") returns the bounds of a manually drawn square named "blue_box" (e.g. 99 82 919 182 0). But how do I alter these bounds, for example with data out of 5 number fields. It would be great if there was a function like: PutLayoutObjectAttribute("blue_box"; var_1, var_2, var_3, var_4, var_5) I made a sample in PHP of what I want to accomplish in Filemaker: http://www.arubaserver.com/beta/window/ Please comment.

I am working on a layout that I would like to prohibit editing to, once signed. What I'd like happen is the following: When a new record is created, its status is defaulted to "Open". Then, when a user presses a button to sign the record, etc, the status changes to "Signed" via a script. Thereafter, the record has view-only access. Could anyone suggest an easy way of doing this?

Does Sliding work when the layout objects in question are located in a Sub Summary Part? I have a field that I want to expand based on the amount of text entered but it does not seem to work. The only thing that seems different is that I have it in a Sub Summary part instead of a Body Part where I have succesfully used the technique in the past. Thanks, Steve

I have a leading grand summary in a layout that shows standard fields (not summary) from a related table. In the Leading Grand Summary only half of the fields are editable for some reason? Ex: the fields in the lower half of the LGS are editable and the fields in the upper half are not? All records come from the same related table, and have a one to many relationship. All fields have the same perm, and are editable in browse and find mode, there is nothing layered over them. I have rebuilt the layout 3 times and get the same thing every time? Once more if I take a field from the upper half of the summary field and move it to the lower half it becomes edit…

Hi FM Masters, I'm creating a library for casting... I work in the entertainment industry and I can't figure out how to create an "insert" button for fields inside a layout. I'm working with families in which all can be different amounts of family members. My base layout has five members. Name 1, Name 2, etc.... Relationship 1, Relationship 2... D.O.B 1, D.O.B 2... and Occupation 1, Occupation 2... My problem: I would like to put a button where I can insert more fields (one row at a time... a row consisting of Name, Relationship, D.O.B, and Occupation) into the database/layout for the families with more members. Also, when the fields are added, I would also like …

Hello, I have a layout that has many custom dialog boxes. Is it possible to have a scroll bar included in a dialog box to accommodate various amounts of text or simply format the box so all of the text is in view without manually resizing the box on the lower right to show all text? I designed a runtime application with Filemaker Developer 7.0 and noticed several dialog boxes had the text cut off at the bottom, I had to resize the dialog box manually. Can anyone help me out on this issue? Thank You, Steve

My layout is for use as a digital preview as a record. How can I make a field read-only, so you can't enter information in it [sOLUTION] use field behaviour :

Is there an easy way to hide a button (or make it unclickable) when a user switches to find mode (probably by clicking a button that performs a script)? I'm still learning the basics of scripting. Thanks in advance, Joni

I have a series of 7 duplicated layouts, the first of which shows 1 pixel shift of all field and text when moving from layout number 1 to any of the other 7. If I check the fields and text with "object info," the numeric referents are exactly the same. If I use the T-square, the pixel shift is apparent. I can't figure out what makes this happen. Thanks in advance for shared wisdom.

I'm having trouble getting the Grand Summary section to give the correct amount on this layout. I keep getting zeros for Summaries based on a parent related fields. The layout below is showing records from the TicketItems table, Item lines are the body. The subsummary section is based on sorting by TicketID. TotalCost is a Summary of Cost, but Haulchrg, Surchrg, and Total exist only on the Ticket because they only apply to the Ticket. Ticket1 Item 1 Cost Item 2 Cost subsummary TotalCost Haulchrg Surchrg Total Ticket2 Item 1 Cost Item 2 Cost subsummary …

Ok trying to print a layout but whenever I sort the records it always puts for example: 1934-1935 After 1953. I know technically why this happens but how do I fix it.

hi All, I am new to filemaker but, I have worked with as a developer for more than 28 years. I have a filemaker database with lots of relationships but for some reason I can not figure out how to make a layout that will allow more than one table for instance a layout with a table and its child records. For instance a Customer and Addresses. I have included the Database file in this post so that someone can point me in the right direction. Thank you for all your help, spurpurajr SCP_Solutionsfp7.zip

I want to print an addressbook for my filofax, pages are 3 3/4 by 6 3/4. I want each letter to be a different page so I can use the letter dividers. I know I will need to do some sort of letter sort, but don't know how. I also don't know the best way to do the layout to get it to print the way I want, but 2 to a full size page that I will then cut. Anyone able to help?? Thanks, Cindy

Does anyone know of a good layout software that can integrate well with FM. I need something that I can create layouts and assign data from individual record. This will be for a print catalog.

Is there any way to set your arrow keys to function like Excell in table view mode. I would like to go form field to field using the arrow keys Thanks The Tramp

Hello Board! Thank you for all your advice so far! I am trying to build a very simple data-capture program that is only 3 fields. However, i would like to use a touch-screen monitor and remove the keyboard. Is there a way for me to build a 1-9/0 keypad on the screen, so when i touch the buttons the numbers come up into a specified field? I would like to publish this on the web and serve it through an intranet and i'd rather not use the OS built in 'on screen keyboard'. A nice and simple 1-9 pad is all that is required. Thank you for any input you can give. If this isn't in the right forum let me know! Cheers, Harry

Hello, I have a container field that holds a pdf file (reciept/invoice) for my expense record. The db will be published to the web. Currently, when the user opens the pdf file a copy is saved to the user's desk top. Is that the only way a user can open the file? If it's saved to the desktop? The user's desktop will become swamped with pdf files. I just hope there is another way. Please advise!

Hi everyone, I wasn't sure where to post this so here goes. I have a solution that tracks jobs. My field people enter information about functions that have been completed and what is left. It also tracks revenue and cost. My problem is that my boss needs to view what he calls a dashboard where he can see a list of all the jobs, what has been done and what is left with all costs and revenue. This means a layout with hundreds of jobs and with the exception of the job number, every field is either a calculation or summary of all the individual functions. It is unbearably slow! Is there a some other way to display this info all together? Are there alternate calculations…

I need access to currently open window names to script in closing certain specific windows. I can make the WindowName function work in two ways, neither of which matches what I read (and what I need) as described in the help file. I should be able to have it display only currently open windows. Formula 1 (see attachment 1) shows one open window (Story Builder - yellow background) when in fact there are three windows open. Formula 2 (see attachment 2) shows three open windows (see window with blue background) when only one window is in fact open. Both calculation fields reside in only one of 10 related tables. Any insights greatly appreciated and t…

Has anyone else come across this bug with which involves Headers Pop-Up Menus and Table Views? It is basically a redraw issue, but the pop up menu seems to move, because when I click there it doesn't respond. ( See attached image... Mac OS X 10.4.11 / Filemaker Pro Advanced 8.0.3 // As a side note the upload of images (png and jpg) to this site doesn't seem to work properly. Only a compressed image was accepted. : / bug.png.zip

I have a container field that gets populated via a script using the 'Insert File' script step. The file gets placed properly, but, I can not open it from the container field. I thought you could click/double click the field and open the file. Also, can't you use a variable to place the file. I tried that as well and I get a box to highlight the file instead. What am I doing wrong?

I have a container field that has 3 options. Each option contians a logo. Based on who the customer is, a certain logo appears. This works great until I close out and reopen the DB. All of the images are gone. I have tried using both options when placing the image and nothing works. Any ideas?

Hi All I am still a complete beginner, so I expect this is a fairly simple problem. I have a drop-down menu with options "beef", "pork", "salad", "fruit" and a radio button set with options "meat", "vegetarian". If the user selects "beef" or "pork" from the drop-down menu, I'd like the radio button "meat" to be automatically selected. If they select "salad" or "fruit", I'd like the button to switch to "vegetarian". Is this possible? Thanks for your help and patience.

I created a runtime solution that uses custom images as buttons, this works fine on my machine but when a user opens the runtime product all they see are white squares where the button should be. Any ideas as to what the issue/solution might be? TIA

Layout A is to show hours per job (from Database A) and revenue per job (from related Database B)summarized by employee. Summaries work fine for hours but only show last entry for the revenue from the related data base for each employee...FM8.0

Hey all, not sure if this is the correct forum for asking this but i figured since this is all about building layouts it might be the place. I am very interested in buying a wacom tablet for my office. I am not the graphic artist or anything. I am simply looking for a way to sketch out and layout graphics quickly and easily. And since I use my mouse with my right hand, but i am left-handed at writing, I could easily use both at the same time. Does anyone know how handy (no pun intended!) wacom tablets are with making layouts in filemaker pro? Is it worth my time? What models would you recommend? Thanks All! - Mike

This is an extreme newbie question: I'm making a simple database for my home library and was wondering how to create a field consisting of a checkbox that would place a webding or Zapf dingbat type checkmark within the box when clicked by the user. Checking the box would indicate that a book had been read. I would then add the pages of the book in that record to a grand total of pages read for all books in the database. Thanks in advance, Tom Carlson

Hello. I'm using FM 8.5 on Windows. I've inserted a leading sub-summary in a report and I can see it in Browse mode but it doesn't appear in Preview mode. Also, the page breaks don't work. Why is that? Details: I have an Artists table and Artwork table. An artist can have multiple artworks. I want to print a catalog that shows all the artwork for each artist, and do a page break between each artist. I've tried both leading and trailing sub-summaries (on the Artist ID field) but neither one shows the Artist fields that I place in the section, and the page breaks don't work. I've tried layouts where the Artist is the main table and also where Artwork…

Can't figure this out; inserting record number symbol doesn't work, because I need the numbers to re-start sequentially after every subsummary break. You'd think this would be a built-in feature? Is it not? I have a feeling that this one's right under my nose, lol... Thx! J

I realise I am being really stupid here but.... I have a form layout based on a table and a list layout based on the same table. One of the fields is the staff assigned to this record. These staff names are the same as the account names used when logging into filemaker. I have created a button to go from the form layout to the list layout but I only want the user to see their own records. So the script on the button does the following things: 1. It puts the current account name of the logged on user into a global field 2. It opens the list layout 3. It performs a find where the account name global field is the same as the staff name field. but I can not wo…

Hi, I've just started using Filemaker and have modified the starter-kit business kit to suit my needs. I now have sales invoice totals, dates and invoice ref. numbers going back to 2001 for 500 customers. I would like to show the annual sales totals for each customer and for each year on a new layout tab but I can't see how to extract this information into a calculation or summary field. Can anybody give me some clues on how to proceed? :)

In a dialog box it's possible to format the text input as asterisks. I can't seem to find a way to do this with a standard text field. Is this possible easily or is there scripting involved? Thanks, Mel

Objective: I'm trying to generate a report which will automatically generate a sequential 'number' for each record in the found set. For example: I have a database of students which contains both active and inactive students. Each school quarter, I need to create a list showing just the active students enrolled. The printed list looks like a simple spreadsheet with the fist column (# field) displaying the students number in the list. e.g., the first student record shown would display "1", the second "2", and so on... ============================= # Student Name --- ------------ 1 Adams, Patick 2 Davis, Myla 3 Jackson, Kendal 4 Smith, Chad ============…

Hi, I was on YouTube tonight and just for giggles I typed in Filemaker and there was a video for a company. I noticed that in the main title bar of the FM program (not the open layout window) there was the company name…I did a search on Google for the company and they had a demo of the program and I downloaded it. Now in the download not only is there a company name but a company icon. Here is a shot of the program as you can see the logo is in the program bar of the FM program and not the open window (which is shown below the main bar). I think I saw the same thing in one of the Nightwing demos but I cant find that one. How do you get a na…

Hello, I have a Report that the user can access via the Layout dropdown. Is there a way to execute a script when the user goes to this Layout by selecting from the drop down menu (I know I can create a button on another layout that would execute a script and take the user to that Layout but this is not what I want to do). thanks,

Hi there I have a large database with in excess of 70 layouts. When I go to select a layout there is only one column shown with the necessity to scroll down to find the required layout, especially as the last one generated sits at the bottom. I know it is possible to re-order these but it seems that the one that I want is always off the page. Is there any way in which the layouts can be made to display over more than one column. Thanks

Ok, Need to create a layout that similar as to what is in the attachment. The problem is that I would like to show records from two different sources in the body. The body would have three fields from each table. What I am running into is that it seems that if there are 5 records from table 1 and 10 records from table 2, it only shows 5 records from each. Any Ideas? Thanks Fred Actually, I just looked again and found that it actually shows all the found records in table 1 and the same number of records in table 2 but the data in the table two records is only the first record shown the same number of times as the number of records in table 1. V…

Morning All, Long time reader - 1st time poster! We're sending out a lot of thank you letters which detail the kind of package a customer has signed up for. These have been set up as 'merge' letters which take the address, name, date etc from the database - all is working fine. The problem I have is that some people subscribe to say 2 of the 5 items we offer, some subscribe to 5 of the five things we offers. I wanted to add a section in the database so that our admin girls can have a set of checkboxes: 1. Does supplier have this X 2. Does supplier have this X 3. Does supplier have this Y Etc, etc. If the checkbox is ticked, the form lette…

Hi, I'm fairly new at this ball game. I'm running a database from a Mac os X.3 system, with 5 client machines all on various versions of os X. I have about 26,000 records on the database, most of which contain a graphic. A few days ago Filemaker 7 Pro started to crash whenever I added a new image to a record and I cannot understand why. I thought it may be the hard drive on the server, but there is plenty of room on it. Thoughts? It'd help me muchly.

I have a text report layout in which the length of the text varies from report to report. The length of the report is long enough to accommodate my estimate of the longest possible report. I have set slide up and shorten size of field, however, it still prints blank report pages at the end. Is there anyway to eliminate extra pages? Does the fact that there is a header and footer force the pages to print?

Problem with Sales Report I have a report by Sales Rep generated by a script with GTRR from Sales Rep table to Sales table. My problem arises when a Sales Rep didn't generate any sales in the month. There is no sales records in the Sales table therefore his name does not appear in the Report (it's a columnar report sorted by Sales Rep with subsummary). Is there a way to show a Parent record (Sales Rep Name) in the report although it has no related record (no sales).

I am wondering if there is a way to add to a layout the found set (record _ of _? I know I can add the record number with @@. For example I would like to show record 3 of 27. When the used has performed a find. I know it shows on the status area but I have that hidden from my users on this layout. Thanks, Cmack

I currently have a layout for printing letters, now I'd like to print all records in a current foundset, but if I select this in my printer properties, the body contains all letters continuous (without a page break), even if I add a page break in the body (part setup), it still does the same. In my layout I have a header, body and initial summary. Does anyone know how to do this please?

Ok , here goes.. I have a database with a product table (which holds retail price, description ect) and a Sales invoice table. I have a field in Sales invoice called 'confirmed discount' which the user enters an amount. I have a tool tip set on the 'confirmed discount' field witch displays a list of products up that retail up to the value of the 'confirmed discount' amount using a List command with a relationship that only shows the relevant product descriptions - this works great. I have just added a 'Product image' field to my Product table that holds an image of the product. In my sales invoice table I have a layout that is a letter that I send my customers. O…

What are the odds of this: I am creating a layout for labels, and in the "Specify Label Layout" dialog, it asks for the specific label size code of the labels I have purchased, in orderto automatically generate the correct measurements. In the dropdown there are numerous label codes, seemingly every one possible EXCEPT the one I have. They are all Avery ...., series numbers going from up from 4000, with other ones. I have L7159. After 6000, it skips to 8000. What the So I will probably now have to laboriously nudge things around manually until it's right? With this label situation, every step there is some problem, I swear it's harder than putting …

I've got a script that creates printed reports from multiple database tables. What I am attempting to do is to produce sequential page numbering so that the first page of the first report is 1 and if that report is 3 pages long, the first page of the second report would be 4 and so on. I've tried the Global variable suggestion that was posted for the Page x of xx solution but it isn't working. Where I would normally place the page number, I'm using Get ( Page Number ) + $$gv_page_number where $$gv_page_number is supposed to be a running total of the number of pages printed so far. It appears to be incrementing correctly, but the Global field which has the calc…

Hey Guys, This may be the stupid newbie question of the month, but I have one report I'd like to do in landscape layout but the rest of the database is portrait and I can't seem to be able to do this? Everytime I change the orientation in that report it changes the whole database. Is it possible...and how? Thanks! -Phil

Hello All! I have a bit of an issue I can't recall when it started but it bugs the crap out of me! After YEARS of agonizing pain dealing with windows 2000. We FINALLY got new computers (rebuilt) with fresh clean copies of windows XP pro. My computer is running a Pentium 4 2.8ghz processor (32bit) with 2gigs of ram. (Dell Dimension 3000 motherboard) - I have 3 monitors hooked up to it with the use of an ATI Radeon 7000 dual pci video card. I run diskeeper 10 to keep the drive defraged for optimal performance. I am a huge memory freak i always watch my resource usage. Anyway, Whenever i am working on layouts in Filemaker, I notice considerable lag when making…

Hello everyone, I am trying to display a button with script when the value of input is EMAIL in type field. I want to click that button to set as primary email. The button will not show up if value is not EMAIL. Is this possible to do? Please help. Thanks in advance!

-------------------------------------------------------------------------------- Hey guys I have a report layout that sorts my records by company and a search layout with global fields for users to enter a date range for the report. I was wondering if anyone had any ideas about how I could make a pop-up menu with each company and depending on which company the user selects, only that company is shown in the report (I also want it to be possible for the user to shift click multiple companies). Also I want each company in the report to start on a new page and to have the company's name and date range in the header so it would read something like: Sasaz…

Recently I changed the graphic (gif) for several buttons. Normally, there is no problem. But when I downloaded the changes to my client on their PC the button displays a message that the graphic is missing and they see the button blank with that message displayed. The buttons work fine, but this has never happened before. The only buttons affected are the ones I changed in that day. I have made many changes before but this has never happened. Anyone know what is going on or what should I do. I use the FM9 advanced to program and my client has FM9 Pro installed in all their user PC's. I have updated all to 9.0v3 and also the FM Server is updated. WOW, I am truly puzz…

Hi, I'm building a solution that has a primarily dark background, with light-colored text (yellow, white etc.). When I enter an edit field or pop-up menu to make changes or make a selection, the background reverts to white, which is a crazy difficult color to edit white text against... Anyone have any idea if that's something I can change? Many thanks

I can find the contents of a field repetition using the Get Repetition function. What I would like to do is be able to do the reverse and find the repetition number given the contents of the repetition. Is this possible?

Hello, I've posted here before but the answers I got made me realize that I am too much of a novice to screw around with trying to put 4 different tables that I have (Clients, Invoices, Appointments and Daytimer) in the same table. My question is this: Is there a way to use some kind of tab method in order to make each table appear every time i click on a different tab in a "master" table? Please, being a novice, I would appreciate an easy answer. Thanks:)))

I am new to FMP, so my first project was a little frightening lol. I am an amatuer magician and decided to make a database for the effects I know and study - and approach it as a FMP project as if I were designing it for someone else. I was wondering if anyone would be willing to take a quick look at it and see if there are areas where I did things blatantly wrong, or violated any "unspoken rules of fmp"? I would really like to become better versed in FMP and even go for the cert eventually. I have attached the fp7 file and welcome any advice. magicvault.zip

Hi, I'm having a problem when I insert a picture in a layout. On my computer, the picture shows, but on the users computers they only see a square with the word Image in it. Can someone help me with this issue? Here's a printscreen from my computer: Here's a printscreen from an employe's computer: Thanx!