Layouts

I am trying to put togather a simple Invoiceing system which i have managed to do up to a point. I have an Invoice header table that contains the invoice numbers, date and client details, i then have an invoice line table that stores the indivudual lines of the invoice. I now want to print the invoice, meaning that i want a report that will print the header and then each line that is linked to that header but i can not figuer out how to do it. can any one help me ?

Hi folks; I have always received excellent answers to my queries and I am hoping that this trend continues. Any assistance you can provide is, as always, appreciated. In a data entry form is there an easy way to create drop-down options that may, or may not, offer secondary options and even offer third options. Something like: 1 Option with 2 sub-options (like 1A, 1B) 2 Option with 3 sub-options and the 3rd choice has 2 sub-options as well (like 2A, 2B ,2Ci, 2Cii) 3 Option with 4 sub-options with the 2nd and 4th choices having 2 sub-options as well (like 3A, 3Bi, 3Bii, 3C, 3Di, 3Dii) I could not get this post to show it graphically but in ess…

I want to create the tools for the user to construct his own mail templates. So here is the deal: I would have a layout with a large main text field on the right side of the page, and on the left side I want to have common pieces of text and relevant fields (tags) that the user can insert into the main text with the click of a button next to the tag. The button(s) will trigger a scripts that will insert the text (or field) where the cursor is in the main text. Here is the problem: Normally I would create a mail template and blend texts and fields in layout mode using merge fields. How do I do that in browse mode?. In other words, I want the user to be able to insert …

