Hey,
Basically I have a linked table linked using one to one relationship with a single table I have created in access. The problem is when a new jobID is entered in the external table, the jobID must be replecated in my access table. This should be a straight foward case of using the cascade update for the relationship but this is blanked out. The table can only be a one to one so I was wondering if there was anyway of coding this automatic update of data? and where would I place the code? Could I use a trigger? (don't know much about these)
Cheers for any help.
Sam
Basically I have a linked table linked using one to one relationship with a single table I have created in access. The problem is when a new jobID is entered in the external table, the jobID must be replecated in my access table. This should be a straight foward case of using the cascade update for the relationship but this is blanked out. The table can only be a one to one so I was wondering if there was anyway of coding this automatic update of data? and where would I place the code? Could I use a trigger? (don't know much about these)
Cheers for any help.
Sam