Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Richmilnix

  • Rank
  • Birthday 07/25/1971

Profile Information

  • Title
  • Industry
    Public library
  • Gender
  • Location
    Otherville, ME

FileMaker Experience

  • Skill Level
  • FM Application

Platform Environment

  • OS Platform
  • OS Version
    Won 10, OS X Mojave

Recent Profile Visitors

4,031 profile views
  1. I’m looking for insight / input regarding an at-home install of FMS 19. Because I’m mystified and can’t figure out what the problem is, I’m writing an everything-but-the-kitchen-sink in hopes that someone might recognize something. To that end, I’m including real local IP addresses (to try and avoid confusion). I’m enrolled in the Claris Developer program that allows me to install FMS and have up to three clients. I’ve installed FMS on two machines: a Win10 box that’s a regular presence on my LAN (hosts UniFi and Subsonic) and a Mac Mini running 10.15.6. (My life is simpler if I can get i
  2. Sorry, I overwrote. FMS won’t appear when the hosts IP address is in the browser bar - only when a local variant (like ‘localhost’) is. And the admin console won’t render in the browser of another laptop on the LAN. Is this an intentional feature of the Developer package, or is FMS malfunctioning on my network?
  3. Well, I wouldn't have minded knowing about that before I dropped the hundred bucks this morning! Oh, well. Some days you eat the bear, some days the bear eats you. -------------------------------- I came back here to ask a question, though. I'm experiencing one strange behavior of my newly installed hundred-dollar FMServer setup, and I don't know if it's one of the ways that the product is intentionally hobbled to preclude my using it for live production (in which case, fine) or if it's a networking flaw that I want to clear up before I start using this setup for testing. T
  4. My situation is kind of particular. Years ago I administered a dozen databases on a local install of FMS (around FMP13). These days, at a different workspace, I do different work and only maintain a couple of local databases on an FMS install that, for security reasons, has no public face (i.e. no browser interface). I'd like to see how stuff "looks and feels" in a browser and on iOS, for several reasons: 1) I'm curious 2) Maybe I'll have an idea to bring to the current job 3) Maybe I'll have an idea for a product of my own. None of those is compelling enough for me to ask the curre
  5. What's the latest version of FMP / FMPA that gets along well w FMS16? I'm in a workplace where I have access to version upgrades, but we're working with files hosted on Server v16.
  6. For an inventory management database, I'd like my main screen to be able to accept pulls from three related databases: - Serialized (valuable tools, which I track and want back - the paintbrush); - Replenishable (cheap tools that I buy by the yard and if one gets left behind I don't care - the paint-mix sticks); - Perishable (disposable tools that are left on the job site - the paint). These will handle their related requests differently. The serialized I'll be tracking properly to make sure we keep track; the latter two I'm looking for more like a system of 'tick marks' to help
  7. I might have confused things (again) by typing the script manually. The script step actually reads Go to Layout [ “staff_schedule_match” (Date_match) ] where Date_match is the named relationship through which my portal is seeing the employees working on a given date. . . . and therefore, I now realize, I need the relationships in the script to be defined through Date_match as well! I gotta admit, I still get confused in trying to map this out. But the solution is working now. Thanks for your input.
  8. I know it's hard to tell because I threw so much information in there, but staff_schedule_match is one table, containing shift data that looks like StartDate: 3/22/2017 StartTime: 7:30 AM EndDate: 3/22/2017 EndTime: 4:45 PM nUID: V204 A second table is the one I'm working in, staff_schedule_interface, intended to be the neutral "window" through which employees view and print the data in above (organized by day, by week, or by name). Given the use I described above, I don't understand what context I should establish. (At least once, I solved a problem by creating a field called
  9. I'm reframing a question that I posted in a confusing way. Using variables seems so simple to me, but I know I'm missing something. I'll just post exactly what I'm trying to do so you guys can tell me why it isn't working. The project is a db that will handle shift schedules for employees. In the one-day view I'm looking at, the essential live field is a global date field called gDate_of_work. A portal is looking through to related records and returning a list of employees (from a table called staff_schedule_match), identified here by unique serials, who are scheduled to work that day. Th
  10. You're right; I was conflating two issues (because I thought my variable trouble was stemming from my mixed-up TOs). Reframing my question in a new thread.
  11. All right, let me try to answer without digging myself any deeper. First of all, I'm not arguing with you guys. Clearly, I overcomplicated things. But since Wim asked what I was after: I'm a part-time developer who only dives back into FMP every few years when I have a problem that needs solving. That means that I don't spend a lot of time thinking about logical schema. As my projects began to grow more sophisticated and more interrelated, I found that my relationship maps were sprawling - mostly because what had started off as a db hosting events was now also hosting staff schedules
  12. You know what, I have only myself to blame - years ago reading about Anchor-Buoy structure I Was really attracted to the notion of discrete TOs coupled by a slew of relationships - but each time I try to implement them I make sort of a hash of it. Thanks for your input.
  13. My goal here is to write a database with tidier relationships than I've used in the past, so I'm intending to use discrete table occurrences of the same data. Here's the roadblock: In layout 2_week_schedule, I have 14 portals that display a staff schedule (two weeks' worth) and can't be edited. My goal is that a logged-in administrator can click on the date field of any one of those fourteen days and go to a layout 1_day_schedule that is displaying the same information, though with more details and one day at a time. The underlying table of each layout is the same, though the layouts
  • Create New...

Important Information

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