Layouts

Hey, I am trying to make a database for my real estate contracts, and I am trying to create a menu like the one shown here, any help? Proforms_Shot.pdf

[color:red]<> Hi Everyone: I have a database with related tables. Table 1 contains the "Master Record" and table 2 contains the "Sales Records". The Master Record table has a Primary Layout with a Portal that displays records in the related Sales Records table. The relationship is pkOrdNum = fkOrdNum. This way I can have an infinite number of sales lines for any given order. The problem is I can can not seem to build a report that shows order history the way I would like. The Sales record database might have hundreds (or thousands) of records to account for all of the Order Lines. What I would like is a report that changes raw data th…

Hi Folks! I've been using FileMaker for, well, decades. However, most of my creations have been simple flat databases. Now, for our small newspaper, I've created a FileMaker 8.5 database with three tables: - Advertisers (listing advertiser number, name, address, et al) - Ads (one record for each ad run by an advertiser) - Payments (one record for each payment made by an advertiser) Conceptually, what's the best way to combine this data into a end-of-month invoice? Thanks! Dave

Hi, I have a text calculation that looks like this: "This is to confirm that Mr. "& First Name&" "&Last Name&", has worked at this Company since "&Date of Hire&" as "&Title&". And receives a basic salary of $ "& Salary The problem I am having is not being able to format the both the Date field "Date of Hire" and the number field "Salary" inside this text caculation. I would like the "Salary" number with 0 decimils and thousands separator ",".

I have a database called volunteer and a field named "interest" (which volunteers can show what they would be interested in doing) The interest field is set up as a check box field with a value list of: recovery packs fundraising ect ect.... What I want is a report that will show "Recovery" with the list of volunteers that have signed up to do recovery, then list packs and so on and so on. Recovery susie smith tommy jones Packs billy thomas Fundraising name name I tried to set this up using a layout with a leading summary and sorting on interest but the list is showing the interest every time with one person. …

I can't figure this one out easily... I have a repeating field, say it's for people's names and has 5 repetitions. I want to display them on a layout as a Merge Field... My question has to do with commas, and periods... If I type: <>, <>, <>, <>, <>. This method will work, but if I only had two names entered in the original field, it would look like this: John Smith, Jane Doe,,,. My question is how to I get it to display the correct grammar, so to speak. I don't know if there's an easy way or if some sort of calculations need to be devised. Any help or suggestions or demos? Thanks!

I'm creating a database which is analyzing some data from surveys created in another 3rd party product. I'd like to add a nifty pie chart to the results of each record in FMP 8.5 advanced. I've googled and found a couple of solutions -- none of which are intuitive. Surely it can't be as hard as i"M makiing it... Jeff

Hi All, I have a layout that allows a user to select the invoices they want to pay, this layout also has a running total, with a restart after each change in the vendor name - telling them the total amount due for all invoices for a given vendor. What I want is to set the final amoount to a BOLD font or just display the summary over the vendor and not the running total - any ideas?

Lables have attached themselves to the tabs of the tab control and everytime I try click them in layout mode to delete them the tab control changes to the page to the one I clicked.How do I delete these lables? How they got stuck: I have a layout with lables and fields on the top 3rd of the page and a Tab control on the bottom. I dragged the tab control to high (over the fields and lables at the top)and when I moved the tab control back down all the lables on top stuck to the tab control??? Does this always happen in FM? Any help would be much appreciated, Thanks

I am new to FileMaker, but not new to development or databases (15-20 years). I have books and do extensive research before asking questions, that is if I am not under a time constraint. I appreciate any assistance with the following: I have a report that I have scripted to run. I show a dialog and filter by a date. This is successful. 1. I want to show a dialog and filter by a date range? 2. I want to display the date range back to the user on the report? Thanks for any help, Lewis Howell

Just a quick question on container color. I had a container red to match the background then changed the background to yellow and changed the container color again to match it. But now when I click the container (it goes to a related record) the container goes to the old color when it clicked....it's not a huge deal just annoying. thanks for any sugestions!

I have been working with 3 different databases to develop different parts of a larger combined database. A) . How can I move scripts from database from DB # 1 and #2 into the the bigger database #3? :. How can I move existing Layouts from #1 and #2 into the bigger database #3? I realize that i will have to relink the fields to the new database but i was wondering if there was a way to pull them over so idid not have to rebuild the layouts from scratch.

