I'm looking for the best way to code this. I'm having a brain bubble today. Here is the scenario: I have a list of records with 2 buttons in the last column for edit and delete. The "userid" is passed as a parameter with the click of these buttons. When I click edit, it brings up a form with some pre-populated data with exception to 1 description field. The query behind this form is joining with 2 tables. Lets say one table is the User data table and the other is a custom table with userid, and user description. When I click the submit button on this edit form, it should do an insert/update on this custom table. My question is to I need to make sure the user id I want to edit exists in this table, or will an update query add the record if it doesn't exist? If I may also ask, what would be the best way to code this? If my situation is not clear, please feel free to let me know and I'll try to explain more.
Thank you in advance. [Non-text portions of this message have been removed]
