I have 3 tables, one to many join.
TblEmployer,(Main Table)
EmployerID
EmployerName
Address
etc.....
TblServices
EmployerID
ContactDate
ServiceType
ServiceCode
TblStatus
EmployerID
Status(Active or Inactive)
DateEstablished
DateClosed
ClosureReason
If an Employer has not had any services in 12 months I need the [Status] changed to Inactive ,[DateClosed]to current date and [ClosureReason] to say "No Activity for 1 year".
If possible, Executed through a command button.
TblEmployer,(Main Table)
EmployerID
EmployerName
Address
etc.....
TblServices
EmployerID
ContactDate
ServiceType
ServiceCode
TblStatus
EmployerID
Status(Active or Inactive)
DateEstablished
DateClosed
ClosureReason
If an Employer has not had any services in 12 months I need the [Status] changed to Inactive ,[DateClosed]to current date and [ClosureReason] to say "No Activity for 1 year".
If possible, Executed through a command button.