Form Design to enter data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I can't find my original post and noone replied to it so I'm going to try
again... I apologize in advance if I offend anyone by reposting...

I want to design a form where users will enter comments per Client ID -
project ID (could be mulitplie projects IDs). I don't want the user to
retype the same comments if it applies to multiple project IDs. User will
enter client ID and projectd ID(s) and comments. I anticipate that the unique
record in the table will be client id - project id. How can I acomplish it
without having the user to enter the same comment multiplie times?
 
recommend two tables:

tblComments
CommentID (primary key)
ClientID (foreign key from tblClients)
Comments

tblCommentProjects
ComProjID (primary key)
CommentID (foreign key from tblComments)
ProjectID (foreign key from tblProjects)

if a comments record is about one project, then tblComments will have one
record, and tblCommentProjects will have one record linked to the
tblComments record. if a comments record is about five projects, then
tblComments will have one record, and tblCommentProjects will have five
records linked to the tblComments record.

you can use a standard mainform/subform setup for data entry, with the main
form bound to tblComments, and the subform bound to tblCommentProjects, with
a combo box in the subform bound to ProjectID, and the combo box RowSource
based on tblProjects.

your table names will probably be somewhat different, but the above should
give you the gist of the setup.

hth
 
Back
Top