I'm building a database editing application. So far everything is done but the relationships. I'm using the GetSchemaTable() method of the DataReader to dynamically add all the necessary controls for each database field. However, I also want to generate look-up dropdown menus for foreign key relationships on the fly. Is there a workable way to discover relationships in SQL? Thanks.