I am currently integrating Maximizer with a web aplication writen in ASP i'm using ODBC and SQL. I'm adding an oppertunity to the maximizer, i also need to add a UDF value at the same time. I add the rec to the oppertunity table, and then need to add a record to the UDF field (V_Contact_No) of the table V_Contact_No, these two tables need to be linked via the Opp_Id field.

Any ideas how can i extract the Opp_Id from the oppertunitys table?