On my estimate/invoice page that list all past and current estimates, the company name 2 line get cut off -- curious how I fix that? Also, on this page, it's sorting by invoice number. I changed it to sort by date, but that wont stick. I've examined this is layout view, and there does not seem to be a lot of flexibitly or room to move any fields there. (I'm a bit novice) thanks!

I have a layout with header, body, trailing grand summary, and footer. The body has 6 fields, it is not showing all the records it should. I get just one record. I thought I had a relationship issue but I put a portal in the header and it shows all of the records correctly. I am also using sliding/printing so I can print this list view out. Any thoughts why list view gives me just one record but portal shows all the records? I am scrolling and the header and footer stays put. Printing provides the same results.

Hello, I would like to print mailing labels for a simple table that includes addresses. However, some records should receive the mailing and some should not. I have created a field with a yes/no radio button that lets me know whether someone should receive the mailing or not. How do I create a new label layout that only prints labels for records with "yes" in that field? Thanks, Benjer

Hello Sometimes when I copy text from somewhere else. It is too big and maybe bright yellow text. I can go to the format window and select the text and change it all to 10 point arial black . But is there a way to automatically do this. Thanks Dave

Here's another example of a larger species of a problem that keeps coming up: I don't quite 'get' how Filemaker prioritizes and applies text formatting. here I have a simple text box for "Title" - set for black 14 pt. Times. Simple enough. But for some reason, when I use this field as a 'Merge Field' to display the title in a heading on a colored background along with some other text, it refuses to display the assigned formatting. So, in Layout mode, I have a text block That reads: <>Value List for <> It's all in 24 pt WHITE text -- and everything appears that way in Browse mode except for the Title data! it works for the Archive Name, bu…

hello, is it possible to lock filemakers window size? im talking about the entire application.. and also disable the maximize and minimize button of the layout and application windows? and in the layout out window dissable the close button... and finally disable the zoom buttons? any help would be greatly appreciated

I am generating a PDF from records in the found set. My layout has header, body, and footer parts. The page size is 11" x 15" with .5" margins on all sides. (Custom page size) The header is 1", the footer is .5"; both containing text. Is there a way to have the body records equally spaced, with a rule above and below, to fill the 12.5" available space? (There will never be more than 20 records in the body space.) Initially, I measured the size (in points) of a record including leading and created a "space" field that was placed above and below the data. Using a Case statement to count the number of records, I attempted to format the point size of the space field…

I have a purchase order report that the user can print. Right now the report just shows grand totals at the bottom of the last page. This works nicely if there are only a few line items and the report can print on one page. However if the report spans multiple pages it would be nice to have a subtotal of each page at the bottom. Is there a way to put a subtotal at the bottom of each page of a report?

I have a layout I copied that when you view in browse or preview, the related (detail) records show the same records for every row. For example, say there are 10 detail rows for the main header row (linked in a relationship). Instead of showing 10 rows, one per detail line, i get 10 rows of the first detail line. This is killing me but I'm sure it's something simple. Thanks in advance

Reports much slower on some computers of similar specs. 3 level sort is 5 times as fast on a slower computer. What could cause this, a badly fragmented disk?

Hi, Is it possible to have a page in a layout that always displays as the last page in the printed report. A map for example. Or NB phone numbers. I tried using Trailing Grand Total but you can't seem to go over the page borders. The info I need to put in is more than one page long. Thanks

Hi I am creating an invoice with a repeating field. How do I insert a "next page" into a multi page invoice. I tried putting text in the footer but it puts "next page" on all of the pages.

I am trying to create a report that has the fields from a record from one database and then selected fields from another database in the body. Actually in the header, I am describing a situation and in the body the individuals from another database to document their responses to the situation that is listed in the header. The two files are not related. Bottom line, I want to document the situation with a description, date, etc. and then print a listing of the situation and a list of the individuals with phone numbers, etc. so I can call them apprise them of the situation. So far I haven't figured out how to do this. Anyone have any ideas?

I'm trying to add a summary or sub-summary (not sure which is appropriate) to a report. I want the sub summary to show a count of different items selected in a drop down list box. What I've tried to do is create a summary field of the drop down list which is a "count of" the field I want to summarize. Then place that summary field in the sub summary layout part. But when I view the report it's just giving me a count of all records in the found set instead of showing me the breakdown. For example the field I want to summarize has 5 statuses "sold", "lost", "bidding" and so on ... On the report I want to see: Sold: ## Records Lost: ## Records Biddi…

I have a DB that i have selected a font size of 10 for the fields When i add a new field, i choose the same font, the same size, but it appears so much smaller? I need to change it to size 18 to get it to look like my other previously made fields. Obviously this affects my layout and the field size.. Any help? THanks!

hi, Can I set dimensions of a layout or of the workspace to a certain desktop resolution e.g. 800x600, 1024x768? Cheers, Dan :)

