Help

[Connie]

I want to find out how I can input information that is
different from year to year but will not change the
present years information. ie. in 2000 John Doe had a
field named Jane. He planted corn with Twitch-high,
thistle-med, and volunteers-trace(these are weeds in the
fields). In 2001, he had the same field (Jane) and planted
corn again with thistle-Extreme, hempnettle-med, and
ragweed-med.
In the database, I can input these but they will be the
same for both years instead of being different. What am I
missing? Thanks for any help!

 

[Larry]

Connie,

Sounds like you need to add a Year field to your table and
make this part of the key for the table. This will enable
you to have multiple rows for John Doe for different years.

Example:
John Doe --- Jane --- 2001 --- ....data....
John Doe --- Jane --- 2000 --- ....data....
John Doe --- Jane --- 1999 --- ....data....

Good luck and Happy Farming!

Larry