Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About btmeacham

  • Rank

Profile Information

  • Gender

FileMaker Experience

  • Skill Level
  • FM Application

Platform Environment

  • OS Platform
  • OS Version
    High Sierra
  1. Thanks for articulating this. This is the behavior I saw, but didn't understand, and was trying to work against, as I worked through the issue. I'm glad to know that it's expected behavior and I wasn't crazy for being unable to find a way to get the portal to work the way I wanted. I've arrived at a solution that required some going back to old records and adding data, but that will work as I wanted going forward. Thanks!
  2. The root of the problem seems to be that when having the portal display the chronologically earliest Screening associated with any one Title, it lists the Venue in order by Venue_ID, the unique identifier field, rather than by earliest Screening Date, and I can't find any way to change this sorting. I've decided to add a field to my Title table that indicates the Venue of the Title's first Screening, and just have it display Venue data related to that Venue, which works fine. Thanks for looking over my issue and giving me some new things to think about.
  3. Thanks, Steve. You're right about it making sense to me and being confusing to others—it has been cobbled together and modified bit by bit over the years, and looks unwieldy now, though it all functions as expected...except for this one weird bit. To answer your other questions, Guest isn't particularly important; it's just a table that joins a Person to a Screening to note that the Screening had a special guest in person. Countries is a table of countries of origin, which is joined to the Title table by the Origin join table, to track the country or countries of origin of the films. And
  4. Thanks, Steve. Sorry for any lack of clarity in articulating my question. My understanding of TOs and TOGs is fairly rudimentary, but I think I grasp the concepts. Here's a shot of the entire graph: These particular TOs are prefixed PER_ as a way to remind me that they're related to the Person table; they're occurrences of other tables that are used to view things through the director of a film, so for ease of organization, I've preceded them with PER_. The Venue data in two tables might be problematic, and I'd be open to a better solution, but I think about it as akin to a Name and
  5. I can't tell if I haven't stated my problem clearly enough, or if those who have looked at it don't think there's a solution? I'd love any feedback and would be happy to provide more info if my issue isn't clear. Thanks!
  6. I’ve got a database of film screenings, and am encountering some confusion when it comes to displaying data in a portal. I have a layout that displays a director’s name and then lists each of the films by that director that I’ve screened. Next to the title of each film, the portal displays the number of screenings of that title, and data about the earliest screening. My problem comes when there has been more than one screening of a particular title, and I’m unable to get the portal to properly display the correct city/state associated with the displayed venue for that earliest screening.
  7. Remember the part where I said it was probably simple? I will never again forget to make sure the result is set to be text. I promise. Thanks!
  8. This seems like it should be simple, but I can't seem to figure it out. Thanks to this solution http://fmforums.com/forum/topic/68663-sorting-titles-ignoring-the-a-an/ I created a field that stripped all of the leading articles from titles I'd like to sort. The calculation works properly, and the resulting "Sort Field" with no leading articles looks right. Then I ran a sort on that field... and found that the titles still aren't sorting properly. This sounds so basic, I'm not even sure how to explain it any further, but the sort I'm getting is only slightly different than what I ge
  9. Aaand solved again. So, despite what the documentation on filemaker.com indicates, comment was correct and using the Default setting results in searches that find words with accents even when accents aren't entered in the search. I was running into a problem where the search wasn't working correctly in a dynamic portal filter situation, so I also used Wim's suggestion to create a shadow field with every possible diacritic stripped out, and ran the filter through that field instead, with the user none the wiser. If I could make this solved twice, I would. Thanks.
  10. I'm returning to this topic because I can't seem to reproduce what I thought was a successful result from comment's advice. In looking at the information at the link provided, it looks like using Default storage does the opposite of what I'm looking for: it does not return a record with an accented name in it if the accent is not entered in the search. As it states, I'm looking for the exact opposite functionality, where someone who doesn't know where the accents fall can search for a person and get the correct result despite not using the correct accents. I'll revisit Wim's suggestio
  11. Great, thanks! That's an even easier fix... I appreciate your help.
  12. Thanks! That did the trick, of course. And I'll see what I can do about getting Advanced installed. I didn't realize I'd be getting this serious, this quickly, but now it seems I have, and I could use the help. Thanks again.
  13. Thanks. I've uploaded a stripped-down database with the Title, Component, and Carrier tables. I have a few sample records in there, and the buttons for "Add a component" and "Add Carriers" work - except when you've specified "1" as the number of carriers, at which point it goes into infinite loop. Thanks for taking a look. Database_Sample.zip
  14. Thanks for the suggestion. I'll look into it and see what I can come up with.
  15. I'm working on a database where users can search by a person's name. Many of the names in the database have accents and other diacritical marks which it's important for us to keep and display properly. Unfortunately, if a user searches by typing in "Francois," the record for "François" will not be returned. Since it's a pain (at least on a Windows machine) to find and use those special characters, or the user might not even know that André actually has an "é" at the end of his name, I'm looking for a way to ensure that a search for a name that includes a character without a diacritic will find
  • Create New...

Important Information

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