I am a novice trying to get on my feet. I would like to build a history db for screen only with a list of events on the right (two fields: year and fact). No brain killer... On the left, however, when an event is clicked on the right, I would like that a description of the chosen fact appear like a large note. I could do this, one above the other: the fact description in the header and the list of events in the body. But I would prefer a screen presentation, horizontal, with a list on one side and the description (the whole card in fact) on the other side. Is this possible with FileMaker?

In access I used groups, In FM it appears to be called a leading summary. How do you insers a group/leading summary into an existing report? I have been able to create a report using grouping, this isn't a problem, I can't figure out how to insert groups into an existing report. Thanks Saddle Tramp

I am trying to design a layout that will involve billing specific companies on a daily basis for a period of a month at a time. I would like to be able to open a specific company record and have all the dates for one month show up on my layout so that I can add to the billing field each day. I do not want to have to create a new record for each specific day. In other words,for example, I would like to see every day in November show up in a record so that I may place a billing amount next to that day, without having to create a totally new record for each day. I could then generate a summary report at the end of the month for each company. Thanks

I need to create a report that shows by month how many inquiries were received in each month. Not quite sure how to approach this?

Is there a way to make the cursor bigger in only FMP apps? Sometimes the little thin line is tough to see and I don't want to ask users to change their computer settings.

Hi to all reading... Well I'm pottering along with my own solution for invoicing and managing my business accounts ok here. I'm wondering if I could have some help with creating an Account Statement Report for my clients, which depending on the client, is either issued monthly or quarterly. The bit I'm stuck on is how to incorporate credits / deposits / overpayments into a running total. On the onset of a contract, I always request a deposit (usually negotiated with the client before commencement, and is not a static figure or percentage), I then work that deposit off! Eventually their account reconciles and they begin paying an hourly rate. So.…

How does one get the Sub Summary to appear on subsequent pages when the records one particular category spans more than one page?

I have a problem with a field maintaining the font size. I have a layout (sales) where I input address information, and the fields are all font size 12. On another layout (label), I have fields that are size 10, as I am printing labels. I can't make the label layout keep the font size 10 - most of the time the font size stays at 12. This usually is due to me pasting information into the fields that are font size 12. Is there a way to tell the field to maintain the font size that I want the layout to have? The font issue also happens when I paste information into a field. If I paste Helvetica size 12 into a Verdana size 12, it keeps the Helvetica fon…

Hi, I'm having a problem with graphics shown on a Mac. The solution was converted successfully from Windows-FM6 to Mac-FM8, but the graphics do not display on the Mac. How can you set the 'store compatible graphics' option with Windows-FM8 ? I don't see an option like that when inserting picture. Any help ?

Is it possible to change the default behavior of the mouse wheel. Rather than changing to the previous/next record I would prefer it to scroll the active portal, window, field etc. In my solution this would be much more useful. This would obviously not apply to you one mouse buttoned people :

Hello everybody! I have what I think is a very basic question. 1). The database is to organise my contacts by what "status" they are. 2). It has one table. There is a field called STATUS, which can have one of three values: COLD, WARM, or DEAD. 3). I want to see a screen that looks like this: == COLD John Doe Jane Smith WARM Bill Bloggs == In SQL terms, I'd run two queries (GET_COLD, which would find all records where the status = COLD, and GET_WARM). Then I'd display the output of each one alternately. But I have absolutely no idea how to achieve this in FM. I'm sure it's basic: can anybody help? Sorry if this is a stu…

