Despair! Linked tables and Datagrid

Hi;

I have the following situation:

An Access DB with 3 tables:
-Products(ID, ProductsName);
-Brands(ID, BrandName);
-Relation(ProductID, Flavour, BrandID, Colour, InternalRef, Price)

I want to display the Relation table, in a datagrid, according to some search criteria given by the user, having the fields Product and Brand replaced by their corresponding description for values in the other two tables.

Example:
ProductID = 3 in the relation table corresponds to 3,Syrup in the Products table. Syrup should appear in the Product column of the datagrid and not 3, as it currently does.

I have managed to create the connection, dataset, and relations in the application and the search criteria works fine... The only problem is that the datagrid always shows the numerid value of the ProductID field in the relations table and not the description available in the Products table.
The same is true for Brands.

How can I accomplish this?
I have this assignment in school and this is the only thing preventing me from completing it.

Thanks for any help.

Solved it.