If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
creating relations with sql
Hi how can I create relations between tables with sql ? Regards Jonas |
#2
|
|||
|
|||
creating relations with sql
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.../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/de...l/acintsql.asp Good luck, Gary Walter "Jonas" wrote in message ... Hi how can I create relations between tables with sql ? Regards Jonas |
#3
|
|||
|
|||
creating relations with sql
Hi Gary,
thanks so much for your help ! Regards Jonas "Gary Walter" schrieb im Newsbeitrag ... 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.../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/de...l/acintsql.asp Good luck, Gary Walter "Jonas" wrote in message ... Hi how can I create relations between tables with sql ? Regards Jonas |
Thread Tools | |
Display Modes | |
|
|