View Single Post
Old 03-05-2013, 08:22 PM   #5
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 28,257
Thanks: 15
Thanked 1,592 Times in 1,512 Posts
Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all
Re: How to save data from different forms in different tablets

Your column names are too cryptic for me to decode so I'll make up my own.
tblFish
FishID (autonumber PK)
FishName
SpecialFlg
etc.

tblFishSightings
SightingsID (autonumber PK)
FishID
DateSighted
Location
etc.

tblFish defines all types of fish and contains one row per type of fish. So, if there are 20 types of fish you are tracking, this table will have 20 rows. I added a SpecialFlg field to the Fish table because you said there were some fish you wanted to treat differently.

tblFishSightings defines when/where you saw a particular type of fish. This table will contain a row for each sighting so there may be 100 different sightings for a given day with the same fish type sighted at different times.
__________________
Bridge Players Still Know All the Tricks
Pat Hartman is online now   Reply With Quote