D
djc
Hello all,
I have a utility (not really big enough for me to call an app) that I use to
manage an area of a database. Its done in access2002. Its an mdb file with 2
jet-conntected ODBC tables from an SQL2000 server. The setup is very simple.
1 table, lets say called customers, has 1 record for each customer...
cutomerID field as key and of course some other non-key fields as well. The
other table, called products, has just 2 fields, customerID and productID. I
want to define a 1 to many relationship between the two so I can use
cascading updates and deletes however upon defining the relationship the
check boxes to enforce referential integrity and cascading updates/deletes
are grayed out (disabled).
Am I not supposed to be able to use this with my setup because they are ODBC
connected or something?
any help is appreciated.
Thanks.
I have a utility (not really big enough for me to call an app) that I use to
manage an area of a database. Its done in access2002. Its an mdb file with 2
jet-conntected ODBC tables from an SQL2000 server. The setup is very simple.
1 table, lets say called customers, has 1 record for each customer...
cutomerID field as key and of course some other non-key fields as well. The
other table, called products, has just 2 fields, customerID and productID. I
want to define a 1 to many relationship between the two so I can use
cascading updates and deletes however upon defining the relationship the
check boxes to enforce referential integrity and cascading updates/deletes
are grayed out (disabled).
Am I not supposed to be able to use this with my setup because they are ODBC
connected or something?
any help is appreciated.
Thanks.