so it isn't required? I used to think primary and foreign keys was just something that you call a colum, but never had to specify. I didn't know there was a difference in how the database functions if it actually knows that a column is a primary or foriegn key. I've always just used the regular columns as the keys... what's the difference in how it treats the column? -trevor
When you're trying to screw it up. That's the primary difference. If you were to leave a primary key field blank, or try to insert data into a foreign key field without that value existing in the related table, it'll choke, instead of letting you mess it up.<BR><BR>No, they aren't required...They just provide an extra level of validation.