Audit Trail

[zburns]

I'm trying to incorporate the Audit Trail as shown by Martin Green http://www.fontstuff.com/access/acctut21.htm
The audit table is working fine but I'm having a problem matching up the audit recordID field with the underlying table ID field in a meaningful way. How do I join both tables in a query so that I can add a field from the underlying table to help identify the record.

[June7]

What is the recordID field? If it is an autonumber then cannot link on this field. If this is a number field for saving the ID from the original table record, should be a simple join in query. The original ID field and the audit table RecordID field must be the same data type for linking in query (autonumber PK links to number FK).

[zburns]

The original ID field is autonumber and audit table recordID field type was set up as text as recommended and that is where the type mismatch occurs. Is there any way around this?

[June7]

I suppose Martin recommends text to handle any type of original primary key. However, cannot join datasets on different data types. Possible options:

1. if you know the audit field will always receive a number value from a number type primary key, then set the field as number type, no idea what adjustment might be needed in code

2. build a query of the original dataset that casts the PK to a text type then join that query to the audit table - Format(ID, "@")

[zburns]

Worked out fine. Thanks