TableAdapter Configuration failure
-
Hello world, I'm working with vs 2005 using a typed dataset. I have a table, 'Trans', that has a relationship with 3 different parent tables ('Participants', 'Service Types', & 'Dependents'). In my actual database, Trans has a foreign key called 'serviceTypeID' which is the primary key in ServiceTypes. I just added a relationship with the other tables in visual studio. The problem lies in a column I created named 'service' in the Trans table. It's expression is Parent(FK_Transactions_ServiceTypes).service. This works fine when I run my program but as soon as I try to configure my TransactionsTableAdapter, I get this weird error 'Cannot find the parent relation 'FK_Transactions_ServiceTypes''. Mind you, I didn't rename the relation or even create it. It was done automatically and all the spelling is correct. Like I said, the expression works when I run my program. Anybody else run across this problem?