Hello,

I'm having some trouble regarding 'same entries' selection...

I.E. I have the following data

List of Hospitals Machine Used Machine Readings

Hospital A Roche Analyzer 12.65
Hospital B Abbot Analyzer 25.9
Hospital C Vitros Analyzer 1.45
Hospital A Dimension Analyzer 3.6

I've structured a Report Form that contains a drop-down list for selecting the hospital, then upon selection (let's say Hospital B), the machine used and the machine reading will appear in the form (Abbot and 25.9). This works out great for Hospitals B and C..but not with A....Upon selection of the first Hospital A (though in the drop-down list, the other Hospital A is at the bottom, the values for it will appear (Roche and 12.65). However, upon selection of the second Hospital A, the same values appear (First Hospital A values) and not its corresponding data (Dimension and 3.6)....It's like it cannot recognize another entry bearing the same name....

Is there a way around this without renaming the second Hospital A to "Hospital A (2)"? I want it to be named exactly as it is named (which is Hospital A).

Many thanks,

lex