I continue to look for a video that will help point me in the right direction on this, but i have myself a little wrapped right now.
I have Dog Events that have Stakes and Entry Fees.
EventTbl
StakesTbl
StakesFeeTbl
The Event table only has Event related information. the Stakes table is a list of various Stakes (Open, Amateur, Puppy, Water, Junior, Senior, Master). An event typically has three stakes and each stake has a fee. Sometimes the fees are the same for each stake, sometimes not, and fees vary from year to year.
The StakesFee table contains the key field StakeFeeID, foreign keys EventID and StakeID, and a field for Fee (currency).
I have a form to create the Event. I "think" i need to create a subform that allows me to select multipe stakes and assign a fee to each stake. I can create the query to pull the StakeID and EventID together, but i'm stuck as to how to create a subform that grabs the Event ID from the main Event form and stores it in the StakeFeeTbl and allows the user to select various Stakes from a dropdown and assign a fee to each stake.
DogRebuild3 (2).zip