Populating a table from a form/subform

[Fish218]

I am a beginner to Access. I am building a db to enter commercial fishing data. I trying to build a form with combo boxes in the header that will automatically populate the fields in the subform (both header combo boxes and subform are fields from the same table).

The combo boxes include Name, Grid, Net Type, Net Material. I will "set" these fields using the combo boxes and then use the subform to enter "daily" catch information. Essentially I don't want to have to re-enter the data from the combo boxes each time I need to enter new "daily" catch information in the subform.



Also if there is a way to "set" the Month and Year the same way in the header and only change the day in the subform that would be great also!!!

Any help would be greatly appreciated!

[June7]

Need to describe data structure. I suspect you need something like:

Vessels
VesselID (PK)
VesselName
Grid
Net
Type
NetMaterial

and a table for:
DailyCatch
VesselID (FK)
CatchDate
Tons
etc.

Set up a form/subform arrangement. Main form bound to Vessels, subform bound to DailyCatch. Master/Child link properties of the subform container will synchronize the related records. Access Help has guidelines on building forms.

Review this tutorial on database principles: http://forums.aspfree.com/microsoft-...es-208217.html

The date parts should be in one field, like: 10/23/2011

[Fish218]

I have one table for commercial fishermen tblCOMM_Fishers:

CommFishID
LastName
FirstName
CommercialLicense#
Address
City
State
Zip
Phone
MayPermit
SummerPermit
NovPermit
StatZone

And One Table for Commercial Catch tblCOMM_Catch:

CommercialCatchID
CommFishID
GridID
LiftDate
GillnetSetTypeID
GillnetMaterialID
MeshSize
NightsSet
FeetFromSurface
FeetofNet
PoundsCaught
PricePerPound
OtherSpecies

I'm trying to create a form that looks like the data entry form (see attached). The "Daily Catch Forms" encompass one month of commercial fishing. I want to be able to put the information that won't change for one monthly report form (i.e., CommFishID, GridID, GillnetSetTypeID, GillnetMaterialID, PricePerPound, MeshSize) and have the data entry person only have to enter FeetFromSurface, FeetofNet, NightsSet, PoundsCaught, OtherSpecies in the subform. I want the information that doesn't change to automatically populate the subform (and tblCOMM_Catch) after each "day" record is entered.

I want the form to look as much like the attached form as possible and as efficient as possible - only have to enter data that changes on a daily basis. I hope I'm being clear enough.

[Fish218]

Also I am building this database in 2007 but we will be upgrading to 2010 (I have 2010 on a laptop) so I could build it in 2010 if there enhancements that could help me.

[Fish218]

Also Also, any field with ID after it has a lookup table associated with it.

[June7]

2010 does have some enhancements, also has some behavior I don't appreciate. I did not find any enhancements that justify an upgrade at work. I use 2010 at home and found one new feature useful for a personal project of mine - conditional formatting offers up to 50 conditions (as opposed to only 3).

Replicating that form should not be difficult. I still recommend a form/subform. Looks like tblCOMM_Catch might need to be split into two tables. The fields that are for daily data should be in a child table related to the table that has the fields that are in the header part of the form.

[Fish218]

Splitting tblCOMM_Catch worked. Thanks.