1 Reply Latest reply on Mar 23, 2012 9:01 AM by TSGal

    Large database and FM GO

    Faganel

      Title

      Large database and FM GO

      Post

      Hi Everyone,

       

      I have a
      task, or an idea which I don’t know, if would work. So let me started with a case
      to get a picture and then I will have some questions.

      I have an
      Excel table containing approximately 7000 rows and approximately 16 columns. This
      table contains my products with article number, description... this articles are
      divided in groups and this groups are distinguee by article number (usually
      first column; column A) which is (contains) 12 numbers long and first 5 numbers
      are the same for each group (group can contain from 1 to 50 product in
      different dimension e.g.).

      My idea is to use this table as database and in FileMaker or Bento(?) create a
      form to “call” information from this database (Excel table).

      Oh yes ...
      this should run on iPad.

      And now the
      questions:

      Can I make
      a kind of form, where will be a field, where I will enter first 5 digits of the
      article number and below will show mi all articles (products) beginning with
      this first 5 digits. After that I will tap on right one and will show me all
      characteristics from the database?

      If this is
      possible; can I make more “search” fields and just search database by any of
      entered criteria and not just by product (group) code?

      I suppose
      that for FileMaker on my Mac this would not be a problem ... what about Bento?
      Can Bento “swallow” this?

      What about “exporting”
      this on iPad ... would FileMaker GO be able to process this (the new iPad)?

      I hope that
      I was clear enough,

      Matej

        • 1. Re: Large database and FM GO
          TSGal

          Faganel:

          Thank you for your post.

          FileMaker Go can open and use FileMaker Pro files.  The key here is that the file will have to be created with FileMaker Pro and then either host the file that can be accessed by FileMaker Go, or download the file to the iPad so FileMaker Go can open the file locally.

          FileMaker Pro would allow you to create a field where you enter the first five digits, and then another listing would appear with that product grouping where you could then select the specific product.  This would require some scripting.

          FileMaker Pro does allow you to search all fields.  You are not limited to just one field.

          Bento is not a relational database product, although it does have some relational capabilities.  Whereas FileMaker Pro links tables together via key field(s), the linking of data is all manual in Bento.  In your case, this may work.  Bento has a Related Data field type that allows you to link records from another table (called Libraries) to the current table, where you bring up a list of records from the related table, enter the 5 digits into the search box, and this filters the list down to those records that meet the search criteria.  You then select the record you want to link and click "Save Changes".  The record in the related table is then linked to the record in the current table; not key field needed.  This information will sync over to Bento for iPad or Bento for iPhone.

          I recommend downloading a 30-day trial version of Bento from www.bentotrial.com, and see if this works for you.  If you run into limitations, feel free to post on the Bento forum at:

          http://forums.filemaker.com/groups/a13a2dc617/summary?lang=en_US

          Let me know if you need clarification for anything I covered.

          TSGal
          FileMaker, Inc.