Currently I am creating a database that has multiple tables. I would like to create a form that is populated with default values each time a new record is entered. Here is an example of what I mean.
Table 1 items:
ID
Item
Description
ReceivedDt
EnteredDt
I would like to have upon entering a new form to have Item and Description be populated each time to:
Product1 Description...