Table Design Question

[NotVeryTechie]

Hi there, hope you can help!

I have to design a database in which one of the activities required is to ensure that the information was sent to a number of people. If it was not sent, it should be done. From the user's point of view, they need to be reminded to do this but the completion of this information should be really quick and easy.

So initially I had in my main table the following fields (there are a whole lot more, including an auto number primary key, these are the ones I am struggling with):

Copied to SJ - Y/N
Copied to GD - Y/N
Copied to SG - Y/N

It was pointed out to me that this is very bad table design. If any of these people leave I will have to go into the design of the database to change the initials. So I am trying now to work out how to do this. The idea was to have those three fields appear on the form and the user can just tick them. Is there another, elegant way to do this that is also good table design?

 

[MSAccessRookie]

You might be better off if you made two tables instead of just the one.

One of the tables could have a Primary Key (AutoNumber) and necessary user information such as User ID, Name, etc.

The second table would have a Primary Key (AutoNumber) and contain at least a column to store the primary keys associated with people (from the first table), and a flag to indicate if they were contacted. This type of construct could allow you to have more than one flag for each user if the need arises in the future.

I know this description is not very detailed, but I believe it could get you pointed in the right direction

 

[NotVeryTechie]

Thanks for that. What I can't work out is how to put it onto a form if I have it in a different table. I can't for the life of me get sub forms to work! Just about banging my head on the desk at this stage.