How to use a lookup table for beginners

[rtcary]

My experience has been with SQL Server using Delphi and other languages where code is written for data integrity. A local service club has asked me to setup a relatively simple Access database where those that will use it have very little experience, and I do not want to be "tied" to it if they need help down the road. Not having experience with the features of Access, I am not sure how to setup the following:



The ClientTbl has a field, Ad. There is a table, AdTble with the following fields:

Primary key: AutoIncrementing
Description: text (30)
Amount: integer (dollar)

I would like to have a dropdown that shows the description, and when selected, the link to the Primary Key is inserted in the field, Ad. Can this be done? Will the Amount show?

Sorry for such basic questions, however, I am a beginner with 35 years experience :-)!

Todd

[June7]

Build combobox on form. Yes, the PK can be the saved value. Yes, the Amount can show if you want. http://www.datapigtechnologies.com/f...combobox3.html