Layouts

Hi, I am trying to create a form view layout with a top and left section that remain in place when users scroll through the form. I have the top information in a header part but I guess this is irrelevant when I am in form view... Can I create background objects or groups that will be static when the rest of the form scrolls? Thanks for any suggestions! rori

Hi. I was wondering if I could get some help. I'm not sure what I've done wrong. On the clients page of my database, there is a table labelled service info. I am unable to select or fill in information for community respite provider and I'm not sure why. I've attached the database. The login is Admin and there is no password. If someone can tell me how to stop getting that to pop up each time it's opened too that would help. I've removed all the account names that I had put on there at first but yet it still pops that login screen up. Thanks in advance for any help you can give. Respite_Clone_1.zip

I'm trying to indicate rating of the quality or importance of the record by having a field called rating, and ideally, i want it to be a five-star rating system like in Bento. Is there an easy way to do this? If not, I'd rather make it some graphical representation rather than entering an integer value. Please let me know if star or some other things can be used in FMP, and if not, what people do about it? Thanks

I've searched for this topic in the forum and nothing came up. It may be a simple answer, but I'm a novice user and can't figure it out. Here's my problem. I'm collecting financial information on a monthly basis, where each month has two records. All I want to do is display the 12 month-end records for a given year in separate columns. The data is located in a table called Net Worth Statement. I'm creating a report based on this table called Balance Sheet Summary, which is where I want to display the columns. I discovered while searching the Knowledge Base that I can create a horizontal portal by selecting only one row per portal and then duplicating …

How might one disable user from using scroll button ... for me it changes the record find but doesn't cause my layout to change..

We are currently building a system that needs fields to appear on (or disappear from) a data entry layout based on the contents of another fields. So, if a check box is checked a few other fields will appear for the operator to fill in that are relevant to that check box. I'm wondering if anyone has any clever ideas for doing this. Barring other suggestions we will likely use a portal to display the ancillary fields or conceal them. (I think this is a John Mark Osborne trick.) This will mean a lot of relationships (clutter to the ER graph) to accomplish this. Conditional formatting won't work because of pull down menus on some of the ancillary fields. A…

Hi all I am trying to store an image inside a container field. If I right click on an empty field, I am able to insert an image in the container and the image is displayed in the container field. I would like to drag 'n' drop files into the container field. If I drag the same image that I inserted using the method aforementioned, I am diplayed a generic image that seems to indicate the file type, but also displays the image name. However, if I drag a document such as an Excel document into the container I get what seems like a preview to the file with no filename displayed. How do I get the image to show? If I use the right-click method of inserti…

The background we use on our local database was created by taking screen-capped slices of another application, and then piecing together in the proper dimensions to fit our needs. It's something I have to stare at 5 hours a day, so I thought it might be nice to give it the look and feel of my other Mac apps. However, after the last upgrade from FM10 to FM11, the slices have different shades, making the whole layout look like a jigsaw puzzle. It doesn't prevent us from working, but it is annoying. Is there any way around this? I've looked through the preferences, and can't find one for "make the image files in your layout look the way they've looked for the past 4 ver…

On an Event Entry screen, users type in the description of new events, much like keeping a journal. The resulting entries are kept in a single table, which can grow to several hundred entries. To help avoid duplicate entries inadvertantly being made for the same event (by different users), I need to show the "description" field from the previous two or three entries at the top of the layout for their reference. Since I create a new record only when entered information is fully validated, the entries at the top would be Last and Last-1 from the table. I'm having a mental block on coming up with a simple way to do this without using a portal. I could use a script t…

I created a Calculation Field (stored), and added it to a layout; however, it doesn't display unless I have the cursor in the field! And once cursor focus leaves the field, it again becomes blank. What have I done wrong? The calc is nothing more than Year(ReceiptDate), where ReceiptDate is a Date field.

Hi all. This has got to be the most basic question but it's got me stumped! I have two tables: "Buildings", consisting of two fields: Building_Id (the key, numeric, auto-enter serial) and Building_Name (text). And "Units", consisting of Unit_Id (key, numeric, auto-enter serial), Unit_Description (text). A building consists of one or more units. I want to relate the two files so that when I'm looking at the "Units" layout I'll see what building a unit belongs to; I've added, in the "Units" table, the field Unit_Bldg_Id (number) and created the relationship to connect Buildings::Building_Id and Units::Unit_Bldg_Id. On the Units layout, I've …

