Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About peaceandplenty

  • Rank

Profile Information

  • Gender
    Not Telling
  1. I think I need to step back in terms of an explanation, Matthew, as I'm not seeing what the tables are exactly. I get how to look up a price from one table to the next, which is what I've been doing, but don't get how to insert the line items that you are describing.  Are saying that each item on the Invoice is an event that consists of the widget and the quantity, so the invoice is a sort of a list of purchase events?  Look at the starter solution that comes with FMP12, which is what started, and why I began this thread. I don't see anything there that looks like what you are descri
  2. Thanks, both of you, for the discussion, giving me enough background to do it. Or hurt myself :-)
  3. Thank you EVERYone for your answers. I can't thank you enough as I slog through this. DB design is oddly compelling, and interesting, but not my day job. Matthew said: "Keep in mind that your invoice should have its own field for product price and it should not simply display a related field from your pricing catalog. Its fine to create a relationship between the two, e.g. to provide popup or drop-down functionality, but the invoice needs to have its own data field which is static and not dependent on changes to your product catalog." And that is exactly how I have been conceptualizin
  4. We have many legacy tables that were setup before FM took all tables into a single file, and wondering if it makes sense to combine them. Business is finally beginning to look better (after many years), so we want to sharpen our office procedures. Examining our FM solutions is part of the procedure. I don't recall which version that the all-in-one capability was added, and I remember seeing at the time discussions of the pros and cons. Aside from the aesthetic issue, and convenience of having a combined datafile, is there an advantage to combining tables? We would have Proposals, Addresses
  5. Say you have an invoice for widgets. One customer pays X, another pays Y for the same widget. How do I construct a relationship between INVOICES and PRODUCT PRICES that would allow this? And further, what if the price I charge customers increases. How do I keep an old invoice from showing the newer values? And when I make a new invoice, how would I populate a value list for the widget so I would see all the prices paid by all previous customers? I looked at the starter DBs for some clues but don't see how they handled this, which must be a pretty common feature of things like prop
  6. Thank you thank you thank you! I never even thought about conditional formatting on anything other than fields– certainly not on plain text. This worked perfectly for me. And the conversation amongst others here and examples opened a few other doors for me, too, entirely unrelated to my original question. Thanks again everyone, and forgive the delay– unlike the other denizens here, I'm otherwise employed, so working with Filemaker is a bit of a hobby (which is obvious when comparing my work with that of real pros). Thanks.
  7. Lots of real estate is wasted on field name labels, especially in iOS. I'd like to see the field name label UNDER the field and visible only in Find Mode; in Browse Mode, the field data in this particular solution is self-evident. This is not what I want: I've been experimenting with conditional formatting with only frustration; I think I want a format that depends on the view mode but we don't have it. And, I've downloaded examples of solutions that others have designed, including the starter solutions, but haven't seen a resolution. Instead, lots of wasted space: Â I wonder if anyone
  8. Sorry dude! I wasn't sure if I was asking the same question that you had when I rudely jumped in. Still not sure if the question has been answered but apologize for thread-jacking…
  9. Well. Who would ever think that humor and database programming could actually hold hands? I'm sure you answered the question but I didn't quite grasp what you are saying, so I thought I'd use a different example and describe what I am trying to do more fully: I've got an extensive book library and, naturally, a FM database that keeps track of my holdings. Every title has a record. So far, so good. Just like any library card catalog, not complex. I'm looking at a simple Form View that shows a record for each book. Now, let's say that I performed a search on the 'Author' field
  10. I think this thread also answers a question I had but I want to restate it in 'novice' terms (please forgive me if I am hijacking, I'll start a new one!) Say I searched for all Florida zip codes in an address DB, and say I'm looking at a single record in Form View. I want to have a list on the Form View that shows the entire found set. I also found this which seems pretty close to what I want: http://fmforums.com/forum/topic/48079-calculation-to-list-current-found-set-record-ids/. But perhaps there's an easier way to do what must be a pretty common thing? Filtered portals, or? Tha
  11. Thanks for the replies, and it seems I've not explained the problem well, as usual! I know how to do the setup stuff, and how to learn what the platform is, etc. That's not the problem. This solution will run on remote devices. It won't use Server. Everything, including product data and product photos, must fit on an 8G iPhone. Photos are critical, but they are very large, ?4M, and there are nearly a thousand of them. So far, so good. The photos are in a table called 'pix', and they are related in the usual way with a serial key. I made another table called 'small pix'. I popul
  12. My products database is very straightforward, nothing complicated. Each product has several photos; the photos are in a separate file as per recommendations here some time ago. Now I am building a version of my products DB for iOS, and naturally the photos (some are 2000 x 3000±) are way too big for the iPhone to handle. So the question is this: I know how to create smaller versions of each picture (there are many ways, I will use Preview or Graphicconverter). What I don't know is how to have records on the iOS refer to the small version of the photo while records on the Mac use the no
  13. Hi Everyone: Is it possible to link a find request with a layout? I would select a layout and when I did, a find request would be triggered?
  14. Dan, thanks, I've been mulling this over. Maybe I should just explain what I want to do, which is to call up the item picture from many different layouts (found lists), and enable the user to click the picture to go back to the calling list. You've given me an idea I want to try before replying fully. Thanks. ps: I can't always get back to this project so sometimes a day or two passes without replying. Don't want to be rude and appreciate the help.
  • Create New...

Important Information

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