MS Access Combining fields into a longer one

[June7]

Understanding primary and foreign keys is critical to understanding relational database principles. You should not proceed until you gain that understanding.

Then you need to understand how form/subform arrangement works.

[Sidran]

Sorry about the late reply, didn't notice that the forum went on to the second page. I did browse through a few videos and links and I think I have understood how the primary and foreign keys work. However I still do not understand how setting the dates in Table D as a foreign key would allow me to populate those fields.

[June7]

Form/subform arrangement. Main form bound to table A that has the primary key field. Subform bound to table B that has the foreign key field. The Master/Child Links properties of the subform container control will synchronize related records. The foreign key value is automatically populated when data entry is initiated in the subform.