Data Entry Solution?

[Guest]

I am trying to find a method that will take one field entered in a form for a
table that will "auto" fill (or pass) that data for all data sets. For
example, instead of entering the DATE for each set, the user would enter the
date into the form and it would be "repeated" for all the other subsequent
sets for that particular date. Not sure if forms and subforms work best or
if there is some code to help with this solution. Any help would be GREATLY
appreciated!

 

[Guest]

Not sure what you mean by "data sets". Different tables? In general, it is
bad practice to store duplicates of the same data all over a database. Better
to have a master/header record for a given date, to which all other "data
sets" would be related.

 

[Guest]

What I am calling "data sets" are one record in a table that share a common
date. Instead of entering in each date for each recodr on the same date, I
need a method to share that date with all those related records. How do you
use master/headers if they can be used for this purpose?