Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Devyn

  • Rank
  1. I will certainly try that. Thanks. I may finally have a convincing argument to get my client to upgrade ;)
  2. Yuck, I was hoping that wasn't going to be necessary. I guess it serves me right for not building my layouts with container fields right from the start. Thanks for the input.
  3. I manage a small office network of 5 computers running FMP9.0 which I recently updated to 9.03 along with the SSL update to match. Two machines that have undergone the update no longer display embedded images in the database layouts properly. While the other three have no problems at all. The images are not in container fields (in retrospect that would have been much smarter) but placed right on the layout board. There is extensive use of auto resize to generate seamless borders and title bars. The images that show "gaps" have been linearly stretched from a single pixel width to the ap
  4. I just thought of something. Is this working because I'm using no body part? I've used various sub-summary sections which (of course) conditionally display based on the sort criteria. I didn't want to show all the Invoice Items if the user only wanted to show the client their Work Order totals, or Labour and Material Totals, or just Project Totals. So I deleted the body part. Its really only the summaries of the data that are important for this application. The user can still display the record data if they want because I've inserted the appropriate fields into sub-summary parts
  5. I didn't know about that context menu search. That's neat, thanks. So here's the final solution (until the client asks for changes ugh..) User creates an Invoice, and enters the Invoice Builder. Only one invoice can be displayed in the builder, necessarily no provisions for hopping between invoices from there. Builder windows. Menu Window. Display Window. A menu window displays billable Projects, their associated billable work orders, and THEIR associated billable Labour and Materials. The menu is very slick, select multiple items, filter by drop downs view related reco
  6. Wow, that article was brilliant. Thanks for that. I really appreciate your help guys. Thanks. I think I'll be substituting some user training for design in this case. :)
  7. Sorry, I explained that poorly. The print layout is based on line items. Line items contains a Summary field (it is a summary field) of Total of Extended Price. That summary field is in a title footer displaying a correct (has now been checked with three unique sets of Line items on different invoices) value for the invoice total.
  8. Fenton, I presume the user would type their find criteria into some global fields on the "Display Invoice Items" layout, click find, then the script would hop to a list view and carry out the find with the global values. Wouldn't you have to perform a bunch of special handling for multiple find requests and special find characters in order to make use of these vital features? Could it even be done?
  9. That's a cool example soren. But (there's always a but eh) I'm not having trouble adding items to the Invoice, its searching within items already added to perform editing and override tasks. The company I'm working for is in Landscaping, so the numbers can be a little fuzzy. Tweaking invoices here and there to meet quotes is a regular occurence. They've asked to search these invoices for this reason: Person doing invoicing needs to make adjustments to the bottom line and remembers some detail of the an item suitable for alteration. To find the item (in a list of potentially
  10. What about a lookup for the line item fields that autofill from the Items table. Use a second occurence of your Items table for the lookup relationship (via the ItemID that must be re-used when a product is discontinued). The lookup will occur when the user enters the ItemID, but it will not auto-update if the Items table is changed (that might be a down-side) without a re-lookup on the ItemID. Like the last poster said, leave the line items connected to the Items table permanently via an auto-enter serial number that has nothing to do with your in-house ItemIDs. Use it to collect
  11. I did read in the help that the Title header takes the data for any fields it contains from the last record on the page. I started this post after reading that actually. Then, on a whim I tried throwing the summary field in there and it worked. So a summary of Total Price =Sum(Invoice Item::Price) is exempt from the last record rule. What's different about the other summary types (running total/count)?
  12. [invoice] ---< [invoice Items] The menu is based on Invoice, the list view is currently based on Invoice Items right. If I end up switching to a portal, I'll simply put a portal of Invoice Items on the menu layout. This is what I had first, but the client asked to be able to search the Invoice (I guess they can get quite long...) and I don't know of any way to search a portal. Now, I've put in a lot of hours on this thing so far, so I might sound like I know what's going on but I'm very new at this so there may just be a simple setting to search a portal that I've just never used
  13. The solution I mentioned (summary field in a Title Footer) is displaying the correct total even when records span multiple pages. The only limitation (and I don't consider it one, because its what I wanted) is that the "pseudo-summary" must appear on the first page. I haven't tried this method with regular footers, only a Title Footer. I only have 1 example set of data right now, so I'll have to check again with a new Invoice to be sure. The Expanding Grand Summary in the linked post looks very usable. One problem comes to mind: If you have any sliding fields on your report
  14. I may have found a solution. Placing the summary field for "Total Payable" in a Title Footer seems to work. I'm waiting for it to break as I try some different record combinations and sorting combinations. Will someone holler if I'm missing some vital point?
  15. Can a trailing grand summary be forced to appear at the bottom of the printed page it appears on? The effect I'm after is the tear-away section on the bottom of an invoice that details the relevant payment information for paying the invoice. thanks in advance
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.