Hello,
I'm attempting to assign a price to a transaction based on the transaction date. There is a table with price changes and dates to post from BUT the prices don't change daily. So a post operation that uses "Date" as the linking key will only post prices to transactions that occurred on a price change day and the others remain blank. I'm needing the blank ones to have a price of the previous price change. Below is an example of the "Price Change Table" where changes are stored and what the "Transaction Table" should look like after the posting/update. I'm hoping there is a simple solution and I apologize if it's too simple to be asking!

Price Change Table
7/1 1.00
7/3 2.00
7/5 3.00
7/7 4.00
Transaction Table
7/1 1.00
7/2 1.00
7/3 2.00
7/4 2.00
7/5 3.00
7/6 3.00