hi I am creating an C# Application in which i am accepting values from the user for ex an ID. Depending on that id value i want to generate reports. the problem is that the ID is in many tables and i want data from all that table. can anybody help me out of this. Thanks in advance.