Need Major Form Help!

I'm trying to write a database for work (accounting firm).

I would like to start out with about 5 tables.

1) Client Information: Would include name, phone, etc and a
field that stated what kind of client (F/S or Tax).

2) F/S Tracking: Would include name and date in, date started,etc.

3) Tax Tracking: Would include name and date in, completed, submitted to gov.

4) Employees: the names of the firms employees.

5) Job Jar: Would include employee name, and which client(s) they should work on.

What I need help with is the data entry form for the Client information.
I would like to have it so I only enter the Client Name once, and only once, and not only
will it update the client name field in the Client Information table, but the corresponding field in
the F/S Tracking table (if the client type in the Client information table = "F/S") and the Tax Tracking
table (if the client type in the Client information table = "tax").

I have tried to use an update query that runs when the Client information form is closed but I think I might be doing it wrong, because I always get the message that 0 (ZERO) records will be updated.

Any help would be appreciated.

Thanks
Mitch Miller