Currently, the only way I know how to do this, is to have two separate forms. One is the “Current Bike Form” and the other is “Archived Bike Form”. On the “Current Bike Form”, once a certain criteria is met and when the submit button is pressed, it will add that record to the “Archived Bike Form”. While this method archives data, the data can get very redundant under the “Archived Bike View”.

This is for a bike rental program. The “Current Bike Form” holds one record for each bike. Fields we want included are the following:  “Bike Serial #”, “Student ID #,” a NEW FIELD, "Maintenance Record," & "Additional Bike Info."

The way my team will like the NEW FIELD, is like this:

“Student ID #” + “Check-Out Date” + “Service Status” + “Actual Check-In Date” + “Fees” (if there were any fees)

In that new field, we want it to keep adding records’ data to the “Archived Bike Form” each time that data is updated with a certain criteria met under the “Bike Current Form”. Is there a way to do this easily? We don’t want 10 records of John Smith. We want it to put one John Smith record with a basic history of what he checked out when under the NEW FIELD.

Any help is greatly appreciated.

Thank you!