Cancelled Records

  • Thread starter Thread starter AW
  • Start date Start date
A

AW

Hi.
I'm a newbie to Access and have a problem for which I am looking for some
assistance. I'm sure the issue is pretty basic,however I would be grateful
if any person could pass on their experience via this group.

The issue:
I have a table (tblMaster) into which I load projects that pass across my
desk, Job No.s, types, sizes etc. This table is used to generate numerous
reports via Queries I have generated.

I would like to know, if when a job is "cancelled" or "completed"
addedwithin the master table, if the record can be transferred to another
table automatically. This table (tblComp) to be added to and not replaced
each time a record is added.

Can this be done, and if so, how?

Any assistance would be appreciated.

TIA

Al@n
 
This could be done, but shouldn't. When you only want to see active tasks,
just filter out the completed ones. It is not standard database practice to
move records to another table just because thier status changes.

Hope that helps,
Rick B
 
Hi.
I'm a newbie to Access and have a problem for which I am looking for some
assistance. I'm sure the issue is pretty basic,however I would be grateful
if any person could pass on their experience via this group.

The issue:
I have a table (tblMaster) into which I load projects that pass across my
desk, Job No.s, types, sizes etc. This table is used to generate numerous
reports via Queries I have generated.

I would like to know, if when a job is "cancelled" or "completed"
addedwithin the master table, if the record can be transferred to another
table automatically. This table (tblComp) to be added to and not replaced
each time a record is added.
Click to expand...

As Rick says, it's best not to have separate tables for this purpose;
doing so causes a lot of overhead and complexity which is not
necessary. Instead put a Yes/No field Active, or an integer field with
values 0=active, 1=cancelled, 2= completed and base your form on a
Query which selects the appropriate records for display and editing.
(Use an Option Group control for the three-value integer).

John W. Vinson[MVP]
 
Back
Top