I have to produce a report where the client's main logo is on the first page of a (potentially) 3 page standard letter layout for a range of found records. The logo I have placed in a Sub Summary (Leading) part, breaking by ContactID. This ensures that the logo appears at the top of the front page of each Contact's letter. Unfortunately if the letter contents span two or three pages I need subsequent pages of each contact's letter to show a "continuation" logo which differs from the main logo on the first page. Is this possible?

I created a layout and on two records the sub summary field does not display and there are values in the two records affected. Anyone have any idea why this is happening and have any solutions?

I need to create a report that shows by month how many records are created and modified based on date fields. Not quite sure how to approach this? I how do I get FM to count something that is a date field. Do I have to create fields for every month? Jan-Dec? As you can see I have no idea how to get this off the ground. Would really appreciate some help my boss wants this info by next Wed. Hope this is not a difficult and involve process.

I just upgraded to Filemaker Pro 9. When moving fields in layout mode, there is a noticeble delay and lag time when dragging and dropping, making it very difficult to place fileds accurately in their place. My computer is not running slow in other prgrams, including older version of Filemaker which is working perfectly in Layout mode. Any ideas?

can anyone help tell me if they know how to make tcards for resource tracking system i am a beginner

I am in the middle of redesigning my DB in to a separation model. So I made a table only DB and a GUI DB. I imported all my tables from my combined APP in to the new table DB. I then imported all my records. I have 22,500 companies, 18,500 contacts, 9,000 emails. The rest of the 45 tables have varying records from 0 - 500. My data displays properly in my current combined app. It displays properly in the GUI. But, when I try to access my contact names layout (172 fields) the Tables DB crashes. I thought, perhaps, it was too many fields on one layout so I broke it down into three layouts: Display Fields (Name, address, etc.) Container Fields Global &…

Can I import data from excel directly into a particular part of a repeating field. Example, a rainfall field defined as a repeating field with 365 repetitions. I want to import the 3rd days rainfall into the third part of the rainfall field, the 4th days rainfall into the 4th part of rainfall field and so on. Is this possible. Seems a simple thing to do, but no option appears when I try and import data to identify which element to place the data into in the repeating field.

Did that make sense?? I am trying to clean up the look of my layoutss and was wondering if Filmaker had the ability to dispay the name of the field inside the field? i.e have it look a bit like the google search bar at the top of browsers - it says "google" inside the search bar, until you start typing. Anyone have any ideas if this is possible?

I've inherited a Filemaker database that I need to modify. When I go into layout mode, instead of seeing the field *names* in the various field boxes, I'm seeing little advertizing blurbs like "Powerful Scripts!" "Customizeable Buttons!" Is this some sort of security/secrecy option the designer activated, or what? What's the point? How do I get the field names to show up instead? Thanks Wickerman

Hello - I have a 4 col layout with a sub-summary part. If the body part goes beyond the bottom of the column it finishes at the top of the next column as you would expect. However, I would like the Sub-Summary part to repeat at the top of the column when it splits the body part. Is there a relatively easy way to do this that I am overlooking? I have attached a jpg to try and help better illustrate my question. Thanks in advance.

Hey guys. I've sort of been thrown into this whole filemaker ordeal. I'd love some help with a problem I'm having. The database I set up is for recording work orders for our editors and assistant editors. The work order itself includes things such as job name, number, editor, assistant editor, producer, as well as time in/time out, overtime, total hours worked... that sort of stuff. Now, what I've set up is it will generate a time sheet for an entered week using the name of the person entered. It will search in both the assistant editor and editor field (because some people will assistant on some projects, and sometimes they are editors on others). Now, tim…

I am having a problem seeing a jpg that I insert into a field. Not sure if there are different types of jpg formats, but I can get some jpg to show. The error message I get is "The file cannot be found:7.jpg." Any ideas or thoughts would be great thanks, dave

