data relationships - love or hate

Hi All,

i am having a problem with the relationships in my app and it is driving me nuts. I have a SQL Server database, within this i have 2 tables linked using pk and fk this works fine when i use a standard query something like:

select * from table1, table2

where table1.PK_ID = table2.PK_ID

correct results here.

This is where the problem starts, i have now created a form to do the same thing. Parent details in single controls and the child details within a grid below.

However when i make the connection between the primary key and the foriegn key within the dataset schema to join the two tables together within the form i get the error that i have violated primary key constraints (when running the app).

Any ideas appreciated.

There doesn't seem to be enough info to answer the question. Is there any chance you're trying to bind to many rows of data to a single control?

I personally don't use relationships in the database.