subform issue

[hair]

I have two tables with a relation one to many - so in the first one a primary key and in the second a foreign key. I make a form with a subform using the wizard, based on those two tables . I replace the text box on the form with a combo, and I set the source of the combo with a query from the origin table. Every time I change now from the combo, I get in the subform the values that are corespondant. But when I want to modify, I get error saying im risking double values on index fields blabla. Where am I wrong?
Thanks

 

[sandi8581]

store value for later use

Hi,

I'm new at this, too, but I am working on a similar kind of form and was having the same problem. When you go through the combo box wizard, first select "I want to look up values in a table or query." When you get to the next to last question, try selecting "save value for later use" instead of indicating the field that you want it to go in.

I hope this helps. This is how I got mine to work.

Sandi

 

[hair]

ill try i tomorrow at work
thanks a lot
but even this would solve the problem, it is not normal because logically u don't double an index when u modify the subform..
Actualy id like to be able to make the subform as i wish without the wizard but i dont know how to link a query with the combo and the subform...got to dig deeper
Ive looked at one already made, but didnt help too much...

 

[Dugantrain]

Hair, in the Subform's properties, you can select its Link Child and Link Master specifications. I highly suggest this; go ahead and start trying to get away from those Autoform wizards. Although I'm not as dogmatic as some about never using wizards of any type, I do find that the Form wizards tend to lead to random corruption.

 

[hair]

Thanks D
I did it like this and it works now
Stupid wizard