Layouts

Rookie, FM6 on a Mac OS/X. I'd love to be able to simply change the font size (to a larger size) on about 50 mailing labels that I have created. All fields. All labels. Thanks for any help.

I am trying to create beginning balance records in one file from another file to show on a report, but I don't want the data to show in the body. I don't mind if it looks like a blank line but I don't want my users to get confused so I'd like it to be invisible. I need to have the record in my found set, however, as the totals depend upon the record. I'm basically combining multiple beginning balance lines into one total that I want to show on a subsummary section above the body. Cin

Hello, I have the following first line in my label: <<Prefix>> <<FirstName>> <<LastName>> My problem is that not all records have a prefix and for those records I get the blank space before FirstName. How can I get rid of this space? thanks! Stephanie [email protected]

Trying to make tickets for an event at school. The tickets would have a graphic in the background and a sequential ordering of numbers as the ticket number. That's it. I would like to be able to print about nine per page (letter sized). I simply cannot make it work. Here is (some) of what I have tried. Have (now) four different layouts on which I have tried this. One has a container field with the background image and a number field (auto-entered serial #'s); this appears to work as I create new records, but under preview (set to print in 3 columns) background image only shows on record #1; the rest of the positions are numbered and positioned correctly, bu…

Can I have my layout be pink for girls and blue for boys? It'd be a nice feature, but I have no idea how to do it aside from creating two layouts. Would I need to create a layout and have it pull up the correct layout based on the value of the gender field, or is there an easier way?

I am a beginner at learning how do this. What I need to do is create something that calculates, counts, summarizes (what ever you want to call it) the number of stores that each of our managers is in charge of. I need to be able to do a FIND by store STATUS (Active, Open, Hold) together with the PHASE (Pre-production, production, permit, construction). In the end I need to find the number of stores that Jim has that are active and in pre-production. I'm sure there is a really simple way to do this I just don't know where to start.

I've created a new layout. I copied and pasted some items from a provided template. If I close the database and reopen it, I get this error: "This action cannot be performed because the required table is missing" Everything seems to work fine - inserting records, serching, printing... It's like it is trying to run a script when it opens. Is there any way to "show all scripts used"? Or something like that? Any ideas on how I can troubleshoot this error? : / Thanks in advance

I have a 'quotation' layout with repeating fields (10 repetitions) with fairly large depths for the field so that if each field was completed in full it would span two pages. Problem 1: I can get the repeating fields to slide and the calculated field beneath them slides up too. However, no matter what I do, I cannot get the field title to slide (indeed in print preview I can't even see it although I have checked that the checkbox not to print is empty) I also wanted to print something underneath the calculated field but I seem to have the same problem. Is it where I am spanning more than one page? Problem 2: I need to be able to PDF the quote form onto heade…

I have a report on which I want all fields to have the same font characteristics (especially size.) However, some of the data fields are using a different (larger) font so that the report (actually labels) does not print correctly. When I look at the individual fields they do seem to be correct yet when I preview the data the larger fonts are still there on individual records. How can I fix this?

Post deleted by Kicker3

I have a few radio buttons where the choices are "yes or no" and those are in as number fields but display yes/no. How can I add a summary to total up the number of "yes" fields that I have for a particular person. I can total up fields with numbers fine, but I can't figure out how to total up the # of fields with the word "yes" in them. Thanks!

Hey everybody, I have two questions for the masters of filemaker... 1) Is there a way to insert a jpg, gif, etc. into a layout so that the picture itself shows instead of an icon that would open the picture in another file? 2) Right now i have a lot of powerpoint presentations stored in container fields throughout my db, which is making it grow a bit too large (up to 169 megs and going skyward). Is there a way to store the files on a host computer only to be downloaded to a user's computer when the user clicks on it, rather than have to store it inside the database itself? all your thoughts/suggestions/help are greatly appreciated. Hope you're havin…

How can I use number of records in a layout, as a part of a caculation. I tried setting a summary feild in the layout to reference, but it only counts the found set, I cannot force a find all from the calculation menu. Thanks for any help, Ed

I have always wondered if this is a possibility in FileMaker, and as I have started to develop DB's for people other than myself it is becoming an issue that I must know the answer to, and if there is not an answer what some people use as work around solutions. After I develop an Invoice or PO type Form there are many instances when a user will need to use more "lines" than are available on one printable page of a layout. I have always had to create a second record and then continue on. Two of the two obvious downsides is you would not get a grand total on the second page and sequential numbering would be off because I really want the second page to have the …

