A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Changing values



 
 
Thread Tools Display Modes
  #1  
Old May 29th, 2010, 12:43 AM posted to microsoft.public.access.tablesdbdesign
Jeffrey Marks
external usenet poster
 
Posts: 4
Default Changing values

I have a many-to-many relationship between Outings (with a primary key
of EventID) and Members (with a primary key of MemberID). There is a
table that ties the 2 together, tblAttendees that holds the EventID
and MemberID.

Recently, the MemberID of the tblAttendees changed on 2 records in the
table. I can see the before in an earlier version of the database and
can see what changed in the current database. It appears to be the
first event in the tblAttendee which is changing when a new member is
added. Am I doing something wrong or ??
  #2  
Old May 29th, 2010, 02:13 AM posted to microsoft.public.access.tablesdbdesign
PieterLinden via AccessMonster.com
external usenet poster
 
Posts: 307
Default Changing values

Jeffrey Marks wrote:
I have a many-to-many relationship between Outings (with a primary key
of EventID) and Members (with a primary key of MemberID). There is a
table that ties the 2 together, tblAttendees that holds the EventID
and MemberID.

Recently, the MemberID of the tblAttendees changed on 2 records in the
table. I can see the before in an earlier version of the database and
can see what changed in the current database. It appears to be the
first event in the tblAttendee which is changing when a new member is
added. Am I doing something wrong or ??


Not something I have ever seen. How are you entering your records? Do you
have Forms based on Outings and Members, each with a subform based on
Attendee? Do you have any code behind your forms? Something here just
doesn't sound right.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/201005/1

  #3  
Old May 29th, 2010, 04:49 AM posted to microsoft.public.access.tablesdbdesign
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Changing values

On Fri, 28 May 2010 16:43:47 -0700 (PDT), Jeffrey Marks
wrote:

I have a many-to-many relationship between Outings (with a primary key
of EventID) and Members (with a primary key of MemberID). There is a
table that ties the 2 together, tblAttendees that holds the EventID
and MemberID.

Recently, the MemberID of the tblAttendees changed on 2 records in the
table. I can see the before in an earlier version of the database and
can see what changed in the current database. It appears to be the
first event in the tblAttendee which is changing when a new member is
added. Am I doing something wrong or ??


One way this can happen is if you have a Combo Box on a form with the purpose
of selecting which record to view; such a combo *should* be Unbound (nothing
in its control source). If you use a Bound combo, it will overwrite the
Control Source with whatever ID is selected when the user tries to search.
--

John W. Vinson [MVP]
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:07 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.