| Subject | Date Asked | Expert |
|
| Conditional formatting | 7/16/2008 | Jamey Key |
Q: I am relatively new to Filemaker (and self-teaching). I'm trying to set up a field that will ...
A: Anna; All you should have to do is make the field a number field with an auto enter calculation ...
|
| Is it possible? | 7/15/2008 | Jamey Key |
Q: I've created 3 file, Quotation, PO and Invoice. In Quotation file I've created field name PO No. and ...
A: Yes, it is possible to do that. I would recommend you have a field in Quotation called ...
|
| When should you use a portal? | 7/10/2008 | Jamey Key |
Q: I'm having some difficulty determining when to use a portal vs. just placing the related field ...
A: Fred; Generally portals are to be used when there are several related records to be viewed as ...
|
| Emailing container field contents | 7/10/2008 | Jamey Key |
Q: I have a project table with a portal containing a related record with a container field (holds ...
A: Susanne; You can email the contents of the text fields, but you will have to drag the actual image ...
|
| Whens hould you use a portal? | 7/9/2008 | Jamey Key |
Q: I'm having some difficulty determining when to use a portal vs. just placing the related field ...
A: A portal will allow you to see many related records at once. For example if you are looking at a ...
|
| XP Service Pack 3 upgrade | 7/8/2008 | Jamey Key |
Q: Our upgrade to XP's Service Pack 3 caused problems with single-sign-on (a/k/a external ...
A: Pam, I am not the best at answering this exact question but I do think that when you have the server ...
|
| Filemaker-multiple labels from one record | 7/3/2008 | Jamey Key |
Q: I need to print multiple labels from each record in my database for tagging inventory and related ...
A: First, I apologize for taking so long to get back to you. I think the best solution, if you can do ...
|
| is it possible? | 7/1/2008 | Jamey Key |
Q: I've started doing my work experience in a company which uses Filemaker pro7. This is the first time ...
A: Filemaker does allow many to many relationships. Sometimes a join table is used as an in between to ...
|
| Resource Catalog | 6/18/2008 | Jamey Key |
Q: I have just recently started using Filemaker, but I've got the basics. I am trying to make a ...
A: Avery; I feel your pain, I really do. I dont think the three table method is the way to go. In ...
|
| Pdf files from FIlemaker Pro Advanced 8.5 | 6/14/2008 | Jamey Key |
Q: I cannot print or email pdf files from FIlemaker on my Intel iMac but it works fine on my older ...
A: Most likely there is something wrong with your email application. FileMaker doesnt actually send an ...
|
| filemaker barcoding | 6/11/2008 | Jamey Key |
Q: We would love to be able to inventory our products and scan them in and out of inventory with ...
A: Chris; Im sorry it took so long to get back to you. I have never worked with a barcode package, so ...
|
| complex family relationships | 6/10/2008 | Jamey Key |
Q: I do volunteer work for various non-profits including a 110 year old school and a much older ...
A: This is a bit complicated (at least for me). What I would suggest is that you need an ID field for ...
|
| page numbering in Filemaker | 6/2/2008 | Jamey Key |
Q: How can I set an initial page number? Let's say I have a layout, and I want to set the initial page ...
A: I'm sorry it took so long to get back to you. I don't think that FileMaker has a built in option to ...
|
| Table relations: ordering system updating stocks depending on date of order | 5/26/2008 | Jamey Key |
Q: First a description of the database, then my question. I have an ordering system for fruit trees - ...
A: Nik; Yes this is too complex for my brain too. I want you to email me directly and if possible ...
|
| restart page number after subsummary | 5/21/2008 | Jamey Key |
Q: I have a report layout with a subsummary by artist. Each artist has many records, how do I have the ...
A: Page numbering and subsummaries do get confusing. Have you looked at the area where you define the ...
|
| unable to tab into field | 5/15/2008 | Jamey Key |
Q: Using FMP 9 Advanced on a PC In layout, I have set a tab order, however, when I go to browse and ...
A: Ask yourself these questions: Do you have access privileges to edit that field? Is the behavior of ...
|
| FMP 3.3 | 5/12/2008 | Jamey Key |
Q: Sup, 1) In a data enrty form how do I switch the tab order around and also os there away to make my ...
A: If you are using version 3, there are no easy ways to do what you want to do. If you can upgrade to ...
|
| Searchable Calculation fields | 5/7/2008 | Jamey Key |
Q: I have a FileMaker Pro data base that holds a collection of images from different photographers. ...
A: Do you mean that you cannot tab into the field when doing a find because it is a drop down menu? If ...
|
| filemaker not allowing a certain search field | 5/6/2008 | Jamey Key |
Q: We use this program at work to keep track of individuals who participate in our events. Up until ...
A: Is the database on a server or kept open 24 hours a day? I recommend that you shut down the ...
|
| Counts from fields | 4/21/2008 | Jamey Key |
Q: I have a world coin database and one of the fields is "Country". I want to show a total of ...
A: I understand your question. If you have Canada, Brazil, U.S. and Japan, you want to show "4" and ...
|
| Filemaker and Excel Interchange | 4/18/2008 | Jamey Key |
Q: This problem has been a obstacle for me for 3 years.How to output a excel file with a predefined ...
A: I dont really have any idea what youre talking about. The only thing I can suggest is in filemaker ...
|
| stupid filemaker questions | 4/12/2008 | Jamey Key |
Q: We're getting ready to design and write a filemaker database for our small but growing company. I ...
A: This is not a stupid question and Im not surprised you cant find it on the FileMaker website. You ...
|
| many-to-many relationship - show all items in other table with rel. info | 4/8/2008 | Jamey Key |
Q: I found a question in mid 2007 "Subject: FileMaker Relationship Troubles" that seems similar. ...
A: So you want to display all possible activities next to a persons name? Will this list be the same ...
|
| Get Record Function | 4/2/2008 | Jamey Key |
Q: I've being try to use this function to calculate the next day on my database (the database ...
A: Let me make sure Im clear. You want to find the date on the next record? So if you are in record 1, ...
|
| Inventory | 3/30/2008 | Jamey Key |
Q: I am making an inventory in FM9. I don't want only a list of goods: I want to input an initial ...
A: So what you want is an actual inventory that will be adjusted when you have a sale and deduct items ...
|
| Deleting Record | 3/25/2008 | Jamey Key |
Q: I am using Filemaker Pro8. I don't know how but a record got added to the end of one of our files ...
A: Nancy; Im sorry it took so long to get back to you. You could have a corrupt file or a corrupt ...
|
| Mergin multiple records into layout report | 3/20/2008 | Jamey Key |
Q: I am importin data from an Excel file of customer invoices, that has multiple records for my field ...
A: Ralph; It might be easier to go ahead and import each record as a stand alone record (instead of ...
|
| Printing postcards thru Filemaker | 3/8/2008 | Jamey Key |
Q: I want to print bulk two sided postcards all in one shot with a filemaker database. Does any ...
A: Candice; I dont know of a way to do that. Unless you print on one side and fold it over, but I ...
|
| Filemaker - can't modify, permissions set | 3/5/2008 | Jamey Key |
Q: I have been trying to figure this out for many months, I need help! So here is the story. My job ...
A: Ok that is because you are not using the Server version. I didnt take that into account. You need ...
|
| Filemaker - can't modify, permissions set | 3/4/2008 | Jamey Key |
Q: I have been trying to figure this out for many months, I need help! So here is the story. My job ...
A: The first thing you need to do is find out exactly where the database resides. It is not on the ...
|
| Printing/Preview Problems | 3/4/2008 | Jamey Key |
Q: I'm working on a project agreement database. I'm new to FileMaker and only have 30 records in the ...
A: Phil; How are you previewing 1024 records if you only have 30 records? Preview generally looks at ...
|
| label making | 2/28/2008 | Jamey Key |
Q: Was wondering if you might be able to teach me how to add cutting lines somehow to uncut label paper ...
A: Those can certainly be made very easily. while in layout mode, just use the circle and line tools ...
|
| FileMaker Summary Question | 2/25/2008 | Jamey Key |
Q: I have a FileMaker database that is used by my organization to store revenue broken down by week. ...
A: Chris; Im not sure what you are wanting to do. Are you wanting Dec. 31 and Jan. 1 to be in ...
|
| Filemaker 9 Relationships for Church | 2/24/2008 | Jamey Key |
Q: I am in the process of setting up our Church's records to their first database --and I believe ...
A: Teresa; Im sorry for taking so long to get back to you. Heres what I did at my church. Every ...
|
| Conditional serial number | 2/20/2008 | Jamey Key |
Q: I've been trying without much success to build a DB for cataloguing photographs. I would like to ...
A: Gus; This is possible. The middle number is the one thats presenting a problem. Getting the first, ...
|
| joining two tables in FileMaker | 2/15/2008 | Jamey Key |
Q: I was going through the steps suggested by you to join two tables..but i could not be able to view ...
A: Gaurav; I am sorry it took so long for me to get back to you. If you will email me directly, I ...
|
| Filemaker 8.5 relationships (portals) | 2/9/2008 | Jamey Key |
Q: I've been using FileMaker 8.5 as a flat file and I can do that pretty well. But as soon as I get to ...
A: Steve; You have to have a common field on each of the Students and Courses. I would also recommend ...
|
| Export from Filemaker | 2/5/2008 | Jamey Key |
Q: How to export data from filemaker to SQLServer tables? Thanks in advance
A: Im sorry, but I cannot help with SQL questions. What i would recommend is that you go to ...
|
| many-to-many relationships | 1/31/2008 | Jamey Key |
Q: I have been working with filemaker for a couple of month now and am trying to set up quite a ...
A: Relationships can be a tricky concept to grasp. The easiest way for me to show you is if you could ...
|
| future dates | 1/17/2007 | Jamey Key |
Q: I am trying to calculate an "end date" based on a "start date" that is already recorded in a field ...
A: The easiest way is to try making the MIPEndDateOnly a calculation with the result of a date. The ...
|
