use a table with 20 entries as a template for new locations

B

Bobi

Hi

I have a table where i collect informations about wather samples. For each
location I need to add som values for about 20 different parameters - each
location genereates 20 entryes in the table - one entry for each parameter.

The list of parameters are always the same. So I'm thinking about creating a
table template with 20 entyres that are copyed to main sample table, every
time i creat a new location.

Do some one have an idea of how I can do that?

Best regards

Bobi
 
F

Fred

Bob, first see if my guess is right regardign what yo are implying.

You have all of these different locations. Each takes readings on an
ongoing basis. Each set of readings includes about 20 parameters taken at
about the same time. The 20 parameters are the same for every station. All
of the data is being entered and stored in one location.

If so, a better approach would be to create 2 main tables. One is a list
of stations, with fields for station name, location etc. plus an autonumber
Primary Key field "StationID"

Then make a "readings" table with fields for your 20 parameters, plus
whatever date or time records you need for the readings. Include an integer
field "StationID"

Link the station ID fields between the tables. Make a "Station" form from
the stations table, and, on it, a "Readings" subform. When you make a new
stations, all 20 of those fields will automatically be there and ready for
data entry.
 
Top