How should I proceed in order to fetch historically accurate records from one form to another? For example, I may look up the price from my Products form for my Order form. The price may change in the future but i do not want the prices in my previous orders to change, as is the case if i simply use the lookup field.

For those of you familiar with filemaker, what are the equivalents in zoho creator for lookup and portal. lookup in filemaker copies the value so that it will remain historically accurate while portal simple displays the current value.

thank you!