FYI, this is my first post. Is it possible (using sliding perhaps) to have columns and their labels hide when the value of their summary is 0? Or even a way for the user to select columns to hide? I have hidden fields by sliding left but I have not been able to stop resizing of fields since this will put the field out of alignment with other fields set as part of that column. It's also nice, though not essential, to use center alignment. There may be some conditional formatting that does this but I can't find the correct option. Also, I thought about using the table view, but the one problem is that I need to label columns using rotated text-field labels (as…

I am working on making a database for events that we get invited to. Some of them only happen once for one date, others are 3 or 4 days in a row, while others are all the weekends in october. What is the best way to store this if someone wants to go in and put in a date or date range and find out all of the events that are happening for those dates. Now that I am typing this I am thinking that the date and time should be in its own table? While the other event information is in anohter table. Any suggestions would be greatly appreciated.

I am currently trying to edit the tabs when using the Event Management Template. When I enter layout mode, and double click the tab, I am able to get into the Tab Control Setup, but all the options are greyed out except for cancel. Is there any way to either, edit the tabs that come in the template or delete the original tabs once I have copied them? (since I am able to edit the copies) Is there a button that needs to be checked/unchecked?

Hi, I'm playing with the Tab object for the first time. Is there a script step that will navigate between the tabs?

I have a detail report that breaks down sales by sales person for each day. My subtotals and grand totals fine, but the detail of sales for each day is missing every other record....any ideas?

I will be having an installation in a non-US (non-$) country. Is there any way to set the currency symbol for a given runtime solution? Is there a value list of currency symbols in RM to choose from? I see that in formatting a number you can specify the currency symbol, but short of finding all the currency fields on all the layouts and changing them one by one for this one (for now) application, I don't know how to change that. And I'm not sure the standard character set would have a lot of the symbols. And then I would be managing two source versions for any updates. Not a pretty picture. TIA

I am a teacher and am working with reports for grading. Is there a method for having the field and border adjust to maximum length of contents? In Excel If I have a row, it will adjust to the maximum height of any one cell in the row. I am using a 3 cell row layout and need it size to largest of the 3 cells in the row and to draw borders around each cell. Thanks, Michael Perry :)

I have a table that needs to have graphics inserted into container fields, but the graphics are from the Corel Draw Graphics Suite Application. The extension on the graphics are all .cdr and filemaker says it does not recognize the picture. Will I need to convert the pictures to a .jpg or .gif? Any suggestions on how to get the graphics into filemaker without having to do a conversion would be great. Please move this thread if it is in the wrong forum. Thank You!! :qwery:

Hello, is it possible to scroll through/print the pages of a report in preview mode with the status bar hidden? I hide the status bar in our application and I can't figure out how preview reports without it. Thanks Rick DeCollo

Hi all, had no idea what to search for so again, please let me know if I am repeating stuff... I am trying to create a start page with 'buttons' and the idea is that each button will link to another file. Ideally I would like to run that independent file inside a frame of some sort so it seems like it is still part of the same file and so it makes it easier to return to the start page. One thing to note is that the linked FM files have password protection in them - not sure if this will be an issue or not... is this possible? thx.

Hello, I have a "text" field on my report that extends four page lengths. If the text entered fits one page, I only want one page to print, instead I get all four pages no matter how much text is entered into this field. I have done this in FM4.0, I thought I was doing it right in FM 7.0. I selected the involved text field,and selected the following; "format," "sliding/printing," "sliding up based on all above," "also reduce the size of the enclosing part." When I view the layout in layout mode, I do not see the arrows pointing up, which identify the field as sliding-up. Any help would be greatly appreciated. Steve

Hi everyone, I have a report using two subsummary parts for name and job. The report should summarize each name and the job should summarize totals for the jobs associated with that name. The problem I have is the parts breaking across page boundaries. The button is unclicked (allow part to break across page boundaries) so the name doesn't and the jobs don't, but I do get a name at the bottom of a page and the associated jobs at the top of the next. Is there a way to keep both subsummary parts together on the same page? I cannot pick an arbitray number of occurences because the number of jobs varies too much. I hope I have explained this properly. Thanks in advance …

I have a DB that works OK, prints OK, but when you look at it in Preview mode, the font turns to garbage - looks like the Martian alphabet. Any ideas?

Hi Everyone I'm sure this is an easy one - I just can't quite work my way through it at present! I've a database with 800 records, each containing images, film-clips and related data. I want to build a couple of introductory layout pages that will help users with no prior knowledge of databases (some of them will be school-kids) to orient themselves within the database and find various useful sets of data. Let's call them 'meta-layouts' for the moment but they're just Menu pages - there's probably an actual name for them. These "Menu" layouts will only contain a background image, text labels and buttons - and from them the buttons will use scripts to go to various ot…

