Insert and Update in one form?
Is it possible to create an insert form that will insert data into table a but will update table b?
Is it possible to update all data in one table column? ie update all records in a column from a 1 to a 0.
Just want to know if it is pheasable before I get stuck in to trying to build it.