# Previous records **URL:** \ **Category:** Ask for Help\ **Created:** [March 28, 2023, 6:56pm UTC](https://community.glideapps.com/t/previous-records/59807 "2023-03-28T18:56:54Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![ccanales](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ccanales/32/24256_2.png) [@ccanales](https://community.glideapps.com/u/ccanales)\ **Post date:** [March 28, 2023, 6:56pm UTC](https://community.glideapps.com/t/previous-records/59807/1 "2023-03-28T18:56:54Z")
How can I avoid that when changing the price of a product, this change does not affect the previous records? ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [March 28, 2023, 6:58pm UTC](https://community.glideapps.com/t/previous-records/59807/2 "2023-03-28T18:58:52Z")
Record the price ---
**Author:** ![ccanales](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ccanales/32/24256_2.png) [@ccanales](https://community.glideapps.com/u/ccanales)\ **Post date:** [March 28, 2023, 7:07pm UTC](https://community.glideapps.com/t/previous-records/59807/3 "2023-03-28T19:07:40Z")
I don’t understand 😅, could you explain a little more please? ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [March 28, 2023, 7:08pm UTC](https://community.glideapps.com/t/previous-records/59807/4 "2023-03-28T19:08:47Z")
When you are recording an item sale, record the item’s price… What are the previous records that you are worried about? ---
**Author:** ![ccanales](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ccanales/32/24256_2.png) [@ccanales](https://community.glideapps.com/u/ccanales)\ **Post date:** [March 28, 2023, 8:46pm UTC](https://community.glideapps.com/t/previous-records/59807/5 "2023-03-28T20:46:33Z")
These are purchases, not sales When I modify the app with the new price, it also modifies the records prior to the date of change. I want to prevent that from happening ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [March 28, 2023, 8:48pm UTC](https://community.glideapps.com/t/previous-records/59807/6 "2023-03-28T20:48:51Z")
Are the prices coming from a relation to another table that contains the prices? How are you creating this for purchases? ---
**Author:** ![ccanales](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ccanales/32/24256_2.png) [@ccanales](https://community.glideapps.com/u/ccanales)\ **Post date:** [March 29, 2023, 5:37pm UTC](https://community.glideapps.com/t/previous-records/59807/7 "2023-03-29T17:37:18Z")
I get the prices from the supplier table, however the problem is: Sample- Item ¨A¨ on 01/12/2023 its price was $ 3.00 Now- Item ¨A¨ at this moment or by now its price is $ 3.50 So item ¨A¨ has rise its price and I don’t want this change affects the previoous price records. How can I avoid change the previous record with the new prices? Note: These are purchases not sales ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [March 29, 2023, 11:10pm UTC](https://community.glideapps.com/t/previous-records/59807/8 "2023-03-29T23:10:52Z")
> [@ccanales](#): > > I get the prices from the supplier table But how are you doing this? Are you using a Relation and Lookup? If you are, you should be writing that price to a basic column when the row is added.