Our Preferred 5 Star Hosting Provider - Award Winning FileMaker Pro Hosting
Results 1 to 2 of 2
  1. #1
    FREE Member
    Join Date
    Apr 2011
    Last Post
    Local Date
    Local Time
    04:36 PM
    Last Active

    Inventory Starter Solutions

    I am setting up an inventory database and using the Inventory Starter Solutions Template. I have all our products that we purchase in but when I update the order date with a new price I am not seeing where it keeps the past information. Will it keep a history of the items ordered in another table? Is there a way I can have it save the pass orders in another table and have the most current only be in the main table? I would like to be able to see a history of the items and also be able to get a year-to-date cost of items ordered. Thanks
    Warning: This is an Old Thread
    This discussion is older than 420 days. information contained in it may no longer be current

  2. #2
    Senior Moderator - FMT Preferred Developer Consultant - West Coast USA - Global Techphan's Avatar
    Join Date
    Mar 2006
    Southern California
    FileMaker Pro Software
    FileMaker Pro Advanced 16
    Windows & Mac
    Skill Level
    Last Post
    Local Date
    Local Time
    01:36 PM
    Last Active

    Re: Inventory Starter Solutions

    This is one of those occasions where you do not want to use the power of a relational database by having the price only in the inventory table (for each product) related to the invoice. Invoicing solutions need to have the price stored in the invoice table so that price increases do not ripple back through old (and paid) invoices / statements.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Starter solutions disappeared!
    By waters7 in forum FileMaker Pro 12 - All versions
    Replies: 1
    Last Post: 09-19-2012, 07:34 AM
  2. Customizing Starter Solutions
    By aklobby in forum FileMaker Pro 11
    Replies: 1
    Last Post: 05-18-2010, 08:16 PM
  3. FileMaker Pro 10 Starter Solutions Webinar
    By Ross MacLane in forum FileMaker Pro 10
    Replies: 0
    Last Post: 04-14-2009, 12:27 PM
  4. Starter Solutions - detailed help?
    By Coltom in forum FileMaker Pro 9
    Replies: 1
    Last Post: 05-26-2008, 05:29 PM
  5. Starter solutions
    By joeydiab in forum FileMaker Pro 8.5
    Replies: 7
    Last Post: 11-29-2007, 02:19 PM


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts