Working with related tables - Auto entering data into related table
I have two tables that are related...
2. Price Adjustment
There two fields in Transaction, Original List Price & Current Price
I have it set up so when a user changes price in the Price Adjustment through a portal it automatically updates Transaction::Current Price = Price Adjustment::New Price. This is done through a simple calculation within the table/field setup under Transaction::Current Price.
The problem is that I have to tab over to the Price Adjustment portal and manually add a price adjustment to create an entry so it forces a current price on the Transaction.
Is there a way I could automatically enter a new entry into Price Adjustment that will add a value to Price Adjustment:: Current Price & Price Adjustment::New Price equal to Transaction::Original List Price. I would like to do this upon entry of the Original List Price.
I know you can use script triggers upon exiting the object. I am just not sure how to create a new related record without going to the layout.
Any other suggestions, I am open to them.