> I have a table with a Foreign Key that references a > Primary Key in another table. I was just surprised > to see that the Foreign Key field can be changed to > null. > > Is a not null rule the appropriate way to ensure the > field is valid?
Yes, it is certainly true in R:Base and I believe it is specified in SQL that foreign keys are allowed to have a NULL value. You can use a further NOT NULL constraint if you want to require them to always be filled in. -- Larry __________________________________________________ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1
