Forms completion

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rhonda - 17 Dec 2007 20:59 GMT

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?

Reply to this Message

mscertified - 17 Dec 2007 21:13 GMT

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

> 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
[quoted text clipped - 3 lines]
> or work around where that will replicate for the user if they click the add
> new record after they enter the first entry?

Reply to this Message

John W. Vinson - 18 Dec 2007 00:17 GMT

>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
[quoted text clipped - 3 lines]
>or work around where that will replicate for the user if they click the add
>new record after they enter the first entry?

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]

Reply to this Message