Please may I have some help - new to Zoho, some experience with Access.

 

I have an application :

 

Invoice form : Invoice_ID , Date , Cust_ID

Invoice item form : Invoice_Item_ID , Invoice_ID, Item_ID( LookUp from Item) , Quantity, Price(Look Up from Item) , Discount, Tax, Extended_Price 

Item form  

 

The item form prices will change daily / weekly or monthly . So I need to create an Archive Invoice Item Form that has the prices saved for the day the transaction took place.

 

So I need to be able to post  ? at each succesful entry / ? end of day the records from Invoice Item Form to Archive Invoice Item Form.

 

I have tried to add script : On Add , Succesful   ....but not really sure . I need your help please..

 

Thanks  Garry