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