I have an Oracle table created. The field 'SourceID' which is now a number field in Oracle used to the Primary Key in Access.
Now, I fished thru the forums to get this answer and the only thing that I found was use a sequence and a trigger, which I have no idea how to do.
So, could somebody point me in the right direction by either sending some code (currently i do all adding, updating, etc from my local machine sql statements) and direct some docs.
Thanks in advance.
Click Here to Expand Forum to Full Width