An informative video (and associated blog post with downloads) by Daniel Shanahan of New Leaf Data on four different ways to accomplish the same task: Updating inventory records in a FileMaker database.
Shanahan explains four ways:
read more and look at the video