Couple cascading cbo to a record

[Real Wally]

Hi all,

I'm building a db to catalogue my prints collection. I'd like to group them in categories. With the examples I found on this site I've been able to include cascading comboboxes in a form and they cascade beautifully (3 categories: maincategory, Subcat1 and Subcat2). Problem is though, I cannot get them to work in combination with a unique record! I have tried all sorts of combinations to link the cascading boxes to the print but they either don't change at all, or my qry returns 0 records. I must be doing something simple wrong but I'm not very experienced and just don't see the solution. I've spent all evening so far and I think it's time for some help.

I've got these tables (there are more tables and fields, but these are the main ones)

Tbl_prints
PrintID
PrintTitle

Tbl_Category
CategoryID
Category

Tbl_SubCat1
SubCatID
SubCat1

TblSubCat2
SubCat2ID
SubCat2
PrintID

The tables are linked by the printIDs.

Now, when I fill in the details for print #1 and then advance 1 record to print #2, (or #3 etc) the comboboxes don't follow.

What would be the solution for this?

Thank

 

[RuralGuy]

Cascading combo's are usually a means of navigating or searching through tables. Why do you believe the combo's should "follow" when you navigate in some other method? Cascading combo's are usually unbound cbo's. Only bound cbo's could possibly "follow" when you navigate some other way, and then they would be useless as a searching or navigating mechanism; unless you put a bunch of code in the other navigation scheme.

 

[Real Wally]

Problem fixed!

The structure is not correct

Thanks Pat! Great tip, I got it to work.