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...