I'm building a database for a high school sports team. There are various related tables for personal information, practice performance, team information (ie varsity, JV, jersey number, position), and competition statistics. I thought creating a new layout for printing rosters would be easy to do since all the information is already in various other tables. However, for some reason I can't make it work. I'm pretty new at database design so I could be missing something very simple. I tried creating a portal with the requisite fields for the roster print sheet (number, name, position, grad year). But the portal isn't populating with all the players, it only sho…

I have a simple list view of records set up but I am having a problem with it. Sometimes when I click into a record it jumps from the top or the middle to the bottom of the list. why is this happening it is very distracting behavior. Is there some way to prevent it?

I was wondering if it is possible to have a text box (in the footer lets say) that the user can just edit like they would in a word processor and not have it related to any table or field. Sometimes we have to put notes on different reports and if you have a text field it changes with what record your on. I don't want it tied to the current record, rather just to the current layout.

There's probably a really easy fix for this but I'm just not seeing it. How do you resize the page width in layout view? On my mac its at 12 inces whereas on a windows computer its shows up to be about 8 1/2 inches which cuts off my report. What gives?

Friends, I am finishing a wonderful project, the catalog of the Baroque Music of Moxos (Eastern region of Bolivia). I´m acting as IT specialist, the real investigation is being done by experts in Music with admirable knowledge in this field. FileMaker was used and everything went as expected, the database runs perfect the scripts do exactly what´s needed and the layouts for the experts to analyze the partitures (images containers) worked great. The idea is now to produce a Layout with the data for each composition along with these image containers. The Layout has a Header, a leading sub-sumary by signature, a body and a trailer sub-sumary again for the same field…

I am importing a spreadsheet into FMPro 11 that looks like this: HAR HA ADM TX PX 67824 ZC 04/06/2009 36854307 4452820 67824 CC 04/06/2009 36854310 4453541 67824 TC 04/06/2009 36907581 6801000 87298 TC 04/14/2009 37057448 6007600 87298 PR 04/14/2009 37057629 9012500 87298 CA 04/14/2009 37057684 9012500 I would like to create records that import like this: 67824 [Record] ....ZC 04/06/2009 36854307 4452820 ....CC 04/06/2009 36854310 4453541 ....TC 04/06/2009 36907581 6801000 ....[these are line items within the form/layout] 87298 [Another Record] ....TC 04/14/2009 37057448 6007600 ....PR 04…

When moving objects they do not always snap to the object grid. I find them about a pixel or so off. Is this normal? That is, is the snap to feature not exactly accurate?

Is there a way I can stop people from resizing my columns? I have their privilege set so that they can't edit layouts, only view them but they are still resizing the columns which screw up my header placement.

I've got a preliminary set of sorting fields, called, let's say, LISTsort1 and LISTsort2. A third field identifies (via text serial #) a record (LISTserial), a fourth describes it with a text label (LISTlabel). I need a drop-down to display a calculation of LISTserial & " " & LISTlabel, but be ~sorted~ either by the text-serial value in LISTsort1 or LISTsort2. Trying to obtain this now, can have either LISTserial & " " & LISTlabel in my drop down, alpha sorted by LISTlabel, or something even less useful. Any thoughts? Selected drop-down LISTserial items are part of a portal

I have a layout that includes 7 text fields, each of which could be empty, or contain up to a page in length. I have them serially placed on the layout and each marked for 'sliding up', so in layout mode 7 pages are shown. If, in one case, all fields contain a single line,and I show the layout in 'preview' mode, all fields properly slide up onto the first page, but there are still 7 pages that are 'previewable' and 7 that will print - the last 6 of which are blank. Is there any way, in this case, to get just the first page to print (or, in general, to omit printing of any trailing blank pages)?

Hi. I was wondering if anyone could offer me some help on a layout/report I am trying to make. Well, it's a report I guess. I have attached both my database and a generic layout sample on a word document for what I'm looking for as it's easier when you see things rather than read them sometimes. Basically what I want it to do is generate a report from the Service Hours layout that lists all of the clients, not just the one particular record you happen to be looking at. I would like it to put all service hours for providers grouped together, and sorted by month. But to put a header for each. It's probably best to just look at my word document…

My old version would show all the files that were open under the windows menu. Just switched to version 11 and only a few of them will show up even though they are open. I am running them remote so I have to go under file> open remote and open them again. The macs show more than the IBM but each computer is a little different. Is there a setting I can change so I can jump from file to file via the windows menu, and have them all show there?

Curious about what you can see with a Mac and if you can modify the object ( for example adding a new color to a cell ) Object.zip

Hi, This is my first post so hopefully this is in the correct forum section. I've developed a DB for my business to track time spent on projects along with actions etc, however I'm having a little trouble on the timesheet entry screen. The issue related to muli users using it over a network (hosted on a local machine) The file has two tables - one with the information on the current user, dates etc to calculate the date for Monday, Tuesday etc (Al Global Fields or unstored calculations based on global fields) and the other with all the data to be stored for each time entry such as the hours work by who on which project on a particular day. The issue a…

Is it possible to open another window while one is still open in same database? Basically I wanted to create a report menu and to add radio buttons that open a specific report when selected.

I am making a report to show products supplied by a supplier. When I create the report, I select the different fileds from both the reports table and the suppliers table but when in browse mode, the fields of the relating table are never populated. It is as though the relationships are not working in reports but work elsewhere in portals etc. what am I doing wrong? See the attachement for relationships.

FM 11 advanced, Win Vista Iâ��m having trouble with summary data in FM 11. I have a layout that sorts by the correct break fields, but 1) the summary totals in the subsummary part are incorrect, (they display the last value in the column, not the total), and 2) an extra â��totalâ�� shows up in browse and preview modes near the below the last subsummary part. Iâ��ve attached a file showing views of the preview and layout mode. The break field â��categoryâ�� is a related field. I donâ��t know if this is the problem. The body part contains the cost data. I know that in FM 11 you can view the subsummary data in browse mode. Could this be responsible for â��totalâ�� appe…

