Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About tinynumbers

  • Rank

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Ugh, I was afraid somebody would say that. Unfortunately, that's not possible right now, due to limited budget and limited time to upgrade the database to the v11...
  2. Ok - I thought that might be the problem - but Filemaker didn't complain about it when I created the relationship. Any alternate approaches which you might suggest which would accomplish the same desired end-result? Thanks.
  3. Yes they are... Conference ownerID - Number lastDay - Date calculation (unstored) defined as: Max (Events::eventDate) Owner earliestDayToShow - Date Owners::id = OwnerConferences::ownerID AND Owners::earliestDayToShow ≤ OwnerConferences::lastDay
  4. I have two tables with the relevant parts defined as follows: Event conferenceID - Number eventDate - Date Conference ownerID - Number lastDay - Date calculation (unstored) defined as: Max (Events::eventDate) Owner earliestDayToShow - Date In the relationship graph, I have the following table instances: Conferences - Conference Events - Event Owners - Owner OwnerConferences - Conference I have these relationships: between Conferences and Events: Conferences::id = Events::conferenceID between Owners and OwnerConferences: Owners::id = O
  5. I could swear I've read how to do this, somewhere, before, but now I can't find it. My problem is this: I have a Value List called PeopleNames which uses values from first field "Person::id" and second field "Person::name". "Include all values" and "Show values only from second field" are both selected. Now, in my layout, where I use this value list to select a particular person (which I use for filtering a list of things), I want to also include at the very top of my menu of PeopleNames an "empty" value, or one that says "*ALL*" or something like that. * I don't want to have to c
  6. Hi. I've been trying to come up with the best way to approach this situation: My table has a numeric value, call it "price". The price is a currency value, but the currency in which the items are priced can be variable. I'd like for users to be able to type in a currency value and a number into a field on the layout, for example "$50" or "£30" or "GBP 30" or "USD 50" etc... - and to have that automatically stored as two items: (A) the numeric value (50 or 30 etc) and (: a link to an entry in the Currency table (i.e. the currency-code or some other unique ID in a table of all cur
  7. Ah ha! Hadn't thought of an approach like that. Very clever, works great. Thanks.
  8. From the FM docs for Duplicate Record/Request script step I'm wondering what may be the same thing as tmas73: is there any way to do a "Duplicate Record" which DOES duplicate the auto-enter data (with the exception of unique serial numbers)? I have some of the fields of my table setup with auto-enter data just to define starting point default values when a user creates a new record. But if I'm doing a "duplicate record", I want to duplicate the user-entered values, not reset the values on the new record to those default auto-enter values. Is there any way to do this that does
  9. I've been reading bits and pieces (both here on FMForums and elsewhere on the web) about how to best handle the notions of "preferences" in a FM solution. The way I'm thinking about it, there are two different uses of the word "preferences" within a solution: 1. solution-wide preferences: User-modifiable preferences which are carried over to all users (in a multi-user environment). If any user changes one of these preference values, all users should immediately see this change. 2. user preferences: User-modifiable preferences which are specific to a single user (in a multi-user e
  10. Makes sense, and that's what I thought must be the case from my experiments with this. Thanks for the details, and for the suggestions on alternative approaches.
  11. I was hoping that within a Groovy script I could do something like this: fmpro.performScript(fileName, scriptName, scriptParam); result = fmpro.evaluate("Get ( ScriptResult )"); ... However, it appears that calling fmpro.performScript(...) triggers the FM script asynchronously - i.e., the FM script will be on a different thread, so the Groovy script doesn't wait for the script to complete before it continues on to the fmpro.evaluate(...). So the fmpro.evaluate of "Get ( ScriptResult )" just sets "result" to an empty value, since the FM script hasn't completed (and therefore hasn't
  12. I wound up using this idea and it is working great for me so far. Thanks!
  13. I was just reading about "Object Influenced Design" in Filemaker, from this article: Object-Influenced Design & Filemaker Pro It seems to be discussing an appealing way I could approach this sort of problem I'm having. But I can't find any more information on people taking this sort of approach to Filemaker database designs. Anyone know any more resources discussing or illustrating object-relational type designs in Filemaker?
  14. Hi. New to Filemaker (but not databases in general) so forgive me if I fumble a bit with some of the FM-specific terminology. I have a design issue that I'm not quite sure how to best address in Filemaker: I have two different types of contact tables in my contacts database (one table for businesses; another table for individuals who may or may not be affiliated with one or more of the businesses in the businesses table), which are almost entirely different in structure, except that they both have a notion of "location", based on an address (which is part of the table definition f
  • Create New...

Important Information

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