data relationships - love or hate

[dagoose]

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.

[MrGTI]

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.