Hiya, FMP11/Win7. We have 8 tables (.fp7 files) and each have their own layouts. A script in one of the tables needs to use a layout (using the Go to Layout command) from another table. Is it possible to share layouts (or import like you can do scripts) between different tables. If this is the wrong way of doing things, what is the correct way? Thanks

Can anyone tell me why/how when you click on the buttons at the top of my pages it turns pink briefly before turning to the selected fill color? I would like to change it to another color, anything other than pink! ha. Just I only selected the only fill color not sure how it is doing that. Thanks in advance for your help!

Ok...I've been staring at this way too long now I think. Could someone please look at the attached and help me with a few things I'm having problems with? I think it's pretty simple stuff I'm just clueless at this point. It's still in the very early stages, I'm trying to make a database from scratch and I'm new to this so forgive me if it's a mess. I would like to do the following: 1. Service Hours Entry Form - Why does the field for "Returns For:" look different from the others...like a shadow on bottom and right or something. 2. Service Hours Entry Form - on the portal - service name, why isn't it looking up the services? Do I have the loo…

Hello everyone. I am creating a few production reports. All goes well as long as there is something to find in the search criteria. If there is no record available, my report shows a blank page in preview mode, but a normal page with no record otherwise. There is a header with useful information, like how many projects for the months there was. It's not because there is no record found that the report is no good. I can have a 100% efficiency if there is no trouble found in the search and I need to see that data, print it and send it to my boss. So how do you people do with that sort of problem? I was thinking about creating a blank record within the tabl…

I'm new here so if I have stuck this question in the wrong place then please accept my apologies. I have just organised a layout in landscape screen view but have decided that i need it in protrait view as i will be displaying the data on a large screen which is mounted on its side. is there a simple way of changing the screen view orientation or do I need to recreate the layout turning each field individually? the big problem i have is that there are probably 300 fields on the screen; its a multiperson (20), multi day (5), 3 slots per day solution; kind of a large grid if you like. help please

How do you add a little X box to a line item so that the user has the option to delete the line? Like in the invoices template. I've tried figuring it out from there but I'm missing something.

Hi, I have 2 windows open, one is in form view which shows the content of the current record. The other one is a list view which is displaying an overview of all the records. I want to use this 2nd windows to quickly find and select other records. So when you click one it opens in the form window. (this i have done with a script) Now when i am browsing through the records in the form window, i want the list window to scroll along. So when i mousescroll down, from record 15 to 19 in the form window, in the list window also record 19 should be selected. Right now it does not "refresh" the selected record, it will stay on record 15. I hope my explanation makes…

Hey guys. Hopefully someone can help me out here... I am looking for a way to have my records sorted by default. I can press the sort button but when I go to a different layout and go back again they go back to the way they were before. How do I get my records to stay sorted by default automatically. Many thanks!

