Autolookup on tables

[m.afflitto]

I was just wondering if anyone knows how to sort of mask an ID as text. For example in this assignment I am doing at university I have a field named Flower ID which is a number. However, instead of displayign that number in forms and tables I want it to display its equivalent Species and Variety of flower. Is there anyway to fix this? Thanks for your help.

 

[chris davies]

this is VERY possible and quite easy to boot. Have you looked at the northwind database that comes with access? if not here goes...

create your tables, create your relationships, in the table with the foreign key, go into design mode and select your foreign key and in the datatype select lookup wizard. you will be given two options,
1. I want the lookup column to lookup the values in a table or query.
2. I will type in the values that I want.

you need to select option no 1.
click next
select your table where the PRIMARY key is and select the value (for example name) from that table, click next and next. the link is done. In design mode at the bottom of the page there are two tabs, general and lookup, click lookup and you will see your relationship linked via a select query.
What we have done here is, linked the name attribute via the primary/foreign key mechanism.