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.