Copying data from one table to another

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

PhilSpears
Mon Jan 16 10:16:02 CST 2006



"Phil Spears" wrote:

> 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
>

PhilSpears
Mon Jan 16 10:18:02 CST 2006

Sorry - wrong area to post this in - ignore here, I'll re-post in Access
area, thanks

"Phil Spears" wrote:

> 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
>

PhilSpears
Mon Jan 16 10:19:04 CST 2006

Sorry - wrong area - I'll re-post elsewhere

"Phil Spears" wrote:

> 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
>