Hi,
I am creating a database to store results of dog shows. I have a main form that holds the Show information, and a subform to record the results/awards for each dog entered. works fine.
the example entry for 1 result in the subform would be:
cmbDogID, cmbDogClass, cmbDogAward
the problem I am having is that one dog may have multiple awards in one show, and I would prefer them all to be entered in one entry since cmbDogID and cmbDogClass would be the same, it's only cmbDogAward that would be different.
So I tried to create a subform within that subform, then the user just has to enter show info in the main form, select a dog and class from the 1st subform, and then select one, or many awards from the 2nd subtable. this should be repeated for each dog entered who won anything.
As you have probably guessed by now, Access doesn't like this idea, it tells me a form with a subform object cannot have it's DefaultView property set to Continuous Forms.
This makes me wonder if I am approaching this in the best way, can anyone help ? I suppose you could say I'm trying to create a "one-to-many-to-many" situation, can I even do that?
I am creating a database to store results of dog shows. I have a main form that holds the Show information, and a subform to record the results/awards for each dog entered. works fine.
the example entry for 1 result in the subform would be:
cmbDogID, cmbDogClass, cmbDogAward
the problem I am having is that one dog may have multiple awards in one show, and I would prefer them all to be entered in one entry since cmbDogID and cmbDogClass would be the same, it's only cmbDogAward that would be different.
So I tried to create a subform within that subform, then the user just has to enter show info in the main form, select a dog and class from the 1st subform, and then select one, or many awards from the 2nd subtable. this should be repeated for each dog entered who won anything.
As you have probably guessed by now, Access doesn't like this idea, it tells me a form with a subform object cannot have it's DefaultView property set to Continuous Forms.
This makes me wonder if I am approaching this in the best way, can anyone help ? I suppose you could say I'm trying to create a "one-to-many-to-many" situation, can I even do that?