save as new record if record is edited

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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...
 
Back
Top