changes to combo box entry to cascade thru table

[Guest]

i have a table of information about people, and one of the fields is 'team
name'. this is a combo box that gets its data from another table that can be
edited by the user. if the user makes a change to a team name, can i have it
so that change is made thru all the entries that are the same in the original
table? it seems like this should be fairly simple but i can;t figure it out,
so i'd be grateful for any help

 

[Guest]

this is what i thought, but i get the error "can't create this relationship
and enforce referential integrity", and my knowledge is too limited to know
why...

 

[Guest]

ah, i think that must be my problem - somewhere in there must be a record
that doesn't exactly match up. thanks very much, i knew it wouldn't be too
tricky ;-)