Hi I have a simple layout list... Which displays all records How might I filter certain records from my list... sample layout and script attached jpg.. Like would search blanks and other calc filed and omit do the trick? Thanks..

I am a bit confused between look up fields or just referencing another table. On my database I have a client form where I enter name, address, phone, etc. On another form, similar to an invoice, I enter services for a client and have the clients name and address fields referenced. I have a value list for the client name, its a pop up and you select from the list of clients. It automatically pulls up the address info. I've got this working fine. But basically, there is one field from the client page that could change periodically. So I want to be able to change it in the Service hours form but for it to not change in the customer form. I've attach…

The layout parts have small buttons called "part labels"...I think. "Header," "Body," and "Footer," for example. Sometimes these part labels are horizontal. Sometimes they're vertical. How can I control that? Thanks in advance, Stan

OK. I am willing to start over from scratch. Trying to create a database that tracks training attendance and gives credit hours to each attendee. I figured most of it out, but I could not get multiple training items in one record to credit hours to multiple attendees. For example; I will have one record to input multiple persons attending multiple training on one day with hours for each training item. I searched the forums like crazy and didn't find what I need. If there is a sample database that does this I can dissect and copy it. Please help.

I would like to stop certain related fields that I display in layouts from being modified. I just want to display the data in list view along with the new data but I cannot figure out how to keep it from being modifiable. I am very familiar with the manage accounts privileges but there is no way to disallow certain fields from being modified in specific layouts. It either has to be in the record or for all records in the layout. I hope I am clear enough. If not please let me know. Thanks.

Hey All, I've run into a strange problem i've never seen or hear of. I have a layout that I select via button or drop down... for instance "Layout". When I select the word "Layout" form the drop down box, it goes to a blank screen and the word "Layout" disappears from the drop down box leaving no text (but the check mark still appears). I freaked out thinking something got deleted, but the records are still there (I know because it says in the tool bar viewing 12,000 records or whatever). I thankfully had a back up copy so I imported the layout objects and just created the new layout... .but when I went to delete the messed up one, i can't. It always appears in …

Can anyone tell me how I change the fill color of a button to have two colors? Like the area behind the navigation button in the invoices template, it goes from grey at the top to black. I can't figure out how to do that using different colors. I'm assuming it's a button that was used because when I right click on it in edit is says button setup

I have a client that needs nearly the exact same information for two different programs. The client wants to use a an existing layout (master budget agreement) as a template for this new second program. I can duplicate the table and the layout but what I would like to know is if there is an easier or faster way to assign the new table fields to the new duplicated layout. All fields change to related fields when I duplicate the original layout and change the "Show records from" pull down to the new table. All the field names are exactly the same...there has to be an easier way than going through field by field and changing them to the new table.

Hi! Simple question: Is there a way to prohibit accidental record commiting a record in order to be able to revert a record while editing?

Can anyone tell me what I have done to cause all my fields, while in layout mode to word wrap?. If the field description is longer than the field length, the words wrap and write on top of each other. It's hard to read anything.

Yes, I have searched the database for an answer to this. Clearly, I didn't find one. I need to highlight the active record in a list by giving it a different color. Old people like me view this database and the small vertical bar at the left of the screen is difficult to see. How do I do this?

How do I go about changing the order of line items in an invoice? Let say you start adding items to the invoice and you you suddenly want to move line #3 to the top instead. If you only have 5 lines then you can just delete everything and retype them but what if you have 30 items? Is there an easier way to move line #27 to go under line #4? The only possible method I can think of is to add an autogenerated number field "sortOrder" and auto sort the portal by that field. To change the order of the line items, you would just change the number in the sortOrder field. But this complicates the process a bit for the end-user because a decimal has to be used in order…

I have a solution with separate data and interface files. The interface file is linked to the data file through external data source. I accidentally deleted the external data source in the interface file and the interface file is totally messed up. All fields are missing and can't be recovered even when I put back the external data source link. What should I do? I can either manually remap all fields (too much work, hundreds of layouts, scripts and TOs) or start from backup files (lost a few days of work). Any other suggestions please.

Hi, If I am going to make pages suitable for FmPro client, browser and iPhone alike, I need to be able to determine what method they are accessing the service - through HTTP, PHP, FmNet. I cannot see where to get this information so I know what layouts the client can use. Anybody help me please? Greg

