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.