http://www.listsearch.com/FileMaker/index.lasso FileMaker Talk is an email discussion forum for discussion of the FileMaker Pro and FileMaker Server database products from FileMaker, Inc. en-us Fri, 16 May 2008 07:24:41 -0400 http://www.listsearch.com/FileMaker/Message/index.lasso?162578 Steve Stearns to FileMaker Talk on 2008-05-16 07:24:41 - I don't know if this has been covered or not. I did search the previous messages, but didn't see it, so I apologize in advance if this is something that has already been addressed. I am trying to export summary data (count of an item) to a differ... Fri, 16 May 2008 06:58:14 -0400 http://www.listsearch.com/FileMaker/Message/index.lasso?162577 Corn Walker to FileMaker Talk on 2008-05-16 06:58:14 - On May 16, 2008, at 12:11 AM, Bruce Herbach wrote: > **I know you ended up with less the 99, but in the testing I did, > I found I could get it to show more fields by making the columns > narrower. I still hit a limit. The two limits in play... Fri, 16 May 2008 00:11:41 -0400 http://www.listsearch.com/FileMaker/Message/index.lasso?162576 Bruce Herbach to FileMaker Talk on 2008-05-16 00:11:41 - Doug, I took another look at FM Knowledge base and may have found the source of your problem. In article 6586, Technical Specifications of FileMaker Pro 9 and FileMaker Pro 9 Advanced,toward the bottom it gives these two items that may apply. ... Thu, 15 May 2008 19:45:51 -0400 http://www.listsearch.com/FileMaker/Message/index.lasso?162575 Jonathan Fletcher to FileMaker Talk on 2008-05-15 19:45:51 - Doug didn't understand Jimmy's suggestion, because he would have realized what a simple and time-saving solution that would have been. j. On May 15, 2008, at 7:24 PM, Doug Pinkerton wrote: > Jimmy is tenacious, but Doug is up against a deadl... Thu, 15 May 2008 19:24:46 -0400 http://www.listsearch.com/FileMaker/Message/index.lasso?162574 Doug Pinkerton to FileMaker Talk on 2008-05-15 19:24:46 - Jimmy is tenacious, but Doug is up against a deadline, and will be content to use two layouts. The solution is a temporary part of a larger project anyway. Thanks for trying. dp ****************************************************************... Thu, 15 May 2008 19:05:13 -0400 http://www.listsearch.com/FileMaker/Message/index.lasso?162573 Jimmy Jones to FileMaker Talk on 2008-05-15 19:05:13 - Doug may have a lucky number in "6", How about making it 6-point font to get all the columns and use the window magnifier in the lower left corner, looks like a large mountain compared to the one next to it or an upward pointing graph, to sho... Thu, 15 May 2008 18:55:32 -0400 http://www.listsearch.com/FileMaker/Message/index.lasso?162572 Doug Pinkerton to FileMaker Talk on 2008-05-15 18:55:32 - Jimmy has better eyes than Doug (which isn't saying much). Making the columns narrow enough while still displaying the necessary data would require 6-point font. Two rows per record would defeat the purpose of the table in this instance. It will ... Thu, 15 May 2008 17:55:32 -0400 http://www.listsearch.com/FileMaker/Message/index.lasso?162571 Jimmy Jones to FileMaker Talk on 2008-05-15 17:55:32 - Doug may be getting wrapped in an absolute, There is a maximum layout width. Not a maximum number of columns. If memory serves the maximum layout width is ~110 or 111 inches, approximately 10 pages. To show more columns just reduce the size of ... Thu, 15 May 2008 17:33:51 -0400 http://www.listsearch.com/FileMaker/Message/index.lasso?162570 Doug Pinkerton to FileMaker Talk on 2008-05-15 17:33:51 - Thanks for the reply, Bruce. I tried that, but the last 36 fields still got chopped. I even deleted all of the records and created layouts with an empty database. It still chops it. I wonder if it has something to do with the fact that I created ... Thu, 15 May 2008 17:17:51 -0400 http://www.listsearch.com/FileMaker/Message/index.lasso?162569 Bruce Herbach to FileMaker Talk on 2008-05-15 17:17:51 - Hi Doug, I think you should be able to view this in table form with out the wrap. I checked FM knowledge base for this and did not find a limitation on columns in table view. As a test I took one of my databases that had 94 fields in a table an... Thu, 15 May 2008 15:36:22 -0400 http://www.listsearch.com/FileMaker/Message/index.lasso?162568 Doug Pinkerton to FileMaker Talk on 2008-05-15 15:36:22 - I have a file with 100 fields. I need to work with all of them in table view. When it creates the table, FM displays only the first 66 columns. The remaining 34 are wrapped into a second line which does not appear in browse mode. I am unable to m... Thu, 15 May 2008 08:43:17 -0400 http://www.listsearch.com/FileMaker/Message/index.lasso?162567 Snip(TM to FileMaker Talk on 2008-05-15 08:43:17 - on 5/15/08 @564, Snip(TM) wrote: >Does anyone know of a Canada-centric truck/delivery routing software >that would work with FileMaker? Further info: FM 9 / MOSX 10.4 / limited finances ;-) -- John Snippe -- This list is a free service o... Thu, 15 May 2008 08:32:45 -0400 http://www.listsearch.com/FileMaker/Message/index.lasso?162566 Snip(TM to FileMaker Talk on 2008-05-15 08:32:45 - Does anyone know of a Canada-centric truck/delivery routing software that would work with FileMaker? We are a bottled-water delivery company based in the Niagara region of Ontario, and need to be able to create efficient routing maps based on the de... Wed, 14 May 2008 17:50:06 -0400 http://www.listsearch.com/FileMaker/Message/index.lasso?162565 Lee Smith to FileMaker Talk on 2008-05-14 17:50:06 - Wow, that I don't think I have ever heard of that tip before. Thanks, Lee On May 14, 2008, at 2:27 PM, Geoff Graham wrote: > No, duplicating the first one saves you having to re-enter the PAID > and SHIPPED values again for the second reque... Wed, 14 May 2008 17:28:50 -0400 http://www.listsearch.com/FileMaker/Message/index.lasso?162564 jake london to FileMaker Talk on 2008-05-14 17:28:50 - Does anyone know of a template to create a yearly calendar in FMP6? Something like this is what I have in mind: http://www.timeanddate.com/calendar/ It doesn't necessarily have to link to month, week and day views, etc, as I'm not looking to use i... Wed, 14 May 2008 17:29:55 -0400 http://www.listsearch.com/FileMaker/Message/index.lasso?162563 Jennifer Chaney to FileMaker Talk on 2008-05-14 17:29:55 - Thanks Doug - this worked like a charm - I just was not thinking about it the right way... Many thanks to everyone else for their help as well!! :-) Jennifer On May 14, 2008, at 3:45 PM, Doug Pinkerton wrote: > It might help if you think ... Wed, 14 May 2008 17:27:59 -0400 http://www.listsearch.com/FileMaker/Message/index.lasso?162562 Geoff Graham to FileMaker Talk on 2008-05-14 17:27:59 - On May 14, 2008, at 5:12 PM, Lee Smith wrote: > > On May 14, 2008, at 12:51 PM, Geoff Graham wrote: > >> Jen, >> >> If you have that as 3 find requests, then you're looking for 3 sets >> of data. I think you want a single find request with thos... Wed, 14 May 2008 17:12:31 -0400 http://www.listsearch.com/FileMaker/Message/index.lasso?162561 Lee Smith to FileMaker Talk on 2008-05-14 17:12:31 - On May 14, 2008, at 12:51 PM, Geoff Graham wrote: > Jen, > > If you have that as 3 find requests, then you're looking for 3 sets > of data. I think you want a single find request with those criteria. > > It is still easier for me to build find r... Wed, 14 May 2008 15:51:05 -0400 http://www.listsearch.com/FileMaker/Message/index.lasso?162560 Geoff Graham to FileMaker Talk on 2008-05-14 15:51:05 - Jen, If you have that as 3 find requests, then you're looking for 3 sets of data. I think you want a single find request with those criteria. It is still easier for me to build find requests in a script the 6 way: Enter Find Mode (do not resto... Wed, 14 May 2008 15:45:42 -0400 http://www.listsearch.com/FileMaker/Message/index.lasso?162559 Doug Pinkerton to FileMaker Talk on 2008-05-14 15:45:42 - It might help if you think of the OR as the primary operator. Find: - Company RBC and Paid No and Shipped Yes OR - Company CW and Paid No and Shipped Yes Create a find request like to address the first line, then create another request to addr... Wed, 14 May 2008 15:28:50 -0400 http://www.listsearch.com/FileMaker/Message/index.lasso?162558 Jennifer Chaney to FileMaker Talk on 2008-05-14 15:28:50 - Hello! I am working on an Accounts Receivable report and got stumped somewhere inside my find requests. Working in Filemaker 8.5 v1... We have several "companies" here (which all produce the same product underneath one roof) and we refer to them... Wed, 14 May 2008 14:35:36 -0400 http://www.listsearch.com/FileMaker/Message/index.lasso?162557 Martha White to FileMaker Talk on 2008-05-14 14:35:36 - Hi Dana -- I'll start digging! --Ginny On Tue, 13 May 2008, Dana Smith wrote: > Hi Ginny > > I've been following this thread as I have a similar situation to implement > in FM9. I need to have several portals displaying on a page and only want ... Wed, 14 May 2008 13:11:44 -0400 http://www.listsearch.com/FileMaker/Message/index.lasso?162556 revDAVE to FileMaker Talk on 2008-05-14 13:11:44 - On 5/14/2008 7:22 AM, "Pete Frend" <pjf@ndsys.com> wrote: > We are troubleshooting the wireless access points and > other issues. How strong is the wireless signal on the clients? -- Thanks - RevDave Cool @ hosting4days . com [db-lists] ... Wed, 14 May 2008 12:55:19 -0400 http://www.listsearch.com/FileMaker/Message/index.lasso?162555 Bruce Herbach to FileMaker Talk on 2008-05-14 12:55:19 - Pete, I have a client (Local school) that runs a wireless network with a similar set up to yours. 2003 Server with FM server 9 and FM 9 clients all running notebooks. The servers are on a wired section of the network, but all of the clients con... Wed, 14 May 2008 10:22:16 -0400 http://www.listsearch.com/FileMaker/Message/index.lasso?162554 Pete Frend to FileMaker Talk on 2008-05-14 10:22:16 - I am running on a Windows2003 Server with tablet PC's using FileMaker Server 9 and FileMaker 9 Clients. I know about wireless and the occasional disconnect issues. However, I am dealing with disconnects every few minutes. We are troubleshooting t... Wed, 14 May 2008 10:17:11 -0400 http://www.listsearch.com/FileMaker/Message/index.lasso?162553 VanBuskirk, Patricia to FileMaker Talk on 2008-05-14 10:17:11 - Thanks Ross! I will give that a shot .. sure sounds logical to me. Trish p.s. Unfortunately, I just had ankle surgery on Monday, so my dancing days are on hold! ;-) -----Original Message----- From: FileMaker Talk [mailto:fmpro@lists.lassos... Tue, 13 May 2008 21:02:52 -0400 http://www.listsearch.com/FileMaker/Message/index.lasso?162552 Winfried Huslik to FileMaker Talk on 2008-05-13 21:02:52 - Jake, I'm not clear on exactly how you want this whole thing to work. Anyway you have to specify somehow what field to change, either - name the field explicitly in a script - click or tab into a field and then trigger a script (not a very reli... Tue, 13 May 2008 20:22:26 -0400 http://www.listsearch.com/FileMaker/Message/index.lasso?162551 Ross Dickson to FileMaker Talk on 2008-05-13 20:22:26 - Jake OK, then try this approach. Place as many different container fields as you want on your layout. Create a button, Change Colour, which runs the one line script: Set Field [, Case( Status(CurrentFieldContents) GetRepetition(gCol... Tue, 13 May 2008 19:52:03 -0400 http://www.listsearch.com/FileMaker/Message/index.lasso?162550 Jake London to FileMaker Talk on 2008-05-13 19:52:03 - Even if the button triggers a script that tells it to enter a field before calling the status function? Thanks for this idea below, though. If it works, it'll be a bit more elegant than the alternatives Best, JL JL Winfried Huslik wrote... Tue, 13 May 2008 19:19:54 -0400 http://www.listsearch.com/FileMaker/Message/index.lasso?162549 Winfried Huslik to FileMaker Talk on 2008-05-13 19:19:54 - Jake, Try this: - three globals for the colors (no need for blank) - no flag field needed - one script per button in a record: Set Field [ "semaphore", Case( semaphore red, green, semaphore green, black, semaphor... Tue, 13 May 2008 19:05:01 -0400 http://www.listsearch.com/FileMaker/Message/index.lasso?162548 Jake London to FileMaker Talk on 2008-05-13 19:05:01 - Thanks. I've done it that way in the past. I was just hoping there was a way to do it that didn't involve having to copy the script, fields, etc over 300 times for the layout I want to make. I hoped maybe there was a way to make the object and scri... Tue, 13 May 2008 19:00:44 -0400 http://www.listsearch.com/FileMaker/Message/index.lasso?162547 Jake London to FileMaker Talk on 2008-05-13 19:00:44 - Okay. Yes, that makes sense. The images are in globals, because you want them available in each record. But the flag is local to each record, because you want the state of the button to be local to each record. Thanks again, JL Lee Smith wrot... Tue, 13 May 2008 18:59:51 -0400 http://www.listsearch.com/FileMaker/Message/index.lasso?162546 Ross Dickson to FileMaker Talk on 2008-05-13 18:59:51 - Jake There is a simple way to do this in fmp6: You have a number field called Flag, gColours, a global repeating container field with a red graphic pasted into cell 2, green in cell 3 and black in cell 4. Cell 1 is blank, and finally a calculated ... Tue, 13 May 2008 18:58:52 -0400 http://www.listsearch.com/FileMaker/Message/index.lasso?162545 Jake London to FileMaker Talk on 2008-05-13 18:58:52 - Yes. I understand it's an old version of FMP. But I haven't work in FMP for a while now and I've never learned post 6 fmp. So this old stuff is what I'm stuck with for now and since the thing I'm building is for personal use, I'm not inclined to jum... Tue, 13 May 2008 18:49:07 -0400 http://www.listsearch.com/FileMaker/Message/index.lasso?162544 Lee Smith to FileMaker Talk on 2008-05-13 18:49:07 - On May 13, 2008, at 3:31 PM, Jake London wrote: I said that all fields need to be global, that was an error, The Flag field should be a normal Container Field, and the Field should be unstored. Sorry, Lee -- This list is a free service... Tue, 13 May 2008 18:44:12 -0400 http://www.listsearch.com/FileMaker/Message/index.lasso?162543 Lee Smith to FileMaker Talk on 2008-05-13 18:44:12 - On May 13, 2008, at 3:31 PM, Jake London wrote: > Okay. But you need that intermediate flag text field. You can't > just do the If analysis directly on a container field itself? You realize that you are using a very old version of FileMaker? As ... Tue, 13 May 2008 18:31:39 -0400 http://www.listsearch.com/FileMaker/Message/index.lasso?162542 Jake London to FileMaker Talk on 2008-05-13 18:31:39 - Okay. But you need that intermediate flag text field. You can't just do the If analysis directly on a container field itself? Question 2: With this method you're going to need a flag field for each iteration of the button. Yes? So if 300 copies ... Tue, 13 May 2008 18:23:13 -0400 http://www.listsearch.com/FileMaker/Message/index.lasso?162541 Lee Smith to FileMaker Talk on 2008-05-13 18:23:13 - You can do this using a script. I created three Container fields, called Red, Green, Black, and 1 Global Field. I filled the containers with the colors, and made a Flag Field, witch is a Calculation, with a result container. Flag Field calculati... Tue, 13 May 2008 18:08:54 -0400 http://www.listsearch.com/FileMaker/Message/index.lasso?162540 Ross Dickson to FileMaker Talk on 2008-05-13 18:08:54 - Trish It's my opinion that the summary fields for each ticket number ( order number?) for each billing type should be in the table where the ticket number originates; that is, the billing records table (BRT), not the line items table (LIT). Th... Tue, 13 May 2008 17:30:33 -0400 http://www.listsearch.com/FileMaker/Message/index.lasso?162539 Jake London to FileMaker Talk on 2008-05-13 17:30:33 - So I'm still back in the old days with FMP 6, and I'm wondering if someone more knowledgeable can help me understand the relationship between the above referenced function and field type. I fear what I want to do is not possible, but I figured I'd ... Tue, 13 May 2008 15:11:50 -0400 http://www.listsearch.com/FileMaker/Message/index.lasso?162538 Dana Smith to FileMaker Talk on 2008-05-13 15:11:50 - Hi Ginny I've been following this thread as I have a similar situation to implement in FM9. I need to have several portals displaying on a page and only want the portals to show the number of actual records in each, not the defined fixed portal size... Tue, 13 May 2008 12:04:35 -0400 http://www.listsearch.com/FileMaker/Message/index.lasso?162537 Bruce Robertson to FileMaker Talk on 2008-05-13 12:04:35 - > OK, I'll admit I'm brain dead this morning... > > FMP 9.0v3 on WinXP. > > I am attempting to rebuild our billing database. It has been > piecemealed together since FM3, so does not utilize tables, has > repeating fields, and is laid out more li... Tue, 13 May 2008 07:51:15 -0400 http://www.listsearch.com/FileMaker/Message/index.lasso?162536 Seth Ganahl to FileMaker Talk on 2008-05-13 07:51:15 - Trish- You probably have this figured out by now, but what I think you're after is a summary field in your billing table that simply pulls in values via the relationship you have to line items. Does that make any sense? -Seth On 5/9/08 9:59 ... Mon, 12 May 2008 11:45:59 -0400 http://www.listsearch.com/FileMaker/Message/index.lasso?162535 Chris Kubica, PMP to FileMaker Talk on 2008-05-12 11:45:59 - All, Relevant link: http://www.applicationarch.com/compare.htm AA Reports are free, PDF-based, thoroughly-researched, objective comparison charts to help you decide which FileMaker-related plugin/solution is right for your or your clients' busin... Mon, 12 May 2008 02:24:12 -0400 http://www.listsearch.com/FileMaker/Message/index.lasso?162534 Andrew Brown to FileMaker Talk on 2008-05-12 02:24:12 - On 10 May 2008, at 16:12, Doug Pinkerton wrote: > Then, create a one-to-many relationship from Package to Book based > on PackageID. Rather than selling books, you're selling packages. It > will seem counterintuitive in those instances where a pa... Sat, 10 May 2008 10:12:07 -0400 http://www.listsearch.com/FileMaker/Message/index.lasso?162533 Doug Pinkerton to FileMaker Talk on 2008-05-10 10:12:07 - You might want to consider two tables. The first tracks packages for sale. A package contains one or more books. Thus: Package ------- PackageID Book ---- BookID PackageID Then, create a one-to-many relationship from Package to Book bas... Sat, 10 May 2008 09:44:10 -0400 http://www.listsearch.com/FileMaker/Message/index.lasso?162532 Andrew Brown to FileMaker Talk on 2008-05-10 09:44:10 - This is my fifth message today, but I threw the others away because when I had finished describing the problems the answers became clear... not too sure that will be the case this time. I have a database of old books, and some of these books cons... Fri, 09 May 2008 18:15:55 -0400 http://www.listsearch.com/FileMaker/Message/index.lasso?162531 Loretta James to FileMaker Talk on 2008-05-09 18:15:55 - Hi everyone, I used to work with Eric Crisp and have been attempting to find him. Anyone know him and his whereabouts? Thank you, Loretta James -- This list is a free service of LassoSoft: http://www.LassoSoft.com/ Search the list archives: ... Fri, 09 May 2008 15:49:17 -0400 http://www.listsearch.com/FileMaker/Message/index.lasso?162530 VanBuskirk, Patricia to FileMaker Talk on 2008-05-09 15:49:17 - Thanks Ginny! I'll give it a whirl with changing the layout table. I hadn't thought of that! -----Original Message----- From: FileMaker Talk [mailto:fmpro@lists.lassosoft.com] On Behalf Of Martha White Sent: Friday, May 09, 2008 1:46 PM To: File... Fri, 09 May 2008 14:39:28 -0400 http://www.listsearch.com/FileMaker/Message/index.lasso?162529 Fletcher Sandbeck to FileMaker Talk on 2008-05-09 14:39:28 - The Lasso tip of the week for May 9, 2008 discusses how to create and call custom tags in Lasso 8.5. Custom tags are Lasso's version of functions or procedures. <http://www.lassotech.com/TotW 20080509> Recent tips of the week include: - Opt...