Hi everyone, I'm trying to design a "Help" section for my database that houses procedures lists for how to use the DB and accomplish certain tasks. My hope was to place a button link on each layout in the DB which would transport users to this section where they could choose a Help Document from a List layout and then display the text and images of the document itself on a form Layout. That's the problem though. The help documents that I've drafted in TextEdit (mac) contain both text and images and now I can't figure out a good way to display both text and images together on a layout in a way that makes sense. I can have the text field to hold the …

Hi, I'm trying to classify my datas into 3 categories: 1. no. of doses by year 2. no. of doses by species 3. no. of doses by breed the problem is that I tried to do the exact same thing than into the CD, the file called Demo 07_2, which consist to have a name and a number. Only that. For instance, I would like it to appear like this: 1. 2006 (number of doses) 2007 (number of doses) 2008 (number of doses) etc etc. 2. Bovine (number of doses) Horse (number of doses) etc etc. 3. Polled Hereford (Number of doses) Colonial Horse (Number of doses) etc etc. But when I tried it, I still had 500…

I have fields that I need to fill with a specific color. I am trying to use the color picker from within FM11 to sample the color that I want from a background image. For some reason whatever I sample is coming out a few shades darker than it should. This is really messing me up with my current project. Any suggestions? I tried changing the color profiles but it did not impact the colors at all. (this is not an issue where I am trying to sample from an image with noise or JPEG artifacts, I am trying to sample from a solid color that I have used many times) I had this problem a few years back and I was able to correct the problem by deleting a beta Fi…

I have a graphic and some text in a header part and they will not print. I have some other text in the header that I have marked "do not print." However, in preview mode or when printed NOTHING in the header part will print. I have no idea why. It has in the past and I have made no changes to this report except to upgrade to FM 10. Any suggestions would be most helpful!! Thanks, Michelle

Hi all, I am new here so if I post this in the wrong group, please point me in the right direction. My question is about moving files that are linked in a container field. Our company has recently purchase a new server that will be file storage among other things. I have moved all of the linked.pdf files to this new server, the link in the container field still points to the old server. Is there a way to update the container link to the new server? Thanks Steve Filemaker Server 5.5 Filemaker Pro 6.0

Hello, Can someone be kind enough to tell me what I am doing wrong with my graphics? I don't understand why they blurr in the lower corners. I set the anchors this way in other DBs but this is the first time I made my own. Graphics.zip

I have a simple problem, but is hard to find the solution. I have a report that use subsummary and grand summary. I want to count the number of the subsummary part, ignore the records of the subsummary, focus on the count of subsummary part itself.Next I want to display the count of subsummary part in grand summary part of the report. I'll try to explain the problem as clear as I can. My report have more than one subsummary part, each subsummary part of my report has several records, each record has the same Reservation_ID and I sorting the subsummary use this field, something that I want to get is if there are three subsummary parts on my report, then the grand summar…

Strange one [color:blue]Couldn't wait... so i uninstalled and reInstalled FM9pro again.... tested and it fixed it... but why the bug? And why didn't the control panel/ add/remove FM Repair work? Any idea's here ALL my layouts.. even a completly different applications... using my FM9 only IS - WAS corrupted in testing my ver 8.5 and 11 work fine with my code. [color:red]ProblemIF I RIGHT click the item or button.... and clicked Button Setup ...It freezes my layout goes un focus... If I hit escape.. that brings my back to forcus.. Ran a REPAIR from the control panel add/remove on FileMaker ok but its still happening? Any…

When I create a new Filemaker database it creates fields that are white on white. I want to define a my own field color as the default. Is this possible in FM11A?

Hello! I have created a ne database with differente tables, my question is if i can just say to filemaker to display all columns i created in database on layout simple so i don´t have to put every column manually on layout. thank you very much. regards, daniel

I have employed this method in one of my screens, to enable the user to quickly navigate through records: Although it works just fine, the problem is that in a list view with many records (exceeding the screen) if you press continuously the down arrow, at some point the current record disappears and you have to go back-and-forth one time to make it appear inside the window. Can anyone figure out why this happens?

Is it normal for a layout viewed in Table mode to be refreshed in very low speeds just because one column contains radio buttons? Are radio buttons so burdensome? I've even found that replacing the radio buttons with a calculated container field and a script run by clicking on it, I get the same effect of toggling the field between 0-1, with faster redraw, less possibility for errors and better user feeling (icon is obvious)!!!

