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 describing (also not sure how this forum handles images; I uploaded a screen cap).  Â
  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 conceptualizing it. But why is it wrong? I'm not clear on 'lineItems'. Is this a field in the Invoices DB? or?And how is that different from just grabbing the price from the Products table? I see that it somehow lives between the two tables, but flummoxed on how to create it?
  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, Invoices, etc, all existing now as separate data files. And secondly how would you actually go about combining? I thought about creating the fields and importing but that just seems dicey to me. Maybe just leave well enough alone? We are running FM Pro Advanced 12 on Mac OS 10.8.5.
  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 proposals and invoices, no? Maybe I need to think about this in a different way?
  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 else has resolved this?
  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 looking for 'Kim Stanley Robinson'. I have more than one book by this author. FM would show me the first matching record, allowing me to scroll to subsequent record that match the search criteria. So far, so good. Keep in mind that the FoundSet includes 'Red Mars', 'Green Mars', 'Blue Mars' and '2312' and that I am viewing them one by one in Form View by simply advancing the record. I could also have a List View that shows all members of the FoundSet, but this list would need to be a different window and different layout. I want the list of matching records to be on the Form View layout. This way I can see all of the holdings by Kim Stanley Robinson, holdings that are otherwise visible only by scrolling, or by switching to a different layout. Maybe? (My skill level is really novice).
  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? Thanks.
  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 populated it by making smaller versions of the photo data. I did not change the file names (FM is using the file names, I assumed). So now it is very simple, with three tables: data, pix, small pix. Easy scripting to tell the iPhone version to use 'small pix' rather than 'pix'. But the system is not very robust. Importing new photos, for example, will require some scripting to be sure that the smaller versions are also made. Am I over-thinking this?
  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 normal, large version. Do I create a new table? How do I populate the new table and how do I tell the iOS records to use the small version of the photos? This isn't an unusual situation I would guess but I don't see how to do it? And of course to complicate matters I need TWO smaller sizes of each photo on the iOS: one for a thumbnail, and another that is large enough to email to clients but not as large and unwieldily as the 'main' picture that resides on the Mac? I am using FM 12 Advanced on the MAc, and FM Go12 on the iOS. Once I learn how to do it for the small iPhone, I can do the same thing so it can run on the iPad with a different set of sizes.
  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.