I have a form which displays fields from a child table of biochemical kits. Fields such as the chemistry description and number of units in the kit etc are stored in a parent table as a single chemistry can have many individual lot numbers of kits.
If I use a vcr to move the record pointer in the parent table the child fields displayed are updated of course but because I am interested in seeing individual kit records and set the vcr to move through the kit table records the parent fields don’t change in sync.
I am looking for a way of moving the record pointer in the parent table to update textboxes on the form which are bound to the parent table when the vcr control is used to move through the kit records. I need the code to be as generic as possible so that it can be built into the vcr class.
Is anyone able to help.