1 Reply Latest reply on Jun 6, 2012 9:04 AM by philmodjunk

    New to Filemaker

    BradFansler

      Summary

      New to Filemaker

      Product

      FileMaker Pro

      Version

      12

      Operating system version

      Mac OS X

      Description of the issue

      I am new to Filemaker and want to make sure it is the right product for my company.  I have 3 questions I need help with. 

      1)  How is the best way to flag duplicate entries if they happen?
      2)  Along with Flagging these entries, how is the best way for new information to update an existing record on a possible duplicate?  (In Access you could run an Update Query)
      3)  How can you "Append" data in filemaker like you an in Access?

        • 1. Re: New to Filemaker
          philmodjunk

          I can see that you are also new to this forum Wink

          You've posted your question to a section of the forum intended for reporting possible bugs with Filemaker products.

          (You did see the notice:

          Report an Issue is for bug reports.If you have a question about how to use a FileMaker product, please post that question to one of the other forums (FileMaker Forum, FileMaker Server Forum or FileMaker Go Forum) that have been set up for that purpose.

          Didn't you?)

          I'll be glad to answer your questions, but suggest you click the FM Pro Forum tab at the top of this screen if you have any additional questions to ask about the product as questions posted there will be seen by many more people and thus will gather more responses.

          1) The best way is to not permit them in the first place with a good interface design, but you can set a unique values validation rule that can pop up a message you specify when a duplicate value is entered into a field where you've specified this validation rule. You can also devise scripts that perform more sophisticated validation checks when the "onObjectValidation" script trigger is tripped.

          2) Can't really answer that question. I can think of many ways to do that and the best answer depends on what you need to update. It could be as simple as a script that finds that records so that the user updates it directly, but there are many other options possible as well.

          3) In FileMaker, you can add a block of new records to an existing table by using the Import Records Action from the File Menu or via a script that uses the same method.

          If you have not already done so, I recommend downloading the 30 day free trial to get direct, no cost experience with this product.

          If you then decide to go ahead and purchase it, I strongly recommend that you acquire a copy of FileMaker Pro Advanced for developement work. It offers a number of development support tools (including  script debugger and data viewer similar to the ones that come with Access), that can save you a lot of time and effort developing a database as well as gaining the ability to take more complete control of the user interface with custom menus and custom functions.

          One final note: FileMaker is not Access. It does not allow the user or developer to use SQL to produce recordsets for forms and reports the way you are used to in Access. It has it's own unique way of accomplishing many of the tasks for which you would use SQL in that system so you have to adjust your thinking and reach for a very different set of tools in order to accomplish the same thing as you would in Access.