Hi<BR><BR>Basically I want to hard code some constraints into my Access 2000 database, in the create table statement in SQL?<BR><BR>For example in one of my tables I have 2 fields which are for an ID of something, but this ID cannot be the same - the two must be different.<BR><BR>I have to have it in SQL rather than using any &#039;fancy features&#039; of access 2000. Also some constraints I would like to put in are checking against records etc that are in different relations - is this possible in SQL?<BR><BR>Thanks<BR><BR>Dan