About relations and foreign constraints

More of a general ADO question but it does have an impact with the Essential Grid. Are there better results when not using a SQL DB foreign constraint versus explicitly defining it within code at runtime? I seem to have nothing but FK or DB Concurrency problems with a simple master-detail grid using a dataset. The underlying SQL 2000 db has a FK constraints defined as well as the master table using a JOIN with detail table (in order to get a total value of all related detail records). I keep fixing/breaking the code, so before I start playing around again, I''d thought I''d ask the pros. Thank you. JV

Loader.
Up arrow icon