Forms completion

R

Rhonda

Here is a question for you, we have a pretty simple database to gather
comments and suggestions from users for improvement on things around our
office, It is a form entry, a suggestion that was given is when users want to
enter multiple suggestions they are having to re-enter the header section of
the form (Basics of name and contact information) repeatedly, is there a code
or work around where that will replicate for the user if they click the add
new record after they enter the first entry?
 
M

mscertified

Are you storing this information in every row of the table?
The way it should work is, when the user first logs on it gathers their
identification data and saves it in a users table. Then it goes to the
suggestion form and collects suggestions. Only the id of the user should be
stored with the suggestions not the whole data.

-Dorian
 
J

John W. Vinson

Here is a question for you, we have a pretty simple database to gather
comments and suggestions from users for improvement on things around our
office, It is a form entry, a suggestion that was given is when users want to
enter multiple suggestions they are having to re-enter the header section of
the form (Basics of name and contact information) repeatedly, is there a code
or work around where that will replicate for the user if they click the add
new record after they enter the first entry?
Click to expand...

It sounds like you need two tables in a one to many relationship - a header
table, related one to many to a suggestions table. You could use a Form based
on the former with a Subform based on the latter, linked by the unique ID of
the header table.

John W. Vinson [MVP]
 
Top