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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|