Hello, Started working on a new project, an eight photo, photo lineup and I need help. I have a contact db which will store data about people as well as a photo. I also have a layout with Global Containers (8 total for the photos I select from the contact db). What I want to do is attach a button to the photo on the contact db that will place the photo in the first Global Container if it is empty. If the first container is Not Empty then the selected photo will be placed in Global Container #2...if #2 is not empty then #3 etc. I have tried to use If Not IsEmpty in the script, but that only can get me to container #2 and then I am stuck. Am …

I have one field with 3 choices: A M, Noon, and P M. When A M is selected I would like the field to be one color, If Noon is selected, then a different color; P M would be a 3rd color. Is this possible? Any ideas will be appreciated.

Is it normal that when I draw a line, it is not fully straight? Check the selected line in the following printscreen. It doesn't align well with the end of the two gray rectangles. That makes the printing not really professional. Is there a way to fix this problem?

I have a layout that has multiple portals (40-50) side by side to display records in a grid format. Is there any way of improving the speed at which this layout displays?

On the Window's side. All of a sudden. I can't see the entered text in a field until you leave the field. Also, this is some kind of window issue. I have a script that open another window. When you choose something on that new window, the new window closes. All of a sudden the first window loses it's graphics and other highlights. It does this until something makes the layout refresh and going to another layout and coming back to it. This is Filemaker 11 advance on XP. This just started the other day. The file works fine on OSX. Nothing's changed on the Windows side.

I received a file where the fields in layout mode display a value, not the field name. How is this done?

I have a layout that shows a list view of various open issues... Multiple users keep that screen up during the day. New issues get added to the list a few times a day. The users need to manually click a refresh button to see anything new added. I want to make it auto-refresh... so I installed a timer that would reload every X minutes. The problem is that if a user is doing something in the app when it reloads, it kills what they are doing and forces them back to the refreshed layout. For example, if a user is entering a new issue when this timer kicks on, it pushes back to the layout and the record they were entering is in there as incomplete…

When viewing a layout, the mouse wheel will cycle through records when scrolled... I have a record details layout that pops up to show the details of a record listed in list view. That all works great - but when a user clicks the details button off the list, he gets that record - but if they scroll the mouse wheel, the records cycle up or down. Can this be turned off somehow? With a little thought I guess I could do something like a self relationship and GTRR and only get those relations... but that makes a much more convoluded scheme to just turn off the mouse wheel. any ideas?

I am a self-taught filemaker user who has recently made the move to sharing a database over the internet, and I have only now discovered how important it can be to make speed-conscious choices in how one defines tables and constructs layouts. I have many unstored calculations, and I understand that I can improve speed significantly by having fewer of these. A fair number of these calculations I use specifically in scripts but don't actually ever need to display in layouts. Am I right in thinking that the speed issue isn't really about whether one has a lot of unstored calculations in one's tables but about whether one places them on layouts that get invoked in the co…

Hello everyone... I was asked to add a feature to an existing file. What we have is a table that has appointments and a field called NSO with a unique text value in it. I have created a new table called NSO_Imports. The NSO_Imports table has several fields ID, NSO_PDF_Name, NSO_PDF_Imported (Container), cNSO. In NSO_Imports I import PDF files into a container field and the cNSO number strips calculates on the NSO_PDF_Name field to get a value that matches NSO field in the appointments table. So I can relate on that. On a layout that is based on appointments, I would like to have a print button that will print the layout the way I have it and if i…

Hi, i will be attaching a BarCode reader to the System i created. How do i make sure that everytime the Barcode scans, on "tab" that it will skip to the correct next field?

This has tripped me up all day... I have a Clients table which stores all my clients (obviously). Just recently I've added another table for a certain type of client (private instead of a company). The reason I have this separate table is because they need more information stored about them than the companies do. Let's call it Private_Details So I created a separate layout and it works well in only showing the private clients. However, now I want the original Client layout to only show the Companies and exclude those that appear in Private_Details as well. I thought it was going to be a simple matter of using a TO for the Private_Details and creating a rel…

I have tried many things to create grand summaries in a layout having fields from related tables. Only those fields from the table directly associated with the layout will give grand totals. I can do sub-summaries using the same tables and layout, I just cannot get the grand totals. The main table is related to the other two by a date field and a unique company number or company region code. I would like to have the grand total following any of the sub-sammaries I have made. I have tried calculation and summary fields with no success - any ideas?

Hi, and sorry in advance for my bad english. I have recently installed Filemaker 11 and I am having a bit of trouble with a very simple task. I have selected the "People Management" starter solution, that has 3 tables (employee, goals, issues). Below the name of the employee, there are different fields and even below, the goals and issues tables. I just want to create new fields that come below the name of the employee, for example, between "last name" and "office phone". I have entered in "manage database" and created a new field, supposedly inside the "employee" table, but in the end the field comes below everything, and in black font. I would l…

