AnsweredAssumed Answered

Price History

Question asked by TKnTexas on Sep 9, 2013
Latest reply on Sep 10, 2013 by philmodjunk


Price History


     I think I am having a senior moment.  I have inventory records.  Originally I had the purchase price as a number field.  But I have decided I want to maintain a history of prices.  I think there might be a benefit when negotiating prices with a vendor.  I have added a related table of prices. 

     I have tied the two tables together with based on the primary key being the sequence number auto-assigned.  How do I get the parent record to show the price added to the PriceTable (child table)?