How to binding Access's Lookup&Relationship Column items in


I have a Microsoft Access database for projects and i added a Lookup&Relationship oclumn to my access database and i typed the values i wanted like an example below.
But when i binding this datasource in my tool and insert combobox and set DisplayMember this column. I couldnt be able to see items in my combobox items collection.

I thought i'm making mistakes in this topic, any experts can help me where i am wrong ?

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Éric MoreauSenior .Net ConsultantCommented:
Maybe I am wrong, but I don't think the values you set in the lookup wizard are available outside Access.

What you need to do is to create reference tables (plain old table that will contains these values). And since that will be just regular tables, you will be able to use them to populate your combo boxes.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Lookup values at the table level are not recommended due to the problems they cause with queries and code.  Since you are not using Access for anything (You are using Jet or ACE if all you are doing is using "Access" to hold data), the lookup has no impact.  No other FE application EXCEPT Access would even see them.

Eric gave you the correct solution.  When you create the new table, don't forget to enforce RI so that only valid values can be stored.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic.NET

From novice to tech pro — start learning today.