What is the best way to create a relationship that allows for values from one file to be displayed in another file. I don't want them to be associated with an ID or anything. For example, I need to define a relationship where I can create a drop down list that is generated from field values from another file and in order to make it useful to me, I would like another field to be automatically filled in depending on what was chosen from the drop down and this is where I need a Relationship. I just define two of any fields and it seems to work but I am not sure if this is best practice. Hope this makes sense. Thank you.

On another note... I have a field who's values are the records of another database and am seeing that records with the same values are not being shown, yet I need them to be shown because there is a date value associated with that record that is different and important. How do I have the relationship show duplicate records?