Thanks jdraw.
I was so fixated on "changing" what was being appended I totally missed the fact I can get the transaction type ID number directly! Thanks for your help.
Thanks for the response. The example database is essentially a generic version - just much simpler, i.e. less columns and only one that can be referenced via a separate table. I have updated names as per you comments.
It may be my naivety not understanding exactly what you mean - I was not...
Thanks jdraw. Unfortunately I can't share the data as it is confidential but I have created a simple example of what I am trying to do. I have searched, but I can't find what I am looking for, probably because I am missing something!
Attached is a very simple database. The [Original Data]...
Upfront - I am a newbie to Access (so be gentle!).
I am converting an flat excel file containing sale and purchase transactions to an Access relational database - 12 out of the 37 columns have repeating values. I have created individual tables for these values and the base table of...