Filtering table inside a form

[Liam87]

I have a table which I need to input data on tree planting across a number of sites for an environment project. I have an ID, site_num, date_plant, species, quantity fields. There are a number of plant species and they may change each year depending on local supply/condition. Each site may have up to 10+ records for a particular date with different species/quantities in each record.



I was hoping to make a form that has a table below(or text box) that displays the records for the date and site so the user can see and check they have updated all the correct information for that site before moving on. I think I would need an unbound text box that defines the values for site and date that does not clear when you hit enter to finish inputing one record(and then a button for the user to clear the site and date).

I'm a bit new to this so any help would be appreciated

Thanks

[orange]

I would not suggest starting with a form. From the brief description, I see these "entities" (things) you are dealing with.

Sites

Trees(this may be species?)

and Plantings

I would suggest these 3 tables

Tree---->Planting<--------Site

where Planting is a Junction Table.

You may wish to review Normalization and Junction Table
You can find more info at http://www.rogersaccesslibrary.com/T...lationship.zip

Good luck with your project.

[Liam87]

Thanks for your timely response,

So would it be like:
Trees>Tree_ID, Species
Plantings>Site_ID, Tree_ID
Site> Sited_ID, Date_Planting, Quantity_Planted

But what I have currently is

Reveg> Site_ID, Date_Planting, Tree_Species, Quantity_Planted
LUT_Trees>ID, Tree_Sp

[orange]

No.

Tree(TreeId, Species,... anything else specific to a tree {height,age???} )
Site(SiteId, SiteName..anything else specific to a Site..{Lat/Long}????)

Planting(PlantingId, SiteId, TreeId, DatePlanted, QuantityPlanted)

PKs are underlined.
In Planting, SiteId and TreeId are FK to the respective tables.
Also in Planting, SiteId,TreeId, and DatePlanted makeup a compound unique index (This is to prevent duplicates in the Planting Table)

With this table structure , you can add new sites, and/or new Tree/species and carry on.