I have an access database. I have two tables, please see below.
Ticker (text & primary key)
ID (integer & primary key)
// some other fields
In this application a trade is entered into the table tblTrade. When this happens I would like a few things to happen.
1) If its a Ticker that doesn't already exist in tblTicker that it gets added and populates the other two fields, name & sedol.
2) If the ticker already exists in the tblTicker then nothing needs to happen.
3) If a ticker in the tblTrades is updated I would like the ticker in the tblTicker table to be updated too.
It looks like I should be using relationships between the two tables. However I do not know how to go about this, in particular on point 1) i.e. how would the name & sedol get updated?
I know I can achieve all of the above by using vba however it seems silly for me to have to write two update queries if there is already a mechanism in place.
Thanks for any help,