Combo Box Problem

I am trying to use a combo box to select from a list in one table and brings up the data from another related table. Both the related fields are a text value. two tables are: Equipment List EquipID (Primary Key) Location Description Repair Request EquipID (Relationship) RequestNo (Primary Key) DateOfRequest WorkRequired CompletedDate Preferablely I would like to do this using ado controls or code but if it is much easier with combo or datacombo boxes I will go that way. The database is currently in an SQL Server Database but I can use an access database if no other option. This is a loud cry for help has I am now coming towards the completion date with completing quite a few forms. Thanks Tony. ## Platform windows 2000