Hi there,

I have been tasked with setting up an Access database to track 4 similar
(but different) entities. Under certain circumstances entities B & C could
metamorphose into entity A. Is it possible in Access 2002 to have a button on
an input form that will replicate most (but not all) fields from entity B (or
C) over to the table containing entity A?

Entity A will be indexed via an auto-number – will this add extra complexity
when trying to copy other entities over to it?

I’m familiar with database theory & basic Access but haven’t previously
designed & implemented a dbms in Access. Any responses gratefully received

Regards

Phil