How do I identify multiple rows with the same value in a foreign key field?

[maniesh]

I have two tables:
*Transaction Record
*Account Details

Account details table has the field "Account Number" as its primary key.

Transaction record has the field "transactio n number" as its primary key and "account number" as its foreign key.

This is a table created in ms access. I am creating a program in vb.net to maintain this database.

When i try to find rows using an oledb_data_adap ter, an error occurs stating that there are muliple values.

i think this is due to the fact that the records in the transaction details table are being selected by the account number. Many records in the transaction details table can have the same account number.

i need a coding to help me display the most recent 10 transaction records of one account number, one after the other.

P.S: transaction record table also contains "transactio n date" field.

[Joseph Martell]

Can you post some code so we can get a better idea of what you're doing?