What is the best way to organize the storage of various archival data?

Question

Microsoft Access

How to properly organize a chronological database in Access? That is we admit there is a "Basic" table. It contains information about objects. There are also two tables "Fillable table 1" and "Fillable table 2".
It is necessary to organize the filling of table values ​​from one form and then select them.
But what is the best way to get attached to the dates in such a case. Since the date parameter in the form must be one. How to be? That is, I see two options:
1. So leave two tables, create one column in the form to record the date, but use VB to record the date in both tables.
2. Combine both tables into one, make one "date" field, but since the data of the second table will also be replenished from other forms, you will have to select the actual values ​​when selecting not only by tada, but also by the highest key ...
Which option is it better to choose, taking into account the fact that in the future it will be necessary to build queries and reports on all this data?

Answer 1

Anton, it would be right, if it helped you, to put the answers as solutions. This is me and about your previous question.
Now let's see. In my opinion, you have a separate entity "software update" and it should be in a separate table and you don't need to interfere with anything. Those. here you have Id, m_version, m_date - and let it be so.
A visit is a separate entity for you, not necessarily connected with the update. So the correct option is two tables, one for each entity. It is extremely important not to interfere with the essence.
How to arrange it correctly? If I were you, I would add a checkbox "updated extremely important software" to the form where you enter data about the visit. Then you have one visit date, but if this checkbox is on, then you write it in two tables. Each entity remains isolated, you do not mix anything, and you have the correct data.