B
Birderman
I hope someone can help resolve this problem.
Using Access XP
I have a form with a subform.
The subform has a combo box that lists data from table 1 (master list of
items) so that the user can select required items to add to the subform. The
bound column is written to table 2 which is used by the subform to
show/store selected items. All works well until I decided to delete an item
from the subform, it also deletes the item from table 1 which I do not want
it to do, when deleted it should only be removed from table 2 and hence the
subform. I have been unable to fathom this one out as there is no
relationship set between table 1 and table 2 with referential integrity set.
Any help in resolving this issue will be appreciated,
Regards
Birderman
Using Access XP
I have a form with a subform.
The subform has a combo box that lists data from table 1 (master list of
items) so that the user can select required items to add to the subform. The
bound column is written to table 2 which is used by the subform to
show/store selected items. All works well until I decided to delete an item
from the subform, it also deletes the item from table 1 which I do not want
it to do, when deleted it should only be removed from table 2 and hence the
subform. I have been unable to fathom this one out as there is no
relationship set between table 1 and table 2 with referential integrity set.
Any help in resolving this issue will be appreciated,
Regards
Birderman