Ken...you are a genius! Obviously I was doing something terribly wrong with
the Primary and Foreign keys because your guided assistance was
successful!!!! I now have the 3 tables that we were trying to achieve with
the Capacities Table showing the Officers, Shareholders and Directors
together! So now I will attempt to make my forms as per your instruction
previously. Is there anything I should do or tweak before setting out on the
form tasks? I really really appreciate your assistance and especially your
explanations..it starts to make a little more sense. I don't do code but
with all of this, I was at least able to understand what we were trying to
achieve. I will copy your instructions now for my forms and will let you
know. THANKS AGAIN!!!