Layouts

I print an attendance roster of members eligible to attend faculty meetings, some who have voting rights, some who do not. If a vote is going to be taken in the meeting, we need to accurately count the number of voters to establish whether a quorum has been reached, in order to make the vote official. I used to have the names formatted as such: printed in red for voters and black for non-voters. But these prickly professors were offended by being marked in red (or not marked in red), so I created a calculation field which displays a discrete * by the names of the voters so we can take our necessary count. Here's the problem. In two places on the page when I print…

If I need to post this in a different forum, please forgive me and point me in the right direction. Creating a database for a client and have one more bump to get over before I'm home free. I'm trying to set up a report and I can't get the results I want. I know it's simply because I don't know enough about parts and summary fields, so I could use some help. I have a number of financial entries. Let's say five of them are in January, and five are in March. When I create my report, sorting by date, it gives me January, January, January, January, January. I'd like to group all financial entires in January, so that I have a "January" heading with just the fina…

This is definitely a newbie question, but here goes: I've got a field in the checkbox format. I would like to show the checkboxes, but not the border around the entire field. I've tried every possible manipulation I can imagine in trying to remove the border while retaining the checkboxes, but they seem to be linked in their formatting. As you will see on the attached, this field is currently really ugly--it works on my layout, but it looks bad. Can I keep the checkboxes but lose the border? Or are they considered the same 'thing' by FM? Thanks!

Hello, I open a pretty large, multi-file solution each day. Sometimes the display refreshes many times before stabilising. Most times, this does not happen. Today it happened a long while after I opened the solution. It just went on and on. A bit of background which may or may not be related: 1. I zip a backup on a remote machine each night. 2. The zip file is transferred and unpacked locally. 3. I then open it. Anybody else suffer 8.5 hiccups? Any ideas of why or how to avoid it? Norman

I currently have 3 fields relating to an employees employment date: The first field is the date of hire The second field is a calculation of years from the first field. The third field shows an employees exit date. My question is this: is it possible to have the second field (calculation of years worked) stop calculating the years if a date is entered into the third field (date of exit) I know I could get a calculation from field one and three after the employee leaves however I do not want a calculation of that nature, I need to be able to look at the field and get a “live” display of the worked years. Or does anyone know of a better way showin…

I have a laptop that runs both Filemaker Advanced 8.0 V3 and 8.5. It's a Dell Inspiron 9300 with 1gb of RAM and an ATI Radeon X300, Windows XP Pro SP 2 all updates. For whatever reason, if my laptop is not restarted for a few days, the display of Filemaker gets out of whack. If I go into Layout mode, I can't see any of the borders of any text objects or any objects at all. When I go into a field and I try to type into it, you can't see any of the text you are typing. When I click out of it, whatever you typed in there will be displayed. All button effects do not show up at all in any format such as Bezeled, Chiseled, Drop Shadow, etc. This is driving me cra…

:) Hi -- can you help me with the best way to approach the problem of having set up a layout which is fine until... one of the fields has too much text in it. I've attached a screenshot of my layout. It's for a database of video tapes. It fits onto one sheet of A4. But there's too much shotlist information to fit in the box. What next? Is it a tab control? I can't work out what I need. I don't want to create a second page for every record -- only those that need the spillover text. Thanks for any help. Phil -- Filemaker infant. Please be gentle.

I have a long list and would like a record to highlight when it is clicked on. This solution is in a multi-user environmnet. I know this must use either variables or globals and a container calculation result but I just cant seem to put it all together. Thanks, Drew

I have 5 seperate files, each containing > 600 fields with specific tab orders. When the customer makes a change which adds a field or changes the location of a field I have to change the entire tab order from that point on. Or do I? Is there any short cut, rather than resetting the entire tab order? Please keep in mind I'm new at this. Thanks

Ok, after the battle last night with my portal problems (again thanks to those who helped), I think I have now lost my mind. I’m not sure if this is a layout question or a tab question so I will post it here in hopes that this is the correct area. I have gone blank on this…I have a tabbed layout containing information about an employee spread out among the five tabs, all is working well. I have one tab which contains an employee evaluation form. Now, as with any evaluation a new one is done each year. My question (which has me stumped) how do I create a new record just for the evaluation form inside the tab area? Example: I have all my tabs containing…

