Re: CHECK() Constraint on Column Using Lookup Table

On Tue, 1 May 2007, Joshua D. Drake wrote:

> You could use a function, or a foreign key.

Josh,

   The foreign key approach will do nicely.

Thanks,

Rich

--
Richard B. Shepard, Ph.D.               |    The Environmental Permitting
Applied Ecosystem Services, Inc.        |          Accelerator(TM)
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863