getting several records for one customer in the fields of a table based on date

[joce]

Hi,

I am trying to create a database for farm auditing. The idea is you gather information monthly from the same farms and enter this into the database.

So as time pogresses for example, farm 1 will have 6 entries for each field in each table, in 6 months time. But i need to be able to see each entry that was put in each month. I do not want it to just show the most recently modified information, and I want it to show the date f these.



Any ideas as to how I go about achieving this?

Any help would be appreciated.

[hertfordkc]

IMHO you need at least two tables. The first table contains farm identification info, i.e. data that is unlikely to change through time. A second table may contain one or more records for each record in the first table (a one to many relationship). The second table is linked to the first by a unique identifier. The second table would also contain the date of each data collection and other info specific to that date.
You will likely use a form (for the first table) and a subform(for the second table) and use the provided linkage properties to keep everything working together in data collection and data recall.
Hope this helps