how do I get the values of foreign keys, that I have used within a database
example Main_DB Main_Table PK title_id 3 FK manufacturer_id 5 FK category_id 4 Manufacturer_Table PK manufacturer_id 5 description man. description Categories_Table PK category_id 4 description cat. description my goal is to get choice 3 's "man. description" and "cat description" I am probably over looking an obvious answer here, but am making the call to the bullpen anyway. Thank you in advance for your help. **DAN**