Updating backend oracle tables from MS Access
My requirement is this...
I have to use MS Access as front end with ODBC connection to Oracle 9i
The application(forms) should be able to update, delete ,insert records
into oracle tables(backend).
i have a main form,which has some unique id's and other info about the
ids and the subform shows several matching id's for that unique id in
main form. the user who uses this application should be able to
1) search for the unique id in the main form such that the subform
displays all its matches
2) they should be able to select anyone match and say approve(there can
only be one match), then that particular record should be updated in the
table.IF I USE A CHECK BOX AND IF THEY CLICK ON ONE RECORD AS MATCH,HOW
DO I TAKE THAT RECORD SAY THE ID , NAME ADDRESS AND ALL DETAILS AND
UPDATE THE TABLE???
similarly when they select some other record i should give option of
deleting other irrelevant matches in the backend table.
the main form and the subform uses the same table as source.updates are
to another table, i should also have to put entry into audit table about
which record was deleted and which one inserted..
How should i do this?? i have attached a sample of how the main and sub forms should be and if i add check box next to match id and if they select (or check)one row, how to capture that particular row's data???
i am new to MS access VBA, any help would be highly appreciated!
Thanks so much!