title: problem with subordinate subjects within a data table
body: <p>I'm creating a database for a small training organisation and trying to resolve a problem with the following table</p>
  
  <p>Trainees</p>
  
  <p>Trainees ID , Trainees First, Trainees Last, Order Name (optional), Trainees Email,
     Trainees HomeTel, Trainees Mob, Trainees StrAddress, Trainees City,
     Trainees PostCode, HP, Mod Training, Mailing list</p>
  
  <p>The field HP stand for Health Professionals and I need to distinguish the group within the table. They also have the option to do either a modular training, or normal.
  Should I create a subset table in this case, or is there another solution?</p>
  
  <p>Another issue is related to Mailing list. I need to flag whether they want to be on subscribers list. Is it ok to have the field repeated in other tables such as customers. I'm not sure this will be good for data integrity.</p>
  
  <p>Any help will be much appreciated,
  Zan</p>