save as new record if record is edited

A

Abhijeet

Hi,
I have a table for maintaining record of forms coming in from consultants.
The form needs to go through a series of inspections and may be rejected or
accepted at each step. I need to maintain a record of the kickback and
accepted dates of the forms. Any pointers on how to do it will be much
appreciated.
Thanks,
Abhijeet
 
B

Brian

Make a separate table and create a subform that contains the accept/reject
status & date of such for each accept/reject:


Main table: Projects
Field: ProjectID (AutoNumber, primary key)
Field: Description

Secondary Table: Inspections
Field:InspectionID (AutoNumber, PrimaryKey)
Field: ProjectID (Long Integer, relationship to Projects.ProjectID)
Field: InspectionDate (ShortDate)
Field: InspectionResult (this is where you will store accepted/rejected)

Allow the user to add each inspection on the subform (linked by ProjectID to
the main form that contains the project info). Sort them by date
 
A

Abhijeet

Thanx Brian. This helps.

Brian said:
Make a separate table and create a subform that contains the accept/reject
status & date of such for each accept/reject:


Main table: Projects
Field: ProjectID (AutoNumber, primary key)
Field: Description

Secondary Table: Inspections
Field:InspectionID (AutoNumber, PrimaryKey)
Field: ProjectID (Long Integer, relationship to Projects.ProjectID)
Field: InspectionDate (ShortDate)
Field: InspectionResult (this is where you will store accepted/rejected)

Allow the user to add each inspection on the subform (linked by ProjectID to
the main form that contains the project info). Sort them by date
Click to expand...
 
Top