Exceptions

I don 't think my attachement made it... Town.fp7.zip

Hi all. Noob. 8.5, Mac. I've got a quick & dirty database that allows one to enter related child records via a portal. Not the recommended solution, but it's really just for (my) training. It appears that when you begin to enter data in a portal row, the next row's fields become 'active', highlighting field borders and activating popup menus (although they all remain blank). I'm sure that a new record isn't being created, but it's odd looking, and implies to a user that another record was created. The portal's deletion mechanism also implies that there's one there. In fact it's left ambiguous as to when a child's actually been created. Is this the normal behavior? This seems to be the case with example files as well. Here's one from 'Using FM 8' that uses scripted buttons but behaves in the same way. I intend to make an add/modify area (and not use a portal) in real projects, but I would expect that many users just use portals, and so it seems really odd behavior, and kinda ugly. Thx

Thank you...that is what I was first attempting to do, but my results were quite clunky. So the auto-complete is the equivalent of 'type-ahead'? I notice that you don't have any options in the table fields themselves, and that you simply have the layout tile field setup to auto-complete. This narrows the focus of my problem: how to know if a solution should be in the field definiitons as opposed to a layout or script? Also, the layout title name edit box actually is the title name field. Won't this allow the title to be changed by the user when entering an issue? The field must be enterable, so it is modifiable.

Hiya. I'm moving from an old 4D environment, and C++, to FM, and having some problems finding equivalent solutions to common problems. In fact, i'm sure that some of the solutions in FM will be totally different. I'm a little overwhelmend, even with the big fat Que book. Lots of little options dialogs and not a lot of overall sense of what's the right thing to do... For example, let's say I've got a comic-book database. The comics records each have a foreign key which is the title of the comic. The title record data isn't stored in the comic record; just the foreign key is kept. There are many titles which have the same (or similar) names. When the user wants to enter a comic, he has to identify what title it belongs to. In 4D, when you start typing a string and then tab, you can trigger a script which opens a new window that displays a list of all titles whose names contain the string fragment you typed. From what I've seen so far in FM, the similar solution would be to set up the foreign key field to create a value list based on related records in the titles table, and show the foregn key plus the title name as the 'second' field. The triggering action is to hit a drop-down arrow. You get the idea. It's not immediately intuitive to the noob. Alternatively, I can trigger the creation of a new window with a button and use a layout The gist of it is, I think there should be an easier, probably organic FM way to do this kind of stuff, and I haven't come across it yet. The value list made of related matches is a little lightweight for this kind of application, and the trigger events don't seem to be available to me without explicit button-clicking. Where's a noob to find organic solutions?

Thanks. I went thru the wringer with them, and spent about 3 hours trying different things: new admin acct, different startup disks, picking apart the perm bits, and so on. Eventually they were convinced that since even the filenames were wrong, the disc was bad and they didn't have a clue how to extract the installer. The killer was that after this, they sent me to Sales, who didn't want to send me a new CD for free w/o a case number. So I jump back in and get a new case #, blah blah blah. I have to wait a week to 10 for a new one. You know they have to paint the top by hand.... My first bad disc since about 1986!

Hi all. Just got the disc, and have a big problem. The installer app shows up as a document, and no amount of digging into the file settings or the package contents have helped. Granted it's a Carbon app and I can't remember what's what with the file bits, but I've tried quite a bit of futzing with Xray. I tried making a new admin account (advice of the FM phone tech) - no luck. Full perms fixup - no luck. Fixup of the Installer Vise app inside the package - no luck. Like I said, I'm a little lost with a Carbon app, but frankly the Info bits seem munged up to me. Any help appreciated!!

I've got the same questions, with a few additions: My MySQL database has many tables, with many-to-one and some many-to-many relations via a connection table. There are a couple of additional index keys (like some alphabetical names, etc) that I might want to keep, but they're not crucial. The design is pretty clean...maybe not a 3NF, but a 2.8 from the Canadian judge . (Sorry) It's easy for me to export the individual tables in either XML or CSV or SQL, using a little program called CocoaMySQL. I haven't done any FM since the pre-relational days, so this will be my first step back in. Before I make the dive, I'd like to know which is the best path to take regarding file types, maintaining the keys, and so on. Oh, this will be FM the regular ($299) version, unless the Advanced is required. Thanx to all....