Updating backend oracle tables from MS Access

[jaishu]

Hello,

My requirement is this...

I have to use MS Access as front end with ODBC connection to Oracle 9i

DB.

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!

 

[KenHigg]

Hi Jaishu,

I hope I don't come off wrong here but I would suggest you buy a good Access book as a starting point. Most of what you have described shouldn't be that difficult. Thing is a forum like this is best suited for more specific questions as most people don't have the time to walk a new user all the way through a scenario like you have described...

Just my 2 cents -
Ken

 

[jaishu]

Hi Ken,

i have developed forms, but can u give me an idea of how to relate- clicking a box and capturing that row when a check box is clicked, since i think i have to capture the data dynamically whichevr is being selected , plz..!

 

[KenHigg]

Sorry, Jaishu, Your question is still unclear to me. Maybe someone else will pop in with a suggestion