I would: dogs.dogfood.requires.requires = IS_NULL_OR(IS_IN_DB(db, db.dogfood.id))
...or something like that. The above is untested... On Tuesday, July 3, 2012 2:17:53 PM UTC-5, joe wrote: > > I have a table called dogs, and a table called dog food. In the dogs > table, the field food is a foreign key referencing the dog food table. Is > there any way to make the field in dogs optional? (I have already tried > setting default = none, and required = false, both failed). Thanks for > your help!
