Mebbe use your front-end code to check that at least ONE is NOT NULL, rather than doing it in the db? joel -----Original Message----- From: thelist-admin at lists.evolt.org [mailto:thelist-admin at lists.evolt.org]On Behalf Of rudy Sent: Saturday, November 10, 2001 1:51 PM To: thelist at lists.evolt.org Subject: Re: [thelist] links --> new windows on demand [ . . . ] hi tyme [ . . . ] excellent tip, by the way -- any database designer worthy of the name will know not to make both first and last name mandatory, so i guess the only question is, should the mandatory field be first or last? rudy