Yes...i know its stupid, but ive deleted a primary key from one table, without realising that this primary key was being used in another (hidden) table. Ive replaced the primary key and redefined the relationships.......any data that was lost can be restored from a backup...
However, when I...
Im not too sure on this, but I think youd have to write a code module using VBA, this script would have to dynamically create a SQL object to create a new relationship link. Im pretty sure you need to use the ADO data connection objects for this task....
peace
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.