ComboBox Filter with foreign keys?

[Richie27]

Hi all,

I want to create a combo box filter - easy enough usually

However - the field I want to use is a foreign key field which, while it displays a meaninful description - it stores the id rather than the text

I want to create a combobox filter, but when I do all I see is the id's - which are meaningless to the user.

Is there a way to get these foreign key filters to display a meaningful text description??



Thanks for reading!

Rich.

[Robeen]

Is your foreign key field a Lookup field?

[Richie27]

It is indeed.

[R_Badger]

I did a demo of this for someone recently take a look here:

https://www.accessforums.net/access/option-group-how-write-text-into-column-25190.html#post122098

[R_Badger]

For interest and completeness also beware table level lookup fields are evil and must be punished.

For why see this:

http://access.mvps.org/access/lookupfields.htm

[Richie27]

Thanks Dude,

It was a combobox filter I wanted, rather than a regular combobox.

Thanks though, I realised what I had to do when looking at this and that I just had to tweak the rowsource sql in the property sheet to get it to display the filter categories I wanted.

In regard to not using lookup fields in a table - I use lookup tables rather than fields - how else are you supposed to make it clear for the user when they are inputting data?

Interesting.