Scott,
Glad you figured it out.
---J the "mindwalker"
>Jason (you, too Paul!),
>
>Thank you so much for walking my mind through this problem!
>
>It was a combination of things. The foreign key value was the first hurdle, thanks for that solution. Also, I had switched to the NEWID() method BEFORE I fixed the foreign key problem and it did not work, so I changed back to AutoInc Integer primary key field. Once I got the foreign key problem resolved, I switched back to the NEWID() method of generating a key and viola...problems solved!
>
>Life is good and I certainly appreciate all the time and effort you guys are putting into answering my posts. It's because of you that this is an awesome site!
>
>Thanks again!