Help! Problems with showing data from XML

Hi everyone, I don't know how to do something that is very basic in a program like Access, hope somebody can help me out! I'm in trouble if not. Thanks in advance.

Got (let's say) three tables (sellers, houses, buyers) and a fourth one, called operations, which relates them all throuh their ID (sellerID, houseID, buyerID). Each row in the operations table has an operationID, a customerID, a houseID and a buyerID. (An operation is a house being sold by a seller and bought by a buyer).

I need to have a datagrid (or whatever as long as it looks like a table) where I can see: OperationID, HouseName, SellerName, BuyerName. All I can get is seeing the table operations and seeing all its rows which are just numbers (buyerID...) and I need it to select the HouseName from Houses where HouseID is the same as HouseID in table operations.

I'm not using a database, I'm storing my data in a xml document. Got the dataset working correctly.

Thank you very much for all your help

As I read your description, a few things come to mind:

Does your dataset have datarelations between the tables?

Have you attempted to run a select against your dataset?

I will be testing this for the next half hour or so, but this information would be useful in helping to debug your problem.

Hey thanks for your help,

Yes my data base has relations in between the tables.

The thing is that I don't know how to run a select command against a xml database. Something as simple as SELECT Name, Age FROM Customers WHERE erased=false is been impossible for me. I've always worked with php and mysql 'til now.

All I wanna do is something Access does very easily. Thanks again.

Here is an article I found on MSDN that shows how to display data from more than one table in a dataset, in the same DataGrid.
HOW TO: Extend the Windows Form DataGridTextBoxColumn to Display Data From Other Tables by Using Visual Basic .NET