Hello,
I am new to Caspio, I encounter a problem here.
I have two Tables
Table#1: Investment(Investment_ID, Client_ID, Latest Transaction date, BookValue, MarketValue)
e.g.
Invest001|Nov 1, 2018|500|1000
Invest001|July 1, 2018|800|2000
Table#2: Investment Transaction(Investment_ID, BookValue, MarketValue, Transaction_Date)
e.g in Table #1 I have following records,
Invest001|100|100|Oct 1, 2018
Invest002|800|2000|July 1, 2018
Invest001|100|200|Oct 10, 2018
Invest001|100|300|Oct 15, 2018
Invest001|200|500| Sep 1, 2018
Invest001|500|1000|Nov 1, 2018
Here I would like to make the following action execute whenever I update the table.
Latest Transaction Date = Table#2:Latest Investment Transaction:Transaction_Date
BookValue = Table#2:Latest Investment Transaction: BookValue
MarketValue = Table#2:Latest Investment Transaction: MarketValue
What can I do to make this happen?
Any help will be appreciated,
Thank you very much in advance,