create a new record (1 Viewer)

[Analyst12345]

Hi,
I am designing a new database to build regular reports on different projects.
There is a project table where data is about the particular project.
Related to that table, there are an Issue table and a status table.
Every project can have many status items and issues.
The status table and issue table will be updated every week.
I am looking for a way to create a database where the project manager pulls the information from the previous report, and updates the information for the current reporting period by creating a new record for a particular issue / status item without overriding the previous week data. This way, every week's data still exists.
I am looking for a solution that I can do with macros as I don't have a lot of experience with coding.
Thank you!
Analyst12345

 

[June7]

I don't use macros. In VBA I would execute an INSERT SELECT action SQL statement to batch create status and issue records for all or a specified project/date. A macro could probably open a query object for the SQL.

CurrentDb.Execute "INSERT INTO Status(ProjectID, StatusID, WeekDate) SELECT ProjectID, StatusID, Date() FROM Status"
CurrentDb.Execute "INSERT INTO Issues(ProjectID, IssueID, WeekDate) SELECT ProjectID, IssueID, Date() FROM Issues"