FileMaker Interface Features
-
I originally posted this as a portal question but am suspecting that the solution can be better found in creating a summary for Invoices. I haven't much experieince in this area so I really could use a head's up:) Here's what I got and what I'd like to see: File one with five records, each with a JobNumber_Status Calc: Job Number: AA Record number 1 Item Type: A Qty: 3 StatusCalc: 0 Job Number: AA Record number 2 Item Type: B Qty: 4 StatusCalc: 0 Job Number: AA Record number 3 Item Type: B Qty: 5 StatusCalc: 0 Job Number: AA Record number 4 Item Type: C Qty: 6 StatusCalc: 0 Job Number: BB Record number …
-
- 3 replies
- 948 views
-
-
Hello, I have 2 problems with filemaker. I have hide the side navagation bar so the mouse wheel will not scroll to the next record, however I would like to scroll the portal. So for example the portal have 50 lines/items and if I use the mouse wheel I can scroll down all the way to the last record in the portal. The 2nd program is the tab fuction, I I have 2 fields in a portal and I would like to tab down to the next records in the portal but to the same field. E.G. 1 line of portal have "item 1" and "item 2" and I would like to tab from item 1 to the next row of item 1, in this case we only use the "tab" key in the keyboard. and where in field "item 2" if th…
-
- 4 replies
- 1.2k views
-
-
I have two databases joined one to many - "customers" and "equipment" The form shows "customers" information with a portal showing related "equipment". Customers each get unique serial number generated sequentially as they are added. As I add records to equipment in the portal, I want to also generate sequential equipment serial numbers 1,2,3 so that I can join the two serial numbers to get unique customer-equipment number that will be used to tie other joined databases. Example: Customer "1" has equipment items 1,2,3,4,5 that will be identified as 1-1,1-2,1-3,1-4,1-5. Customer "2" has equipment items 1,2,3,4,5 that will be identified as 2-1,2-2,2-3,2-…
-
- 2 replies
- 719 views
-
-
I am new to the forums, but not to FMPro, though It's been some time since I last touched it. I edit weekly newsletter featuring articles written by others. I compile them and email the doc to a subscription list. For years, I've been running the articles through a text editor to clean them up then C&Ping the into a Word document where I use paragraph styles to format the headlines, bylines, endnotes, etc and to construct a table of contents. The newsletter is in a three-column layout and each page includes a header and a footer (which are different on the first page). The styles I use are: - Section Heading - Title - Byline info - Lead-in tex…
-
- 6 replies
- 1.1k views
-
-
Please excuse if this is too simplistic of a question... I've been building a project/task tracking db and I've just now tried to create some reports. Ulitmately, I want to see all my projects and their associated tasks in a printable report. I've followed the instructions in the FM help and in the "Sams Teach Yourself FM 7" book, but I'm having a heck of a time getting subsummaries to do what I think they should do. Even using the sample files from the "Teach Yourself..." book -- I keep having the same problem. Take Parties and Guest for example. One party can have multiple guests. There's a parties table with a field called "Event" and a Guests table w…
-
- 2 replies
- 903 views
-
-
Dear All, I have attached 2 fp5 database examples. Here's what I want to do but don't know how: (Relationship defined by field base ID) If I select "Option 1" from the value list of FIELD A I want field XY to show the value list of FIELD B, if I select "Option 2" from the value list of FIELD A I want FIELD XY to show the value list of FIELD C. How can this be done? FIELD XY must contain some kind of calculation or script. Thanks in advance, A. db1-2.zip
-
- 2 replies
- 750 views
-
-
I have a database that prints out a two page invoice. There is a portal on the layout that spans two pages because the orders have so many items. It works fine for the most part, but if you change the printer then the printable range changes and I have to go in an modiy the layout. Is there a way to link to portals? Can I put on on the first page and then have he second one pick up with the remaining records? Or can you think of another way to get a portal to span two pages?
-
- 2 replies
- 787 views
-
-
I run a Sick Children's Fund where I have a parent table listing the clients (children) and their details including location. In a related table (related by Serial Number)I record disbursements to each client. Each client usually has many individual disbursements over a several month period. I am using a portal to record each line of disbursement which creates several records (called Amount) for each client. I use a summary field for the total amount given each client. I need to create a report grouped by location and sub summarized by the amount spend in each location. I can group the location but the best I can get the report to do is list each record of e…
-
- 2 replies
- 700 views
-
-
We need a FileMaker 7 plugin or another way of displaying the current window without scrollbars, and without FileMaker 7 zoom/mode/status area controls in the lower left corner.
-
- 7 replies
- 1.7k views
-
-
I have a script which copies text from a portal row and pastes it for viewing into a different layout. I have a button that then navigates back to the original layout. There may be 20 different rows in the portal. How do I write the script to navigate back to the same portal row I just pasted the text from?
-
- 2 replies
- 766 views
-
-
I've just started trying out filemaker 7, (I'm converting from Access). I've managed to use the Product Catalog Template and modify it to my needs so it looks and acts like my access database except for one thing. I'm tring to implicated a fairly difficult sorting solution. Heres what it is: Each Record has one assigned keyword and a price value. I want each record which has the same keyword to find the total average of price. This average is then sorted accending with the other keyword price averages. This is probably have to be done in script, if anyone could help, it would be great! I'll give a gmail account too if you want. Database: http://…
-
- 6 replies
- 1.1k views
-
-
I need to set my numbered purchase orders back to zero. Each time I create a new one I get the next higher number. I assume this has something to do with Value lists. Thanks for any help.
-
- 2 replies
- 736 views
-
-
I am working on a layout that has a text box (edit box) that starts at the bottom of the first page and continues to the second page because it holds a large amount of text. Whenever I print from this layout, the first page prints fine, but at the top of the second page, the first 10 or so lines are the last lines on the first page. Some of the text is being printed out on the first and second pages. I have "Allow part to break across page boundaries" enabled. Does anyone know a solution to prevent the duplication of text on the two printed pages? I have thought of just using a merge field since this is a print-only layout, but I need a border around it and…
-
- 5 replies
- 934 views
-
-
I'm having a problem with spell checking. In a new duplicated layout when I say check record, it only checks one field, but if I go back to other layouts built on the same file and table the check record works on the whole record. I'm on 7v03. Any suggestions? Thanks.
-
- 5 replies
- 1.1k views
-
-
Hello, I want to change the initial row # in a portal from a script. I looked around for this and couldn't see that anyone ever came up with an answer? Thanks!
-
- 1 reply
- 750 views
-
-
Hi, I've been building a Marketing DB and I need some help on "How To" create SubSummary Report using Data from a Portal. I've included a copy of the DB that I'm working on for review. I understand relationships, but I'm having an awful time understanding how to get that information to work for me. I have four table: Tastemakaers, Clients, Tracking, Products; and I'm trying to creat a report system that displays the following information per Tastemaker: Company Name First/Last Name Address 1 Address 2 City/State/Zip ----------------- ( I'm assuming Portal Data of: ) Client 1 Date Album Sent (If Sent At All) Date EP Date Single Date Reco…
-
- 10 replies
- 1.4k views
-
-
There are certain fields where it would be useful for Filemaker to offer already entered completions to a field, depending on what you have already entered. This would operate like the address field in OSX Mail or the URL address in IE, in which drop downs appear with URLs already in the cache to click on, depending on what you have typed. Can anyone outline how I would set this up in FMP 6 (Mac OSX)?
-
- 1 reply
- 808 views
-
-
Hi, In order to stop bad user entry into my database, I need to stop more than 40 orders in total being placed. A customer can have 5 orders, 5 "active" orders that are not set to cancel. But basically the user enters the orders via a portal relating to the orders table. I need a way that when they click the Weightneeded which is a popmenu of weights, a way to check that there haven't been 40 orders. So far i have tried adding a script to the field but i just get loads of problems like the dialog wouldn't show and it wouldn't count correctly, here is the script i was trying to use: If(OrderCounterSum >=40) beep show dialog("Error" etc) ElseIf goto…
-
- 9 replies
- 1k views
-
-
I have a layout of patients with 2 portals. The first displays all of a patients medication allergies. The second portal displays a patients medications. The second portal has an active field and sorts so that all the active medications are on top. It does display nonactive medications below that to see what may have changed recently. I know it is difficult to print from portals, therefore I would like to make a layout that for a given patient prints there name as the header, followed by their medication allergies and then their active medications.( I would need to limit the medications to where the active box is checked). So far I can only get it to print all of t…
-
- 3 replies
- 837 views
-
-
Ok guys and gals, this should be fun. I have File A which contains job records, one job per record. File B has late letters that I have sent for jobs that haven't been paid. I need a portal in File A that reminds me to send a second follow-up letter, after 30 days have elapsed and the silly people still haven't paid. I delete the letter from file B when they have paid so there aren't any letters there that don't need to be. I'll create a third file "C" for the second letter sent, but that's another story. Right now I just need a portal that shows me all the job letters that are 30 days old so I know to send a follow-up letter. I have a Menu layout in the job file "…
-
- 13 replies
- 1.3k views
-
-
I am still working in version 6 of Filemaker. I have a layout where I am working with a limited amount of space so I need to display the same portal in 2 columns, 5 rows displayed in each. I need the second column to start displaying data at row 6 thru row 10 . I know that in version 7 this is an option but I am not ready to upgrade this application yet. Dose anyone have any ideas how to do this?
-
- 1 reply
- 632 views
-
-
Hi, I'm using a value list of elements with checkboxes. For each record, an element is checked if it is used. A record can have more than one element checked. Records are into groups (sub-summaries). Each group needs a summary for how many of each element are checked. I found myself having to create a lot of fields to do this. 3 field for each element of the value list. - a field per element with a calculation with "PatternCount" - a summary field to get the "total" of the calculated field above: - a group summary field for this element Since i have 5 elements in the value list. I have to define 15 fields. Is there a better way? Maybe …
-
- 2 replies
- 680 views
-
-
Is there any way of keeping the portal row from being highlighted when clicking in a portal row. Other than changing the portal layout. thanks
-
- 3 replies
- 943 views
-
-
Hello, I'm new with FM. I must debug a web page. We had an application running on FM4 someone import pages in FM7. With FM7 we try the FM web server and I have a model (layout) who works correctly in FM7 but the problem is when I try this model in a web page, some icon not appear or not the good icon appear. I think it using 3 tables. The major table can have some "X" for some fields and when it have a "X" it must appear an icon from an other table. Example: When the field Glove have "X" the icon Glove must appear. Do you have an idea why some icon doesn't appear and sometimes it's not the good icon appear? Thanks for your help.
-
- 4 replies
- 869 views
-
-
On one of the FM forusms, I had seen references to a portals book. It may have been privately published. Does anyone know anything about it? Thanks.
-
- 0 replies
- 678 views
-
-
Table A contains investors names Table B contains various funds A unique identifier is a name, fund, and account number. This is a calculation field. I want to fill out a form and I have to choose the correct person and fund. I thought I could use the unique identifier in a value list, but FM won't let me. It won't store the calculation since it uses values from related fields. I can make my own unique identifier instead of calculating one, but this seems an unnecessary thing to do, as the computer can calculate the info. So I do I get this to work in a value list?
-
- 7 replies
- 1k views
-
-
Hi, Is it somehow possible to have a functional value list (global field; pop-up menu) in the header part, while the window is in list view? Jari V.
-
- 2 replies
- 789 views
-
-
I have a number of layouts with subsummary and trailing grand summary parts. Each layout has the sort field and a summary field in the subsummary part, then the summary field again in the trailing grand summary part. When the records are sorted by the sort field for the subsummary part, everything displays fine and correct. However when a reorder is added to the sort so that the records are reordered to be decreasing by the summary field, the summary field content goes blank in the subsummary part. It still displays correctly in the trailing grand summary part. It doesn't matter which summary field I put on the layout, the one that is included in the reorder goes bla…
-
- 10 replies
- 1.1k views
-
-
Help! ok, I'm a newbie to filemaker pro....here is my problem; everything looks fine when I am in browse mode, but when I go to preview mode some of my data files get cut off! I did notice that there is a diagonal dashed line that goes across the page where this cuts off?? but I don't know what that line is or how to get rid of it! (line looks like this: Can someone please tell me what this is and how to delete or fix it? thank you so much in advance. ebbhead2
-
- 1 reply
- 1.3k views
-
-
Merge fields inherit font formats. Can they inherit changes in the paragraph formats, specifically tab settings? Our intention is to print complex (and changing) text-intensive layouts by concatenating a record's text fields into a single merge field. But we can't do this if tab settings specific to that record won't transfer. Thanks for any help you can provide.
-
- 2 replies
- 753 views
-
-
I am using @@ to number rows in my portal. However, FM always puts in the next row number even if the row is blank. Is there any fix for this. I have tried using {If(isempty(SerialField); ""; Get(PortalRowNumber))} This wont work either. Ivan
-
- 2 replies
- 762 views
-
-
Is there a way to import the custom values from a value list from one version of a solution to a newer version of the same database? When I update a database that I have at a client's site, I typically bring a clone of the update, and run an import script to bring in all their data. The one thing that gets missed is if they edit the custom values of a value list. I know how to import the values from a value list from one database into a text field of the newer database using the Design function ValueListItems(), but how do I put those values into the appropriate value list? The only work around I can think of is to create a table of value list text fields and re…
-
- 2 replies
- 622 views
-
-
I am using FileMaker Dev 7.03 on Windows 2000 SP4 using a Matrox P650 graphics card. When in Layout mode every object I click on the doted outline line is offset by 6 x 3 pixells which makes it very difficult to possion objects. Is there a bug or am I doing some thing wrong?
-
- 5 replies
- 945 views
-
-
Filemaker 5.0 I designed a program at 800x600 resolution and when I installed it the user screen is 1024x768 so it only displays on 1/2 of the screen How do you ensure a window is open to its largest capable size? This meaning the window must fill the user's screen, therefore a 800X600 user will have his window sized to 800x600 and a 1024x768 user will have his window sized to 1024x768. I guess the real question is that this window needs to be maximized as if the user clicked on the maximize button on the title bar and the proportions are right.
-
- 3 replies
- 2.1k views
-
-
Hi, I try to copy Icon from Applications, files or folder (using apple-info) and then paste thoses icon in my layout to use it as a Button-icon. But, every time the graphic look crapy, especially when the icon have a bit of a soft edge or shadow. You can try what i mean with the Quicktime icon from OS X . . . Is there a special way to import graphic so you can use it in FMP thx guy
-
- 2 replies
- 889 views
-
-
I have a portal of 11 lines on my sales form tied to my invoice line item table. Great. I've set up a subtotal of all line items on the portal. The calculation for this subtotal field on my Sales form is: Sum(OrderLI::LineTotal). Great. Works fine for the first five line items then it craps out giving me a ? in the subtotal field. What's up??
-
- 2 replies
- 608 views
-
-
I have a value list based on a relationship between two tables accounts and school districts. The field the list is based off of is a calculation. It combines the districts name and id. I need the list to be sorted alphabetically but I can't make it happen. How do I do this? Thanks
-
- 1 reply
- 639 views
-
-
I have a layout in list veiw. There is a footer with all the buttons to set up the printer and print. The print script brings the layout into preview mode and prints. The problem I'm running into is the computer continues to print the footer as well. I know how to tell fields not to print, but how do you tell the footer and everything in it not to print. Thanks for your time
-
- 1 reply
- 990 views
-
-
I have 3 tables: ProductSales;ProductLineItems;ProductInventory. ProductSales is related to ProductLineItems via Invoice#. ProductLineItems is related to ProductInventory via ProductID. I have an order entry layout based on the Product Sales table. It has a portal based on the productLIneItems table which allows users to enter in purchased product. I have another portal on the layout that is based on the ProductInventory table. In this portal I wanted to show OnHandQuantity for the product that a user is entering. It works for the first product entered into the LineItems portal but it doesn't change when you go to a different product on another line. What am …
-
- 4 replies
- 668 views
-
-
Hi, I have a members database with a picture field in it. I want to be able to take the members photo with a web cam or digital photo but i've been told i can't do that with filemaker. Does anyone know how i can do this? Is there a new feature in 7, a work-around or a plug-in somewhere? By the way i've never used a plug-in before so if that's the way to go i'd also appreciate some basic pointers on how it works. Any help would be appreciated.
-
- 3 replies
- 1.9k views
-
-
I have defined a global field that is set up for 10 repetitions. On my layout I have 10 fields which each respectively refer to this global field. The entry into these fields is done via a common value list. I basically use this to keep track of different versions. ie/ field 1 = version a14, field 2 = version a15, field 3 = version a14. This setup has been working fine so far until the other day when I put it online to share with other users. What happens is that I set my versions for each of the respective fields based on my defined value list and all looks good. However when I close the database and relogin to it all the fields that I have set versions for …
-
- 14 replies
- 1.2k views
-
-
hi, I have a problem with a portal showing unwanted records, basically a user can cancel an order, but when cancelled the portal row needs to omited somehow from the portal, basica structure of db, tbl_customers, tbl_orders and tbl_turkeys. the reason that i don't want them deleted is due to the business wanting to keep a record of all orders placed. Maybe an export to a file would work? dunno played around with it for ages and still no success. The user cancels the order by pressing a button, this is to stop uncancelling orders and for validation. any help would be great! MnR
-
- 3 replies
- 833 views
-
-
I have this value list that is populated from the USE CUSTOM VALUES option. I use it, for example, to select BillyBob, Skippy or Rex as a good candidate to assign a task. Every now and then I would like the option to de-select these candidates. IE, I would like to be able to click into a field and select (NOTHING), thereby setting the field to empty. Can anybody tell me how to make this happen? THanks, Jarvis
-
- 3 replies
- 785 views
-
-
So I'm designing my first commercial database and would like to see what the general consensus is regarding the size of text displayed in a browse layout - excluding labels and headers. I've been using 10pt. Thanks. -Kevin
-
- 2 replies
- 971 views
-
-
Hi i am very new to FM and Database, and have the following Problem: I have two tables, Customers and Persons. One Customer can have more related Persons (Single Relationship). I have a Street and Town field in each table. i want to type in Streets and Towns, but to be remembered. So when i make a new Customer or a new Person, and go to Street or Town, there should be a Popup List, with the Streets and Towns, already entered in the data before. I tried to make a Table Towns and made a Relationship to Customers, and this works, but when i want to make a relationship to persons, Filemaker always tell me to make a new occurence, i think this is a second table. But i j…
-
- 1 reply
- 661 views
-
-
Does anyone know how to lighten up the highlight color so that I can still see my text when it is highlighted? I've looked all over here and also on usenet in some of the Windows groups. In Word and Outlook, etc. when the text is highlighted it changes color to a contrast so you can still see it. Not so with FileMaker. On my Mac at home I can have the highlight color be anything I choose.....I can't find anything like that on the Windows machine here at work....What to do? Thanks. Deborah
-
- 1 reply
- 755 views
-
-
Fellow developers, occasionally I stumble across layout limitations, for example things that work in one layout part but not in others. Example: up to FP6, global fields placed in the header part could only be edited in Form view (since FP7 it also works in List and Table views). Other Example: In FP7 IWP I was not at all able to edit fields placed in the header part. I do not look for a solution to the latter problem, but I'm looking for a comprehensive list of "Dos" and Donts" for layouts. The FM docs I know about don't say a thing about this. I am sure the knowledge is hidden in all the posts here, but it is very hard to find via a search (I tried). Can any…
-
- 1 reply
- 863 views
-
-
I have a simple letter layout with a text box arranged with: <<current date>> . However, today, the date displayed is "January 22, 2005" -- my Mac is setup to a server so the date and time are correct. Its probably simple but need to know how to make it read "today's date" -- which in this case, today, is February 11, 2005.
-
- 8 replies
- 995 views
-
-
I have a portal which contains multiple related records that I want to merge to a letter. Example: Record 1 has three associated portal reocrds. The fields are MealType, Date, and Cost Estimate (i.e., lunch, 2/21/05, $8.75). I want to insert/merge all three related records into part of a letter. I am able to merge the first related record into the letter but I'm unsure how to merge the rest. Any advice?
-
- 3 replies
- 785 views
-
-
I have several portals on a layout and I am trying to go to a specific portal based on certain criteria. If i just use Go To Portal Row, I will get the first portal on the layout. What do I do if i want the second portal, etc. ? Thanks for your help.
-
- 7 replies
- 901 views
-
-
Ok, I have looked at some of the questions / answers relating to this and they helped me but not all the way... So This is what I need to do: I have already Setup -- a table "Broker" that is linked to a main page [relationship] Mainid --> RelMainid. On this broker page I can enter all of his information [address phone etc...] There is a pull down list on the main page -- the list gets indexed from the "broker" page. What I would like to do next is make a submenu pull down that will have only contact name that relate to the broker listed in the first pull down. This contract should have all of there own information like notes and email addres…
-
- 5 replies
- 795 views
-
-
-
I currently have a 5.5 file that tracks customers and what they bought. It has worked for a while but my business has outgrown the functionality I built into it. I recently picked up a copy of version 7 and would like to build it the right way this time. Here's what I have currently. In the file I have 3 Tables. One for the customers, One for the orders, and one for the detail of each order. My reasoning for doing this is because of repeat business. I'd like to be able to easily see all of that persons orders. Ultimately, I'd like to display all of this information on one layout. I set it up to display 2 different portals. The main layout is the customer in…
-
- 3 replies
- 748 views
-
-
Hi, I have a portal in my solution with a number of calculation fields. 2 of these calc fields show $0.00 on the last row which is not a record. The fields: Desc Bid Price= "Desc Cost + Desc MU Amt" & Total Desc Bid Pre= "Desc Bid Price * Quantity" show $0.00 on the last row. The fields: Total Desc Cost = "Desc Cost * Quantity" & Total MU = "(Desc M U Entry / 100) * Total Desc Cost" show nothing. All fields have same number format: format as decimal, fixed number of 2, $ notation, use thousands separator. How can I get rid of the ghost $0.00 and what makes them appear on some calcs and not on …
-
- 9 replies
- 1.9k views
-
-
Hi, I've been reading several of your posts (for the last few days), and I'm not sure if I'm on the right track or not? I have 2 databases. One for storing all the data for products, and a second which will deal with enquiries, quotations etc. All of the products have a unique part no (ID), but these are assemblied into a finished product. What I trying to do is to in the equiry form, I want to select a size from a pop-up menu (easy straight forward value list), the next field will be another pop-up list only showing the main component of the selected size (relationship between enquiry and products thru size, value list based on product table related thru e…
-
- 1 reply
- 790 views
-
-
When viewing the records in list view, a 'current record bar' appears at the side of the record that is current. This moves along side each record as you move up and down. Is there a way to enhance this record bar, so that it acts like a highlighter across the page, from left to right. So as you move from record to record, it is (more) obvious to the user what record is current. Cheers
-
- 1 reply
- 852 views
-
-
I have so far been able to relate tables and have them work normally. I related a new table for medication lists by patient id and name. I can not get the patient id and last name to show up from related records. It just says 0 records. I have posted my database files. The main problem is on layout patients. Any help appreciated. The account is admin with no password and it is only test data. patients.fp7.zip
-
- 1 reply
- 808 views
-
-
Hello, all. My boss wants to be able to enter "canned" text into a text field to save folks from having to type the same phrases over and over. My idea was to have a value list field containing all the canned phrases people typically enter next to a button. The user selects the canned phrase from the value list, clicks the button and the selected phrase is placed into the text field above right where the cursor is. I know the 'insert text' script step, but I can't figure out how to get it to insert text at the cursor. Ideas? Thanks.
-
- 1 reply
- 2k views
-
-
When I switch to a table view the Field Names all show up as a row across the top of the page. Is there a way to make them display vertically in column on the left instead? Microsoft Excel has a feature called TRANSPOSE where you can take a row of field values (A1-A2-A3) and convert them to a column (A1-B1-C1). I'm trying to generate a report that has a list of tasks in a column on the left and a spreadsheet like matrix that contains values on the right. Is this feasible in filemaker? Thanks, Jarvis
-
- 3 replies
- 962 views
-
-
Well, I have a layout that displays something, when I change to preview mode, or when I print the layout, it displays a totally different layout... I can't find the field that are printed on the layout mode of that layout?? I hope you understand what I mean, thank you in advance.
-
- 2 replies
- 772 views
-
-
is there a way to make a font blink in filemaker? or a trick to make it seem to? I have a check. If field A is empty then field B says "Open". I also have a check that if the record is over a week old and field A is empty, field B says "Open" in red. I'd rather something far more annoying. like blinking. Is this possible? Thanks
-
- 10 replies
- 2.7k views
-
-
I am having a strange problem with a conditional VL. I have three tables: Events, Exhibitions, Bookings. I create an event for an exhibition.. Each Event record has: (unique) EventID.txt, EventName.txt and ExhibitionID.txt (to relate it to the Exhibition) fields. Exhibition1 has, say, 2 events.. Event1 and Event2 Exhibition2 has, say, 3 events.. Event3, Event4 and Event5 Events is related to Exhibitions via ExhibitionID field (Relationship is called "Events{fromExhibitions}) I need a conditional VL so that when in a Booking record I key in the ExhibitionID and the value list only will show Exhibition - RELATED EventIDs and EventNames in the pop-up. I…
-
- 1 reply
- 699 views
-
-
I need to create about 35-40 individual Layout pages from one Main Layout page, but is there a way to update all sub pages if I edit the original Main Layout page? (basically, like having a
-
- 3 replies
- 957 views
-
-
Whenever I get emails from my mac in Entourage, I copy some of that info and paste into Filemaker. I have Filemaker set to be ay 9point Helvetica, but when you paste into any field, the formatting is lost and it stays at the formatting that it was from the email. Is there anyway to force the formatting in FM, so that it is always Helvetica 9 point? thanks.
-
- 2 replies
- 830 views
-
-
Guess I posted to the wrong area...so here goes again. I have placed a portal on my sales layout from my products list. I can get it to select a record from a pop-up menu to display a record from products...great, however, on the next line when I choose another record the first line is replaced to match the second line. Plus the third row will not show the menu to select another Product ID?? Any ideas? Thanks.
-
- 2 replies
- 740 views
-
-
Hey, I have a database on people that are a member of our club. When people leave the club they get a mark 'inactive'. I don't want to delete those records from the database, but just never see them on any lay-out. How do I do this? I know I can search and leave away those records, but this is a bit frustrating for all people looking in the database and doing their searches and having the 'inactives' come up in their searches as they are included in their home made searches. tia, Michel
-
- 1 reply
- 717 views
-
-
can someone please help me? i'm tied up... i have 2 databases (dbA and dbB). dbA contains a unique field number for every record. dbB has several records related with one unique record in dbA. question: how can i define a field in dbA to view a summary of all the checkboxed values from a value list for every related record in dbB? i hope my question isn't as lousy as my filemaker knowledge... thank you! Maureen
-
- 2 replies
- 647 views
-
-
I find that in FM7 a value list in a field formatted as Pop-up List is very, very slower than when the same field is formatted as Pop-up Menu. Does anyone agree with me? Thanks for any help.
-
- 1 reply
- 802 views
-
-
I am a bit in trouble in solving this. I have three type of invoice layouts- one for international ,one for US Customers, onve for multiple stores (multiple packing slips and single invoice); and one for international customer I currently have all layouts in Exel. Invoice 1: (US Customer)-just a regular commrecial invoice Invoice 2: (Multiple stores)- 1 single invoice with multiple stores/ and different quantities of product for each of them Invoice 3: (Overseas)- Almost same info like "Invoice 1" but has additional fields. THanks in advancee
-
- 3 replies
- 866 views
-
-
Hi all, I'm new to Filemaker. I've always worked with access and now switching to Filemaker. But I'm lost. I have a lot of exams records in two tables. Each table from a different school. I have, among others, two fields: subject and qualification (and only two items in it: passed and failed). I have thousands of student records. I would like to count fail and pass exams for each subject and build a layout. More or less like this: Subject Passed Failed Chemistry 80 91 Maths 100 80 Biology 230 25 Please, could anyone help me? I know it may be an easy problem but I do nead help. T…
-
- 4 replies
- 896 views
-
-
Is there anyway to make a field act as a button in table view? Thanks, Anthony
-
- 2 replies
- 835 views
-
-
I have noticed that users are able to change fonts when they enter text into a text field in FileMaker. In layout, I specify a specific font and font size. But users can go into browse mode, go to Format-Font and Format-Size and they can change the font and size for each text field. I have several users doing this, which results in each record's text fields being of different fonts and sizes. Is there any way to prohibit users from setting a different font and size while they are in browse mode?
-
- 2 replies
- 823 views
-
-
Hi Guys, thanks for all the help so far, am getting along in leaps and bounds ! I would like to use a portal to display a conditinal value list, is the possible? I have a table which contains names and type of person, eg artist, producer etc, and from this through a third table have created a conditional value list which shows a list of only artists. For reasons of IWP I wish to have this list displayed in a portal for people to select and enter data from, is this possible? Thanks in advance Steve
-
- 1 reply
- 697 views
-
-
Does any-one know if it possible to dynamicly name a layout based on a global field and if sdo how do you acheive this. thank you in advance
-
- 1 reply
- 757 views
-
-
In FM6, I used to use the disappearing portal trick described on page 414 of "Special Edition: Using Filemaker Pro 5". Basically you use a portal to make buttons and fields diappear or reappear based on a relationship. I can't seem to make this same bahvior work on FM7. I'm trying to make a "show all contacts" button disappear when the user is viewing the complete set of records, but when the user is viewing a smaller found set, the "show all contacts" button would reappear. Any idea what I may be doing wrong? Or is there a change in behavior in FM7?
-
- 3 replies
- 2k views
-
-
Newbie here trying to set-up what I think should be a simple portal. I want a button that will allow me to add the current date in one field and then on the adjacent line it will allow me to enter as many lines of free text as I want. Each time I press the button the most recent date and note will be added to the top of the list. I can draw this out (see illustration below) but can't seem to define the fields, relationships and write the scripts to get it all to work. It seems to me I'm making it harder than it actually is. Any help is greatly appreciated.
-
- 1 reply
- 849 views
-
-
Hi, As you may guess, I'm fairly new to Filemaker but I love it! Anyhow, I have a small company which currently uses 5.5 - I am (with a little help) rewriting our workflow system. I have some nice layouts but we have some PC's running different screen resolutions to others. Most run 1024 x 768 and the layouts have been designed to fit nicely. My laptop however runs 1400 x 1050 and the layout is too small. If I zoom to 150%, it's just a tad too big but acceptable. What I would like to do is perform a 'calculated zoom' if at all possible, where the layout will zoom dependant on screen resolution. That way, the layout will appear the same on all PC's regardless of resolut…
-
- 4 replies
- 1.1k views
-
-
Hi, is it possible to export a layout from "file1" and import it in "file2". Both are Filemaker6 and have the same structure - the same number of the fields and the same field names. Actualy "file2" is a copy of "file1". Thank you for your help!
-
- 4 replies
- 926 views
-
-
I have database where each record is a client. I want to display all the clients in a list within a portal on a browse layout. Is this possible, and how would i set up the relation to work?
-
- 2 replies
- 623 views
-
-
Gang- I'm creating a telephone directory and I need to duplicate the behavior found in many dictionaries or encyclopedias: I need to show in the header the first surname on the page and the last surname on the page. They must both be in the header and appear in the format "surnamefirst - surnamelast" where surnamefirst is the last name of the FIRST record on that page and surnamelast is the last name of the LAST record on that page. I'm at a loss as to how to do this. If I just put the surname field in the header, it correctly displays the first surname from that page, but what must I do to somehow grab the last surname from a given page?
-
- 6 replies
- 1.2k views
-
-
Hello, I am hoping this is simple but I have not been able to find it. I I want to format my field so that when the user pastes text in to the field the field formatting overrides the text formatting. Right now, if I paste text in to a text field, the text retains the color and formatting from the original document. Thank you for you help, again... John
-
- 2 replies
- 1.2k views
-
-
It is certainly a beginner problem (that's what I am): I need to extract the amount of different records(textpatterns) from a field and publish it as a chart (i bought a small programme therefore from http://www.briandunning.com/store/invoice.php) I tried several solutions from this site but so far successless; My own approach: case.... and thereafter sum(field) failed because of circular problems. What would be the fastest result on a fair amount of different text strings within a field???
-
- 1 reply
- 588 views
-
-
What fonts should(/shouldn't) I use in a WIN-MAC FM7 solution? Thanks, Paolo
-
- 4 replies
- 4.6k views
-
-
This seems a simple idea, but I can't figure it. I want to create two fields called 'Month' and 'Year' for data entry via Value Lists (the first listing Jan thro' Dec, the second listing 2005, 2006 and 2007). This is how it is done on those holiday booking web sites. How do I configure the fields and how do I extract the information from them to form a valid date (assuming the first of each month)?
-
- 11 replies
- 1k views
-
-
I have some buttons that I want to change text in, but I can't figure out how to do it. I right-click and get no options, I double-click on it and I get the Specify Button window.
-
- 1 reply
- 972 views
-
-
I want to make the value list used in one field to be dependent on the value of another field in the record. For example, Country = "United States" State/Province value list = "Alabama, Arkansas, etc" or Country = "Canada" State/Province value list = "Alberta, British Columbia, etc" How do I set this up?
-
- 2 replies
- 767 views
-
-
Are there any cautions or common mistakes in creating summary reports with data drawn from more than one table? I'm trying to pull data from two related tables, but am getting invalid totals as well as display oddities (blank lines and multiple total lines in GrandSmry part where there shoud only be one). I started with a manually-constructed report and also tried the report wizard. Neither work right. I'm doing something wrong, but I don't know what. To be more specific, I have one table which records data from a checkbook, with a related table that contains data for those checks which are payroll checks and have withholding amounts. (Most checks don't have th…
-
- 2 replies
- 813 views
-
-
I have 4 tables in my database. Of those, several are used in a relationship in each table for multiple lookups. (For example: Client_Code, Client_Name, Client_Type, Client_Cost are in two or more tables with different types of data). Rather than having to go into each screen and enter the same data, is there an easy way to make a single screen that will put the data into each table?
-
- 1 reply
- 1k views
-
-
File one: Record number field Process field Category field File two: Record number field Category field Portal containing Process field. If File one, Record number=::File two, record number for the portal and the Process field within the portal then this Process field returns all Process entries of File one for a particular Record number, regardless of category. What relationship(s) are needed to get the portal to only return only the Process entries of File one by only one particular category for a particular Record number without the category field being present on either the general layout or the portal of File two?
-
- 7 replies
- 835 views
-
-
HI, I am using filemaker pro 6 and what i am working with is a database of ppl who i want to mail letters to, everyone has different sorts of addresses some are long or short. Some ppl have one line in there address & others require more space, what i want is to get rid of all the blank spaces so when i print out the letters there arent all these huge gaps, i really need a step by step here, because i tried the sliding objects and i cant seem to get it to reduce the blank spaces so its more compact, can anyone help me? i would be so greatful....Thanks!!!!
-
- 2 replies
- 965 views
-
-
Is there any way to turn off portal highlighting for specific portals? I have a few one to one relationships that use large sized (as in a 400x400 pixel rectangle containing 10 fields) portals to display information, if the user misses the intended field with a mouse click they are greeted with a large black rectangle. Not the end of the world, but it is ugly and I know it will cause confudion for some of my users.
-
- 2 replies
- 753 views
-
-
I can't seem to get buttons to work in Preview Layout. If I am in Preview layout how does the user get back to the original layout without using the Status Area? I want to hide the Status Area from the user. Thanks for any input. Bob...
-
- 9 replies
- 1.4k views
-
-
I used to use Filemaker Pro at a previous workplace on OS X and now I have moved to another location which is Windows based but would like to use all of my old templates. Would I be able to load them onto a Windows system with Filemaker Pro for Windows installed, I am not that skilled at re-creating them from scratch. Your response would be greatly appreciated. Thank you, Jason.
-
- 5 replies
- 857 views
-
-
Hi guys hope you are all keeping well - in fm7 mac only enviorment. I have a really silly question _ what are the step to go about getting a value list that will add the users other to the list? So my field Photographer list contains Roy D Merser Billy Bob kelly Other... so if the user inputs david goodspeed in the other box the list from then on will be Roy D Merser Billy Bob kelly david goodspeed Other... I know its not a good idea to have users to do this but this is the only one and its static information anyways thanks for you time any comments suggestion more than welcome.. D
-
- 0 replies
- 663 views
-
-
I'd like to create a splash screen to open my database. It would have two buttons to navigate to other files -- that's easy. I'd also like to have a portal displaying all records from one of those files. I seemingly need a relationship between the spash screen file and the target file but am not sure how to create one that will let me view all the records by a particular field since there is no inherent relationship and the spash screen will always be just one record. It must be easy but I am missing it in the moment.
-
- 5 replies
- 748 views
-
-
In web view, is there any way to hide the View As drop down box from users? All it does is add confusion and I can't find it anywhere in the help. Thanks!
-
- 0 replies
- 624 views
-
-
I made a picture to better describe what I'm trying to accomplish. Basically I work for an industrial shop that has about 30 machines that jobs are running or reserved on. I'm trying to make a scheduling program where someone can insert, delete, and move around jobs on a whiteboard. Since the people who'll be using the program are not usually around computers I'm trying to make it as simple as possible. I thought about having drag and drop blocks (sometimes a group of blocks if a job is spanned across several machines at different times) but to be honest I'm not sure if it's even possible (although I think almost everything is possible in FM7 if you're creative enough…
-
- 3 replies
- 1.1k views
-
-
I have 3 text fields in a FM database... one is the users name, the other is their function (eg painter or plumber) and the other is the group (a letter reference eg A,B,C or D) that he/she belongs to. Now what I want the main database to do is populate a drop down box based on a matching group reference - for example the main database records says this job belongs to "group a" and we are looking for "plumbers" only)... so I want a pull down list to only have group "a" members who have a function of "plumber" generated from the other database. Is this possible?
-
- 5 replies
- 959 views
-
-
I use a value list taken from a table called "Job numbers" but it is getting extremely long. I would like the value list to include only "Active jobs" so I have created a field to label the job as "active" or "inactive" but how do I make the value list only display the active job numbers?
-
- 6 replies
- 944 views
-
-
I have a little newsletter and sell advertising to supplement the cost. The cost buy an ad depends on the size of the ad and the amount of subscribers. For instance RateCard A is for 1000 subscribers. A 2/3 ad would cost you 50.00. Now if subscription rises, I would create a new rate card called RateCard B. What I would like to do, if possible, is create a DB that contains two value lists and returns the current rate for the publication. The two value lists would be AdSize and RateCard. Right now in the AdClientOrder, I can choose 2/3 and it will show the current price. How do I also ad a value list that if RateCard B is chosen, the price will increase? I …
-
- 4 replies
- 837 views
-
Recently Browsing 0
- No registered users viewing this page.
Who's Online (See full list)
- There are no registered users currently online