Want to display entry relating to an ID of table

[ElBlues]

I am creating an updatable Football league website:

I have a table called Divisions with two columns: division_ID and Division, where Division is the label and division_ID is the value.
I have another table called Teams with the division_ID value, how do I display the Division label on a page with the Teams data?

I have a relationship of one to many on the Division_ID field, do I need to create a query in Access to display the labels when it gives a value? How do I do this?

 

[lespaul]

SELECT TeamID, TeamName, Division FROM tblTeam INNER JOIN tblDivisions on tblTeam.DIvisonID = tblDivisions.DivisionID

this query will return the TeamID and TeamName from the tblTeams and the Division NAME from the tblDivisions.

Leslie