I agree with Colin here,
You should never have got to this situation in the first place. Looks like you want to continue with this structure but also have a master table? - I don't think its the best way to go with this.
Have your one table which an extra fields distinguishing between the...
I am the Owner of Access Database Solutions Who are a small British organisation that specialise in creating tailor made access applications for your business or personal use. I am a professional access database designer who create professional, modern and user friendly access applications.
I...