can't set a null-constraint on foreign key columns

mindplay · Post by **mindplay** » Wed 28 Dec 2011 19:13

It appears there is no way to control NOT/NULL for foreign keys?

To be clear: in a one-to-many relationship, I can't find an option that will make the foreign key column NOT NULL in the generated schema.

Am I missing something?

Shalex · Post by **Shalex** » Thu 29 Dec 2011 10:09

Please press the [...] button in column editor to set all column attributes.

mindplay · Post by **mindplay** » Thu 29 Dec 2011 16:21

Found it, thanks!

To be clear: I double-click the association to open the association-editor, then select the column in the "columns mapping" list below, and then the "..." button reveals.

(perhaps consider making this visible on the property-grid somehow?)

Helen · Post by **Helen** » Tue 03 Jan 2012 15:04

Thank you for your suggestion.
We will investigate the possibility of implementing this functionality. But there is no timeframe at the moment.