M
Marnie
I have a form based on a table (tblProcess) with several fields that make the
key, FacilityCode, FacilityPlant, Process. I have a subform based a another
table (tblProcessQuestions) that links to this form using these fields. It
works correctly except when the user changes the data in one of the key
fields on the main form. The data in tblProcessQuestions retains the
original values entered on the form. Do I have to somehow store the original
values to determine if they changed and then delete and recreate the subform
table or is there an easier way? The tables are SQL Server 2000.
Thanks
key, FacilityCode, FacilityPlant, Process. I have a subform based a another
table (tblProcessQuestions) that links to this form using these fields. It
works correctly except when the user changes the data in one of the key
fields on the main form. The data in tblProcessQuestions retains the
original values entered on the form. Do I have to somehow store the original
values to determine if they changed and then delete and recreate the subform
table or is there an easier way? The tables are SQL Server 2000.
Thanks