Hello
I am working with a database that is linked to a read-only SQL tbl. The primary key in the SQL tbl is "jobnumber" which is linked one-to-many to "jobnumber" in another Access tbl that has other fields relating to a job number. However, "jobnumber" must be loaded into the other Access tbl in order to create a link where I can update these other fields relating to each job number.
I was wondering if there is a way to have all existing records from the read-only SQL tbl automatically update into the other Access tbl so I don't have to load them. In the relationship, the cascade update check box is dark, not allowing me to check it, thus ruling out this possibility (maybe). Any ideas?
Thanks a lot
Jeremy
I am working with a database that is linked to a read-only SQL tbl. The primary key in the SQL tbl is "jobnumber" which is linked one-to-many to "jobnumber" in another Access tbl that has other fields relating to a job number. However, "jobnumber" must be loaded into the other Access tbl in order to create a link where I can update these other fields relating to each job number.
I was wondering if there is a way to have all existing records from the read-only SQL tbl automatically update into the other Access tbl so I don't have to load them. In the relationship, the cascade update check box is dark, not allowing me to check it, thus ruling out this possibility (maybe). Any ideas?
Thanks a lot
Jeremy