I have the following layout which I want to print: SUBHEADING (from repeating field line 1) COMMENT FIELD 1 SUBHEADING (from repeating field line 2) COMMENT FIELD 2 SUBHEADING (from repeating field line 3) COMMENT FIELD 3 Sometimes a subheading and its corresponding comment field is empty. I therefore want to slide the fields below it up to eliminate the space, but this doesn't seem to move them up as I want. Each of the comment fields is a separate field, but the 3 subheadings represent different lines in the same repeating field and this seems to be the source of the problem. I've thought of concatenating all the fields into one calcu…

OK, here is a question, about page numbering. I have a layout for printing customer bills. Now with some of the records the accounts slip to a second page or even a third page and id like to make it say 1of3 2of3 3of3 depending on how many pages the file is going o need to print. Any ideas on how this could be accomplished?

Greetings, oh wise ones! I have searched and searched, but have yet to find much information on whether it is possible to hide an empty field on a layout, but show the rest of the record. Specifically, I have a layout for required tools and supplies. Its table contains fields for item name, whether or not the item requires an MSDS sheet (Yes/No) and a container field which will hold the link to the MSDS PDF file (if one is required). Is it possible to hide the link field if it is empty, but show it (with border) if non-empty? Thanks in advance, Jeff

I'm a newbie to FM development and am hung up on what to do here. I have a few tables (please see attached PDF for my relationships graph) that are related that I want to reference in a portal. I want to associate Items to an Auction. The auctions table is related to an AuctionItems table. Items are related via the AuctionItems table. On a layout, I have details of an auction, and want to be able to add predefined items (from the items table) via a portal. I would like the fields Item Number and Item Desc to show in the portal. I **should** have my portal and relationships setup okay, but I am not for sure. I'm having a few issues: 1. If the …

Please help me out with this one. FM forms are giving me fits. OK, I have a relatively simple database to keep track of grades. Each student takes 3-4 tests per week. My wife needs to enter their grades for each test and then output results per student. The final report should be one report per student showing their performance on each test. The number of tests and type of tests vary week to week. I have the following tables and fields: Students Table with: StudentID StudentName Report Table with: ReportID ReportName StudentID Grades table with: GradeID ReportID TestID NumberRight PercentageRight Test table with: TestID Test…

I recently switched from Filemaker 4.0 to 7.0 Developer and from OS 9.2 to 10.3.9. I converted several data bases. I have a three page spread sheet layout in landscape in my Accounting file. Previously I used a Image Writer which doesn't have drivers in 10.3.9. I have a HP 4000TN Laser Jet on the Ethernet Lan and a Epson C86 Ink Jet at my desk on USB. I can only print the first page of the layout. What am I doing wrong. Thanks.

