Automatic Copy of Data

[weircolin]

Hi

The database I am working on is used for names and addresses and also
for holding information of concerns that the persons have raised. Not
all of the concerns have names attached to them as they can remain
annonymous. The information of the concerns are kept on a different
table from the names and addresses etc.

What I am looking to do is if there are more than one person having the
same issue, rather than inputting the data 150 times, is it possible to
have a text box etc on the form where whatever number is enetered into
it, it will create that many records of the concern?

Thanks

Colin

 

[weircolin]

Hi

Thanks for replying.

Its really for statistical purposes for our organisation. I have a
form where I use the DCount function to count the amount of entries on
a table with specific data.

If we find, where we do, a group of people who are having the same
issue and we want to log it onto our database, we would need to enter
the data lots of times.

Colin

 

[Guest]

Why could you not just create one record that has a field with the number of
times the issue has been reported?
The only reason to have it multiple times is if there are differenecs in the
data in the records.

 

[weircolin]

That would make so much sence! Thank you.

Am I able to add that to the form and table and default it to have a
value of 1 and to apply it to the records that have already been
entered?

Thanks

Colin