c# - UPDATE a Table when another has been modified -
c# - UPDATE a Table when another has been modified -
i have 2 tables in access database. (sql examples fine).
the first table table called reports.
the fields :-
id reportname reporttypethe sec table template, user store host of reports. user modifies template table each week. below fields :-
id userid reportname reporttype scheduleddate completed assignedbyi have in code working, overlooked vital.
i need reflect changes user may create study table, i.e, edit reports name, template table, instance of edited report, shows new name.
i'm struggling work out how can this?
any help appreciated, doesn't have exact code, more method.
only works .adp project, should able using trigger.
something
create <trigger_name> on study ....
c# database ado.net oledb
Comments
Post a Comment