I have two tables, one is called
userprofile the other is called users
Everytime a new record is inserted into userprofile I want to update the table 'users'
this a mockup structure
department ( want to update this field on every insert from the userprofiletable)
As now , the table userprofile matches users on uid = id , there is no contratins, or foreign keys, which I probably would need, not sure,,,
How can I do this.? Thanks in advance......