Hi guys, (I'm using Developer 7) I've done a search already, and although I found solutions to change the color of a field through calculation or script, what would you do if you had, say, 100 fields that needed this done ? That's a lot of calculation fields, or a high maintenance (and not to mention large/slow script). I was thinking of doing something with a portal, displaying a background based on the field value, but I can't figure out how I'd do that with multiple fields... Anyone have any suggestions (and lets hope they include conditional formatting like excel into version 9) ? Kehama

I working on a database to automate our scholarship notification to students. I have it just about done, and want to be able to create a button that looks at the information I've given, and takes me to the CORRECT individualized letter I've created (with data for that need). Let me explain: We have student who are going receive an academic scholarship and a housing scholarship. Some can just receive a housing scholarship, and others will just receive an academic scholarship. I have individualized letters with this data already entered. What I want to do is make this an automated process, so a secretary, etc. can click a button once the award information is e…

Although a relative neophyte to FileMaker (haven't used the application for years), in other databases (based on FileMaker such as in AppleWorks and old Apple versions of FM), I was easily able to insert a "check box" in my layout (one of the fields). The blank check box could easily be checked to indicate that a certain action or condition had been met or left blank to indicate "no", etc. However, I cannot determine how to do this in FileMaker Pro 8. Can anyone help with this? Thanks, Dale

Where can I get additional multi-use buttons designs?

Is there a way to modify the column headings in table view?

I'm new to FM so be gentle with me! I need a layout to display records between 2 dates that the user enters. The table contains a date field, "deliverydate" which is the one I want to base my results. How do I go about it. Sorry if this is really basic stuff to you pro's! John

I have a script that walks through the entries. When finished I must click in window to get updates of totals. How can I do this at the end of a script, un selecting the last script and totaling, rather than clicking in blank area of the window? Thanks Steve

A client enters in this report manually in excel. They'd like it generated through filemaker. Any thoughts on how to generate this report, based on the number of orders a client has? Thanks everyone!

i wana create a INTELLIGENT message sender so that if some fields have a specific criterias a dynamic message send to a specific client user and shown in a popup window in his/her filemaker window, how can i do that?

One of my layouts must have gotten corrupted somehow; all of the fields and images/text I had on it no longer show up. In fact, nothing shows up on this layout, and the layout name is blank on the left hand side of the FMPro window. I've created a new layout from scratch without any difficulty, but can't do anything with this old layout. Clicking "Layout Setup" does nothing, and I can't add any parts, fields, etc., and hitting Ctrl-E does nothing. Does anyone have any idea how to delete this layout?

Help! I've spent the better part of the day trying to solve this problem: I'm trying to print merged labels in FMP6. I selected the type of labels I wanted to use. I told it to print the labels in 3 columns across. When I preview or try to print, I only get the first label on each page. It isn't printing one label per page, but ONLY the first label of each page, skipping the 29 labels in between, although they are there in the database. I'm sure it is a setting problem that I've made, but I can't find it. Would appreciate any suggestions.

I just wanna scroll down my form, and it wants to change records. Any way around this?

I cannot delete any records in one of my files. I have two files set to relate via an ID field. The relationship allows deletion of either record if the other is deleted, yet they won't delete. Via script or menu bar, I get the message if I still want to delete and of course I choose to delete. Yet nothing deletes. Account prefs are for administrator so allows deletion. What am I missing? Thanks. PS The solution structure is: GUI file with one record and tons of globals that I use as match fields to bring in the related tables from other files and tables. The Data file has the data. The BR file has the calculations, concanotations, graphics etc. The …

[edit: I checked to see if duplicating the layout and then making changes would work, and it does, so it appears that it's possible to have a corrupt layout? Is this a common problem in FMP 8?] I just lost an entire day's worth of work due to a bug in FMPro 8, and I can't figure out what's going on. I did a lot of tweaking with a layout, adding tabbed layout submenus, deleting a lot of fields, adding others, and formatting everything just so. When I exited out of FMPro and came back, none of my changes were there. None. I've experimented with adding just one text field and one field, clicking "Save layout changes", exiting the program and coming back, and …

I've converted several files from fm5 to fm7. I'm now putting all the files into one file and relating the tables. No problem. The problem is some of those files have a very large number of layouts that are mostly custom reports and other things that the client prints out all the time. How in the world am I going to escape the slow tedium of recreating each layout in the new solution file??

Is there a way to only enable certain fields to be entered under certain conditions? For instance, if I have a field specified as a pull-down list with options 1, 2, and 3. And I only want certain other fields to be able to be edited when option 1 is chosen. Then other fields can only be edited when option 2 is chosen. Etc. Thanks.

I have a layout that is supposed to group sales for the day by agent and prvide the total sales each agent did for that day. When I run the layout I do not get the agent name to print out and the total is the grand total not the sub total for the agent. I used the wizard and an working with the script FM created as part of the wizard. Any suggestions? Thanks, Wizbang

This is really dumb, but I can't find a simple solution... I have a client that receives orders on the internet. She cuts names, addresses, etc, and pastes them into the appropriate FM field. Frequently the data is in a larger size font, or an odd color. She wants the data to convert to the font, size and color of the appropriate field. Is there a way to do this other than a complicated script that will reformat the text in each field?

"i wana to have a list report that shows my each field contents how many time repeated in my database"

one field contains lengthy text and is formatted to scroll. a second field is a repeating field that contains keywords that I input based on information from the first field and is the related field for a portal from another database. is there a formatting step that would allow me to freeze the first field as I edit the second field so that the first field does not return to the beginning of the text? If not, are there suggestions for other ways to solve this ... I am considering creating a new window containing only the second field, but don't know if that's the best solution. Thanks.

What if I want to exclude multiple records from a report? I know I have to attach it to a button. I want to exclude records that have the project status as finished. However, I have a container field that corresponds with the project status field. For example, when the field says "finished" the container field becomes gray. So, how can I exclude the container field color gray and the project status "finished" from my report? Sorry, it was a long question.

Hi all, I've created an invoice report showing amounts outstanding 30, 60 & 90 days. What I'd like to do is exclude invoices marked as paid from the report (Each record has an "invoice paid" yes/no popup field). Any help would be greatly appreciated! Steven

I know that you can restrict modification of a field value based upon the user's privileges. However, can you prevent the user from even clicking into a field that they don't have access to modify? So, if the user only has 'view' access to a field, I don't want them to even be able to to enter into the field. They way I think FileMaker works is that FileMaker will allow access into the field, yet if they try to modify it, they will receive an error. I don't want them to even be able to click into the field if they don't have access rights. Other users will have higher levels of access and should be able to click into the field and modify it.

Hell again, I'we seen FM files that have a line dividing a set of layouts in layout menu? How can I do that? Thank you. Regards,

Sorry if this has been asked before, we are having a problem with FM8 that we did not used to have with FM6 We have a number of scripts that we use to insert common paragraphs into quotations that we send to our clients. The field for the quote is almost A4 in size. Normally the user will type in specific unique info for the first part of the quote and then choose a script to add the common paragraphs like delivery times, terms etc. In FM6 we could run the script and the text would word wrap if it was longer than 1 line. In FM8 we are finding that instead of word wrapping, the word at the end of a line will split, resulting in the first part of the word on 1 line…

I was wondering if in find mode there is a way to stop the find button from showing up in the status area? I want to force the end user to use the find button I'm providing so it can run a script I have attached to it.

Hello, I am pretty new, and am wondering if there is a way to add space between fields all at once? Everything in my database crammed together and overlapping! I have attached a screen shot. If you can't open it, I'd be glad to email a copy to you. Thanks in advance for your help! Alisun

I am fairly new to all of this, but I have a real good start on a FileMaker solution that I have designed to keep track of individual sales reps in our company. I am having a problem getting any reporting to work, mainly because I'm not sure how to do it. Here is the short of it - I have several value lists set up where I can select from a main screen which sales rep - what the product is - and the result of the sales call. I am trying to come up with a reporting page that will show me, based on each sales rep - different stats on them - but I have figured out that I need to be able to read into a value list for a search. I'm at a dead end with this. …

Hi, I need to greate a word document, based on a word template, with information from filemaker as companyname, adress, person, zipcode, city, country and header. Is this possible?

I have a crosstab-type report consisting only of summary and sub-summary fields. I want to have conditional formatting of several of the subsummary fields, and I've been using the traditional way of doing conditional formatting: creating a _display calculation field with a formula like so: Case (sumReconciled < sumPhotoDone; TextColor ( sumReconciled; RGB (255;0;0)); TextColor ( sumReconciled; RGB (0;0;0)) ) It displays correctly in the layout with the formatting, but it all the subsummary parts are displaying the grand summary value-- i.e. they're all the same and not broken down by the grouped field. Is it possible to show the correct data and th…

Hi! It is possible to show all layouts in layouts menu to Administrator and hide some selected layouts in layouts menu to the other users? Thanks...

I'd like to use the Auto-complete option for a field, but the process has become very slow. (There are 46,000 records, which might be part of the problem. The solution is served on a Windows network) Is there anything I can do to speed things up?

I made all this work fine, users get this message "NO ACCESS" on a layout.Is it possible to make it so that they automatically go back to the main menu when the no access is written? Thank you?

In FMPro 7.03, I have a list of records, with a two-page layout - when I print them, I find certain records come with an extra, or third, blank page. This does not show up in preview mode, but only when I print, whether to a printer or to a .pdf. Has anyone run into this? Many thanks,

On any of my layouts, when I tab into a field (set to select all upon entry) the field background changes colour. Can anyone tell me where this characteristic is assigned and whether or not I can change it? Thanks very much. Wingnutt

Hi ! I have a problems with fields that don't disappear like similar other fields when they should. Please see attachement... There is 15 portals which each shows information of their relasionships. In blue boxes there is "callsigns" (A1, A2, etc). When there is something to show the callsigns appear in portals. The order of callsigns can be changed. If I remove whole callsign, in some portals all information disappears as it should. But there are some portals where empty blue box still remains. It works perfectly in other portals. I have tried to copy correctly working portals and changed the relationships correctly. I also have tried Bring front/send bac…

Okay, I'm still fairly new to Filemaker, and I can't seem to get around this annoying behavior in my layouts. Whenever a user clicks into any field to enter data, every single field on the layout becomes "highlighted." I put the term in quotes because it's not *exactly* highlighted, but the little dotted lines appear around all the fields. This doesn't interfere with the functionality of the db, but it annoys the heck out of me. Anybody know how to prevent this?

I've produced a report, and am having trouble displaying the jobname field, as some of the records contain a "?" instead of the value. Now I know that the field is smaller than the actual title, hence filemaker substitues ? with the title, but is there a way where I can force FileMaker to display as many words that will fit in that space as possible - without the need for creating another field with a calculation. Many Thanks

Hello, I have been using FM8 on my home computer and office computer, the program acts differently on each one. Office: when moving items around in layout, there are some serious pauses as I move. It is very slow. Is this to to do with a graphic card, or is there a setting that I can modify? Home: when opening FM, it loads slowly, taking about 40 secs to open a file. At my office, it is almost instant. My computer at home is older, so I would assume a memory issue? Thank you, Michael

Okay. I found this odd, but I have this layout (project cover) with a portal listing the projects from another table. I have records in this portal on this project cover layout, but it's not showing up in preview mode. Did I miss something?

How can I get filemaker to allow me to type in a 6 digit number into a number field, then when I press enter perform a script of my choice? It's a PIA clicking the "import" button everytime.

I have a report that currently looks like this: bob 12 bill 10 bob 8 ben 13 bill 4 I want it to look like this: bob 20 bill 14 ben 13 When i mae the part into a sub-summary of names, no records show up at all. Any help at all would be GREAT!!!

Hi dear helper, I am new in FM8, so here's my big question: I have a drop down list on my layout, and would like to enable the search feature on this. If the user chooses an option from the valuelist in the dropdown list, FM should automatically search for the records that match this option. How should I do this? tnx in advance, Regards,

I could have sworn that I heard somewhere, maybe at DevCon, that with FileMaker 7/8 you could use buttons on a layout while in Preview Mode. My feeling now is that I am wrong, because my tests have proven me wrong. Anyone know the actual answer to this?

I am currently working on a work order database for my employer. I have a key in the employee information table called the pawprint which is a unique user name for each employee. This information table also includes their location, phone number, etc. My problem is that I want to be able to enter this pawprint in a blank in my main Work Order table, and have the name of the person, which is uneditable in the blank below it. I am including what I have so far. Any help would be much appreciated. LAPS_Database_Test.zip

Is there a setting to show the field names in layout mode? Since fm7 fields show ghost data rather than the field name in layout mode.

I have a report that lists payemnts received ona specific day. I woudl like to SUM up the payments amounts for the day and get a count on the number of entries. I ahve tired to doa Column List/Report format, group by Payment Date and tell it I was sub totals and grand totals. When I get to the page in the wizard to set up the subtitals it will not allow me to selelct a field. My report uses the following fields: Transaction Number (text) Account Number (number) Payment Date (Date) Payment Amount (Number/Currency) Payment Fee (Number/Currency) Can someone please provide some guideance? Am I suing the wrong format or might I have a settin…

Merry Christmas! Sure could use some advice/suggestions for an unexpected problem I'm experiencing getting merge field boundaries to behave appropriately on my printouts. Presently, there is an blank space occurring where no data occurs in a merge field. I want text to automatically shift left (and/or up) when data does not occur in the preceeding field. This is how I've formatted the merge field objects so far to remove the blank space from my printed document: 1. Confirmed that table fields are formatted appropriately (i.e., no extra spaces), and 2. Confirmed that merge fields are formatted appropriately (i.e., without extra spaces), and 3. Formatted…

Happy holidays all: quick background - im working in an inventory file which contains ALL of our material we produce and sell. Im working on an inventory report which consists of all sub summaries and a trailing grand summary. one sort breaks the report into two groups, export and domestic and another summarizes the costs of the individual material types. the material types would be the "line item" part of the report. what i would like to be able to do is to generate a percent of the total cost (total cost being the total amount of each export and domestic) of each type of material. i can generate these percents based on the total of the entire i…

I've been used to MS Access and I'm switching to FileMaker 7. In Access, graphics are supplied to add to buttons. There doesn't seem to be any in Filemaker... or am I'm missing something?

Hello everybody. I am searching for a zipcode database to add in my personal database. I want to input a single zipcode and it will fill in the city, state by its self. Does anybody know where I can find this information? Thank you.

One of my FMP users has fields on her layout that have little black arrows associated with them. Has anyone ever seen that?

I have a Filemaker solution that was created in FM6. When we used the FM6 version, we could print on W2 Forms. Now that we have converted it to FM7, it doesn't work. I'm using a 8.5 by 11.0 sheet of paper that is perforated in the center with all the W2 boxes preprinted. I can get the first W2 to print right, but the second one is off by .25 inches and no matter what I adjust (Page Margins, Body Size) the darn thing won't work. Can anyone help me?

I have a layout with (Records showing from ProductDetails) I also have the InventoryTransaction Table in a portal on the same layout. I use the portal to enter inventory into the InventoryTable. This works just fine. But when I want to do an Inventory(List) (Records showing from InventoryTransactions) The transactions show up but have no Idea what Product they belong too. Why can't the InventoryTable see the ProductDetail table? Is it a one to many issue? if it is, how could I fix that. Or is it a layout issue? I'm so confused. Thank you in advance

Hello, I'm new to FilemakerPro 8. I've created a database with a bunch of fields, but each field only displays the first line, and only prints out the first line. I have to click on the field for it to show the entire data. How do I make the field bigger in order to show the entire text data? Also, how do I print the entire data in the field and not just the first line of each field? I've tried to resize the field, but the data overlaps with the next field. :

Hi.. my ## is not working.. when i go to browse or preview mode it gives me a '?'. I tried creating newlayout with columar list type and choose inserting page at bottom right, it also gives me a '?' instead of my page. Anyone know whats happening?? Thanks a lot.. Kelvin

I have a weird situation -- some of my fields display text as Titlecase, even though the field is formatted as plain text. The field is a plain text field, without any auto-enter calcs. Try as I might, I cannot enter a capital letter in the middle of a word, which is frustrating for some names. (Also, if I try to redefine the font as "lowercase," it still displays as Titlecase.) Other fields on the same layout do not have the same problem. What could be going on? Also, if you have an answer to this one, you might know how to strip and then add formatting, which is necessary to output to Word and other programs. I've tried TextStyleRemove and TextStyleAdd, but t…

I've got a file with records listed under diferent dates. In another file i want a report that shows certain fields from each of the records for a month. i've made a relationship matching the month on the report to the month of the records but only the first record is showing up in the report, and its showing up 12 times. Any help?? Please please Please!!!

Im trying to do a report that shows info from a files records for a certain date. i set up a relationship between the date and the files records dates. and then used this relationship to get the needed fields. Which works but only for the first record. To make it a bit more abstract: i have file1 and file2. In file2 i want a rport with file1's records for a given date. Help!!! Please!!!

I am using FMP 7, which as far as I know doesn't let you draw gradients. I am wondering if version 8 finally has gradients in it? It is ridiculous to me to have to draw a gradient object in another app to place into a FM document. Especially in a version 8 application.

I hope this will be the right section as Reports, Printing and Publication does not seem to have a portion devoted to Reports. I have a template completed with four layouts in one file in FM6; the four layouts comprising Tasks, Materials, Delivery and Buyouts. Each record is for either Tasks alone or with Materials; Delivery or Buyouts and are all identified by Job_Number. In another file with four tabbed layouts there are portals for showing all the related data by Job_Number – all is well. Even though I have learned so much in the past year or so, I have no facility whatsoever in creating Reports and Reports are needed here for printing since at leas…

I have a simple database with two tables: People and Donations. The People table contains contact information on donors. The Donation table contains records of each donation. The two tables are linked via a Person ID number. The list of donations from the Donation table appears in each record in a layout in the People table via a portal. All of this works fine. I want to create a letter as a layout in the People table and use data from a field in the Donation table in that letter as a merge field. I have been able to do this successfully EXCEPT if more than one Donation record exists for a donor, I have not been able to figure out how I can select the specific D…

Has anyone experienced problems with the "Change to hand cursor" suddenly not working on Mac OS Tiger? Specifically, a file I'd been working on suddenly lost its ability to change the mouse arrow to a hand when it was over a button. The checkbox for this feature is still checked in the Button Setup dialog for every button of every layout in the file but none work. I quit FM 8 Advanced and opened the file with FM 7 Developer and got the same results. Other FM files still work fine. I then copied the solution to my Windows machine and opened it there and it worked fine. I closed the copy on the Windows machine and copied that copy back to the Mac. That copy of a …

I have a database that is 99% finished. Now I would like to add a calendar feature to it. The calendar is from Cleveland Consulting. How do I add a calendar icon to the layout so when the user clicks on it, it will open the Cleveland Consulting Calendar? Thank you for you help.

I figured out my problem. Thank you to all. Now, I have another question. I have this report created from the "projects layout." In the projects layout, there is a portal logging the notes from our client, "cool beans." In my project report, I have fields from the project layout, but I want to also include the most current log entry from the portal "cool beans." But it seems, I am only grabbing the first entry from the log entry. What should I do?

I'm trying to create a list of projects organized by their project status. Here's what I want it to look like: Project Category Project Name - Assigned date- Due Date --- etc. Another Project Category Project Name - Assigned date- Due Date --- etc. So, I created a the layout, and I previewed it. Everything was working well. But then, I closed out of the file, and all of sudden the layout I created didn't show. What did I do wrong? Thanks, maulanday

Hello. Is it possible to allow the user of a standalone Filemaker solution to create and modify layouts (for printing) while restricting their access in layout mode? Also, can scriptmaker be used in layout mode at all? My idea is to provide a layout screen where say there is a custom panel for the creation of the allowed fields (the status area will always be hidden). The user can move and resize these fields to all them to create a truly custom layout.

Here's my problem (fm6). I have 2 files, parents and students. Students have elementary and high school students. I need a list of all parents with their elemntary children sorted by number of elementary children they have. The key from parents to students and back is parent id. I created a calc field in students that comes up with a 1 if elementary child(call field EL). In parents I have a field that is the sum of that field in students (call it SUM_EL). Then in parents I have each record with family name and a portal of child with grade. I can sort it by SUM_EL but the problem is I can't just choose elementary children from students. It does all. So now I go to …

My meagre GetSummary skills are unable to solve the following - here's how I'd like my report to look: SUBSUMMARY CAT A CAT A VALUE CAT A XX% subsummary total by sub-category A value XX% subsummary total by sub-category B value XX% subsummary total by sub-category C value XX% subsummary total by sub-category D value XX% SUB-CATEGORY TOTAL % 100% SUBSUMMARY CAT B CAT B VALUE CAT B XX% subsummary total by sub-category A value XX% subsummary total by sub-category B value XX% subsummary total by sub-category C value X…

Hi Guys, Im designing a WAN enabled database system. Im currently working on the user interface, and due to the nature of it being hosted online, thought it would be appropriate to create buttons/tabs using the FileMaker tools, as the buttons redraw faster than if they were graphics(and I've got quite a few layouts Im going to be working on). Im looking for an OSX type interface, before I recreate this has anyone done this natively in FileMaker and wouldn't mind sharing the buttons? I am only after two buttons, The highlighted(blue or granite) Tab, The white (unselected) Tab and ( as a bonus the "heading" bar that goes underneath the tabs (although I could probably c…

I have a purchasing form I need to create. Depending on the item selected they want different options to appear on the screen. I can't see any way of doing this in filemaker from what I have seen so far. The only other option is either hidding the fields that don't apply, or making them unclickable and still appear on the screen. So is it possible to hide a field based on the item selected in filemaker? Or is it possible to disable fields based on a selection in filemaker? Thanks.

Hello, I am trying to add a new layout that I created, to an already existing file with multiple layouts in it.... I saw that you could export records, but am I able to export the layout and then import it into my existing document? please help! Thanks!

I am a beginner using Filemaker 7. I have a database with several text fields and one value list per record. I am wondering if there is a way to change the color of all the field text depending on what item is chosen from the value list? For example, I want item 1 in the value list to be red (is there even a way to make items in a value list different colors?) and when I select it all the text for that particular record changes to red. Then I want all the other items to be different colors and change their text accordingly. Or is there an easier way to do this differently? Thanks.

Hi.. I am not able to figure out how actually can i put this 'back' (script call for: go to layout) button in my table layout. Help needed.. its in the 'AdminCheck' layout.. Thanks a lot.. Kelvin Overseas_Travel_Report_FMP.zip

In our database, each record requires varying amounts of image containers. The images need to be large to show the detail required. Since we need to print reports (and save PDF's) of these records- and the reports can be many pages- what is the best way to be able to only have the number of large image containers necessary for each record. We want to embed and not link the files. Can we have a... add image container button (where the user can add additional containers), therefore only displaying the required amounts of images. suppress the reports from printing/ saving to PDF image containers that are empty? some other solution? thanks so much for yo…

Hello! I hope that I'm posting in the right area. I set up all my fields in Define Database, but cannot see them, neither in Layout or Browse Mode. I put a lot of work into defining the fields, but am not able to view any of them. It looks like I have a BLANK database. Where are my fields? Help! Alisun

hey im sure theres a simple answer but i cant seem to figure it out i have a relationship from one table to another project->role via projectID rolename is a field in role there can be many roles for a project currently im trying to print out only the most current role added to the db and im using a merge field to do it so now my layout looks like this "current project role is <>" heres the problem its still printing the first role i ever added to the project so where i would like to see: "current project role is role9" im seeing "current project role is role1" ive set up the relationship with a descend sort by role:…

I've been developing on a Mac, where I've been pleased with the look of the layouts and the handling of the windows. Now, when I've put the system on a client's PC, many things are different -- color, hairline lines, font smoothing, etc. -- it doesn't look nearly as good! Worst of all, I have not figured out how to control the FMP Pro Window frame on a PC. I basically want to Resize to fit, and then adjust the FMP Window to fit that, and then adjust to maximize, so that you don't see a double frame (with two scroll bars -- very confusing!). Is there an easy way to control this?

I can;t believe in all of the years I have been using FMP that I have never had this need, but I fianlly do and now, I don;t know if it can be done, or how to do it. Can I display on one report, the result of multiple searches? What I need to be able to do is show how many times an employeed did "X" activity over a period of time. Then I would like to display results in a format that shows yearly totals, monthly totals, and weekly totals. This is easy to do across several automated reports, but I don;t have any idea how to do it in one report. Thanks for any thoughts or ideas in aadvance. Steve

I have a database with three main tables: Reports; Projects: Evaluations. In each report, we evaluate the progress of about 20 projects. Each project is evaluated according to 5 criteria (relevance, efficiency, effectiveness, impact, and sustainability). Each project can be assigned any one of six possible ratings for each of these criteria (-2, -1, 0, +1, +2). For each report, I want to summarise the number and/or value of projects by criterion and by rating. This is a simple matter if I take one criterion at a time. But if I try to summarise all criteria at the same time they are "nested". Is there any way to summarise all criteria at the same time and at the same level…

Hello all. I'm trying to create a table view of a flat Filemaker DB that includes all 89 fields in my DB. I go through the "Create New Layout" steps and select "Move all fields" but when I view the table, it cuts off the last few fields (stops at about 80). According to Filemaker, the column limit for a table view is 4000+. There is no logical reason for the fields to be left out. They're all simple text fields. There are a few that have repeating values, but they show up fine. I'm using FMPro 8 and tried fixing this in 7 on both Mac and PC, but nothing seems to work. The view keeps dropping fields. Any help would be greatly appreciated! Thank…

Hi Folks, I'm looking to create a contact database in filemaker 7, however the template I downloaded isn't cutting it for me, so I thought I would post my question here. I'd like to create a contact database, but would like it to be connected to the Oracle Tables I have at work. Here is the kicker I would like to be able to track how often each person is contacted. I guess I'm envisioning a nifty mail-orderesque service screen where one call and all of a sudden I know everything about that caller. oh and ps, I have no budget, so its all on me! Thanks.

For my data entry fields I would like all the fields to be boxed in with borders all the time. In browse mode if I have not mouse clicked or tabbed into any of the fields to enter data the appearance of the layout is the way I would like. However, once the mouse is placed into the field to select a radio button or enter text, all the other fields on the page seem to "fade". I.E. all the borders become dashed lines instead of the hard boxed-in lines previously there. I pulled up the filemaker example solutions that come standard and those had this same effect as well, but when I looked at some other example files I had lying around this effect wasn't there. I tried looking…

Hi everyone, Is there a way to print page 1 of whatever in the footer? I can print page 1 easily enough but can't figure a way to add the total number of pages.

Can somebody help me to design interface (interface is attached with the message) in File Maker Pro 8 under window xp platform? Kindly help me as soon as possible. please go on this link to see interface. http://www.maclane.com/ubbthreads/downloads//503066-clientinterface.JPG Thanks & Regards, Barbara Smith

I have a text field that is used across multiple layouts which needs to have lines parallel to the text. The records have varying page numbers so a line of exact length will not do. The text field can't be expanded with the use of margins due to it affecting other layouts (an idea from another thread). Someome mentioned merging the line with the field for sliding, but I read that this can't be done. Any ideas how I could have my parallel lines ?

Hello All, I have an application where it would be easiest to have my records showing up in a grid pattern instead of a list format. Is there a good solution for doing this out there? I have toyed with doing it via several side by side portals, but have not had any luck so far. In addition, this portals solution may eventually work but in practice, it's not very pretty. Any suggestions appreciated. Thanks, R

Is there a way to keep text from printing on a conditional basis? I'm refering to text objects, not text within a field. For example, if Field1 is empty I'd like to not print the field lable "field1:". Basically, this would be the automated equivalent of selecting "Do not print the selected objects" in the Sliding/Printing dialog box.

Attached is a file of what I need my end product to look like. (I have removed or renamed some client specific information.) I have 2 tables in the same file from which I need to create a report that resembles the one attached. Currently the guy working with this report runs a script that exports fields from both tables and puts them into an excel document. The rows with numbers in column A are from one table and the rows with OPI in column A are from the second table. He has to format all of the colors, strikeouts and add some text. He want's to be able to do all of this in FileMaker. Is it possible to do without portals? I don't have a problem wit…

I wasn't quite sure where to put this so just hear me out first...I'm ok with general relation database theory but i have real problems when it comes to reporting certain information... Righto Lets say i have two tables: Table 1 - ID 1 (Unique) - Date Field 1 Table 2 - ID 2 - Date Field 2 The relationship is structured as such: ID 1 = ID 2 & Date Field 1 <= Date Field 2 So basically i want to filter out all the records that don't meet the criteria of the relation ship... and present a report laid out something as such: ID 1 (Record 1) ID 2 Date Field 2 ID 2 Date Field 2 ID 1 (Record 2) ID 2 …

I have a specific layout that I need to use. My problem is how to go about doing it. I need to be able to use the button "Add New Order Part" to be able to clear the fields for the previous order part (While maintaining the information in the database) and add a new Order Part to the original order. I am trying to use Portals but I don't want the previous order part to show along with the new part order. I want it to look like a totaly new order...with the company name and original order information kept in tack... Any Suggestion? I have attached a couple of screen shots to help you understand what I need. Thank you

The company I am working for has been using a scheduling app I created several years ago (FM5). They like using it, but have decided to go with a large manual (magnetic) schedule board- possibly in conjunctrion with FM.They want to have the ability to move around the magnet pieces to help determine schedule and daily work load (which they aare already doing on their small monitors)..they are a visual group. I am trying to convince them to purchase a Smart Board and use it as a digital "magnet" schedule board and use the exsiting structure to store and view the data the data. Has anyone created a layout in which one could drag and drop fields in a job board t…

As one who works more in dynamic web design, I often return to Filemaker expecting to find in the Filemaker interface some of the dynamic layout features of, say, PHP include (or even a frameset). What I miss is being able to make, say, a menu bar of buttons with their links and have them appear in a number of other layouts. When I change one page, all pages should reflet that change automatically. I have experimented with convoluted merge values for buttons and their labels - but found them all wanting. As I embark on a big new upgrade of a 4-year-old database, I am ever more conscious of the need for elegance (in the economic sense). Has anyone any b…

I wanted to call this a question of ontology, but figured that wouldn't get much attention... As I understand it, FM7 uses the context of a table occurrence to determine the recordset to view in a given layout. However, it is not clear to me what happens to the context when a user or script changes the layout in the window. Specifically, if I am viewing a client record in my database window, and I click on a button that changes the layout to view the client's invoice records in the ClientInvoices layout--a layout that is based on a TO that is linked to the original client TO--how does FM respond? The ClientInvoices TO is supposed to be based on a link by client…

Hi, In single space view the data is fine- in double space data gets cut off- there is a note that says page 1 ends at line 44 and page 2 at 88- but I don't see how to adjust page breaks in layout view or know what to do to make it so all the data can be scrolled to in browse mode. Any tips appreciated- Om

I am a novice and have the following scenario: Parent table with following fields: Invoice number (primary key), Customer, Project Code, Expense Total (calculated field: sum of Amount field in child table) Child Table: Inv Nbr (foreign key), Expense type (by value list), Expense Amount Relationship: Inv nrb in parent table = inv nbr in child table A project may have one expense-invoice to a dozen+ of invoices. My problem is as follows: I want to be able to total invoices (eg total of Expense Total field in Parent table) by project code to show a cost per project. In other words, I need a list that shows invoices grouped and totaled by project num…

I have a database of various types of media (VHS, CD, DVD, MiniDV etc..) I am creating a script that will print out custom labels based on what type of media is selected. The script is something like: IF AssetType = MiniDV Go to layout MINIDV_Label Enter Preview mode Print Else if AssetType = VHS Go to layout VHS etc... The problem is, when I switch layouts the correct record is showing, but when I enter preview mode, it jumps to the first record in the table. Any ideas on how I can keep the record I am working with the record that prints out??