Thanks pBaldy, never quite used Append Queries before so bare with me. So when I append my new tables I should include the PK from the old table.
OldTable
Id (pk)
Stuff
Things
Somthing
StuffTable
StuffID (Pk)
Stuff
ThingsTable
ThingsID (pk)
Things
Thats a bad example probably, but Do I...