Hi, I'm trying to print a list of multiple related records. The parent table "Case" has two related child tables: "Gross" and "Part" (Gross and Part are each related by "__kp_CaseID/_kf_CaseID"). Generally speaking, for each "Part" child there is a corresponding "Gross" child (however I have good reasons for not joining these to make one table). There may be any number of Gross/Part pairs related to "Case". Anyhow, what I'm trying to do is to print the following information: (Header) fields from "Case" (Body) field from "Gross" (Body) field from "Part" (Footer) page break The trick is that I want all of the child records from "Gross" listed seque…

I have a number in a number field that is for US Dollars. How do I format the number to display as a merge field with two decimal places. If it is possible to have it do the dollar sign as well that would be great but I can just preceed the field with a typed in dollar sign. Thanks, Drew

Is there a way to create standard headers and footers (one for portrait and one for landscape) to be used on almost ALL layouts without having to copy and paste it on all of them? If I create an header and "group" all objects together and copy/paste it on all layouts THEN if I do change something on one layout, I'll have to change it on all layouts... and there is quite a lot of layouts in our systems. The portal approach seems interesting but maybe there's another specific way to do so. I'm still stuck with FM 7. Thanks I still concider myself n00b :

I have a standard summary printout in list mode and in preview the horizontal lines are not parallel! Of course it looks terrible when printing.... anyone seen this before?

Hello everyone! Can someone shed some light on how could I get a SINGLE report to show both the Fiscal (YTD) totals along side Monthly totals? The report I am talking about is really a Monthly report that our customers would get, but I'd like the report to show the Fiscal (YTD) totals for reference. Any ideas are extremely welcomed! Thanks in advance, J

hi. i'm using FM for the first time on my mac. i'm a musician trying to create a database of local schools so i can do a personalized mailout. i want to choose whether the script is sent either to the head teacher or the music co-ordinator (and occasionally letters to both). can i have the two contacts in one school file, and then select which one i want to use for the mailout by editing the layout? or do i have to create a separate related file for additional contacts? i have read the manual, but being a musician, it's little technical. many thanks!

Sorry if this is a very newbie question, but I've been looking everywhere for the answer but have yet to find it. I have text field with varying data length. I would like a layout report to print all of the text in the field. In Access there was a "grow" function that allows the text to expand down the page if there is too much (rather than disappear). Is there a filemaker function that will do this for a particular field as well?

Hello all, I created a columnar list report layout. Now, what I want to show the user is the total number of pages. In the footer, I have a page number symbol with the word "Page" in it. When I click preview mode, it reads Page 1. The report is actually 3 pages long. I want it to say: Page 1 of 3. How can I get it to show me the total number of pages in this report?

Hi, (this may belong in the print section, but since it involves a layout I posted it here) I have searched most of the day and can’t come up with anything close. Is it possible to have a report layout to print only the fields that have data in them? (if you know of post explaining this, could you tell me how you searched for it, I tried inserting all operators into the search and still could not find anything). Thanks, James

I've got a Class Registration database. Tables Students Classes Registrations Payments Registrations is a join between Students and Classes and a one-to-many with Payments. I'm trying to create a balance sheet for a class that will show all the Payments made towards a Class, sorted by Student with a summary of those Payments. Right now, I've got a layout based on Payments. I GTRR from Class to Registrations to Payments and sort by student name. The total is in a summary field showing amount paid. That's almost fine. Students can register for a class without making a payment. So the "Balance Sheet" won't show any of those students. I c…

One part of work involves filing out forms with calculations. Is there a way in import an image of the form, so I can put my fields on top of it, and print the page as a whole with the form and the fields together, rather than having to load the printer with a xerox of the form, and adjusting my fields to fit that pre-printed form? I am using Pro 9 on a Mac. Thanks.

Thank you for looking. I've just received my FMP this week and have learned how to make custom Layouts etc.. on my customer database. I'm setting up printing customers address on postcards and what I need to understand is how to print only customers with zip code 07728 for example. I've been going thru the manual and each time I think I've got it I get lost, i.e., field control etc... Can you help please? Thank you so much Tom

