ADO.NET INSERT new record that has a foreign key in the table
===

I am fairly new to ADO.NET. I am ok with all the basic INSERT, etc. But now, I have a problem inserting a record into a table that contains a foreign key. I have done some research but am still stuck ... so here goes:

I want to INSERT a new record into a table called Professionals. It has a foreign key mapped to a different table. The FK is WAPublicUserID.

See Image: http://www.binaryjack.com/images/pro_design.png
[I would embed the images but I need 10 reputation points to do this]


When I create a data model, the WAPublicUserID isn't listed in the Properties of the Professional data model. 

See Image: http://www.binaryjack.com/images/fk_pro_wap.png


Therefore, when I try to create an INSERT in my code, the WAPublicUserID field can't be found and I can't insert the record. The WAPublicUserID that I wish to use already exists in the WAPublicUser table that the FK is mapped to. 

See Image: binaryjack. com/images/insertCode.png [I need 10 reputation points to post > 2 hyperlinks, so I broke this address ;-x]


**How do I go about Inserting a new record in the Professionals table that contains a foreign key to an existing record in the WAPublicUser table? Thanks!**

  


 