Our Preferred 5 Star Hosting Provider - Award Wining FileMaker Pro Hosting
Results 1 to 2 of 2
  1. #1
    FREE Member
    Join Date
    Apr 2011
    Posts
    4
    Downloads
    0
    Uploads
    0

    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
    Posts
    2,266
    Location
    Southern California
    FileMaker Version
    FM 9 Server, FM 10 Server, FM 11, FM 11 Server
    OS
    Windows & Mac
    Skill Level
    Intermediate
    Downloads
    0
    Uploads
    0

    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

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Welcome to the Original FileMaker Forum
With designated forums for almost every FileMaker topic...FileMaker Today is a free-to-join community where you can boost your FileMaker expertise, build better solutions and solve your technical challenges. If you're building FileMaker solutions, this is the place for you.
Follow FMT
We Are FMT
FMT is home of The World's leading FileMaker News Site, Worldwide Developer Directory, FileMaker Connect Community and so much more.