I have a report layout which has a letter on it. In the middle of the letter I have a 12 row portal. Each row in the portal has 2 rows of fields, the top one is merge field with a description and cost, the one below is a paragraph of formatted text which describes the item. I have the portal expanded down quite a bit to make sure there is enough room to fit the varying lengths of the description text. I have set the sliding to All above/reduce the size of enclosing part. But it's not reducing the extra space in the portal at all. It’s leaving it the exact same size. Any ideas? I just can't figure out what's wrong.

I hate these.... I have been using 8.0 since it came out but have not gotten any of the upgrades yet. I am also on Windows XP. Had no issues then yesterday I did SOMETHING not sure what. Now when i RUNNING FM and i try and copy, cut, or paste in any application it hangs all the applications which i have to force end by hitting the close X or using the task manager. Besides reinstalling any ideas on how to fix this? I have tried other brand new DBS with no success. I can cnp without FM just fine it is only when it is running that i have clipboard issues Strange eh?

I'm a newbie and thanks for you help. I need to make a report with the monthly totals of the records. All the records have a date and an amount that I need to group by month. I only need to see the monthly totals, for example... Oct.......54,000 Nov.......55,000 Dec.......56,000 I've tried to make a summary report it has a subsummary sorted by date part which i put the date field and the amount field into but it does not total by month. It shows like 20 Octobers followed by 25 novembers, etc;... please help.

Hello, I am working on a invoicing solution for the company I work for, and as part of this solution I need to print off a calculated number of labels. (For packaging) I have a count field with the number of products on the invoice. And what I would like to do is to use this value to print off that number of labels. I have looked at the "Label Generator" file but I am having difficulties trying to reverse engineer this to match my own needs. I would be grateful if anyone could give me a few pointers on how to manipulate this to solve the problem listed above. I appreciate any help that might be offered.

Hi, Do any of you mathematicians out there can help me with the formula for rounding up and down a time to the nearest quarter hour? Thanks in advance, Ukyo

Hi I am not sure where this query should be but I am just putting it here. I would like to store the login information of all the programmers that work on the hosted Files. I also would like to capture their IP Address and Computer Name. Get(HostIPAddress) and Get(HostName) gives me the IP Address and Name of the Server where the files are hosted but I would like the client IP Address and Client Computer Name which the programmers are using. Is their a way to do it ? Thanx

I'm not sure I'm explaining this correctly - but the problem is that the layout stops showing the sub summary sort after I've gone back into the table to make some data changes. The sub summary is based on the "street name" field (and there's a "street name summary" field )and then there are a series of summary fields, let's just call them a, b, c,d, etc. For each street, I get the totals for each of the summary fields. The first time I set up the layout, after much trial and error, I can get the layout that I want (I'll skip over why I can't get it right the first time.) But - when I review the list of streets, I see that some streets are listed twic…

I really hate to bother everyone with such a newbie question, but this thing is getting the best of me and I am about to just give up on it. I have a date field and I want the date shown to turn red if it is within a 7day window, so the viewer can see that the date is approaching soon. I have tried the Date <= get(currentdate)+7 and change textcolor calculation but I get nothing. What am I doing wrong? Can the textcolor be used on a date field? Thanks James

OK let us say that you create a new record, then you input a number in a field, lets say 1,000. now what i am trying to do is to get a second field to reconize what has been put in the first field and automatically put the correct number in the second field lets say the second field is to show 10% of 1,000. so you put 1,000 in the first field click off the page and 10% of that thousand automatically pops up in the second field. any ides??

Please help me. I need to turn this PDF into a FileMaker report. I have a report that first list the top 4 projects. Then at the bottom it lists the additional projects excluding the 4 projects. Is this possible? Thanks, Maria IMS_Project_Status_120506.pdf

I currently have a field that "Flashes" or "Blinks" when you navigate to that layout. It is the only one on the layout that does this. I cant seem to locate any information about a problem such as this. Has anyone ever had this happen before? Thank You, Brandon

I have created a custom pop-up window/dialog which I would like to be able to close by hitting the enter key (rather than using the mouse). Is there any way to do this in Filemaker 7 or 8?

I'm trying to manage large blocks of text displayed in individual fields. I'd like to provide the user with buttons to move to the top and end of the block. In other words, exactly what the Ctrl+Home and Ctrl+End keys do from a PC keyboard. I've been working with the Set Selection[Record::Field] but can't get the results I need. My example shows the results I've gotten so far. Is there a way to construct a "Type In" script step that is equivalent to the user typing into the field? If so, can the characters be control characters? If so, will they be stored in the block or acted upon (as if they were being typed)? BTW, I want to avoid executing any tru…