I have read the Topic below mine, but Im not sure that it is what I need, and If it is Im not getting my mind to see their post working for me...so forgive me if this is on the same line as the Topic below this one...here is my question: Good Afternoon, I am working on a little db for our k9 unit here at work. Here is what I would like to know if it is possible to do. I have a main layout which has four buttons on it, “Building, Vehicle, Area, and Other”. When clicked they take the officer to a layout (of a related table) so they can enter various information about the Building or Vehicle etc. that the K9 was used and how the dog was used etc. …

Hi all A simple lookup has me baffle to no get out. I have delete every table and have start over three times and have spent four hours today on this so I hope some one can find where I am going wrong. The bolt table is where I stored the bolts information. The Job_bolt table is where I want to stored the bolts required for a specific job. The vessel table is the input table. I make a relationship between the vessel table and the job_bolt table using the quote field. I make a portal using this relationship. I aslo made a relationship between the Job_bolt table and the bolt table. The job_bolt table is where I want to do the lookups. In the vessel table input I atta…

I found this file in another post, but I did not want to hijack the post for my own question. How does the graphic change when the user clicks on it. This is a feature of FM that I've not yet figured out, yet I see it everywhere. This must be something simple. Thanks ahead for answers. LockIndividualFields.fp7.zip

This layout displays fine in FMP 8.0v3 / Mac OS X 10.4, but not on Win2K. I'm just attaching a screen capture in the hopes that the problem will be familiar to someone. Will provide pixel-precision details if needed. It appears to be somehow related to the calculated container field that lies behind the text ("Cash"), which turns green to denote the current sort column. But I have tried shrinking that field drastically, as a debugging measure, and there is still about 1-1/2 cells-worth of graphic plastered over the footer of my layout. Thanks, Chap

We just signed up our database to be hosted on a shared server. The technician who signed us up mentioned the advantage of optimizing the database to be viewed on a web layout. Can anybody direct me to a discussion of things to look for or do when developing a layout that will be viewed on the web? Thanks for any guidance, Jarvis

Just trying to copy a few buttons with some text and pasting it a different layout, but it takes over a minute to do the actual paste. In fact I am receiving a paste progress bar while I am waiting. Is thing new in 9? There are no graphics involved, and no conditional formatting...just four squares and four text fields that have scripts attached. This is a remote file that I am working on. Thanks.

Is there a way to change the caption on a button? I would like to be able to copy a button, paste a bunch of copies of it, change the action they perform, and then change their captions. It's faster than making different buttons and trying to resize them all to the same size. I know there's probably an easy way to do this but I just haven't been able to figure it out.

Hi, I have Advanced 8.5 installed on an intel iMac running 10.4.10. In layout mode, holding 'option' and dragging/dropping an element does not duplicate the element. Also, holding 'command' while dragging or multi-clicking does not allow multiple selection. Option and command keys seem 'broken' in layout mode, but work fine in other modes. There is nothing special set in System Prefs > Keyboard & Mouse. I have tried deleting the FMPro prefs without success. Option & command keys work fine in all other contexts and applications. Does anyone know what is causing this? Thanks, ft.

I either read or heard (on a video) that you can paint multiple fields or labels by clicking on the paint icon and then holding the Crtl key down and bringing the cursor across the fields/labels you wish to format. Obviously I am wrong, because it doesn't work for me. How do you accomplish this? I am redoing all my layouts to a softer look and it requires painting 100's of labels and fields. Thanks for your help. Al

I have multiple True False tests some with over 400 questions. For the purposes of scoring them, I would like to be able to hit T or F (or 1 or 2) and then have the cursor automatically advance to the next item (i.e., field) without having to hit another key (i.e., tab or enter). Any advice on how to do that?

Hello, I want users to open any/all layouts without the ability to edit any records except through the following buttons: Add;Edit;Save;Delete How can I do this? p.s. I don't want them to click outside the field and commit either. How can I do this? :help:

Hi, I'm getting a number from a calculated field. If the value is less then 1, it shows as .xx, how can i get it to display as 0.xx??? I've looked at number formatting etc, but i can't see how. Thanks in advance, Skip

