This topic is locked

using the audit and keys feature

11/20/2017 3:40:52 PM
PHPRunner General questions
S
swanside author

Hi all.

I have an audit table and I have set it to audit the jobs on add and edit. The jobs table has Job_No as its primary key, is there a way I can get the audit table to become a chiled table from using the Job_No in the keys from the description?
So the description in the audit table has this for an example?

---Keys

Job_No : 1052798

---Fields

Logged_By [new]: BARRY SMITH

Order_Date [new]: 2017-11-20 16:34:05

File_No [new]: DL 2211

customerPK [new]: 1125

locationPK [new]: 1315

CustomerRef [new]: CM 1457

CallerName [new]: 242


Cheers

Paul.

H
headingwest 11/20/2017

Can you do 2 new views:

  • vw_job
  • vw_jobaudit
    Then set up the views as master/detail

S
swanside author 11/21/2017



Can you do 2 new views:

  • vw_job
  • vw_jobaudit
    Then set up the views as master/detail


I can, but I dont see how I can setup the Job_No as a key as when the audit field contains description and the job_no is part of the description and not an actual field?