Hello everyone, I need some expert advice. I was building a layout with a field for a “Course” selection, I was just going to us a value list with drop-down arrow on the field, and then I found out that they had about 400 courses. How can I effectively implement a solution so that the user will not have to type each course ID in the field? The only thing I can think of is using the value list, and have the auto complete enabled and not show the drop-down arrow on the field? Am I thinking correctly on this one, or have I once again made it more difficult than it has to be? Thanks for any suggestions. Barndon

Hi there, newbie layout puzzling question... I 'm trying to show in a 2 row configuration data from a database, in a "calendar like" way. For example, we want to show appointments at a given date. We get the results for that given date and we SHOULD have an appointment every 15 minutes starting from 10:00am (15 minutes is not a rule it could be 30 on occasions). I can only manage to show each appointment time and name on a single line with the next following on the next line... This is how the layout looks now: Header -> Appointments for Date variable Body -> App_Time variable - Last_Name variable - First_Name variable What I want is to have 2 app_tim…

I'd like to use a consistent GUI for the Contacts database I'm developing, with navigation buttons on the right. However, I can't follow this through to the List View (or table view, for that matter). So I thought I'd try and show the records (found set) in a portal on a Form layout so I can keep the GUI consistent. Problem is, I can't get the relationship to work properly and display all records in the found set of the primary table. I'm using the field "ContactID" for the self join in both the primary Contacts table and the TO of it. I've tried the "=" operator as well as the "X" operator, neither of which is getting me the proper results. Any suggestions…

I want to store only a reference to a photo in a container field to reduce the size of my database file. Q1. If the photo is stored only as a reference, does this affect speed of navigating between records & layouts ? Q2. Using FM Server does the folder containing photos need to be in a specific directory on the server e.g. ..../data? Hope someone can help.

I'd like something equivalent to sliding (for printing) to occur in Table View on Screen so that Browsing in Table View could look something like the following for a 2 field, 3 record example: Description_________Item number Short text_____________349 Longer text____________444 description of item 444 causes just this row to be larger Another short one______222 Is it possible?

Hello, I am very new to FM and I have a question which I am sure is so simple, however I cant find the solution anywhere. I have created two tables, I want to enter data into table #1 and have it also fill in table #2. I want to be able to delete the data from table #1, yet have the data in table #2 remain, I guess what I want is a record kept of the data from table #1 even though it has been deleted. Could someone point me in the right direction? Sorry if this is not the beginners section...could not find any area for new kids on the block. Thanks for any help. Brandon

I have certain layouts that have the status area toolbar hidden. When I hit a button to find records I cannot see the records in the found set as the staus area toolbar is hidden. [color:orange] How can I show the records in the found set whilst the toolbar is hidden?

I'm trying to display a preview of PDF files in a container field. This is in a cross-platform FM8 database stored on a server. The users are 1/3 Mac, 1/3 Windows 2000 and 1/3 Windows XP. I could get the file preview to display in Windows 2000 and Mac by using a Windows 2000 PC to drag the file from it's folder on the network into the container field. The first page of the file then displays as a preview on the Mac and Windows 2000 PCs. BUT on Windows XP the preview doesn't show unless you click on the container field. Then the file hangs up for about 3 minutes until the preview displays. Way too slow to be functional. This happens whether it's dragged and drop…

Someone has probably asked, but I couldn't find anything. So anyway. I have used the setting "do not print selected objects", but now I have some layout where the fields do not print. The appear fine in browse, but not in preview. It sounds like "do not print selected objects" is set for these objects, but it is not. Has anyone had this problem?

Can someone please update this to make sense for version 7.xx and up ? Their script steps and associated syntax do not match our version and even the article itself seems to contradict itself. http://tinyurl.com/w8qcq Answer ID 2654 APPLICABLE TO FileMaker Pro 4.x, FileMaker Pro 3.x This solution can be used to create return address labels, to duplicate a specific number of records, or to duplicate individual records a specified number of times. The solution assumes that you have already created the fields and records you wish to duplicate. Also, because this solution adds duplicate records to your database, you may want to apply the solut…

Is the latest 8.5 version able to print duplicate labels such as return address labels without having to create duplicate records - a messy solution for a fundamental operation that should be built in for label printing imho.

Sorry, I have just started using FM and do not know all the correct terms…I did not mean to offend you. I withdraw the question.

I'm trying to make a crew list that is first sorted by Department. when I put the Dept. name in a Leading Summary, nothing shows up, and when I put it in a Sub-Summary, it shows up in front of every entry. I just want the Dept. to be listed once in front of the top name. Any ideas?