Have a small Filemaker DB I made for a local club, nothing special, ID, Name, Address ect. They would like it setup so that a member can just enter their ID and Filemaker will keep a record of attendences, Name, Date, Time. What would be the correct way to setup Filemaker? Should I create a new layout with Name, Date & Time fields and have FM create a new record each time someone enters their ID or is there some way to create a list of attendences without FM creating a new record for each? My reason for asking is that after several years of say 50 to 70 people entering their ID weekly, wouldn't this create a rather large DB. I have looked through the Filemaker Templat…

Is it possible to center content in FMP window similar to website behavior? I am interested in making database to... ...If user moves or resizes window, content will re-center itself. Maybe this feature is web based only? Thank you for any help and tips on this topic! ;)

Hello. Im new to FM Forums and need some printing help. I tried to search topics but couldnt find the answers I needed. I think this should be fairly simple: I would like to print 30 records, 1/2 size so to fit 2 records on each sheet of 8.5x11 paper. Please help! Thanks in advance.

hi, I'm trying to input hebrew into a field. except for that the marker is staying at the begining of the line all the time, when I try to use anything else besides letters and numbers, it is showing it at the begining of the line unless I print a letter afterwards. For example if I try to end a sentence with "." then I would get "דוגמא." For those of you who don't read hebrew, the dot should be on the other side, and yes, the fields are alligned to the right. Any suggestions?

I am investigating how to design my printing page layout to mimic security paper (nothing seen on the printed page but "VOID" or other symbol when the page is copies). Under the magnifying glass security paper and background hash marks in one direction and "VOID" written with hash marks in another direction but the same gray as the background. To avoid lengthy experimentation: has anyone done this with the design tools and have suggestions on the which background style and shade etc to use? Thanks

I am helping a friend with a small business. I have created a basic, single table, membership application but it needs to be modified periodically. It is not convenient for me to make the modifications on the "production" database. What I would like to do is get a copy of the "production" FileMaker database, make the modifications and then import only my non-data changes (layouts, scripts, etc.) back into the "production" database. I know I can import scripts, but what about layouts or schema changes? In other words, is there a way (without using FileMaker Pro Advanced) to perform normal developer enhancement functions?

Hi all - first posting I am new to db's and am looking for a way to setup a link between my current database and some form letters (ie inventory assignments, user contracts, repair waybill) I have one list setup and would like to link with a button to some printable documents that import information like serial numbers, make, model and from another list (not yet setup) of user names and profiles. I would also like to set up a third that would have account information (names, $ amounts, items taken, returned, etc.) Also would like to have as a standalone db for other colleagues to use without the ability to edit and modify db setups only to add and delete entr…

Hi all i have searched every where for this and have found nothing. i am trying to create a contents page for my reports. is there a way to copy the page number each record is on in preview mode to a field 'pn' for each record Thanks Craig

I have to make a report where I need text in the header, showing on every page. No problem. In list view the records can go from 15 to 360+. I need text in a 'footer' part, but only showing on the last page (page setup is legal - landscape). The help file says: Title Footer: Appears only once at the bottom of the first screen or page.... I need it on the last page... I have now: layout in list view, Header with text and no fields. Body: fields from record (title) Footer: only text, but has to show up on the last page only.. Is that possible ? and how ? TIA

I am new to file maker,i have a problem my database has 3 tabels with the following fields Customers:CustomerID,Address,City Location:LocatioId,Address,City,CustomerId(fk) Equipmnet:equipmentID,Type, Serial#, Loactioid(fk) Each customer mustt have one or more loctions Each location can have A single peice of equipment I want my reports or layouts to show each customer followed by the customers locations Any help would be very much appreciated thanks

I have just had a client inform me that they have been using FileMaker preferences: Enlarge window contents to improve readability; I only now understand the underlying layout issues re inconsistencies I have been chasing from 'feedback'... Developing on a mac, and testing under parallel; FM 8.5Adv. All layouts (except pop windows) had been structured to be a uniform size, and I had written scripting to force the same height on table view layouts, and sizes were adjusted for the vertical real estate losses in windoze title and menu bars etc. Never having noticed this windoze 'versatility' before, my initial tests show that after designing uniformly sized…