Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

I am haveing a hard time understanding lookup tables

Status
Not open for further replies.

pbardotz

Technical User
Oct 9, 2005
4
US
I have not been able to construct lookup tables for my Access form entries. I am able to do lookups by having a one to many relationship in the query but that only gives me the information if I know the name or codes.

Does anyone have an example of how to do a lookup table for a form or query?

I have an employee name that I want to enter and have the table fill in wage rates, but I want to be able to pick the name from a table instead of a list or drop down box.

Thanks.
 
'I want to be able to pick the name from a table '
Don't understand what you mean by this. There is certainly no feature in Access that does it.

For data entry you would normally use a form contining a combo box (drop-down list) the combo can use a table as its row source - is that what you want.
If so create your table and enter the values you want in it; then add the combo box to your form using the toolbox wizard and it will guide you through it.


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top