Hi,
I have 2 tables (A & B). After Table B is saved the data in table A should be deleted based on column value in Table B.
Eg: Delete rows in both the tables if (Table A [Column C] =Table B [Column C]). The data in both the tables are different except for column C. Any help on this or a link to similar app would be of great help.
If you search in the community for things like:
You should find several good posts about how to have one record affect another on another table.
In your case, instead of doing an update or whatever, you need to call the delete action.
User | Count |
---|---|
37 | |
31 | |
29 | |
22 | |
18 |