While we click any button the button color changes to black for the moment the button remains pressed. How can we prevent that or change the 'onclick' color to button color? Actually i want the to suppress the dialog box that appears asking to save(when automatic save is turned off). So i set the button control of the screen to "refresh", but now as i click anywhere the screen momentarily turns black. Is there any other way to supress that dialog? -rksh

Hi I am trying to create a report that summerizes how many amendments where made on jobs produced in a week. In the Trailing Grand Summary I have a field that I would like to have the count of Unique Job No's. The problem I have is when a job gets ammended it keeps the same Job No so when I do the count it has many duplicates included. Is there a way of summarizing on unique Job No's ?

Hi there, I don't know my way around FileMaker at all, though I've been trying to pick it up. I can't figure out how to do something that seems fairly basic. I want a layout that only shows a particular field (and its label) when that field contains data. If the field is empty (and this is the bit where it maybe gets hard) I want the fields beneath it to move up to fill the space. But if the field is over a line, I want it to resize and push everything else down. I don't want to set up different layouts for each possible permutation and making a calculated field won't allow me the formatting I want. I think I'm struggling to find the information I need beca…

Hello all, Have been a "lurker" for a while, and found all the answers to my questions, however i cant find any clues on this one... What I am trying to do is create a letter that is personalised with information that is not directly in my database, for example; in the database i have a field that contains a partners name, if this is filled in there are additional paragraphs i need to include that relate to married couples, i've thought about using different layouts but there so many variables i would need about 20 diffenerent layouts, what i need is an IF calculation that populates perhaps a merge field with data that is stored somewhere else? i'…

Greetings, I currently have a layout with issued equipment (about 60 items). I want to generate a report of the items issued to that individual. How do I get the report to only print out only items which have been issued (and skip the blank fields / not issued) and not have to place all the items on the report to print out. Thanks, Jim

I have two templates. 1 is a purchase order template, the other is a contact management template. Im sure some of your already have this set up but, again, I am horrible at anything that has to do with scripting and programming. I want to create my customers on the contact management template and somehow import their information into the "billing information" section fo the Purchase Order template. What can i do or how do I make this happen? Thank you all for your time! D

Have a database used by Macs and PCs. Students use the database to complete online tests. However, if I use a font such as Arial, the setup on the Macs looks different to that on PC. Consequently, some questions appear "hidden" behind a field. I need a font that will leave my layouts appearing identically on both. In an ideal world, I'd stick with century gothic which is on both machines but gives me the problems mentioned. Any ideas? Thanks.

I'm trying to mark or highlight certain records in list view based on a condition in another field? I can't change the text colour because I use the text colour already for something else. I want to make a background behind the text. I started with a global container repeating x2 Then I drew a box the size I wanted to use as the 'highlighting/backdrop" for want of a better description. I pasted the box into one repetition and left the other blank. I added the calc field: If( Term=1; GetRepetition ( Background colours ; 1 ); GetRepetition ( Background colours ; 2 ) ) I put this field onto the list layout under but bigger than the other fields The …

