Filtering data in Access 2000

Hi,

Can anyone explain in detail, how a drop down list in access 2000 can be sorted and filtered, so that the data related to it is shown in the adjacent colums or rows?

Thank you,
Lalitha