Here is what I have
Table 1: (Accounts Activities)
Table 2: (Account 1)
TransActionID : Autonumber
what I am looking at is to create in Table1 a record everytime a record is created in Table2 and keep that record updated/linked to TransactionAmount of Table2
for example if I add in Table 2 an entry for $10 I want to create a corresponding record in Table1 linked to it and if that amount is updated in Table 2 the record in Table 1 shld follow
Is there anyway to do that in Access?