Question Modifying a record and saving in a new location (1 Viewer)

Hello World!

I'm working on a database that will be used by two different groups. Group A provides a list of items to be investigated by Group B.

I'm wondering if it is possible to:

i)
have Group A create an excel file of items to be investigated (let's call the file tblNEW)

ii)
open a record in the file through a form (let's call the form frmINPUT) to allow Group B to input investigation findings

iii)
save the modified record into a separate table of all the work that has been done (let's call this table tblWORK)

iv)
delete the investigated record in tblNEW once it gets saved into tblWORK


At this point I'm primarily looking to find out if this is possible. If so, then I will begin looking into how to make all this happen.

PLEASE HELP! Thanks everyone!

Cheers!


-ed

Yes, it's possible.