FileMaker Interface Features
-
Can somebody help me with the following? I'v got two databases: 1. One CD-file (with track-description) 2. One Library-file (with info about a library) What I would like is to have is an index (in the Library-file) of all the CD's a Library contains. In this example I would like to create only 5 records (CD's: 1001, 1002, 1003, 1004, 1005) in stead of 587 (CD's + Tracks) for the library called "1000 SERIES THE GENERAL" (which is a record in my "Library-file"). So I like to see an index of which CD's are in this particular library without tracks and without duplicates. But when I add new data of a new CD in the CD-file, for instance 1006 with 75 t…
-
- 0 replies
- 776 views
-
-
I am counting the records that are displayed in a portal and want the results to be displayed in a field automatically Author is the field that I am using to count portal records I have a Calculation field with the calculation "Count(portal::Author)" it works fine...BUT when there are no records in the portal it won't display the 0 in the calculation field...I need it to display the 0... THANKS
-
- 1 reply
- 1.2k views
-
-
Hi, I've recently been introduced to FMP 4.1 and am having a problem with configuring a "find" layout. I have a group of 100 members who each sit on roughly 65 committees. I decided to cast one field with repeating values for the committees, and ideally would like to choose one of these committees from a value list, hit a find button, and go to a new layout that lists the committee's members. Actually I have managed to accomplish most of this, only I am now unable to display the committee that was searched on in the "Results" layout. Will the repeating field prevent me from displaying the search criteria, or is their a workaround - such as a script - to display the n…
-
- 1 reply
- 803 views
-
-
Is there a way to make a field default to the first value in a value list when a new record is created? I want my value list to show NEW when a new record is created, unless the user specifies another value. I think this rules out auto-enter. Thanks for the advice!
-
- 2 replies
- 937 views
-
-
I want one layout in a filemaker pro 5 database to display all of the records in a list. I have tried following the instructions in the user guide for leading grand summaries, I have done everything it says, but its not working. Can anyone tell me where I'm going wrong?
-
- 2 replies
- 1.3k views
-
-
I have two databases. One is an employee record and the other one is a payroll. In the payroll file I have a field that you can choose the individual to pay by looking up their name from the last name field in the employee database. I have the field as a pop up list using the last name field from the employee database as the value list. The problem is that the list will not show people with the same last name. The list only contains the first record entered with that name spelling. First, is this the best way to do this and if so is there a way to get the value list to show all of the records in the database?
-
- 1 reply
- 812 views
-
-
How can i create a portal with the blank line at the first row?
-
- 2 replies
- 1k views
-
-
I am trying to create a layout with a set of 13 similar text variables;each with values selected from the same value list. I am trying to make the inputs via a table of radio buttons, one set for each variable. When I create this, using FMP3.0, each radio button has the text of the associated value right next to it. I would like to get rid of the text and get the buttons closer to each other so the table will be compact. I can't figure out a way to do it. Any suggestions?
-
- 4 replies
- 1.3k views
-
-
I was wondering if there is some way that I can automate the database so that if a particular value in a field is selected and the selection of that value would automatically jump to a text box, or a text field. For example...the field type is called Assessment Scope, and the two values are "General Population" and "Condition specific" where when condition specific is selected there needs to be some way to enter text. So say someone selects "condition specific" I would want it so that when this is selected they are then able to enter text to describe the condition.
-
- 1 reply
- 1.1k views
-
-
I'm new to file maker. I use filemaker pro 5 for mac. I already have a layout for my classes preparation. Since I teach in 4 classes, chemistry, physics, etc, I want a popup menu with all thoses classes name. And when I choose, lets say physics, I want that all my preparations for that classe to appear and not the others. How can I do that?? I've tried to put a value list with the subjects in it. Then I went on every preparation and choosed the right category for it. But whats next? Do I have to put a search button? I wouldnt like it. Please help me or refer me. Thanks Bernard
-
- 1 reply
- 934 views
-
-
A local organization runs 4 fundraisers each year. They have 4 databases that maintain records for each. What they want to do is create a master report that lists everyone who's worked one or more of the fundraisers and their total collections for each event in which they participated. Some individuals work all 4 and others just 1. How do we get all the names into one field with duplicates removed. I can display names from any one of the 4 easily but can't get a combined list. A calc field combining participant lists from the 4 databases fails with a beep and message saying "this field can't be found." The organization would like to have their information displayed simi…
-
- 1 reply
- 862 views
-
-
In the body of a report, a record contains two rows of information. Sometimes there is no information in the second row so I don't want to leave a blank space in the second row. Ideally I'd like the next record to move up. I've tried sliding and it still leaves a space for the phantom second row. I tried inserting a find command in the report script to eliminate the blank second row, but then it did not include the whole record because of the second row. I thought I read that you could shrink a section, but can't figure out how to do it or if this is a solution. Any ideas would be most welcome! Thanks!!!
-
- 1 reply
- 1k views
-
-
Is it possible to make a value list conditional on the values from two different fields? Example: I have a quotations file with quote numbers and revision numbers, I want to use the quote number then the revision number to determine the current price for the item (quote number 5, revison 3) in question. Thanks! I think I've found the answer in another forum.A calculated key is the solution. Create a calc in the quote file, quote number & "-" & Revision. Then put the quote number, followed by a "-" and the revison in the match field in the other DB to join them. Does this sound right? [This message has been edited by markga (edited September 01, 2000).]
-
- 1 reply
- 956 views
-
-
As mentioned earlier, I'm experiencing problems with printing of layouts, that look totally O.K. on the screen, but are printed in a wrong way. the font on the printed version seems to be smaller, than on the screen, because mor words fit onto one line. the result is, that the text occupies lace vertical space on the page, and therefore the elements, that follow this text are not moved up high enough, thus there is to much blank space between the text and the rest of the page. On screen everything looks fine. I've heard of printing problems with filemaker on PCs and HP Printers. Could this be the reason of my problems? Is there a work around? Thanx in ad…
-
- 0 replies
- 855 views
-
-
Is there any way to make a field that is divided into sections so that when the form is used each section can only be edited by the authorized person depending on there log in password.
-
- 4 replies
- 1.1k views
-
-
Hi all...We've been fairly successful into creating an archive for our reporters to look up material using the Web Companion plug-in that is running via FM Unlimited. However, we have a small problem with layouts. Problem 1) We cannot get IE to display imported pictures. Problem 2) No matter what Web Style is chosen (Grey, Blue & Gold, etc.), Navigator displays everything in a sickly green. Does anyone have any suggestions how to fix these problems? Thanks...Bill
-
- 2 replies
- 931 views
-
-
Hey, I know you can't slide/shrink a header, but I am producing a multipage report, and have a piece of information--whose size changes greatly, that I would like to preface the report with (in the header or the equivalent thereof..) the problem is that if there isn't the maximum of information in there, there can be a ton of white space before the data begins... is there any fix to this? Thanks
-
- 5 replies
- 1.3k views
-
-
Howdy folks. I have created a relational database that I think flows well from layout to layout, lots of GoTo buttons positioned near relational data etc. And still, a few of my users are begging for a "Back" button like the ones they use in their browsers so they don't have to remember where they came from. It would have to remember both which file they came from and which layout because there is a multitude of ways to get anywhere in the whole database. I am using version 4 on a Mac. Thanks in advance for any help. ------------------ Regards, K. ~~~~~~~~ Data is not information unless it is informative.
-
- 5 replies
- 1.2k views
-
-
quote: Originally posted by richshone: I tried to lay one field over another so that if one is filled in it shows through the other one (which in this case stays blank), and visa versa. I am having a problem whereby my tab function makes the second field (which would be blank) block out the first one if I tab through them, even both are set as see through. This problem doesn't occur if I mouse click past the second field, and this allows me to see what is in the first field just fine. Is there any way that I can change this so that I can use tabs for this part of my database? Thanks I am not sure what you are trying to accomplish, but you could simply remove bo…
-
- 2 replies
- 952 views
-
-
i have a db of students. i have a popup with a value list from the student's names. what i want to do is allow the user to scroll down, select a student, and have that student's record appear. can this be done? added hassle. user is not allowed to change the student name data. if i make the field unchangeable the value list disappears and it becomes a regular field. thanks Dave
-
- 2 replies
- 1k views
-
-
This may seem like a stupid question, but what is the difference between a footer and a trailing summary. I am trying to create a summary that (a) has the page numbers at the bottom of each page (I used a footer for this) and (: has the totals etc at the end of the report no matter what the number of pages. So far I have placed the totals in my footer but this would place the totals at the bottom of each page woulnd't it? Which would I put first? Footer or Summary? Thanks for clearing up a dumb question...
-
- 3 replies
- 1.2k views
-
-
I need help with how to create a field containing a list of items from another database. I have two databases SUITES and SETS. The relation between them is a 1-N relation with SUITE_ID::SUITE_ID so that I can get a list of all the sets in a particular suite. I can of course show the sets in a portal in the SUITE db, but what I want to be able to do is to export the list of sets together with information for each suite. I have tried just exporting the related fields, and they all are there, but the format is wrong. When I do the export I want the output (in TAB-format) to come out something like this: SUITE_ SUITE_info1 list=SETS SUITE_info2 e.g: 0210A1 …
-
- 1 reply
- 1.2k views
-
-
I am a beginning user of FileMaker 4. I have a two fields in my database: Application and Version. Application is a pop-up that lets you choose Photoshop, Outlook, IE, etc. I want Version to be a popup relevant to whatever application was chosen. For Example, when the user chooses Photoshop from the Application popup, the version popup only shows 5.5, 5.0, 4.0.1 etc. But when the user chooses Outlook Express, the version popup shows 4.5, 4.0, etc. Is there any way to do this? It would be soooo helpful and save a whole lot of time. Any ideas?
-
- 2 replies
- 1.2k views
-
-
Hello All I'm jumping head first into the world of networking a FM solution which relies heavily on portals, and I tested it out last night. The disturbing fact I discovered is that the dialog box warning the user that someone else is modifying the record pops up for numerous portal rows, no matter what record the first user is in. It's almost like they are in many records because of the portal, which makes sense in a way but is pretty annoying. I thought that portals were like windows, rather than doors. I don't have any field in the portal with entry capability, and use it only as a way to go to the related record (via button) for data entry. What I want is for …
-
- 2 replies
- 1.3k views
-
-
Here's what I'm trying to do. I have a portal showing the leaderboard of a motor race: who the driver is, laptimes, position etc. Can I put a button in this portal next to each driver so that, when the user presses the driver's picture, team info, past performance etc are shown elsewhere on the layout? This information is held in another file. If I can't do this, is there any other way to do what I want?
-
- 1 reply
- 853 views
-
-
I have a long, narrow portal, 30 records long. If I could split this into two short portals of 15 records, it would display oh so nicely on a web page. Can I do it? Note: the data changes dynamically. I can't rely on setting up two portals and using a function of the related data to tell it which portal to go to.
-
- 1 reply
- 1.2k views
-
-
I need to average flows every seven days for each month and haven't got a clue as to how to create this formula. Can anyone help?
-
- 1 reply
- 883 views
-
-
Currently, each record in the database is set up where the top section is the user information, and the bottom is the course the user has signed up for. Each record only shows one course, and a user can have multiple records with different courses for each record. How do I create a layout which shows the user's information once on the top part, and on the bottom is a list of ALL the courses the user has chosen? Thanks, Anita
-
- 2 replies
- 953 views
-
-
When I try to size a field with the object size box I can never get exactly the number I need. For example: I want the box to be exactly .220 inches but the thing always rounds it to .222. No matter what number I enter it rounds it to something that is close. Can I have an exact number such as .220? Please Help.
-
- 1 reply
- 1k views
-
-
When I select an object and bring up the Object Size Box it shows me the size of the box. When I select several objects at one time and bring up the Object Size Box it shows me the size of the entire selection, not just each individual object and if I were to change the size number it would change each object that was selected just a little to match the entire size that I requested. Now my question is, Is there any way to select several objects then make each object the same exact size?
-
- 0 replies
- 956 views
-
-
I understand that the width of a value list is determined by the width of the field it's attached to but how about the length? I'm using Arial 8 pt. and the value list gives me 10 visible choices before I need to use the scroll bar. Is there any way to exercise control over the length of this popup window and the number of options available without having to scroll?
-
- 3 replies
- 1.2k views
-
-
How can I get rid of the drop shadow on pop-up menus? They look ugly and a bit funny when they are in portals... I'd like it so they looked like normal fields. I don't want to use pop-up lists because I don't want the user to be able to enter anything but what is in the value list. Thanks
-
- 1 reply
- 1.6k views
-
-
This problem will be hard to explain but I'll give it a try. In a layout I have, I have a text box that has text baselines giving me a box that looks like a piece of lined paper. To the right of this box I need to place individual fields for each text baseline because of password reasons, but I can never get each field to line up perfectly because the size of the area made by the text baseline is not know and the field that I am trying to create on the right of each text baseline will not conform to the size I need. HELP
-
- 0 replies
- 843 views
-
-
I am working on a database for a bus charter company, I have a value list of drivers and one for buses as these two items are sledcted and placed into service I need to show them in use, for a date and time and then release them when this time has pasted . Any ideas? ------------------
-
- 1 reply
- 1.1k views
-
-
My company has used File Maker for years on MAC computers, but they have decided to switch to PC's. When we transferred the database from the MAC's to the PC the layout on the screen was fine, but when we print a sheet the layout becomes misaligned. We have sheets of data that display operation numbers in one column and they must line up with the operation data in another column. Well on the screen the numbers line up with the data, but when we print the sheet the numbers no longer align with the data. It worked perfectly on the MAC version, but when used on a PC we have that problem. What could cause this problem? Please help.
-
- 0 replies
- 980 views
-
-
hey I have two pull down menus and I wanted to change the second menu based on what was selected in the first menu, my fix was this, have the second value list defined from a field, the field it refrenced was a calculation based on the first pull down menu...the calculation part of it worked very well... but the value list didn't update properly sometimes, and was slow to update if it did.... I was wondering if anyone has done something like this, and if so what the fix was...... thanks
-
- 1 reply
- 1.1k views
-
-
I would like to know about a layout I saw on FileMakerPro database. This person has the multiples databases. There is not a switchboard to connect them. Instead there is tabs at the bottom of the screen like tab manila folders. If I press on the tab it takes me to the different database. Is this difficult to do? I have not seen ways to do this in my database. Perhaps my version is too old? (I have the 4,1). Thank you for anyone who can respond. ------------------ Mikhail Petrovich Vimov
-
- 3 replies
- 1.3k views
-
-
Is there an easy way to hide buttons on a layout for printing? If not, is there a hard way? Also, I read the response to Phil's question about buttons as menu bars and am just a little confused by the answer. I would appreciate a little clarification on global containers etc. as designing a menu bar (that also doesn't print) is most likely the next thing I need to figure out. Thanks....
-
- 2 replies
- 1k views
-
-
Hello everyone. I'm a newbie, and I have a question. Is it possible to use a script to choose what value list to use? A little more background: My company uises FM to track the shipping of products. We have certain companies that we have agreements with. We currently have a script that fills in the contact info of the companies, and we would also like it to change the listing of products they can choose from, as each has a different subset. Is this possible, if so how. Please help!
-
- 1 reply
- 1.1k views
-
-
I know it's called a heirarchical value list but I can't get it to work right. I have a field called "Group #" with a value list where the user picks their group. After this I want a value list to pop-up in a field called "Sales Rep". This value list is based on the group # (4 groups and a show all option). How do I get this to work. Thanks for any help you can give
-
- 2 replies
- 1.1k views
-
-
Hi, I'm creating databases using FMP 5 on an iMac using OS9. Every so often the files are copied to my obsses computer an Apply Laptop which is also running FMP 5 and OS9. What I noticed this morning when I looked at his files is that the font used in the headers of the layouts is different from the one I defined it to be. I set the Header font to be Calisto MT and the body to be Arial in my files. In his, however, both the header and body use Arial (the header looks like Arial, not sure cause I couldn't look, but it wasn't Calisto.) It doesn't look bad, but the other way it just looks nicer! I'm just wondering if this is a result of the copying or what or a diffe…
-
- 3 replies
- 962 views
-
-
Hi all, I have recently set-up a layout where I have a portal that filters out only portal rows that have a purchase order number or a purchase order number recieved value. This causes me to have a relationship to filter out this data. This is fine and it works great. Now I would like to fix those portals. I have successfully done that as well. But by doing that you need another relationship. My question is can you set-up a portal to have 2 relationships? I would like to have fixed and filtered portals. If anybody has any ideas please help! I'm open to changing my design as well. Thank you to everyone. ------------------ Ryan [email protected]
-
- 1 reply
- 1.3k views
-
-
Hi there, I'd like fields to be strongly highlighted for the user as they tab around a layout entering data....for all fields...text boxes, pull-down menus etc...so that the can see very quickly just where they are. The best visual look I would like would be if the border surrounding the field changed colour (perhaps to a thick yellow) How do you do this ? Phil
-
- 1 reply
- 918 views
-
-
Does anybody know how to fix portals? I need to have a scroll bar cuz there are multiple records, but I don't want it to go back to the first portal row after I click outside the portal. If I'm looking at the 50th portal row then I want it to stay there. Any ideas??? Thanks in advance. ------------------ Ryan [email protected]
-
- 1 reply
- 1.4k views
-
-
Is there a way to highlight the record that is currently in focus (Other than the tiny black line at the left of it)? Try it in a columnar list report in Filemaker 5 or above.
-
- 0 replies
- 940 views
-
-
I have three databases, time sheet( a simple portal for entering project hours logged), time sheet line items( for storing that info as separate records), and projects(for distributing that info to the appropriate project record). I want to create value lists unique to each project record and generated each time I create a new record, that can then be attached to a field in the time sheet file. Can this be done?
-
- 1 reply
- 986 views
-
-
I am (primarily) a home user, so I hope that my question won't seen to simple. I am still using 4.1 (I'm a student...), and I have a database that I want to have display a list (check boxes or pop-up) that eliminates an entry when that entry is selected. I want it to simultaneously enter the value that is being removed into another field. I realize that this will require a script, but I can't seem to make anything work. Any suggestions?
-
- 3 replies
- 1.2k views
-
-
I would like to be able to customize colors on the color palette. If this is possible, how is it done? (I am working on a PC- if that makes a difference)
-
- 1 reply
- 944 views
-
-
I am (primarily) a home user, so I hope that my question won't seen to simple. I am still using 4.1 (I'm a student...), and I have a database that I want to have display a list (check boxes or pop-up) that eliminates an entry when that entry is selected. I want it to simultaneously enter the value that is being removed into another field. I realize that this will require a script, but I can't seem to make anything work. Any suggestions?
-
- 0 replies
- 1k views
-
-
I want a common footer to run through all the various layouts I am creating. This will be the menu bar. I also want to have a button that shows "Switch to Admin mode" that disappears when clicked on (and the user is put in admin mode) to be replaced by a different button (I DON'T just want the text of a button to change) that says "Back to standard mode". How do I make a button invisible ?
-
- 1 reply
- 987 views
-
-
Is there a technique for keeping ALL of the fields from "highlighting" (showing their borders and changing color) when selecting just one field?
-
- 0 replies
- 935 views
-
-
posted June 07, 2000 10:27 AM -------------------------------------------------------------------------------- I want to paste a pdf data file into a database of FM Pro 4. If I create a container field I am able to do it, but it will not allow me to move or re-position it within the container and also it does not keep the filename assigned to the original pdf, it is just a generic label for the file. It would be great to find a way that FMPro could accept pdf's the same way that e-mail excepts them. I would like to resolve this issue this week. Thank you for your help on this frustrating topic. Brian Unger ([email protected])
-
- 0 replies
- 935 views
-
-
In Filemaker Pro v5 I want to have a dynamic value list in one layout based on the data entered in multiple fields in a different layout. Example: One FMPro database file. Each record in the database contains info on a different football team. In one layout there is a separate field for each player's last name. In another layout I want a pop-up menu listing all the last names of the players. It is simular to the "get value from field" option but instead of creating a value list of all entries in one field from all records in a file, I need a list with the entries in multiple fields in one record. Is this possible? Thanks, ------------------ Bryan …
-
- 2 replies
- 1.2k views
-
-
I am designing a database for my role-playing game and I want my radial buttons to appear as a 3D raised button rather than the flat button that is created. I've seen it on other FM databases and was wondering how to do it. Please help?
-
- 1 reply
- 1.3k views
-
-
in version 5 there is no "new break" option in the layout setup (used to be accessed by "option" clicking the layout setup menu item. Does anybody know what happend to it, is there another trick to achive the same, and if not, are FMP ever going to bring it back Thanks
-
- 0 replies
- 1.1k views
-
-
Rental categories Rental items Both in a table-like set up of 10 repeating fields. I have Rental Items looking at Rental categories, and then showing only values that relate to the Category item (i.e. Tables: round, square, oblong, etc.) The problem: All the repeating Items fields reflect values of the first entered Category. I have done the categories two ways: from a field, and custom entered. I cannot get the 2-10 Items values to reflect the entered Category value. HELP!!! And thank you, Pat
-
- 1 reply
- 1k views
-
-
Hello, I am working on a contact db which is predominantly used in list view. I need to make the currently selected record in list view visibly different to the other records. Can anyone tell me if it's possible to 'highlight' the records background or a text field in a different colour - ONLY WHILST IT IS THE CURRENTLY SELECTED RECORD. The little black vertical bar on the left extremity of the current record is okay but I need to make the whole record or just the main info 'jump out from the crowd'.? Thanks.
-
- 3 replies
- 2k views
-
-
Hi, I'm working with pop-up menus in FMP 5. I want to restrict the choices possible in a second menu based on their choice in a first one, ie a conditional/cascading menu structure. I've seen solutions to this problem for v. 3 and 4 which are huge and labourious, but I think it's supposed to be easier in v. 5. Any help would be great thanks!
-
- 2 replies
- 1.8k views
-
-
The 2/98 FMP Advisor advised using the MS San Serif fonts from the MS True Type Font Pack II for the best looking user interfaces. Is this still good advice, and if so, from where can these be obtained? The URL listed in the magazine no longer works to obtain the pack? Thanks. ------------------
-
- 1 reply
- 1.2k views
-
-
-
- 0 replies
- 867 views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online