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
> 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...
[quoted text clipped - 5 lines]
> 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?