Thread: Changing values
View Single Post
  #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