Table History

  • Thread starter Thread starter MadCrazyNewbie
  • Start date Start date
M

MadCrazyNewbie

Hey Group,

I have a table with the following Feilds:

MobilePhoneID, PrimaryUser, DepartmentID, CallOptions, MobileNumber, SDC,
GPRSTarrif (Lookup to Another Table), INumber, & ContractStartDate.

I would like when a User Modifys the above table, for example the INumber or
the Primary User for this to have a history, for example the phone is given
to J.Bloggs, but i want to know who previosly had it?

Is this possible?

Anybody got any links or could help?

Many Thanks
MCN
 
create a separate table and store history before you update or delete from
the parent table.
Av.
 
Avnrao,

Many thanks for you post? sorry im a sort of newbie, how would i do that?

Many Thanks
MCN
 
Back
Top