Duplicating date in a field to a new record

[Guest]

I am new to Access and was wondering when entering date in a form, then going
to a new record in that form to enter more date, can you duplicate the same
data you just entered in the previous record? Ex: Customer - date - order#
and amount are fields in my form. I have a customer 'A' that orders several
items. Can I duplicate customer 'A' and the date without having to retype
the same info in every record?

 

[Arvin Meyer [MVP]]

If you database is designed correctly, you do not have all the information
in that one row of data. That is one of the main differences between a
database and a spreadsheet.

A customer table handles all the customer information, and orders table uses
the customer ID from the customers table and handles all the order header
information (CustomerID, Date, etc.), and an order details table handles the
items on the order.

For an example, have a look at the Northwind sample database that came with
Access.