Dear ALL,

I have an issue with SQL queries but it is directly related to ADO.NET objects for our ASP page. I am using C# to create a customer service portal to track telephone calls from our customers. I am creating the database using sqlexpress inside visual studio. I have the following issue:

I have tables: CUSTOMERS, DISTRIBUTOR_NAME, PRODUCT_NAME, CONTROLLER. All have unique IDs (primary key) and another column containing appropriate data.

Inside PRODUCT_INFORMATION (master) table: I have created foreign keys that relate to another column name coming from the above said tables. This is how I have set up the relationships.

Now on my user interface I have fields such as Serial Number, Customer Name, Distributor Name etc...all coming from different tables. I want to populate the information from the database by the click of a button. Secondly I want to insert data first. Could anyone suggest how to insert data when there are multiple tables associated and the ID columns are referencing one master table: "PRODUCT_INFORMATION".

Regards