Jump to content

zenmom

Members
  • Content Count

    30
  • Joined

  • Last visited

Community Reputation

0 Neutral

About zenmom

  • Rank
    member
  • Birthday 08/07/1951

Profile Information

  • Title
    Publisher, Editor
  • Industry
    small publishing (short stories, print-on-demand)
  • Gender
    Female
  • Location
    Salem, Massachusetts
  • Interests
    Gardening, cats, natural history... I find *everything* interesting (which is sometimes a problem, it's hard for me to focus)

Recent Profile Visitors

1,166 profile views
  1. Dear comment, Ah, that makes sense. I will try the two table solution. Thanks! M.
  2. Okay, I'm back! Let me give two different examples. First, tracking expenses. I'd like to be able to enter data with the basic "building block" being a receipt. If at the end of the day I've got 3 receipts, I'd like to enter the data with each receipt as a separate thing that I can track by vendor and date. Within each receipt the items might fall into various categories, as in the following three receipt examples: On a hardware store receipt, the line items might include a personal expense (table lamp for me), a "house" expense (LED lightbulbs, to be reimbursed from our co
  3. I suppose there could be different categories or subcategories, but in that case there would be many, many categories, to the point of being unwieldy. But let us sidestep that by saying they would not have different dates, just different costs, as in an invoice with n+1 line items. How would that be handled?
  4. Dear Collective Wisdom, Hi, semi-novice here! I might have asked this question a couple years ago, but if I did I couldn't find it in the archives. I'm using FM Pro 12, on an iMac OS v10.12.2 aka Sierra. (I know I'm behind the times, am planning to catch up to FM Pro 15 soon. But for now, v12 it is.) So. I'm setting up a database to track expenses. My first bash at fields is shown in the attached screenshot. (I may prune out a couple of the fields near the bottom of the list.) The db currently has 3 records, to wit: "banjo maintenance", "Revere Ware copper-bottom pot", and "Fi
  5. Thank you, that's much closer to what I had in mind!
  6. Oooo-kay, here I go again! I'm working on an expenses db currently. For report purposes, I want it to look like this: [Category] [sub-category] [individual entries] . . . (etc.) [sub-category] total: [total by sub-c.] [next Sub-category] [individual entries] [next Sub-category] total: [total by sub-c.] (and so forth... followed by:) [Category] total: [total by Category] (and then at the very bottom:) Grand Total: [total of all items] I'm att
  7. zenmom

    Cell "padding"?

    Hi, I'm working with FileMaker Pro v10. I'm back mucking around with it after being away from it for awhile. I find the text or data in the cells easier to read if there's a little white space between the edge of the cell and the beginning of the text. I figured out how to go to Layout Mode, then Format > Text > Paragraph and then specify an indent value. So the leading edge now has that lovely little sliver of blank space before the text starts. However, (and this is not a huge deal, just frustrating because I keep thinking there *ought* to be a way to do this), I haven't been able to f
  8. Ah-HA! This seems to have done the trick. In Layout mode, I went to the menu item "Layouts", and then selected "Layout Setup...". The "Show records from:" section didn't have the right info in it. I changed the entry there to Cost (the table I'm trying to work with), and I was then able to create a new record. So far, so good. Thanks for the tip!
  9. Dear Collective Wisdom (and bcooney, if you're out there!), I am once again taking a flying tackle at my health supplements db. It contains separate tables for different areas, such as Supp (the main definition of each supplement), Dose (how much to take and when), Source (where to get it), Area (what health area it supports), and so forth. There are join tables (preficed by "j" in the table name) to connect the tables as necessary. And there are various relationships defined in the relationships graph. So far so good. However, now I'm trying to add a table named Cost, which will re
  10. Hi all! I've got a nutritional supplements db. With some advice from bcooney (thanks!) I've got it set up with separate tables for Supplements, Areas (i.e., health areas that supplement might support), Doses, etc., plus join tables with appropriate entries and a relationships graph to tie the tables together. So far, so good... mostly. However, I've run into a problem. In the Supplements table (titled "Supp") I've got a field that indicates whether or not that supplement is currently part of the regimen. The field is named Current, and if the supplement is currently being taken, I e
  11. Dear bcooney, Thanks for showing this to me, it looks like it'd fix that pesky list break problem. Unfortunately, it requires v9 and I'm still on v8.5. But hey, a good reason to upgrade! M.
  12. Hello, Collective Wisdom, I've got a layout that is getting close to what I want. I request the range of records I want, and display them, organized into sub-summary lists (thanks, bcooney, for your help). The problem is that sometimes I'd like a page break before a particular sub-section, and sometimes not, depending on how long the list of items is below that particular heading (for example, the old "widows & orphans" problem with a heading and 1 item at the bottom of a page, and then the rest of the items on the next page). But I don't want a page break before *every* sub-section,
  13. (Apologies for the double post, my computer hiccuped which sending...)
  14. Dear bcooney, Many thanks for your previous help! And... now I've got two more questions. I've slimmed down my working copy of the supplements database to fewer tables until I get the basics straightened out. I'll add the other tables (doses, cost calculations, sources?) later. For now, I've got it down to 5 tables: Area Supp jSortArea jSuppArea Dose (I'm not using Dose at the moment, but it had a lot of data I didn't want to re-enter, so I didn't delete that one.) The table Area defines the different areas of support (body systems & genetics). The table
  15. Dear bcooney, Many thanks for your previous help! And... now I've got two more questions. I've slimmed down my working copy of the supplements database to fewer tables until I get the basics straightened out. I'll add the other tables (doses, cost calculations, sources?) later. For now, I've got it down to 5 tables: Area Supp jSortArea jSuppArea Dose (I'm not using Dose at the moment, but it had a lot of data I didn't want to re-enter, so I didn't delete that one.) The table Area defines the different areas of support (body systems & genetics). The table
×
×
  • Create New...

Important Information

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