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.
FishID (autonumber PK)
SightingsID (autonumber PK)
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