Auto-Create Potal entry?
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 product.so 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.