Updating value in another table

[nostr4d4m]

Hej,

I am trying to create a way to filter my Companies by LastContacted which is date and before was entered manualy.



I want it to be set automaticaly each time new entry in T_ActivitiyNotes is created.


P.S. One Company has many activities. Each activity has many Notes.

I need to update variable LastContacted in table Companies. Value for LastContacted should come from table T_ActivityNote field DateCreated (it has standartvalue =now() ). Each time new note is created companies LastContacted field should be updated too.

How can i do that? I cant find the way to transfer data.

[AccessPonderer]

If you were using a better SQL server you'd use triggers, as far as I know access doesn't have that functionality.

If you're taking the data from a form, then you need to add an UPDATE query that updates the companies table when you insert a new note into T_ActivityNotes. Is there any reason why this wouldn't work?

[nostr4d4m]

It actualy worked. Done it in SQL. Thanks!