Update Field in one table from another

[mitch97144]

I need to update a field within one table based upon a value from another. The problem is after i have setup the relationships the field i need to update will not work.

I have enclosed a screen shot of the relationship and field layout.

I need to update the field" registered with"(tblhistory) using the data within "clubname"(tblplayers) ,this field is updated from clubname(tblclubs) via a relationship.

Please help at a loss.I am not sure whether i need to change the design and relationship side of the database.

 

[quest4]

Have tried an UpDate query?