Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / January 2006

Tip: Looking for answers? Try searching our database.

Form Design to enter data

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
monia13 - 25 Jan 2006 21:19 GMT
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?
tina - 26 Jan 2006 02:53 GMT
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?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.