I have suddenly encountered a problem with a layout in a file that has been very stable (up 'til now). This file has 17 different layouts. When I go into Layout mode I can work with 16 of them just fine. But, when go into the other one, FMP crashes. I have tried a recovered copy, and a backup copy from a week ago, and both do the same. I repaired the disk permissions and closed all other applications, except the finder. HELP!!!

Hi, Has anyone here had experience with creating a touchscreen layout, I would like to bring up a window with a keyboard layout on it and be able to use the system without the need of a keyboard or mouse. any ideas much appreciated. Regards, Roy

Hi, I have a question about creating a DEMO version of an application with a date expiration. I have read several postings, which state that someone has created a DEMO of their application by using a “Date” expiration. However, I have never seen a posting as to how they accomplished the expiration…I have made many attempts to create a “Date” expiration but have yet to accomplish it. I have successfully created a DEMO of my application by using a limited number of entries before the DEMO locks up. I would really like for the user to be able to enter all the records they want, so that the can do a full test drive of the application and have it expire after 15…

Hi! Sometimes when I put text or field on layout, go to browse mode and back in layout mode, text falls 1px down. Then when I double click in text or field it jumps up, but when I go into browse again it falls down. I happened to me on few layouts...I have to create layout from scratch. Can duplication of layouts or copying elements be the problem?

Hello! I am new to both FileMaker AND this forum so this might be a very dumb question but i just can't figure it out. I want to have a field (order status) on my layout BUT when I PRINT i don't want that field to be there. How do I make this happen?

Hi there -- I'm a real beginner with FM, so please excuse the very basic question. I couldn't find a post about layouts with 2 pages. I have a layout which groups all my fields in an A4 size for printing, but I now need to add an extra page. (I'm making a database of video tapes and need a whole page for shot list details instead os sqeezing them into a small box). I can't work out how to do it -- sorry. Thanks for any help. Phil

Hello there, I am new to both Filemaker and the FMForums website. Having read through the helpful post here over the past week or so I've managed to get a lot of help. However, I have a problem when it comes to reporting, specifically sub-summary reports. I have been involved in developing a Invoicing solution for the company that I work for. At the moment I have the invoiced items entered via portals in a multi-tabbed set-up. What I am aiming to do is to group these fields into a report which prints off each portal record for each invoice. (N.B. I have tryed using portals in the report stage but they do not display all items when there are many and …

Not sure whether this has been asked b4, izzit possible to show two related tables in one layout? Meaning one table on the top half of the layout page while the other on the bottom half. I'm not sure how to break it into half... Portal only shows one related record right?

Is it possible? I want a particular checkbox to be checked by default when there is a new record added? This is to display to my staffs whether there is any new records for them to view. Or is there any other method to notify in a layout when there is new records entered from another table? Thanks

Hi Everyone, I've got a question about displaying (and manipulating) related images. I've got a related table that I want to display multiple images for one record. The thing is, I'd like to display six pictures (three rows, two columns). Using the portal doesn't seem very flexible, can it be done with the portal? Or is there another way? I was thinking about having a separate related table for each of the six different kinds of pictures, that way I don't have to use a portal right? But that doesn't leave room for the possibility that we may want more than six pictures for some records... Also, is there a way I can have a button next to each pictur…

I'd like to display the total number of records in a table at the bottom of a layout. I want this count to be of all records in the table, not just the records in the current found set. I'm guessing that I need to use a global field to store this, but not sure how to proceed. Can anyone offer any advice? Basically, the bottom of the the layout should have a label along the lines of "## records in the database." where ## is the total number of records. Thanks!

I have a report that takes job tasks, rolls those up to a job code level, then summarizes by manager and chief. something like this: Chief -- Manager ---- Job Code Total ------ Task ------ Task ------ Task ---- Job Code Total ------ Task ------ Task -- Manager Total Chief Total For the life of me i cannot figure out how to get the sum of the Job Code costs to calculate on the manager and chief total parts. The task totals work fine. Can anyone shed some light on this? Please let me know if you need more info

I use FM6 for membership reasons and need to send out addresses to a mailing company. I am trying to export them to a word file for ease, but no joy. Suggestions?

Hi - I'm trying to create a way for a user to choose a surrogate primary key (serial number) but only see a more descriptive field. FM has the ability to show a value list based on a field, and only show a second variable. However, this seems to only work correctly with popup menus. With a drop down, you see only the second field when you click the field, but when you leave it, you see the actual variable assigned to the field (in this case the surrogate key). This will be confusing to user, but I prefer not to use a popup because it doesn't allow autofill by typing first letters. Any way to do this? Or some other way to hide the primary field so I could show t…

Hi all, My problem now is as follows: I have a database up and running that is filled with products (so I can't post it due to privacy issues). My company needs to print out the Specifications of these products in order to send to customers. I just can't make a layout that I feel comfortable actually presenting to customers due to the amount of white space I'm creating. Each product has 9 categories, brought in through portals. Each of these categories contains between 8-15 fields. I need to make a layout that prints properly if every single field is filled (worst-case scenario), but that also prints if various amounts are. Some products also do not contain c…

I know this must be simple but please help. If I run a script from within the file and it tell it to go to my date field, I get a drop down calendar as I should, but if I call that script from a different file (Main Menu) I just get a blinking cursor in my date field

I have a file with student records. Each student has its own information and a parent id. I need to determine how many children are in each family and pritn a report that is sorted by that number. For example Davey Jones might have 5 children in school. Tom Lasorta, 4. Anna Frank, 5. It should come out with a 5 children group displaying Frank and 5 children, and Jones with the 5 children info. Then the 4 children section with Lasorta and children info. As I mentioned, I can differentiate parents using the parent id. Thanks, Mike

I have a Header that includes field labels: "item" and "qty". The Body only has fields item_name and item_qty (so that each line item does not have its own field label); so far so good. I use the Leading Grand Summary to include the field labels, "item" and "qty", as well so that there are the column headers for the first page . I use the Header to include the field labels, "item" and "qty" so that there are the column headers when there is a second page of line items. The Trailing Grand Summary has the sum fields and some Terms and Conditions text. The is a Footer with address info. However, in some cases when the number of line items only f…

We have several databases running each containing numerous layouts. Is there a way to print a list of the layouts set up in a database?

I am trying to build a form which uses a field that can self-expand, i.e. is not constrained by set vertical boundaries. For example, if I enter one word into the input field, the resulting field is one line high. If were to I enter a list of items numbered 1-10 or if I enter a long string or paragraph that wraps 10 times, the field adjusts to be 10 lines high. Is this possible in FileMaker?

I downloaded an example database posted to one of my questions and it had the part labels displayed vertically. Many times I have fields that are mostly covered by the horizontal labels which can be annoying. I searched around trying to find a way to change the direction of the labels but I couldn't find anything. Does anyone know how to do this? Thanks js22

I have a report layout that has a trailing grand summary. I would like to be able to print a footnote in the footer on the same page as the trailing grand summary. Placing the footnote text in the footer causes it to print on every page which is unacceptable for my audience. I've placed it in the trailing grand summary part itself but again my audience did not like this as it is never in the same location. Can anyone help me with this. Thanks!

Hi All. I have a script that checks for all of the field validations when the user tries to exit the record/layout (I have two buttons that allow navigation away from the layout). If any of the validations fail, the user gets a specific error message and the script exits. This works perfectly, except for one issue. I have several portals on the layout and i do not believe that the validation checks against every related record, only the first one. Is it possible to script a check against every related record? Thanks for any input.

Ok I have worked out how to use the seperation model in FM8.x, but I have a client that uses FM5.5 and 6 and wish to use a seperate GUI and Data model, but for the life of me cannot work out how to best do this, does anyone have a good example to share please of an FM5 or FM6 seperation model. Cheers

Heres my situation. My company is dealing with manufacturing. So we have an order, and we assign employee numbers to work on that order. We are using a field as a Checkbox, with a Valuelist that has all the employee numbers. In a 2nd Layout we want to create a report. We would use Find to filter down to a single Employee. and review the orders that employee worked on. We used the same field, except as an edit box to show the data. Now I have 2 problems: 1) the Editbox does not show the Employee Numbers in numeric order. It shows who was clicked first first, and second is second. 2) The edit box shows only the first chosen number. It does not put them…

I would like to display on a layout the order in which the table is presently sorted. If the sort selection is changed, this field would reflect the new sort order. How can this be done ? I tried with a global field and the Get(sortstate) function but this only tells me if the table is sorted or not (0,1)- doesn't give me the field name. I'm also looking for a method where a user could select the sort fields from a dropdown list (where I would put only a few fields-not all of them), and have the sort run after having done the selection. Thanks for your help

I have a script that takes the user to a print preview mode for several reports with user abort [off]. The user needs to select the continue button to scroll through all the reports and exit the script, which takes them to another layout. Is there away to allow the user to cancel the print preview at any time and return to the other layout? if i turn user abort [on] it will allow the user to cancel the script but leaves them on the report layout. thanks for any help.

I do not know if this is the right option of the forum but I have to put questions about the color combination of the filemaker database layout and the design as well. Can I use the same colors as the web? What colors are the most appropriate for the layout of the database. As I know progs use different colors and design from the web. Any sourses will be gratefully acceptable. Pascal

I have seen a tweak to create a sidebar in List View and conquer the black lines between Header and Footer. Somewhere in the old Scryptology Developer Toolkit or in Filemaker Magazine. Can anyone tell the key word to find it again or point to example somewhere. Ta Regards Eric

I was wondering if FM 7 can freeze fields much like Excel. I have a number of fields across the screen and I want to keep the ones on the left while Vert scroll to the right. Can it be done with little efforet? THX MS

I am a new user and I am using FM Pro 8.5 trial version. I can add and reorder fields in the Define Database dialog but when I OK out of it the first time and then reorder fields a subsequent time, the new order does not show up in any of the views. I can add new fields and change their order within the dialog but the new order does not show up in any views when I OK out of it. I can rename fields but any data associated with a field will remain associated with the original field regardless of the new name so this is not a valid work-around. If I delete a field, it leaves a gaping hole where the field was. This is a serious problem as I have no way of maintaining an exist…

Here's the little problem I am having, I was hoping you guys and gals could help me out. The file has two main scripts, one to go into preview mode (and sort by company) for the sub-summary layout report, the other script to go back to Invoice layout as Browse mode. I've read the usage of the GetSummary function, where I think that the break field is not doing what it should, as the field is blank. It would be great if someone could solve this one . . . summary.zip

Hi, A client wishes to include a bitmap signature on a letter. The text moves up and down the page a bit depending on merge field data, while the bitmap picture or object stays put. Is there anyway to link the signature to the text so that the signature moves together with the rest of the text? Thank you! Laura

I've got a database where all the fields have 20 repetitions. This is to set up meetings. Any given person can have up to 20 meetings. However, I may be in meeting #3, Joe may be in meeting #5, and Sandy may be in meeting #1. Regardless of what repetition any record is on, I need it to sort and print by date. How do I set up my layout so that it allows for all repetitions, but only prints a repetition if it has a date in the date field?

Hi, I am pretty new to Filemaker although I am experienced in developing for Access and SQL Server etc. Anyway I'm trying to setup a simple database to track backups using Filemaker Pro 8. I have two tables - called Media and Tapes with a relationship between the two through the MediaID field which I have setup to allow new Tape records to be created through this relatinship etc. The Media table also has a field called Media Label. I want to setup a layout for Tapes which allows me to create a new tape record with an associated MediaID but by selecting a Media Label rather than a Media ID in the layout. I have setup a value list for Media Label using M…

I am developing an order entry/tracking system in FM8 for a silkscreen/embroidery shop. Each order may have multiple styles & colors of garments, as well as multiple sizes with varied quantities per size. I'm trying to figure out what would be the most effective way to create the records for the styles/colors/sizes/quantities. Currently, I've got a table for the entire order and within that table is a portal with a record for each item. (Each item could be a different style or color of garment.) I have a description field which can contain the color and style of each shirt. For the sizes and quantities, would my best option be to have a separate field for each si…

I have a date field. I only want dates entered by selecting from a drop-down calendar. I've tried turning off entry to the field and attaching script with: Go To Field [ dropdownField ] ... with and without Select Field Contents Nothing I can think of works. Unchecking 'include icon' allows the pop when field entered - but doesn't prohibit entry to the field. Once the calendar is open, I don't want them to be able to click again and end up in the date field itself. I haven't played with 8.5 yet - maybe GoToObject? But still, we are on vs. 8 and I want it now. Is there any way to pop that calendar via script? It must be something simple I'm missing. …

I would like to create a report that will show related data. For example, I have a database (DB) that tracks websites. The DB has 4 tables; Website, Owners, FQDNs and Notes. I want my report to look something like this; ******************** WebSite - MyWebSite Owners - John Doe, Jane Doe, Robert Doe FQDN - www.mywebsite.edu, mywebsite.edu Notes - 10/05/06 Created a new page. 10/06/06 Deleted page. 10/15/06 Added graphic to main page . 11/01/06 Attended conference to discuss future changes to the look and logic of website. ******************** What would be the standard way for extracting the data from my 4 tables to get this type of report?

Hi all, My problem is when I soft by date, how I calculation the cost field / amount field *100 = My percentage field result. Thank for your reply! Soft_Report_Problem.zip

Something probably very simple here, but if I can't put my finger on the solution. If sex is Male, then I want a specific layout to be shown (A male figure). Eg. User chooses Male, and then clicks a button to view a diagram. I want that diagram to be of a male. Same for female. Would appreciate any advice! Thanks

I am trying to create a layout that will display the last seven records of attendance along with customer demographic information. I know how to get the records through a find, but I am having trouble coming up with a solution to display them. Oh yes, and I need the horizontal versus the vertical layout of a portal. It would look something like this. Name - Phone - att. record 7 - att. record 6 - att. record 5 - etc. The record would display whether they were present or not. Sorry if this is not clear, please let me know and I will try to clarify. Thanks

[color:green]Here's a stumper for you. We are using filemaker 8 in a small office of 4 computers. One of our layouts imports media names from another layout as a drop down list. On the host computer, the alpha list stops around the S media. On all the other ones, the list is able to be viewed through Z. This wasn't always the case and we're not sure what happened or how to resolve! Any ideas on problem/fix? Much thanks.

nfm...

I have a layout I use for printing, that shows nine or ten records per page. In the footer, I want it to say "Records 1-10" on the first page, "Records 11-20" on the second page, etc. I can only figure out how to insert the number of the LAST record on the page (using symbol @@). Sorry if this is really obvious, and thanks for any help.

I would like to use filemaker to complete forms using data from each of my clients. The forms are available as PDFs, and I would like to ovelay each client's data onto the form. I tried to save the file as a jpeg using Adobe Acrobat standard and import the file into filemaker but the quality of the printouts is horrible. Does anyone have any suggestions on how to doing this?

I have three repeating fields that contain name, address, and city state zip. There are 31 repeats. I want to be able to create a label layout and move these fields onto the label layout. Not possible that I can figure out. Please help!!

Didn't see a specific category for this so I'll try it here. I have implemented the chart example from Filemaker's website into my own. It works great. I am using the pie chart. But it does not transfer to shared users. How can I get them to see the chart too?

Hello gurus, I am trying to create a form which takes the free text input of a field from my database and prints it on the resulting page. The issue is that the field (text box with scroll bars) could have anything from a few words to a many paragraphs of data within it. When creating the hardcopy form, I am using mail merge fields to output the data and the part in question needs to be printed in its entirety, to be followed by other static data, which is then followed by yet more dynamic data. How do I get a field to dynamically resize and adjust the space required automatically?

Dear all, I have a database which I plan to separate it into two different files. One files for all layouts and the other files is for all the tables. After that I will do the kiosk mode for the layout files. Is there a simple way of doing it while i still get to keep my scripts working properly? Thanks

I'm having some trouble displaying borders on my print layout. I have a attached an image of what I have done so far and what I would like to achieve. I need to display borders (like a table) but as some of the fields can contain alot of text or almost none, I have to resize the fields in order to print it. The resizing works very well, but as it's a A3 print, I need to include borders to make it more readable.

Here is a question that has puzzled me for many a year but i have never thought of posting as i just thought it is too annoying to tackle. I like most break my data down into the smallest possible parts.. this is great for most kinds of report ... but ... the CV is as everyone knows a complex animal. I want to create a database driven CV. So I have several databases... Education Employment Press Publications Events Referees Now i need these all on one sheet ... oh and they all have different layout formats ... and every time i print it it changes... So do i have to create a CV database with multiple overlated layouts and import the …

Hi there. I have an avery label layout which is working well, except for one thing. I have a combined "field" in the layout which is: Salutation & " " & First Name & " " & Last Name & " " & Professional Designation However, when the Salutation is blank, it leaves a space before the First Name. How do I get rid of it? Thanks!

Hi, I'm using filemaker 8.5 and I'm trying to get a layout that displays one of two portals conditionally. I'm working on a database for the lab that I work in. To do an experiment you can use either of two different mixtures. The layout that I'm working on is an overview of what was done. What samples were used, conditions, and the components of the mix used. So I made two portals to the two tables that store the two different mixture compositions. I stacked the two portals on top of each other. Is there a way to conditionally tell the layout to display this portal in front of this portal? And how would you set up the script to decide which layout to dis…

Hello, When I am printing list of people in my database, I have address field which I resized to show 5 lines of address. But some records are w/o address, so when i print, there is free space. Is it possible, that the "body part" and field will scale automatically, so my list should be like this?}:| Name addressline1ifNotEmpty addressline2ifNotEmpty addressline3ifNotEmpty addressline4ifNotEmpty addressline5ifNotEmpty

I have recently upgraded from FMP v5.5 to v8.0. Former separate files and their relationships are now separate tables and relationships in one file. A few layouts that contain table fields and related fields behave differently when changing records. For example, in layout mode I set my "advisment" layout to view records from my "main_info" table. For some records in browse mode, it shows "main_info" data fine but will not allow data entry in related fields on the same layout from my "advisor" table. Other records show both field types just fine. When I switch the layout to show records from my "advisor" table, I can enter data in the advisor fields and see previously ente…

Hello, I am trying to figure out this: I have database with lots of people. When I am printing list of those people, in each person i have two field for telephone and two for mobile, like this: Tel1: 111 111 111 Tel2: 111 222 222 Mobile 1: 123 123 123 Mobile 2: 321 321 321 what I would like to do, is to hide field name (Tel1, Tel2, Mobile 1, Mobile2) if the field with that telephone number is empty. Because now, my printed list seems like this: Tel1: 111 111 111 Tel2: 111 222 222 Mobile 1: 123 123 123 Mobile 2: 321 321 321 -------- Tel1: 111 111 111 Tel2: Mobile 1: 123 123 123 Mobile 2: Thank you for …