1 Reply Latest reply on Feb 24, 2011 11:23 AM by philmodjunk

    Sub records, or child database?  iPad solution for QC checklist

    TimWatson

      Title

      Sub records, or child database?  iPad solution for QC checklist

      Post

      I'm wondering if anyone can help me think through a solution.

      Basically I need an iPad solution in our warehouse for checking quality control on products that we bring in via freight containers.  Each container has a PO# which I would like to be a record in a parent database.  On each PO, there are about 50 seperate item UPC's that we will be checking quality control for.  I need each of these items to be a record as well, but as a sub-record of the PO that it is a part of. I think...does that make sense?  Or am I thinking incorrectly?

      So first, we would browse (or search) the master database for the PO# that the inspector would be checking-in product for.  Then, once the PO is pulled up, the inspector would be able to scroll through the individual records of products that were on that container.  For each record, there will be a full page of "quality control" checklist items that the inspector will go through and click on and make notes about.  Then scroll to the next record (product) and repeat the form for this next product.

      The goal is that we would be able to view QC issues per item on a specific container.  And browse specific containers for all of the QC issues that were present on that container.  Also, we would like to be able to enter an item number and see which containers this product was on, and get to the QC notes that way.

      Any ideas on how should I set this database up?  For each container that arrives, we have a CSV file with all of the products on it, that we can use for importing the records for that particular PO.  We will do this import for every new container.

      Currently on a trial version of FMP11, and trying to create a solution during this time to sell my supervisor's on buying the software.

      Thanks!

        • 1. Re: Sub records, or child database?  iPad solution for QC checklist
          philmodjunk

          Look up "portal" in FileMaker help. You'll most definitely need a table for the PO's and a related table for each item listed on that PO. You may also need to set up a QA notes table that you would link to either the PO and/or individual item records.

          Here's a greatly simplified invoicing demo you can download and study. It was created by someone named Comment who used to be active in this forum. He uploaded it to a different FileMaker form than this one: 

          http://fmforums.com/forum/showpost.php?post/309136/

          Purchase order systems, typically use the same basic structure, it's just that you are buying instead of selling so it should be a good place from which to start.