Looks like you have just about got it all coverd,.

I am working on a datagrid right now, and i have found that formating...

I was not aware that a table and a proc could not have the same name,

It was a proc that i named ProductRestrictions.

Thank You,

Erik...

Do you have a good recomendation for a relational database book? and or videos?

I have a Prodcut table that has a FK (ProductID) in a ProdcutRestrictions table. This ProdcutRestrictions Table need to have a uniquekey going to another table called (LadderSpacing)

How do i connect...

Im not worthy!

Like Arnold ,.  (I'll be back)

Nevermind I see how to run this.

The only part i am not understanding is the @newProductID. I realize that it is a input parameter, i am not getting how to link it to a column.

Erik...

Thank you very much...

Erik...

I forgot something, here is a link to where i have a pic of my tables and the one on the far right is the one in question. IF you;ll...

Colt 45 - the original point and click interface  <-- Thats funny...

Thanks...

I am 7 days a week right now.

OK,

This has been a great day! I have a MUCH better (And i did not before today)understanding about how relationships work, what a great picture has been painted.

You guys...

I see, the Categories table is binding to ever CategoriesProductID in the Product table.

The way that i thought that i was setting this up was to do right the

Every where i have a duplicate CategoriesProductID (In the Product table) that repersents another result.