By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,656 Members | 920 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,656 IT Pros & Developers. It's quick & easy.

Data taken from one record and placed into another record

P: n/a
Jon
I have a database that mysteriously takes information from fields in
one clients record and places it into the fields of another client
record. This happens sporadically. I end up finding data all over the
place.

Has anyone experience this? Is there a way to fix the problem
Nov 12 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
Jon wrote:
I have a database that mysteriously takes information from fields in
one clients record and places it into the fields of another client
record. This happens sporadically. I end up finding data all over the
place.

Has anyone experience this? Is there a way to fix the problem


At a guess it has something to do with how the data is entered. You'd
have to give more info:)
--
regards,

Bradley
Nov 12 '05 #2

P: n/a
Just a guess, but if you've setup relationships and you have Cascade Update
Related Fields selected you may get the results you describe.

--
Reggie

www.smittysinet.com
----------
"Bradley" <br*****@REMOVETHIScomcen.com.au> wrote in message
news:5i*****************@news-server.bigpond.net.au...
Jon wrote:
I have a database that mysteriously takes information from fields in
one clients record and places it into the fields of another client
record. This happens sporadically. I end up finding data all over the
place.

Has anyone experience this? Is there a way to fix the problem


At a guess it has something to do with how the data is entered. You'd
have to give more info:)
--
regards,

Bradley

Nov 12 '05 #3

P: n/a
Jon
"Bradley" <br*****@REMOVETHIScomcen.com.au> wrote in message news:<5i*****************@news-server.bigpond.net.au>...
Jon wrote:
I have a database that mysteriously takes information from fields in
one clients record and places it into the fields of another client
record. This happens sporadically. I end up finding data all over the
place.

Has anyone experience this? Is there a way to fix the problem


At a guess it has something to do with how the data is entered. You'd
have to give more info:)


In this database you can input information into a field and on the
selection of another field, notice that other fields have magically
brought information from other records into it. These is no link to
bring other information into the current record.

I am led to believe that information is being transferred
automatically to and from adjacent records without request. This seems
to be the main problem that exists.
Nov 12 '05 #4

P: n/a
Then you need to see if there is code running behind the form triggered by
you changing fields/moving focus, that runs and sets the value of the
so-called fields. Also check the table(s) that the form is based on to see
if there are default values set during design time. Open the table in
design view to check. Other then that I've never heard of data magically
appearing in records from adjacent records. One other thing you can try is
open the table directly and try changing/adding records and see if you get
the same results. If so it's default values set in the table or
relationships. One other thing I forgot to mention, if this is a multi user
database, maybe someone else is changing the data.

--
Reggie

www.smittysinet.com
----------
"Jon" <ca*****@hotmail.com> wrote in message
news:da**************************@posting.google.c om...
"Bradley" <br*****@REMOVETHIScomcen.com.au> wrote in message

news:<5i*****************@news-server.bigpond.net.au>...
Jon wrote:
I have a database that mysteriously takes information from fields in
one clients record and places it into the fields of another client
record. This happens sporadically. I end up finding data all over the
place.

Has anyone experience this? Is there a way to fix the problem


At a guess it has something to do with how the data is entered. You'd
have to give more info:)


In this database you can input information into a field and on the
selection of another field, notice that other fields have magically
brought information from other records into it. These is no link to
bring other information into the current record.

I am led to believe that information is being transferred
automatically to and from adjacent records without request. This seems
to be the main problem that exists.

Nov 12 '05 #5

P: n/a
Jon,

Please don't multipost - get the same thread working independently in
several newsgroups. In stead, crosspost into all of the relevant groups.
That way an answer in one group will appear in that same thread in all
groups.

I'm aware of at least two groups with this same, isolated, thread working.
I'll add the other thread here. Unfortunately that will yield two threads
working in the other group.

HTH
--
-Larry-
--

"Bradley" <br*****@REMOVETHIScomcen.com.au> wrote in message
news:5i*****************@news-server.bigpond.net.au...
Jon wrote:
I have a database that mysteriously takes information from fields in
one clients record and places it into the fields of another client
record. This happens sporadically. I end up finding data all over the
place.

Has anyone experience this? Is there a way to fix the problem


At a guess it has something to do with how the data is entered. You'd
have to give more info:)
--
regards,

Bradley

Nov 12 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.