Here’s the scenario. I have four tables, all with client-related data, for
instance, first name, last name, phone, address, notes about conversations
and discussions with each client, and a couple other fields. I have a PK on
each Table, with AutoNumber for the Data Type. I added one more table, Names
Table. I am thinking of creating four queries, each including the client
data from each table and I will link each of these four tables to the Names
Table. This will be a Search Query, so I can search for client names, and
see related records. Then I am thinking of creating an Update Query so I an
add data to the Notes filed. Does this make sense? Is this the best way to
set up this kind of DB?

I do have one more specific question. I linked the Names Table to each of
the four client-related Tables. I enforced referential Integrity, but I was
not able to check Cascade Update and I wasn’t able to check Cascade Delete.
Why can I not check cascade update or cascade delete?

Basically, I want to organize what is now four Excel files. Also, I want to
be able to collect and update conversations and discussions and interactions
with a given client so my team and I can know more about what the clients
like and don’t like as we prepare to contact each client (and maybe make
updates based on the conversation with the client).

I welcome any/all advice.

Thanks!
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.