DAPs - picking up wrong field

[firthk]

I am trying to set up a DAP based on a table & it all works fine but when i select a certain field (horse_id1) from the drop down list of fields available it returns the data from another field (horse_id) which is held in a different table ?? is it something to do with relationships - any help would be much appreciated
thaNKS