Hi everyone,
I've just started using the 'Diagrams' section of SQL Enterprise Manager. I'm completely new to it, so this is probably a very basic question.
I've set all the relationships between tables (linking pks to fks across tables), but some of these relationships are optional (i.e. can be left blank. Sorry, I'm sure there's probably a proper technical word for this kind of thing). SQL complains if I try to leave such fields blank (null) when inserting records (incidentally, I'm doing this from a VFP frontend).
I see I could just clear the "Enforce Relationship for INSERTS and UPDATES" checkbox on the relationship properties window - but is this the correct thing to do for this situation? Are there any other major considerations I should be concerned about? Sorry if this is a bit general...
I've just started using the 'Diagrams' section of SQL Enterprise Manager. I'm completely new to it, so this is probably a very basic question.
I've set all the relationships between tables (linking pks to fks across tables), but some of these relationships are optional (i.e. can be left blank. Sorry, I'm sure there's probably a proper technical word for this kind of thing). SQL complains if I try to leave such fields blank (null) when inserting records (incidentally, I'm doing this from a VFP frontend).
I see I could just clear the "Enforce Relationship for INSERTS and UPDATES" checkbox on the relationship properties window - but is this the correct thing to do for this situation? Are there any other major considerations I should be concerned about? Sorry if this is a bit general...