G Gary Walter May 28, 2004 #2 Hi Jonas, MSDN website had an excellent series of articles by Acey James Bunch that I think will help. The article "Fundamental Microsoft Jet SQL for Access 2000" discusses "constraints as the way to establish relationships between tables." http://msdn.microsoft.com/library/en-us/dnacc2k/html/acfundsql.asp "Intermediate Microsoft Jet SQL for Access 2000" discusses how "Constraints can also be used to establish primary keys and referential integrity, and to restrict values that can be inserted into a field." http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/acintsql.asp Good luck, Gary Walter
Hi Jonas, MSDN website had an excellent series of articles by Acey James Bunch that I think will help. The article "Fundamental Microsoft Jet SQL for Access 2000" discusses "constraints as the way to establish relationships between tables." http://msdn.microsoft.com/library/en-us/dnacc2k/html/acfundsql.asp "Intermediate Microsoft Jet SQL for Access 2000" discusses how "Constraints can also be used to establish primary keys and referential integrity, and to restrict values that can be inserted into a field." http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/acintsql.asp Good luck, Gary Walter
