VB6, Access 2000 DB with two tables.
Master table with Text indexed key ("JDN") (NOT the primary) linked via this key to the "JDN" field in the master table. Child records only contain 3 fields, the key "JDN" text field, a text field with the date and a text field with the time.
In access the fields are linked one master to many children.
I would like some help in processing these records.
1. Add a new master record, and when when the masterrs.update takes place, add a detail record.
2.) When a new master record has been found, skip to the last detail record (so I can display the last time this event for this master occurred)
I have all the code done and working for the master record, finding, reading, adding, editing etc. It is the addition of the child records that is wearing me out. If someone could just post the 10-20 lines of code showing the correct sequence, I would be appreciative.
Masterrs.ADDNew or Masterrs.Edit
change change change
Masterrs.update
[miracle occurs here]
(add new detail record using JDN as key with current date and time)
And
Masterrs.seek successful
skip to last Detailrs record and display date and time in their text boxes on the form. (No editing allowed to child records)
Thanks in Advance
GWB