If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
linking tables for maximum efficiency
Hi,
I am trying to build two tables containing information about fish that we have collected: tbl Fish: FishPK (one for each individual fish; autonumber) CollectionPK (links to tbl Collection which contains information about where and when we collected the fish) FishName FishAge FishSex FishLength tbl FishAnalysis: FishPK Analysis1 Analysis2 Analysis3 Analysis4 The chemical analyses are only performed on a subset of the entire fish collection. I am pretty happy with this design, but am open to suggestions! In particular, I want to know if this design allows me to: 1. build a query to find the individual fish that have (or have not) been used for chemical analyses 2. build a form for entering results of the analyses - when I receive the data, it looks like this Collection ID (not PK) FishName Analysis1 Analysis2 Analysis3 Analysis4 - which means that I have to collect data from two separate tables before adding the new results to tbl FishAnalysis. How do I build a form to simplify this process? And is my design correct to enable my form? I would appreciate any input! Thanks, buggirl |
Thread Tools | |
Display Modes | |
|
|