Changing values

J

Jeffrey Marks

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 ??
 
J

John W. Vinson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pimary key when consolidated 5
Combo box question on a form 3
Combine 2 tables in Access 2000 1
Design and Relationships 2
Combo box updates on a form 1
Change to form 3
Acronym 1
Memo fields in a query 4

Top