combo box filter almost working

[Lifeseeker]

Hi,

I have very small sample TEST database to play around with and it's the combo box filter this time.

I followed a tutorial on-line and got it almost working state, but need your expertise.

as you can see from the attached file, every time you make a selection from the Category dropdown box, the selection in the initiative dropdown is narrowed. But Access wont' confirm the selection. It gives a warning saying that

"the current field must match the join key "?" in the table that serves as the 'one' side of 1:m relationship. Enter a record in the 'one'side table with the desired key value, and then make the entry with the desired join key in the 'many-only'table...

I checked in the initiative table, and all initiatives have a corresponding category.

I think I'm really close to getting it to work, but just stuck again...

Any thoughts guy?

many thanks

 

[John Big Booty]

You are using Table level Lookups in your Junction Table, read the article here to find out why this is a bad idea.

Additionally consider implementing a naming protocol for your DB objects, avoid using spaces and other special characters in your object and control names, stick with alpha and numeric characters and the underscore. If you use TBL_TableName, FRM_FormName, QRY_QueryName etc. this will make things a lot clearer in your code as to what object that code is referring to.

 

[Lifeseeker]

You are using Table level Lookups in your Junction Table, read the article here to find out why this is a bad idea.

Additionally consider implementing a naming protocol for your DB objects, avoid using spaces and other special characters in your object and control names, stick with alpha and numeric characters and the underscore. If you use TBL_TableName, FRM_FormName, QRY_QueryName etc. this will make things a lot clearer in your code as to what object that code is referring to.

Thanks for the feedback. I'm not sure how I should make the changes. So in the actual lab table, I should make the CITY as the FK?

 

[John Big Booty]

The FK in you table will be the PK of the record, you are referring to, in the reference table.