L
Liz James
Db has a complicated dataset to update. Many of the edits a user would make
just involve locating the correct record and editing in the form. However
there is a type of edit that is much more complex and I envisage the
following scenario, but is there an easier way?
Complicated edit process:
1.Locate the record to edit.
2.User indicates that this edit needs to change the type of item from a
section of track (ItemA) to a fixed point on a track (ItemB). These two items
use completely different forms with many different combo boxes to select the
field entries from. Item A has 3 fields in common with Item B and they have
15 fields not in common. This is why they have completely different forms.
3.Need to display the data from the record to be edited while the
replacement record is being entered.
4.Remove the record to be edited from its table and place in temp table (not
sure how to do this).
5.Open form for Item B, user completes edit and manually copies the data
from the 3 fields that are in common between the two items (because the
original record is visible but read only)
6.Save the edit as a new record and delete the original record from the temp
table.
7. What if the user realises that the edit was a mistake and wishes to
reverse the edit process?
just involve locating the correct record and editing in the form. However
there is a type of edit that is much more complex and I envisage the
following scenario, but is there an easier way?
Complicated edit process:
1.Locate the record to edit.
2.User indicates that this edit needs to change the type of item from a
section of track (ItemA) to a fixed point on a track (ItemB). These two items
use completely different forms with many different combo boxes to select the
field entries from. Item A has 3 fields in common with Item B and they have
15 fields not in common. This is why they have completely different forms.
3.Need to display the data from the record to be edited while the
replacement record is being entered.
4.Remove the record to be edited from its table and place in temp table (not
sure how to do this).
5.Open form for Item B, user completes edit and manually copies the data
from the 3 fields that are in common between the two items (because the
original record is visible but read only)
6.Save the edit as a new record and delete the original record from the temp
table.
7. What if the user realises that the edit was a mistake and wishes to
reverse the edit process?