Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

linking tables drop down

Forum home » Delegate support and help forum » Microsoft Access Training and help » Linking tables for a drop down list

Linking tables for a drop down list

ResolvedVersion 2003

Amie has attended:
Access Introduction course
Access Intermediate course
Access Advanced course

Linking tables for a drop down list

Hello again,
I have created a table with all the london postcodes and their burroughs. What I would like to do is have an option under my POst code column(in a say address table)which when u click is linked to the POst code list where you can select the start of the Relevent POst code...ex SW1.....
This must be possible ?

Thanks!!!

RE: linking tables for a drop down list

Hello Amie

Thank you for your question.

We hope you find the forum a useful resource, but would like to draw your attention to the following points from our fair use policy for the forum:

- Posts should relate to content covered on the training you have received.
- Any posts that do not relate directly to training you have undertaken will receive a reply providing advice on further training or consulting services that we can offer in relation to your post.

On the basis of this post and others you have asked, it appears that there are many questions you have regarding Access that are beyond the scope and content of the Access Introduction course.

We can assist you to have your database up and running in the way you wish, but this is something that we would arrange as a tailored training or consultancy on Access.

Please contact our enquiries team if you are interested in taking this forward.

Thank you
Best Training

Access tip:

Splittng a database

Split your database into two (at least).

Keep all of your code, forms, reports, etc. in one 'code' database and all of your tables in another 'data' database which is then linked to the 'code' database.

This makes modifications, updates and back-ups that much easier and allows you to work on a new version of your 'code' database without affecting existing users. It also makes it easier should you wish to convert a single user databases into a multi-user networked version.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.