Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About jmci

  • Rank
  • Birthday 07/04/1953

Profile Information

  • Gender
  • Location
    Brantford, ON, Canada
  • Interests
    Tai Chi, Lions Club
  1. A client has asked me to design a custom CRM system for his company to replace a legacy system. This client has some familiarity with FileMaker Pro. In initial discussions he is hot on the idea of using table view instead of list view layouts. I've been a contract developer using FileMaker for many years and have never employed table view in a project I've delivered to another company. I know that table view has evolved somewhat recently and I'm interested in hearing the community's opinion of the advisability of using table view instead of list view and the reasons pro and con. If it's as bad
  2. OK, let's hold that technique in reserve You seem to be able to add more than one y-axis field. Could that be the solution?
  3. I've been struggling with something and I don't even know if it's possible to accomplish it in FileMaker. A client has acquired data from the Medicare about outpatient surgical procedures that have taken place over the last several years. The data is available in one table that contains many fields but there are three fields of interest: Year: the year in which the surgical procedure took place Payment Amount: the amount paid for the procedure Facility Type: the type of facility at which the facility took place (there are four possibilities) I've also created a summary field
  4. I'm working on my first data separation model project and it has an Invoice table. There is also a related Payment table. The Invoice table has a calculation field that sums the Payment::Amount field in related records. It also has a Balance calculation field that subtracts Invoice::SumPayments from Invoice::Total. In the user interface file I've created an Invoice form layout on which I've placed a portal to an occurrence of the Payment table. Rather than the user entering payments directly into this portal the user clicks a button above the portal that runs a script that opens a w
  5. Is there a way to allow a senior employee or middle-manager to assign new accounts, to existing privilege sets, without granting that person full access privileges?
  6. Can anybody explain why the conditional formatting formula evaluates as false or can't be evaluated while the control has focus?
  7. Hi Raybaudi Actually I didn't really have a problem understanding 1 as the conditional formatting formula. True is always true and that's easy enough to understand. What I don't understand is why the conditional formatting formula evaluates as false or can't be evaluated while the control has focus. jmci
  8. I've seen FileMaker apps designed by others where the fill color of an object on the layout changes as the user enters that object. For example, as the user tabs from one editbox control to another on a layout, the fill color of the current object changes from white (the apparent default color) to yellow. I always thought that technique was cool and wanted to know how to accomplish it. I've recently had an opportunity to look at a file which used that technique. In layout mode I saw that all of the editbox controls on a layout had a default fill color of yellow and each of these controls
  9. That's an interesting choice. Now, back to my problem... I reasoned-out the cause of the problem by myself. The OnLayoutEnter trigger of the Splash Screen layout must have fired when the file first opened but, since I had already assigned my Startup script to run at file open, the triggered script couldn't execute until the Startup script had finished. Of course by that time the Startup script had already navigated to the Home layout but the triggered script still went ahead and installed the menu set that belonged to the Splash Screen layout. To test this theory I un-checked the OnL
  10. Several of my layouts have two menu sets. One is used when the file is in development mode and contains menus and options that are not included in the menu set that gets installed when not in development mode. My Splash Screen layout is one of those with two possible menu sets. The Splash Screen layout also serves as an About layout and when the user navigates to that layout I want to present the user with a minimum of menu options. On the other hand, when in development mode, I want many of those menu options available to me. What I can't understand is how the OnLayoutEnter trigger
  11. My File Close script navigates to a splash screen layout. The OnLayoutEnter triggered-script for this layout installs a menu set with almost no options. When the file opens, the splash screen layout is the current layout (as intended) and my Startup script pauses for two seconds, does several other things, then navigates to my Home layout. The OnLayoutEnter triggered-script for the Home layout installs a menu set with many more menus and options and all is well. The problem is that immediately after program execution exits from the Startup script, the OnLayoutEnter triggered-script f
  12. That's what I wanted. I knew that enforcing RI at the interface level wouldn't be good enough in every situation.
  13. OK, I see it. That would work. Thanks Now, would that enforce my referential integrity delete rule in all circumstances such as if the file was accessed by another external file?
  14. Forgive my inexperience but what do you mean by the "calc for the RLA"?
  • Create New...

Important Information

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