Cascading Problem

[escoyne]

I'm having trouble with my cascading boxes. I cant get the second combo box to pull the info based on the first combo box.

Here's the dB.

 

[boblarson]

I'm having trouble with my cascading boxes. I cant get the second combo box to pull the info based on the first combo box.

Here's the dB.

1. Get rid of the lookups at table level!

2. You should have a product categories table for the category lookups.

3. Your combo should be storing the ID and not the name, and the criteria was all messed up.

See attached file.

 

[escoyne]

Thanks Bob

Just a quick question, why doesnt the product name stay on the first line, when you change the category on the second line?

 

[boblarson]

I believe it is because you are basing your combo row source on the same table. You really should have a categories table.

 

[escoyne]

Ok, i changed that into a different table. But still the same thing

FYI-- I'm a newbie with Access so I'm going on the fly with all this

 

[boblarson]

I think I struggled with this when I was building my POS system. I wound up putting the category and product selection on the main form and then clicking a button to add it to the details (using a SQL Append query and then requerying the subform). I know that it has to do with the subform being in datasheet view which causes the strange behavior with the cascading combos.

 

[escoyne]

Thats kinda what I was looking for initially. Here's what I done so far. Can you help me out with the SQL Append query?