Does FM Pro 7 allow us to insert a pop up calendar (like the one in Yahoo calendar where you can add your tasks for a specific date just by clicking on a particular date so that user doesn't need to enter the date manually)? Could anyone help me to make this calendar thing possible? Thank you....

Hello, I'm new to FM, so please excuse my question if you think it's really stupid, or should be asked in a different forum. I'm using FM 5.5. I have a table which could be sumup to the following fields: - name: name of a person - book in date: date the person should arrive - book out date: date the person should leave - check in date: the actual date the person arrived - check out date: the actual date the person left I would like to build report on a date period (range from date1 to date2), which will return something like: Date ....... Book IN . Book OUT . Check IN . Check OUT . Present forecast . Present real 01/01/2005 ..... 2 .......... …

I am trying to change the background colour of the body of a layout from a light blue to transparent. Doing Layout>Part Set Up>Body and selecting transparent does not want to work - I still have an unwanted blue blackground! Any ideas? Frank

I did a contact database some time ago where the name of the contact was used in a layout as text in the heading <<name>>, I have to use it again but i want to modify the size of the font used. I have tried to select it and change it, it appears fine on layout mode but doesnt change in browse mode. Help please Marco Bahon

Working in an old database (v4.1)... There are 3 or 4 subsummary parts at the top of the report layout--to allow for different groupings (report grouped by school, by gender, etc). Is there some quick and easy (i.e. drag and drop) way to rearrange the subsummary parts? TIA Abbe

The app I'm building will be a kiosk mode interface to a database that will run on computers with a variety of screen sizes. I really want to assume at least 1024x768, but I know that some users will only have 800x600 - and others would love to take full advantage of their 1280x1024. I've been looking over books and FileMaker docs and it's beginning to look like managing layouts and windows is going to be a real pain - if I want to try to optimize the app's behavior to all these environments. Can anyone point me to a good discussion of layout design and window management in the presence of various screen sizes? (It doesn't have to be specific to kiosk mode, but it would h…

Right now I have a layout with a ton of fields--which means you have to scroll down down down to look at all the information. I want to create a layout that will have different pages or tabs for each record so that it opens with a section general information and then can click over to more specific info like contacts or background, rather than scroll down forever. How is this done? thank you in advance.

I've got a layout with three different portals. There are three different tables that contain customer information, the main layout contains the customer's name and contact info. I've related everything together with unique ID numbers, and my layout with the portals works fine. The problem is when I go to print. The portals don't print well, especially when they break across page boundaries. I can set up a layout with sub-summaries that will display the records from any of the three related tables, but can't seem to figure out how to get all three on the same report sorted first by customer, and then by table.

I'm new to FM Pro - have a database with prospects by year (text field). I want to create a report which auto filters on the current year, and then displays field details for records which pertain to only the filterered (current) year. How do I do this?

Hi everyone, I'm working with multiple windows more in vs. 7 than in prior versions ... much more. I've only been opening new windows over the top of each other, using straight layout switches or closing the prior window as I move a User through their process - never minimizing. But I still occasionally get a User trapped with the error "Can't modify because it's being modified in another window" in a few places where I've forgotten to add a Commit Record/Request. Oh dear. I'm reviewing my window-handling processes for several reasons (including many new features in vs. 7 that I'm just now figuring out how to take advantage of) But I have a few questions: …

I was just writing a script that I intended to use to drop the user into a new window and step the window into Layout mode, from Browse, and can't find any way to do that. Strange that there are script steps to enter all of the other modes (and views) except this one. Thinking that I could just do this as an applescript step, I opened FM's dictionary and darned if there isn't a way to do it there either. Yes, it's easy enough to get there by command key, I just wanted to make the user explicitly aware that they were in layout (it's to fine tune a print layout). Anyone have an answer for this? Much appreciated! Tony

I have a subsummary report. Because some parts that are summarized don't have many line items, it would not look nice to have a page break for each part. Some of the parts have quite a few line items, and continue on to the next page. Problem is, the column headers that are in the subsummary part don't print again at the top of the next page. Is there some way I can get the subsummary part to print again at the top of the next page (in an ideal world, with a "Part (continued)" note).. Like so: ------------page 1 Invoices for My Company Invoices for Acme 1 2 3 4 5 Invoices for Baxter 1 2…

I've been trying to make a traker for the finance company i work for. The database holds information on customers who have applied for a loan with us, each application will have a status of Pending, Not Paid, Paid, Declined or Cancelled. I am trying to make it such that each record is colour coded to the state the application is in. I have had some success in making colours appear depending on the state by creatin 5 fields each named as one of the 5 possible states and containing that state. then creating 5 relationship each from the status field to one of the state fields. Then creating 5 portals, one for each state and putting a different colour box in each portal.…

I have a DB based around a table called

I have a database with many layouts. For example, I want to fill the color of blue to the header and footer of all layouts but don't need to do that for each layout individually. The same thing, if I want to change the color, I want a way where I only need to change once... Please let me know if Filemaker Pro has such a feature! Thanks very much! Jie

I've got a few layouts that are unavoidably long. I'd like to add navigation buttons that allow the user to scroll up or down. Any experienced FMP people have a simple solution? Thanks in advance for your input, Mark

Greetings! I posted this under Printing Issues, but maybe somebody in here knows what I need: It took me awhile to figure out the ins and outs of a line items file, but some of the posts in here have helped me get out of the "repeating field" and it's confusions. But now I can't figure out something else: To make this as easy as possible, If I can find the set of desired items in a line items file, how do I set up a print layout that is based on other criteria in the items? For example, in a vendors file, sorted by item number, I need to display the status of different orders and inbound shipments. I can find for the vendor and sort by the part numbers, b…

Is there a library of small icons available, such as "insert","Delete"? Ivan

hello. I have a text field in a table, which has information the user can type into. It's about 4 lines high in the data entry form. However, you can put a lot of text in there... obviously if you print that form, you only can see the first 4 lines of text. is there a way to create a report, which will expand the field - or grow the height to show all the text in that field? It could be the text is only 4 lines - but it could be that the text is many lines and there should be a way to adjust that dynamically.. is there? how do you do it? thanks for you help in advance, sincerely, J__

I was wondering if anyone has done something along these lines: A user enters the variable data # of rows and # of columns. Click on a button that would create the records and label a text field for each record. For example, the user enters the following: Number of Rows: 12 Number of Columns: 8 96 records are created, with A1,A2,A3,A4,A5,B1,B2,B3,B4,B5,C1,C2,C3,C4,C5 Etc... TIA, Charlie Abrams

Hello, I was wondering if there is a way to stop scrolling with the mouse wheel in windows. I have a Project->Tasks relation (1-M). I have the project data at the top and a portal at the bottom, which shows the descriptions of the tasks. I then click on a Task in the portal and (using go to related record) it takes me to a tasksDetail_Layout, which shows all the good details. The problem is, if i have a mouse wheel, while in that view, i can scroll the wheel and it will take me to other tasks. I'd like to have a way to keep from going to any other tasks when using the wheel. Once i have finished viewing the task and maybe editing it, I want to jump back to…

I have a table (not created by me) that has one field (referrals) that has from 1 to 4 inputs. IE - from 1 to 4 persons names. There are other fields with the same problem: address, city, state, zip. I am trying to make and print labels from this field, but so far all I have been able to get is one label, the first name in the field. I have searched and so far have not found an answer. I could redefine each field (refname1,refname2,etc,etc) but then would have to make 4 label layouts for each one. Is there a way I can print each name in the field on a label without going through hoops?

holas i created a photo data base, which contains a media container (for the images thumbnails) and some text fields (for the metadata). i've already organized the records in a form- and list-layout, but i'd like to view the thumbnails in a layout similar to a photo-gallery on the web (rows AND columns). i tried to rebuild FM's solution (photo catalogue), but didn't get through. does anybody know how to do the gallery-layout or knows how FM's solution work? thank you, mil gracias.. patolujolimone

I have modified the Purchase Order Template that comes with FM 7. I will use the modified form to fax or email to our suppliers. I am able to get 25 repetitions on the first page of the form. How can I make a second page print if I need to order more than 25 items and still keep the same PO number? The entire form is contained within the form body. There is no Header or Footer. Thanks, Phil

Hi, I have a DB that I am going to be using on the hospital floor as a Resident. It has several tables: Problems: Each problem is a new record and is given a "problem #" Then linked to each problem # are other tables like: - Medications: What I'm going to treat the problem with - Tests: What I ordered to diagnose each problem etc. So, what I would like is a summary form that I can print a daily note from. It would look like this: Hypertention - Medication A - Medication B - EKG Asthma - Medication C So basically it's like a project manager in a way. Each problem has several components linked to it. I can just go to the med…

Ok. I have too many layouts. Is there a way to organize layout? Trees, folders, ect..

Hi there Wondering if anyone can help me get back on track with this - I have hit a bit of a block! I need to include Statements & Invoices that will get info from sales and Job Sheet but maybe I just need either sales or Job Sheet rather than both - Am I over complicating? Also need to have the VAT work out amounts quarterly but can't figure out how to do this... Also where I have email and telephone as portals do I need to include any other info fields in the telephone and email table? File attached - can it be rescued? Any advise would be greatly appreciated. thanks, diane MINE_FMP.zip

I am trying to to view a related record in a new window, but I can't seem to get it to work. Concept of what I am trying to do: I have a file that have two tables, 'Customer' and 'Address'. I have a layout in form view that is based on the customer table. There is a portal on this layout that is related to the address table. I want to be able to click on one of those addresses listed and for that address to open up in a new window filled with the address I clicked. What is currently happening: I click the portal row and the new window appears but not the correct the address I clicked. I either get a blank record or the first record in the portal …

Hi, How can i make things (text or even record) changed there color base on a what is type in a field ? ex: I have a field "Priority" wich is a Value list : High, med, Low. So, if i select "High" I would like the record to appear in a red tint, or at least the text "High" becoming red. thx guy

Hi. I'm not sure if this is the correct forum for this but here goes... I have an Invoice Status field which the user can change by means of a dropdown box. What I need to do, is to write to a log file every time the user chooses a new status. How do I do this? I've been trying out a test script (I set the field as a button which performs the script) as follows... Allow User Abort(Off) Go To Field[select/Perform, "Status"] # add to log file using the new value of the "Status" field Exit Script However, when trying to add the new status value to the log it doesn't work. It applies the addition to the log using the old value of the "Status" field…

What am I doing wrong? I have a layout that contains a header and body area. If I try to increase the size (vertical) of the header, then if I try to restore it back to the original size by sliding the line that delimits the area (not sure of the correct name) back to where it was originally, it refuses to do so and leaves white space around the graphics ... this layout uses coloured rectangles behind the fields. The only way (that I could find) to recover from this was not to save the layout. I had this happen on another layout. I made the mistake of saving it and was not able to restore it to its original condition. (Perhaps I could have by copying it from a backup…

Friends, can you help me obtain a running count of records under a subsummary? I've tried summary fields, the GetSummary function, &etc but no luck. Under each break of the subsummary I want to number records starting with "1" and on up to the number of records. Then start again with the next break. What am I missing?

Hello I'm new to version 7 although I've been using Filemaker for over 10 years. There seem to be some fundamental differences and I wondered if people had advice on the best way to do something. It seems I'm not the only one out there with this idea but several people have said that copying tables isn't the best way to go about things. I'm using a solution from Queue that allows you to count how many times an option is selected in a repeating field. (http://www.fmforums.com/threads/showflat.php?Cat=0&Number=134738&an=0&page=0#134738) However, I'm having problems getting it to just evaluate the results for a found set of records. So I was thinking …

When I use the New Window script item to create a pop-up type window that is smaller than the full screen window, Filemaker automatucally takes the old window and changes its dimensions to match the new window. Is there anything I can do to prevent that behavior? Thanks.

I have created a new layout. One of the fields is telephone numbers. When I go to format and click on the fields The name field and phone number field will change colors, text whatever I want, except for the size of the text. When I specify a size on the phone number field (set up a a text field) some of the records will change and some will stay the same. The ones that won't change - if I change them in browse mode to what I want it changes the font size on those particular records back in the original layout as well. What makes the records respond different and what do I do to make layouts with the font size I want?

Hello, I've seen this problem in both 6 & 7, and I don't know if it's a bug or a feature LOL Anyway, suppose that, instead of specifying a background fill color for a particular layout part, you insert a graphic that isn't solid. Now if you add a field on top of this background graphic and specify a background fill pattern as transparent, everything looks good, until the screen refreshes (like when moving to the next record). What you see is a white "screen flash", which isn't very attractive. Is there *any* way to work around this, short of removing the background graphic and specifying a background fill color? Regards, Sean Mills

Hi We use FileMaker 5.5 and 6 I've noticed this problem before and it's really irritating! When designing a layout that I intend to use for print purposes I align all the fields and their labels so they look fine in layout/browse/preview mode. The layout consists of a logo, field labels and merge fields. The field labels and the merge fields are different fonts and different sizes. Then in this case I'm using Adobe acrobat to print to a PDF file. When I print to the PDF the merge fields are not lined up correctly with their field labels. The same happens when I print the layout directly from preview mode, so that eliminates the problem being…

Newbie-ish Question: So I'm getting ready to start cleaning up my application. I've come up with a color scheme/left-hand navigation pane/"main area" coloration etc. What's the best way to make it uniform on all/most of my layouts? I estimate that I have about a 12 -15 different layouts that the user will see - all of which I want to have same base "look amd feel". Thanks in advance for your input. -Mark

I have a DB listing shirt sizes and pants size for 400 records. The sizes are controlled by a value list using radio buttons. I am trying to do a sub summary showing how many of each size I need. When I do a sub summary by shirts and pants I get the following breakdown. Shirts: YS 4 YM 6 but then I get the following breakdown for the pants: Pants: YS 4 YS 3 YM 3 I want the pants to display as YS 7 YM 3. I know that it has to do with my sort order but is there any way to sort by two fields consecutively?

I created a line items report and all was great, until I went back to add a field, now my report is not subsummarizing how I created it with the report wizard. I didn't change any of my page breaks, so why did my report go from calculating my subsummary totals, to not showing any totals and listing all the records one after another? The field I added was in the header and not in the body..not only that, but another report began doing the same thing and I didn't even touch that one, If you change a layout does it affect your other layouts as well??? All ideas are welcome...thank you!!

I have a custom label layout, so the layout's size set at a size that will allow me to print 5 labels out onto the label. However, whenever I add a new field to the table that the layout uses, FM7 will automatally add the field to the end of the label, which expands the size of my label and throws off the printing for the label. I realize I can just switch to another layout when I'm editing the table, but I'm curious to see if anyone knows if there's a way to either lock the layout, or have fm7 not automatically add the field to the end of the layout. Thanks

Ok, I have a DB for a sports league. 2 realted tables-1st table contains team name, captain name, etc and the 2nd contains all the players and their id numbers. They are related by an index field. I have it set up now so you can choose the team name from a drop-down menu and all the info and players are displayed via a portal...but I need to be able to display 2 teams that I choose from the menus and their respective information side by side on the same layout. I can't seem to find a direct way to do this, can anyone help. Much appreciated.

The latest FM update now pastes styled text (with font, size, etc.) into text fields along with text. Unfortunately, I almost never want to preserve font and text style when I paste stuff into a database. How can I set up a layout to disregard any font or text style and use the field's defaults settings? Alternatively, how can I strip out font and text style or execute the paste command so that font and text style don't get into the database in the first place? Thx, Chuck Henebry

I have started a layout of family contacts. Does anyone know if there is a premade template out there that I can use for a family tree? I'd like to keep it all in FMP. Thanks! [email protected]

Hi. I have a table (A) with >100 fields, which is formatted with a custom layout. I would like to create a different table ( using a subset of the fields from table A with the same layout. Is there a way to duplicate an entire table, then rename and edit it? Thanks, Gwen F.

Is there a maximum number of pages you can have in any single layout? I was trying to have over 10 pages or page breaks, but it wouldn't let me drag the body down any more. Is this the max ? (10 pages)

I am stuck on what seems to be an easy layout. I have a table of medical patients and within that are two portals, one for medication allergies (each patient can have many allergies) and below that a portal for their medications. In the medication portal there is an active checkbox and the portal sorts active to top and inactive to the bottom. (again each patient can have many medications). All I want to do is on that same page have 1 button that will create a report that I can print with patient being worked on at the top, then allergies and then only the active medications. Would appreciate any ideas. I will attach a sample file without any real patient data. Than…

Quick question regarding layouts, Ive got a layout I

Hi all! Any advice would be really appreciated... Say I have a checking-account like application: I have a transactions table that stores the withdrawals and deposits to the account. And let's say I have a summary field that gives me a running total for the account. Then I would like implement the following process: 1) Allow the user to pick a year to report on. 2) Look up the starting balance for that year in a table. 3) Generate a report that adds the starting balance to the running total. More specifically, let's say the report shows the starting balance on January 1 of the chosen year then shows subtotals for every month. I'm okay with steps 1) …

I'm trying to create a report that will prompt the user to enter a date range, but will already have certain criteria checked off that it needs to include in the results. Here's an example of the fields: [Date In] - This is where the date range can be entered for lookup [Rush] - This is a checkbox that will have already been checked before the user enters the dates [stage]- This is a drop down list of items and "Hotslip" is the one to be used as part of the results. Now I know you can just go into Find Mode and make these choices yourself, but is there a way to automate it where "Rush" will already be checked and "Hotslip" will already be chosen so that when t…

I have records sorted by employee name, and in preview it looks fine, with the name and then all the records sorted below the employee, but when I publish it on the website, the employee name shows up, and the records below are not at all for that specific employee... like its not taking the sort on the web or something. There is no summary fields or anything complex, just one simeple3 sort by name. Any ideas?

In my FMP 7 database, I have a layout/report that uses info from two tables. When I bring up the basic tabular layout for one of the tables, call it table A, I notice that due to some cutting and pasting done in populating the table, the font style varies across the fields and rows. When I view my layout/report in Preview mode, I find that the field font styles I specified in my layout/report design are ignored and the font styles seen in the basic tabular layout are being used instead. How can this font style override be eliminated without resetting the font style of every field in every row in table A? I hope this makes sense Thanks, Steve C.

In list view, is there a way to make it so that the current record has a different background color? I am very new to FM, any help with this is much appreciated!

I am a bit of a Newbie to FM, but I have been building websites for years. I am wondering if anyone knows if FM has the ability to do layouts in frames? In other words, is it possible to have a list of records on the left, when you click on the record details of that record appear on the right but the list of records stays on the left. Any ideas? Thanks!

Does anybody have a procedure for changing the background color of a field that has focus or is selected? I don't think this is possible but thought I would throw it out there before i totally dismissed it. Is there a plugin that might do this? Thanks! John

All, I want to create my own themes. This is not documented in the FMP 7 Help, but the theme files are easy to locate and they are pretty straightforward XML. So I could change themes or create new ones if I like... trying this and that to get things the way I want them, spending a *lot* of time doing so. So... does anyone have, or know about, a documentation of possible settings? FM does not provide that information, it seems- I scanned the Techinfo without result. Thanks for any help! Lutz Pietschker

I have a simple database that is designed so that users can log company supplies they have used on a week by week basis. Each week the employee will create a new record and log there supplies. I have another layout in this database designed so that I can print all of this information for that employee/week. The problem I have is that when I go to the printing layout It shows me all the records. I only want to view/print the record I was looking at on the other (browse) layout. Is there a way to say "find current record" via a script? Any thoughts are appreciated.

I want to create a layout with a menu to access other layouts. Exemple: Go to "FILE" and a menu pop-up let you select where to go, or just select "print". and something like that. Go to "Exit" and exit the app. Is this possible?

Hello, I have a 1-M / Master-Detail layout. In the header i put my main table (Invoices) and then in the body I put the invoiceLineItems table. Invoices has a 1-M relationship with InvoiceLineItems table. is there a way to print the header only on the first page and then on subsequent pages only print the body? sorry if this is a faq. thanks J__

In the preview mode the one row in the bottom is appear, but why in printing result the one row disappear ? i have enabled Sliding and printed on. can you help me?

Is this possible? Have a nice looking header with two buttons in it with script applied to the buttons. Do I have to recreate this header in all layouts or is there an "Apply To All" function somewhere? Thank you!

How can I start page numbering other than by 1 without putting blank pages in my layout? Or how can I decide the starting number of page numbers?

hey guys i have a layout that has a blue background. on top of the background is a large white rectangle. on top of that are multipl eother colored rectangles. on top of them i have transparant text fields. anytime you click on any one of the fields that are transparant you can see through all of them all the way through to the background. is there anyway to get around this? is this a bug or am i just doing something wrong? thanks, Anthony

I tried searching for this topic, but couldn't find any posts... I want to be able to create advanced button designs for my FM solution. I'm using FM Developer 5.5. on Windows XP, so that rules out the button tool that I found on Apple's website. Does anyone know of a button generating tool that allows you to create buttons for use in FM on the windows platform? I found out how to make cool "Aqua" buttons using Photoshop, but am unsure of how I can implement these in my FM layouts. If I "Insert Picture" it inserts a rectangular image (even though my Aqua buttons have rounded ends). Also, the colour that the button makes upon click is HIDEOUS! Anyone out the…

I want to affect, with a percentage, the total of each summary fields seperatly with different % numbers. How can I do that? Is that possible?

Hi. I'm new to FileMaker Pro so please bear with me. I have a Person table and a related Donations table. I am using the Layout Wizard to make a report with groups (based on the FullName calculated field in Person) that includes the donations from each person and subtotaled per person. When I click the Specify button to choose the Amount field for subtotals, all the fields in the list are greyed out for all tables and I can't specify anything for subtotaling. Am I going about this right way? Is it possible to get subtotals in a report containing related tables? Thanks David

I understand that FM7 introduced the possibility of having more than one table in a file ... and that it was thereby possible to have metadata and layouts in one file and data in another. Is this so? If so, is it possible to combine layouts from several files into a single file?

The layout header is light gray with some black text. The rest of the layout is a subsummary line. A footer contains the text "hi there". Viewed in Preview mode there are 23 pages, completely and utterly white. Everything is set to be printable. It was working until I did some fiddling, so most likely it was one thing I did to make everything invisible. Does this make anyone go "ah-hah"? Gratefully, Chap

Hello, It was tough to describe what I am looking to do in the Subject line. I am trying create a form that only populates if corresponding fields are populated. Let me give this some context.....I have created a database to enter in details for producing photo shoots. All of the logistical information is enetred in several layouts (using tabs for the user interface). What I am trying to do is take the information that was entered about a specific photoshoot and output that to a form. When the photo producer needs to get something approved, they would push a button to take all of the information that was input and present it in a nicely formatted form that…

New to FP7. I added a great looking header to one of my tables. Is there a way to apply said header to all existing and new tables I create? Many thansk all!

Hey Guys, i want to be able to have a status area on the main screen of my ui. the status area will show how an order works its way through they system. i want to be able to use either pictures that change automatically based on a condition or an object that changes color automatically based on a condition. this condition will be a simple true false with only 2 possible results for each object or picture. anyone know how to do this? Thanks, Anthony

I've searched Filemaker Help and can't seem to find anywhere to set "hyphenation" on. I'm typing in an invoice description (for types of services rendered) field and when getting to the end of the text box, it's not hyphenating the words, forcing me to manually enter a "return" to type on the next line. Any help would be greatly appreciated. Thanks

I have design a layout in which I need about 70 tabs in a few text items such as four fields and two text labels populated with field <<info>>. I have entered the tabs' settings every 25 pixels up to 500 pix and no more new tab... I need them but I do not know how to overcome that issue. Is there a workaround with other program -Which one?- and the pasted text manteins the format? Any idea? Does the versi

Hi I am new to FM (just got it as trial). In one of the samples that come with FM there is a Purchase order table that I want to copy into my test database and modify it. How do I copy that table into my DB? Thanks

I'm trying to modify some layouts ... but one is proving difficult because I cannot access the status area. In addition it has a body part. I have been unable to identify why it has a body part (I think it has to do with reports), but other layouts don't and I can't see how to remove it and how to get my status area back. The documentation is not at all helpful about what causes parts to exist in a form.

Can anyone help me get my Newbie head around this... On a job sheet I need to detail individual product items - some jobs have many different products used so I don't want to limit myself with repeating fields - each product has a unit cost and some have a specific tax rate which I would like to have attached to that product, maybe I should give up for today and start again tomorrow but I just can't figure out how to go about it. any ideas would be great thanks

I setup the table, my problem comes in when trying to print labels (off a 6 label per sheet) when the first 2 labels have already been used.(or any combination have previously been used) I need to make it print on the next available label. I can't figure out how to do this. Any help will be appreciated much.

I've got a table which contains rows of data (previously created on another system and imported). The rows contain data like: Jan Chevy 310 Jan GM 125 Jan Audi 289 Feb Ford 122 Feb Saturn 301 Feb Honda 227 March BMW 341 March Porsche 298 March Mini 432 ... What I need to do is get this data into columns so that it's more spreadsheet like. i.e.: Jan Chevy 310 Feb Ford 122 March BMW 341 Jan GM 125 Feb Saturn 301 March Porsche 298 Jan Audi 289 Feb Honda 227 March Mini 432 I've created a secondary table (in the same database) with the fields for the (9) columns going horizont…

Hello all, I have an invoice and am having trouble with my sub-summaries not displaying the data correctly. The following is what I need my invoice to generate: 1. Show all the suppliers that were used on one invoice for one customer by month. 2. Show a total of all line items for that month by invoice number and customer name. Problems: (Right now I only get 1 supplier line and 1 total in browse mode, in preview mode I get more line items, but no totals or breaks between customers) I am using the report wizard, but I don't think I am entering the correct fields to be summarized, or I am putting them in the wrong place. I'm not too sure what…

Question 1: I use FMPro 7 and have a question. Provided the subject matter, you may be able to tell i am new to filemaker. I am building a database that has to add contacts. Each record has company address, phone numbers, etc.... I also have fields for contact person: Name, Title, Email, Dept, Contact Rank (1,2,3,etc) I would like to create a button that when clicked, a new contact person with all the contact person fields are duplicated, rank+one, clear fields (no text from the prior contact.) I would like it so that the first three or 4 contacts are visible to the screen, then the rest, if applicable are seen using the scroll bar. Can someone please …