AnsweredAssumed Answered

Auto-Create Potal entry?

Question asked by DeanMoray on Jun 27, 2011
Latest reply on Jun 27, 2011 by philmodjunk


Auto-Create Potal entry?


FM 11

New to FM so please bear with me.  I have a PRODUCTS table with information about the products with a related PRICE table that has the key field, a date field, and a price field. I want to easily update prices but also track price changes for each i can track price history.

What I am trying to do is have a list of all products from one vendor with the current prices showing and if I change the price in that list, it auto-enters the new price and current date into PRICE table for that product.

I figured out how to have a price field in the Product table be a calculation of the last portal (sorted by date). But if I use that field in my products list, it is a calculation and I dont want to enter the price directly into it and delete that calculation

I am looking for suggestions on how best to accomplish this.