How do I automate additional records in other related tables?

Hello all,

I have quite a few tables in my database and they all are related by a
client code. Until now the codes have been entered into each related table as
needed but I would like all the related tables to automatically create a
record with the client code every time a new client code is created in the
primary table.

I'm a "self-taught" user of Access and am not sure if this is even possible.
Any help would be appreciated.

Thanks in advance.