Table Navigation 
Author Message
 Table Navigation

I have a temporary table created by joining two other tables.This table
is used in order to enable the display of the data contained in both of
the parent tables.

I can edit and delete from this temporary table.

I however need to be able to reflect any edit/delete action in one of
the parent tables.
I have tried to do this by capturing the rowid of the row in the
temporary table however
I have been unable to use this to locate the apprpriate row in the
parent table.

For example if locationnumber contains the row id which is of the same
type as the column runnumber then the only record that is changed in the
parent table rsRunTable is the first
record and not the one identified by runnumber =locationnumber.

Obviously I am doing something wrong does anyone know of an easier
method of doing this?

Set rsRunTable = dbRunLog.OpenRecordset("Run", dbOpenDynaset)
      With rsRunTable
       .OpenRecordset
       .FindFirst !runnumber = locationNumber
       .Edit
           !hours = Text1(0).Text
        .Update
      End With

Thanks

Kevin



Sat, 24 Jan 2004 16:02:52 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. re Explicit Transaction Control and Table Navigation

2. Table editing/navigation

3. HELP! Record Navigation and table frames

4. MS A2K with SQL Server navigation delete button

5. db navigation troubles: Data Environment hierarchy

6. Forms Navigation in VB6 ?

7. Navigation button bar

8. better ado navigation control???

9. IIS, session end and automatic navigation

10. Problem with Record Navigation using ADO, MTS, AS/400

11. ASP dynamic user changeable Navigation bars

12. Control and Field Navigation


 
Powered by phpBB® Forum Software