Hi all, I might look foolish asking question,but i am new to filemaker pro,so here it goes. I have three tables 1.student 2.team 3.semester student and team have a join table : stu_team. with student and team primary keys in it. The stu_team table is connected to the semester table , to keep information about which student was in which team in which semester. this is the relationship graph: relationship graph now i created a layout with the table as semester and it looks like this: layout i want to use this layout such that i should be able to see all the students in the given semester by choosing the team name. …

A field has a button applied to it. The first thing I want the button to do when the user clicks it is to record the name of the field. How can I do this? [color:red]Get ( ActiveFieldName ) or [color:red]Evaluate ( Get ( ActiveFieldName ) ) fail to return any value for me. The field is set to allow entry in browse mode. Many thanks in advance.

I have a calculation field (Buyer's Premium) in the sub-summary of an invoice that adds a Buyer's Premium charge to the invoice based on the 'Total', summary field. I then created a summary field to total the Buyer's Premium. I want the total of the Buyer's Premium show up in a trailing grand summary. A total shows up, but it is incorrect (greatly inflated). What am I doing wrong?

My FMPA8.5 is having problem recognizing layout theme installed and repeatedly asking me to re-install (which I did). Any idea how to resolve the problem? Please refer to the attachment which I wasn't able to upload earlier. The error message appear when I try to create a new layout. Theme_files_error.zip

I would like to display several fields in a tabular format where one of the fields contains varying amounts of text. I would like to have the layout diplay all of the text in the text field, wrapping it until all is displayed, and then starting the next record. Something like this: Blah 1 Blah 2 The Text to Display ------ ------- ---------------------- data1,1 data1,2 XXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXX data2,1 data2,2 XXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXX data3,1 data3,2 XXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXX …

If I have a user who does not have permission to view the layouts in a folder. Is there a way to remove the folder from view. The user does not see the layouts inside the folder but does see the folder. The user then wants access to what's in the folder because he/she sees the folder. It would be nice to have the folder not visible if the contents are not accessible to the user. Thanks

So there may be a very simple fix to this question, but I seem to be overlooking something. As you can see below, I have a very simple report. It consists of a leading grand summary with title and date range. Its main contents are a sub summary that takes all the records in a found set and catagorizes those records based on any promotions that were given. It also has a trailing grand summary that totals all of the record amounts for loads, yards and promotions given. The last column represents a ratio of promotial $'s given per yard. The question I have is in regards to the final column. The field SumPromo.Yrd is a calculation the devides SumPromoAmt by SumQty. T…

Hi. I've been trying to come up with the best way to approach this situation: My table has a numeric value, call it "price". The price is a currency value, but the currency in which the items are priced can be variable. I'd like for users to be able to type in a currency value and a number into a field on the layout, for example "$50" or "£30" or "GBP 30" or "USD 50" etc... - and to have that automatically stored as two items: (A) the numeric value (50 or 30 etc) and (: a link to an entry in the Currency table (i.e. the currency-code or some other unique ID in a table of all currencies). So the question is how to parse that user input... Or maybe …

Dear All, I Have an odd inquiry: Is it possible to format the height of a cell according to the amount of information within it? I know that I can adjust the height of rows in a table layout. But if I need more room for some cells and less for others, is there way to automate custom sizes for each. Please see attached image "FMP_inquiry_1" to see what I mean. Is there a way to align information in between cells in a table rows? This alignment depends on the University name, is there a way to automate the placement of other information based on this field? Background information: We are using FMP to consolidate records for all of our gr…

I've created a layout that contains a header and body. Whenever I go into preview mode the layout always says that there are two pages even though the second page only contains header information. How do I fix this so that if the user prints it only prints the page with the relevant information?

I would like to control whether an object is showing or hiding. Objects like fields, text objects based on merge fields, portals, etc. What I am trying to accomplish - without building additional developer layouts - is the ability to show or hide information about the file based on Account Name. For example, I have kludge a calculation that will display "developer" helpful information that will display if the User logs in with the Developer Account. Seems to work - but the layout gets extended to the right to display this information because the merge field that displays the data needs to exist. So, in "Developer Mode" this is great. However, in normal Use…

This should be pretty easy. I'm trying to find a way to always insert the current year into a block of text but am unsure of the text command to use. So the result of, "The current year is @@" returns text of "The current year is 2010"

Hi all, I have three table :student, team and semester. student and team have a many-to-many relationship and student and semester have a many-to-one relationship.I want a layout that can display all students in a particular team at a particular semester. That is when i choose a semester from a drop down list , i should be able to see all students who are in a given team during that chosen semester. Please help me on this one!! thanks, sunshine3

I haven't been involved with FM since V8, but back then it was really hard to set up a List view that looked like a Table. In V10 it's just killing me. This must be something virtually EVERYONE wants to do at some point: create the appearance of a Table, with horizontal and vertical lines as separators, using a List. Why? Simply because you can do more in a List view. Mind you, it's not hard to make a sloppy-looking one. If you don't care if the vertical line segments have a "dashed" look, instead of flowing smoothly into an unbroken line from top to bottom, it's easy. But I -- and I daresay a lot of FM developers -- want it to "look good." Can anyone …

I wanted to create what I thought would be a simple report. I created a database for my wife's practice so she can take client notes and track billing. The notes and billings are in related tables to the client personal data. The report was to show all successful credit card charges in a date range selected by the user. I wanted the report to group by name and within the name group sort by date. It would show a subtotal for each name and a grand total at the end of the report. So I created a layout in the "ClientBilling" table. In the "ClientBilling" table I have a field "FullcardName" which is a calculation of the fields LastNameonCard & ", " & FirstNam…

When scrolling though a set of records in a portal the field that comprises the record itself changing to a selected state. I can't really describe it better then that, but I've included a picture of what I'm talking about. Is there a way to format the field or portal so that this doesn't happen?

I have a report layout with a single line I am trying to fit 3 fields onto. The line contains static text along with 3 fields that will contain contact name, current date, and staff name. i.e. - "REPORT SENT TO <> ON <> BY <>." The issue that I am running into is that the Contact Name field can potentially contain anywhere from 1 to 6 different contact names (July and Jill and Debbie, e.t.c.) and I need the line to auto format to accommodate this. This of itself it not a huge issue as I can create a text field that uses the field names contained inside of <<>> and it will automatically adjust the rest of the text to accodate this. …

Does anyone know where to obtain cool graphics for use as border and tabs and buttons that I can use in my filemaker solution to make it look nicer? Thanks

I have check part to break over page boundary in the part setting in layout but a long field always starts on a new page? Is there something else need to do? The field has sliding up and reduce size of part checked. cheers

Hello helpful people, I manage a few different FMP databases and have noticed that when I "View as Table" or create a report, only one of the related records tied to a given record is displayed (the earliest entered one, I think). For instance, I have a table for "customers" and another for "checks received." It is a one-to-many relationship, since some customers divide their one-time payment into more than one check (it's a long story). On the main layout where I enter the data, I have a portal to the "checks received" table, and that's where I enter the different checks (their amounts, numbers, etc.) I made it so that I can enter up to four checks (check records) i…

Solved a screen sizing issue! Is there a better way then what is described below? My solution is used by many people in the company, some have 17 in. screens while others have 30 in. I originally designed and developed the solution on my 30 in. So you can guess when viewed on a 17 in., it did not fit. To solve this, I redesigned to fit on the 17 in. (the smallest in the company) and give user the option on start up to view a large screen or a small screen. Typically, users with a 30 in. monitor view the large screen which is simply the 17 in. layout zoomed to 150%. Also, while designing the new layout, I noticed some fragmentation to fields, embossments, et…

I would very much like to be able to display and work with a number of records (6) side by side but I see no way of doing it. Is it possible? I'm on 8.5 but will be upgrading soon. Thanks Roger I think I've sussed it... portals side by side, one row each but each showing the next row to the portal to its left. Is that the way? cheers

I've got a layout that uses repeating fields for a pretty standard invoicing report. The problem is, for certain repetitions, the descriptions can get pretty long and would force the repeating field to extend past a page boundary. Is there any trick that will allow a repeating field to continue to print past a page break?

I plan to create a layout to display an analysis of some of the information in my database. It will essentially be a table that displays the same list of items for the x axis and the y axis, with the values in the table being number that represents how strong the relationship between each item is. I'm trying to have the labels on the x axis appear slanted, like the table on the right side of this website: http://websort.net/ I can't seem to do this with merge field labels and it seems it's not possible to do with plain text in FM. I can get FM 11 if it's possible to do this with the new charting feature. I'm also open to other suggestions, but I'm just t…